APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on ASG_DOWNLOAD

Line 32: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

28: AND b.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
29: AND au.RESOURCE_ID = acc.RESOURCE_ID
30: AND b.LAST_UPDATE_DATE >= b_last_date;
31:
32: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
33: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
34: l_dummy BOOLEAN;
35:
36: BEGIN

Line 33: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

29: AND au.RESOURCE_ID = acc.RESOURCE_ID
30: AND b.LAST_UPDATE_DATE >= b_last_date;
31:
32: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
33: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
34: l_dummy BOOLEAN;
35:
36: BEGIN
37: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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

56: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
57: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
58: );
59: END IF;
60: /*** push to oLite using asg_download ***/
61: l_dummy := asg_download.markdirty(
62: P_PUB_ITEM => g_publication_item_name(1)
63: , P_ACCESSLIST => l_tab_access_id
64: , P_RESOURCELIST => l_tab_resource_id

Line 61: l_dummy := asg_download.markdirty(

57: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
58: );
59: END IF;
60: /*** push to oLite using asg_download ***/
61: l_dummy := asg_download.markdirty(
62: P_PUB_ITEM => g_publication_item_name(1)
63: , P_ACCESSLIST => l_tab_access_id
64: , P_RESOURCELIST => l_tab_resource_id
65: , P_DML_TYPE => 'U'

Line 117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

113: ( SELECT RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID
114: FROM CSL_MTL_SECONDARY_LOCATORS_ACC
115: );
116:
117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
119: TYPE item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
120: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
121: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

114: FROM CSL_MTL_SECONDARY_LOCATORS_ACC
115: );
116:
117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
119: TYPE item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
120: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
121: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
122: TYPE counter_Tab IS TABLE OF CSL_MTL_SECONDARY_LOCATORS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;

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

179: ACCESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY
180: , COUNTER, RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) VALUES (
181: l_tab_access_id(i), sysdate, 1, sysdate, 1, counters(i), l_tab_resource_id(i), items(i), locations(i), organizations(i));
182:
183: /*** push to oLite using asg_download ***/
184: l_dummy := asg_download.markdirty(
185: P_PUB_ITEM => g_publication_item_name(1)
186: , P_ACCESSLIST => l_tab_access_id
187: , P_RESOURCELIST => l_tab_resource_id

Line 184: l_dummy := asg_download.markdirty(

180: , COUNTER, RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) VALUES (
181: l_tab_access_id(i), sysdate, 1, sysdate, 1, counters(i), l_tab_resource_id(i), items(i), locations(i), organizations(i));
182:
183: /*** push to oLite using asg_download ***/
184: l_dummy := asg_download.markdirty(
185: P_PUB_ITEM => g_publication_item_name(1)
186: , P_ACCESSLIST => l_tab_access_id
187: , P_RESOURCELIST => l_tab_resource_id
188: , P_DML_TYPE => 'I'

Line 379: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

375: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
376: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID
377: AND A.RESOURCE_ID = I.RESOURCE_ID
378: AND A.RESOURCE_ID = U.RESOURCE_ID;
379: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
380: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
381: TYPE inventory_item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
382: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
383: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 380: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

376: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID
377: AND A.RESOURCE_ID = I.RESOURCE_ID
378: AND A.RESOURCE_ID = U.RESOURCE_ID;
379: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
380: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
381: TYPE inventory_item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
382: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
383: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
384: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;

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

413: , COUNTER, RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) VALUES (
414: l_tab_access_id(i), sysdate, 1, sysdate, 1,
415: counters(i), l_tab_resource_id(i), items(i), locations(i), organizations(i));
416:
417: /*** push to oLite using asg_download ***/
418: l_dummy := asg_download.markdirty(
419: P_PUB_ITEM => g_publication_item_name(1)
420: , P_ACCESSLIST => l_tab_access_id
421: , P_RESOURCELIST => l_tab_resource_id

Line 418: l_dummy := asg_download.markdirty(

414: l_tab_access_id(i), sysdate, 1, sysdate, 1,
415: counters(i), l_tab_resource_id(i), items(i), locations(i), organizations(i));
416:
417: /*** push to oLite using asg_download ***/
418: l_dummy := asg_download.markdirty(
419: P_PUB_ITEM => g_publication_item_name(1)
420: , P_ACCESSLIST => l_tab_access_id
421: , P_RESOURCELIST => l_tab_resource_id
422: , P_DML_TYPE => 'I'