Functional Description
Purpose
This function display the Parents/Children Relationship of F1201.
Setup Notes and Prerequisites
It has to be used with business function B1200050 and B1200100.
Special Logic
Technical Specification
If it is the fist item
Get the record from cache and return the record
else
The Linked list Data Struct (dsTempNode) is
B1200200
2. Store Data Pointer
Get- Call business function B1200100 to Get items from Cache with Level, Parent and
Sequentialfetch (='1') as passed parameters
Add to the linked List as first element
Return Cache record: Level, Asset Number, Sequence Number and Parent
While flag is equal to zero
Retrieve first Linked List element
If retrieve is success
Listwith Parent and Level of the linked list item as parameters
Add to the linked list as first element
Return cache record, Level, Sequence Number and Parent
Set Flag to 1.
Else
Close cursor and free data pointer by calling B1200100
End if
Else
Set Flag to '1'
NomoreRecords = '1'
Destroy Linked List and remove Data Pointor
End if
End while
D1200200 - Cache, Get Parents/Children Relationship
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAssetItemNumber | NUMB | MATH_NUMERIC | NONE | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
nLevel | INT01 | integer | NONE | NONE |
Number of Days in Future to Query for Responses Due. | ||||
mnParent | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
mnSequenceNumber | MATH02 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance High Value. | ||||
idLinkListPtr | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cNoMoreRecords | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cIfFirstItem | EV02 | char | NONE | NONE |
'1' = First item
| ||||
nDisplayLevel | INT01 | integer | NONE | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szCacheNameOrNumber | JOB | char | OPT | NONE |
Job Number |
B1200050 F1201, Create Parent Child Asset Cache | ||||
B1200100 Cache, Process Asset Tree |
None |