APPS.CSP_PROD_TASK_PARTS_HISTORY dependencies on CSP_SUPERSESSIONS_PVT

Line 193: CSP_SUPERSESSIONS_PVT.get_replaced_items_list(p_inventory_item_id => cdl.inventory_item_id

189: if l_inventory_item_id is null then
190: l_increment := 1;
191: end if;
192: -- we should also consider if any of the items which are replaced by this item already processed so modified above static cursor with ref cursor
193: CSP_SUPERSESSIONS_PVT.get_replaced_items_list(p_inventory_item_id => cdl.inventory_item_id
194: ,p_organization_id => NULL
195: ,x_replaced_item_list => l_replaced_items_list);
196: IF l_replaced_items_list IS NOT NULL THEN
197: l_sql_string := 'select cdl.inventory_item_id

Line 433: csp_supersessions_pvt.get_top_supersede_item(p_item_id => p_inventory_item_id

429: l_debrief_line_id NUMBER;
430:
431: BEGIN
432: l_supersede_item := null;
433: csp_supersessions_pvt.get_top_supersede_item(p_item_id => p_inventory_item_id
434: ,p_org_id => null
435: ,x_item_id => l_supersede_item);
436: IF l_supersede_item <> p_inventory_item_id THEN
437: OPEN supersede_items;

Line 447: CSP_SUPERSESSIONS_PVT.get_replaced_items_list(p_inventory_item_id => l_supersede_item

443: FETCH primary_uom INTO l_primary_uom_code;
444: CLOSE primary_uom;
445:
446: IF l_task_part_id IS NOT NULL THEN
447: CSP_SUPERSESSIONS_PVT.get_replaced_items_list(p_inventory_item_id => l_supersede_item
448: ,p_organization_id => NULL
449: ,x_replaced_item_list => l_replaced_items_list);
450: l_sql_string := 'select DEBRIEF_LINE_ID
451: from csf_debrief_lines cdl