DBA Data[Home] [Help]

APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on ASG_DOWNLOAD

Line 1451: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

1447: TYPE inst_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.instance_id%TYPE INDEX BY BINARY_INTEGER;
1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;
1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1451: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1452: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
1453:
1454: acc_id access_idTab;
1455: inst_id inst_idTab;

Line 1452: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;
1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1451: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1452: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
1453:
1454: acc_id access_idTab;
1455: inst_id inst_idTab;
1456: res_id resource_idTab;

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

1482: , 'Update ACC record for all resources, count = ' || l_tab_access_id.COUNT
1483: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1484: END IF;
1485:
1486: /*** push to oLite using asg_download ***/
1487: l_dummy := asg_download.markdirty(
1488: P_PUB_ITEM => g_publication_item_name(1)
1489: , P_ACCESSLIST => l_tab_access_id
1490: , P_RESOURCELIST => l_tab_resource_id

Line 1487: l_dummy := asg_download.markdirty(

1483: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1484: END IF;
1485:
1486: /*** push to oLite using asg_download ***/
1487: l_dummy := asg_download.markdirty(
1488: P_PUB_ITEM => g_publication_item_name(1)
1489: , P_ACCESSLIST => l_tab_access_id
1490: , P_RESOURCELIST => l_tab_resource_id
1491: , P_DML_TYPE => 'U'