APPS.CSL_MTL_SERIAL_NUMBERS_ACC_PKG dependencies on ASG_DOWNLOAD

Line 19: sequences ASG_DOWNLOAD.ACCESS_LIST;

15: IS
16: TYPE item_Tab IS TABLE OF mtl_serial_numbers.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
17: TYPE serial_Tab IS TABLE OF mtl_serial_numbers.serial_number%TYPE INDEX BY BINARY_INTEGER;
18:
19: sequences ASG_DOWNLOAD.ACCESS_LIST;
20: resources ASG_DOWNLOAD.USER_LIST;
21: items item_Tab;
22: serials serial_Tab;
23:

Line 20: resources ASG_DOWNLOAD.USER_LIST;

16: TYPE item_Tab IS TABLE OF mtl_serial_numbers.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
17: TYPE serial_Tab IS TABLE OF mtl_serial_numbers.serial_number%TYPE INDEX BY BINARY_INTEGER;
18:
19: sequences ASG_DOWNLOAD.ACCESS_LIST;
20: resources ASG_DOWNLOAD.USER_LIST;
21: items item_Tab;
22: serials serial_Tab;
23:
24: l_dummy BOOLEAN;

Line 80: l_dummy := asg_download.markdirty(

76: , 'Pushing ' || sequences.COUNT || ' inserted record(s) to resource: '||p_resource_id
77: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
78: );
79: END IF;
80: l_dummy := asg_download.markdirty(
81: P_PUB_ITEM => g_publication_item_name(1)
82: , P_ACCESSLIST => sequences
83: , P_RESOURCELIST => resources
84: , P_DML_TYPE => 'I'

Line 111: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

107:
108: /**/
109: PROCEDURE DELETE_SERIAL_NUMBERS
110: IS
111: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
112: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
113: l_dummy BOOLEAN;
114:
115: /*Delete all serial numbers from acc table for which the assigned subinventory is no more,

Line 112: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

108: /**/
109: PROCEDURE DELETE_SERIAL_NUMBERS
110: IS
111: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
112: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
113: l_dummy BOOLEAN;
114:
115: /*Delete all serial numbers from acc table for which the assigned subinventory is no more,
116: or for which the status has changed*/

Line 184: /*** push to oLite using asg_download ***/

180: , 'Deleting ' || l_tab_access_id.COUNT || ' invalid record(s)'
181: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
182: );
183: END IF;
184: /*** push to oLite using asg_download ***/
185: l_dummy := asg_download.markdirty(
186: P_PUB_ITEM => g_publication_item_name(1)
187: , P_ACCESSLIST => l_tab_access_id
188: , P_RESOURCELIST => l_tab_resource_id

Line 185: l_dummy := asg_download.markdirty(

181: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
182: );
183: END IF;
184: /*** push to oLite using asg_download ***/
185: l_dummy := asg_download.markdirty(
186: P_PUB_ITEM => g_publication_item_name(1)
187: , P_ACCESSLIST => l_tab_access_id
188: , P_RESOURCELIST => l_tab_resource_id
189: , P_DML_TYPE => 'D'

Line 238: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

234: WHERE RESOURCE_ID = acc.RESOURCE_ID
235: AND SYSDATE BETWEEN NVL( EFFECTIVE_DATE_START, SYSDATE )
236: AND NVL( EFFECTIVE_DATE_END , SYSDATE ));
237:
238: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
239: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
240: l_dummy BOOLEAN;
241:
242: BEGIN

Line 239: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

235: AND SYSDATE BETWEEN NVL( EFFECTIVE_DATE_START, SYSDATE )
236: AND NVL( EFFECTIVE_DATE_END , SYSDATE ));
237:
238: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
239: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
240: l_dummy BOOLEAN;
241:
242: BEGIN
243: /*** get debug level ***/

Line 268: l_dummy := asg_download.markdirty(

264: , 'Updating ' || l_tab_access_id.COUNT || ' changed record(s)'
265: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
266: );
267: END IF;
268: l_dummy := asg_download.markdirty(
269: P_PUB_ITEM => g_publication_item_name(1)
270: , P_ACCESSLIST => l_tab_access_id
271: , P_RESOURCELIST => l_tab_resource_id
272: , P_DML_TYPE => 'U'