APPS.CSL_MTL_ONHAND_QTY_ACC_PKG dependencies on MTL_SYSTEM_ITEMS

Line 219: FROM MTL_SYSTEM_ITEMS_B

215: CURSOR c_trackable_flag(b_inventory_item_id IN NUMBER
216: ,b_organization_id IN NUMBER
217: ) IS
218: SELECT COMMS_NL_TRACKABLE_FLAG
219: FROM MTL_SYSTEM_ITEMS_B
220: WHERE INVENTORY_ITEM_ID = b_inventory_item_id
221: AND ORGANIZATION_ID = b_organization_id;
222:
223: r_trackable_flag c_trackable_flag%ROWTYPE;

Line 233: TYPE track_flagTab IS TABLE OF mtl_system_items_b.comms_nl_trackable_flag%TYPE INDEX BY BINARY_INTEGER;

229: TYPE rvsionTab IS TABLE OF csl_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
230: TYPE loc_idTab IS TABLE OF csl_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
231: TYPE lot_numTab IS TABLE OF csl_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
232: TYPE res_idTab IS TABLE OF csl_mtl_onhand_qty_acc.resource_id%TYPE INDEX BY BINARY_INTEGER;
233: TYPE track_flagTab IS TABLE OF mtl_system_items_b.comms_nl_trackable_flag%TYPE INDEX BY BINARY_INTEGER;
234: acc_id access_idTab;
235: inv_id inv_idTab;
236: org_id org_idTab;
237: sub_code sub_codeTab;

Line 337: , mtl_system_items msi

333: , JTM_ACC_TABLE_S.NEXTVAL ACCESS_ID
334: , msi.COMMS_NL_TRACKABLE_FLAG
335: BULK COLLECT INTO inv_id, org_id, sub_code, rvsion, loc_id,lot_num, acc_id,track_flag
336: FROM csl_mtl_onhand_qty_mv ohqmv
337: , mtl_system_items msi
338: WHERE msi.INVENTORY_ITEM_ID = ohqmv.INVENTORY_ITEM_ID
339: AND msi.ORGANIZATION_ID = ohqmv.ORGANIZATION_ID
340: AND (ohqmv.subinventory_code, ohqmv.organization_id) IN
341: ( SELECT ila.subinventory_code, ila.organization_id

Line 402: , v_message => 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD'

398: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
399: jtm_message_log_pkg.Log_Msg
400: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
401: , v_object_name => g_table_name
402: , v_message => 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD'
403: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
404: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
405: END IF;
406: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD(inv_id(i),org_id(i),r_secinv_resources.resource_id);

Line 406: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD(inv_id(i),org_id(i),r_secinv_resources.resource_id);

402: , v_message => 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD'
403: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
404: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
405: END IF;
406: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.PRE_INSERT_CHILD(inv_id(i),org_id(i),r_secinv_resources.resource_id);
407: END IF;
408:
409: END LOOP;
410: END IF;

Line 425: , mtl_system_items msi

421: , ohqacc.subinventory_code
422: , msi.COMMS_NL_TRACKABLE_FLAG
423: BULK COLLECT INTO acc_id,inv_id, org_id, sub_code, track_flag
424: FROM csl_mtl_onhand_qty_acc ohqacc
425: , mtl_system_items msi
426: WHERE msi.INVENTORY_ITEM_ID = ohqacc.INVENTORY_ITEM_ID
427: AND msi.ORGANIZATION_ID = ohqacc.ORGANIZATION_ID
428: AND ohqacc.resource_id = r_secinv_resources.resource_id
429: AND NOT EXISTS (

Line 475: , v_message => 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.POST_DELETE_CHILD'

471: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
472: jtm_message_log_pkg.Log_Msg
473: ( v_object_id => TO_CHAR(l_current_run_date,'MM-DD-YYYY HH24:MI:SS')
474: , v_object_name => g_table_name
475: , v_message => 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.POST_DELETE_CHILD'
476: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
477: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
478: END IF;
479:

Line 480: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.POST_DELETE_CHILD( inv_id(i)

476: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
477: , v_module => 'csl_mtl_onhand_qty_acc_pkg');
478: END IF;
479:
480: CSL_MTL_SYSTEM_ITEMS_ACC_PKG.POST_DELETE_CHILD( inv_id(i)
481: , org_id(i)
482: , r_secinv_resources.resource_id);
483: END IF;
484: END LOOP;