APPS.CSP_PROD_TASK_PARTS_HISTORY dependencies on CSP_SUPERSESSIONS_PVT

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

191: if l_inventory_item_id is null then
192: l_increment := 1;
193: end if;
194: -- 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
195: CSP_SUPERSESSIONS_PVT.get_replaced_items_list(p_inventory_item_id => cdl.inventory_item_id
196: ,p_organization_id => NULL
197: ,x_replaced_item_list => l_replaced_items_list);
198: IF l_replaced_items_list IS NOT NULL THEN
199: l_sql_string := 'select cdl.inventory_item_id

Line 437: csp_supersessions_pvt.get_top_supersede_item(p_item_id => p_inventory_item_id

433: l_debrief_line_id NUMBER;
434:
435: BEGIN
436: l_supersede_item := null;
437: csp_supersessions_pvt.get_top_supersede_item(p_item_id => p_inventory_item_id
438: ,p_org_id => null
439: ,x_item_id => l_supersede_item);
440: IF l_supersede_item <> p_inventory_item_id THEN
441: OPEN supersede_items;

Line 451: CSP_SUPERSESSIONS_PVT.get_replaced_items_list(p_inventory_item_id => l_supersede_item

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