eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_MTL_ITEM_LOCATIONS_ACC_PKG dependencies on ASG_DOWNLOAD

Line 41: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

37: AND b.ORGANIZATION_ID = acc.ORGANIZATION_ID
38: AND au.RESOURCE_ID = acc.RESOURCE_ID
39: AND b.LAST_UPDATE_DATE >= b_last_date;
40:
41: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
42: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
43: l_dummy BOOLEAN;
44:
45: BEGIN

Line 42: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

38: AND au.RESOURCE_ID = acc.RESOURCE_ID
39: AND b.LAST_UPDATE_DATE >= b_last_date;
40:
41: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
42: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
43: l_dummy BOOLEAN;
44:
45: BEGIN
46: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

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

65: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
67: );
68: END IF;
69: /*** push to oLite using asg_download ***/
70: l_dummy := asg_download.markdirty(
71: P_PUB_ITEM => g_publication_item_name(1)
72: , P_ACCESSLIST => l_tab_access_id
73: , P_RESOURCELIST => l_tab_resource_id

Line 70: l_dummy := asg_download.markdirty(

66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
67: );
68: END IF;
69: /*** push to oLite using asg_download ***/
70: l_dummy := asg_download.markdirty(
71: P_PUB_ITEM => g_publication_item_name(1)
72: , P_ACCESSLIST => l_tab_access_id
73: , P_RESOURCELIST => l_tab_resource_id
74: , P_DML_TYPE => 'U'

Line 117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

113: ( SELECT RESOURCE_ID, INVENTORY_LOCATION_ID, ORGANIZATION_ID
114: FROM CSL_MTL_ITEM_LOCATIONS_ACC
115: );
116:
117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
119: TYPE location_Tab IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
120: TYPE org_Tab IS TABLE OF MTL_ITEM_LOCATIONS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
121: TYPE counter_Tab IS TABLE OF JTM_MTL_SEC_INV_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;

Line 118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

114: FROM CSL_MTL_ITEM_LOCATIONS_ACC
115: );
116:
117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
119: TYPE location_Tab IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
120: TYPE org_Tab IS TABLE OF MTL_ITEM_LOCATIONS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
121: TYPE counter_Tab IS TABLE OF JTM_MTL_SEC_INV_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
122: locations location_Tab;

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

168: ACCESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY
169: , COUNTER, RESOURCE_ID, INVENTORY_LOCATION_ID, ORGANIZATION_ID ) VALUES (
170: l_tab_access_id(i), sysdate, 1, sysdate, 1, counters(i), l_tab_resource_id(i), locations(i), organizations(i));
171:
172: /*** push to oLite using asg_download ***/
173: l_dummy := asg_download.markdirty(
174: P_PUB_ITEM => g_publication_item_name(1)
175: , P_ACCESSLIST => l_tab_access_id
176: , P_RESOURCELIST => l_tab_resource_id

Line 173: l_dummy := asg_download.markdirty(

169: , COUNTER, RESOURCE_ID, INVENTORY_LOCATION_ID, ORGANIZATION_ID ) VALUES (
170: l_tab_access_id(i), sysdate, 1, sysdate, 1, counters(i), l_tab_resource_id(i), locations(i), organizations(i));
171:
172: /*** push to oLite using asg_download ***/
173: l_dummy := asg_download.markdirty(
174: P_PUB_ITEM => g_publication_item_name(1)
175: , P_ACCESSLIST => l_tab_access_id
176: , P_RESOURCELIST => l_tab_resource_id
177: , P_DML_TYPE => 'I'

Line 441: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

437: FROM MTL_ITEM_LOCATIONS L, JTM_MTL_SEC_INV_ACC A
438: WHERE L.SUBINVENTORY_CODE = A.SECONDARY_INVENTORY_NAME
439: AND L.ORGANIZATION_ID = A.ORGANIZATION_ID;
440:
441: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
442: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
443: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
444: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
445: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;

Line 442: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

438: WHERE L.SUBINVENTORY_CODE = A.SECONDARY_INVENTORY_NAME
439: AND L.ORGANIZATION_ID = A.ORGANIZATION_ID;
440:
441: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
442: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
443: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
444: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
445: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
446: locations location_Tab;

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

473: , COUNTER, RESOURCE_ID, INVENTORY_LOCATION_ID, ORGANIZATION_ID ) VALUES (
474: l_tab_access_id(i), sysdate, 1, sysdate, 1,
475: counters(i), l_tab_resource_id(i), locations(i), organizations(i));
476:
477: /*** push to oLite using asg_download ***/
478: l_dummy := asg_download.markdirty(
479: P_PUB_ITEM => g_publication_item_name(1)
480: , P_ACCESSLIST => l_tab_access_id
481: , P_RESOURCELIST => l_tab_resource_id

Line 478: l_dummy := asg_download.markdirty(

474: l_tab_access_id(i), sysdate, 1, sysdate, 1,
475: counters(i), l_tab_resource_id(i), locations(i), organizations(i));
476:
477: /*** push to oLite using asg_download ***/
478: l_dummy := asg_download.markdirty(
479: P_PUB_ITEM => g_publication_item_name(1)
480: , P_ACCESSLIST => l_tab_access_id
481: , P_RESOURCELIST => l_tab_resource_id
482: , P_DML_TYPE => 'I'