APPS.CSL_MTL_ONHAND_QTY_ACC_PKG dependencies on ASG_DOWNLOAD

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

283: AND ohqacc.resource_id = r_secinv_resources.resource_id
284: AND ohqmv.last_update_date = l_current_run_date;
285:
286: IF (acc_id.COUNT > 0) THEN
287: /*** push to oLite using asg_download ***/
288:
289: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
290: jtm_message_log_pkg.Log_Msg
291: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')

Line 308: l_dummy := asg_download.markdirty(

304: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
305: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
306: END IF;
307:
308: l_dummy := asg_download.markdirty(
309: P_PUB_ITEM => g_publication_item_name(1)
310: , P_ACCESSID => acc_id(i)
311: , P_RESOURCEID => r_secinv_resources.resource_id
312: , P_DML => 'U'

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

358: AND ohqacc.resource_id = r_secinv_resources.resource_id
359: );
360:
361: IF (acc_id.COUNT > 0) THEN
362: /*** push to oLite using asg_download ***/
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
364: jtm_message_log_pkg.Log_Msg
365: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
366: , v_object_name => g_table_name

Line 389: l_dummy := asg_download.markdirty(

385: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
386: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
387: END IF;
388:
389: l_dummy := asg_download.markdirty(
390: P_PUB_ITEM => g_publication_item_name(1)
391: , P_ACCESSID => acc_id(i)
392: , P_RESOURCEID => r_secinv_resources.resource_id
393: , P_DML => 'I'

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

437: AND ohqacc.subinventory_code = ohqmv.subinventory_code
438: );
439:
440: IF (acc_id.COUNT > 0) THEN
441: /*** push to oLite using asg_download ***/
442: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
443: jtm_message_log_pkg.Log_Msg
444: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
445: , v_object_name => g_table_name

Line 462: l_dummy := asg_download.markdirty(

458: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
459: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
460: END IF;
461:
462: l_dummy := asg_download.markdirty(
463: P_PUB_ITEM => g_publication_item_name(1)
464: , P_ACCESSID => acc_id(i)
465: , P_RESOURCEID => r_secinv_resources.resource_id
466: , P_DML => 'D'

Line 561: l_dummy := asg_download.markdirty(

557: END IF;
558:
559: FOR i IN l_tab_access_id.FIRST..l_tab_access_id.LAST LOOP
560: /*** 1 or more acc rows retrieved -> push to resource ***/
561: l_dummy := asg_download.markdirty(
562: P_PUB_ITEM => g_publication_item_name(1)
563: , P_ACCESSID => l_tab_access_id(i)
564: , P_RESOURCEID => p_resource_id
565: , P_DML => 'D'