APPS.CSP_SUPERSESSIONS_PVT dependencies on CSP_SUPERSEDE_ITEMS

Line 14: FROM csp_supersede_items

10: Type v_cur_type IS REF CURSOR;
11: CURSOR get_planned_item(c_inventory_item_id NUMBER,c_org_id NUMBER)
12: IS
13: SELECT item_supplied
14: FROM csp_supersede_items
15: where INVENTORY_ITEM_ID = c_inventory_item_id
16: and ORGANIZATION_ID = c_org_id;
17:
18: CURSOR is_item_scrap(c_inventory_item_id NUMBER, c_org_id number)

Line 401: CSP_SUPERSEDE_ITEMS_PKG.insert_row(px_supersede_id => l_supersede_id

397: l_supersede_id := NULL;
398: IF l_item_supplied IS NULL THEN
399: l_item_supplied := l_inventory_item_Id;
400: END IF;
401: CSP_SUPERSEDE_ITEMS_PKG.insert_row(px_supersede_id => l_supersede_id
402: ,p_created_by => -1
403: ,p_creation_date => sysdate
404: ,p_last_updated_by => -1
405: ,p_last_update_date=> sysdate

Line 691: from csp_supersede_items

687:
688:
689: cursor check_item_planned_exists(c_org_id number,c_item_id number) is
690: select 'Y'
691: from csp_supersede_items
692: where organization_id=c_org_id
693: and inventory_item_id=c_item_id
694: and sub_inventory_code ='-';
695:

Line 843: from csp_supersede_items csi,csp_supply_chain csc

839: and csi.condition_type <> 'B';
840:
841: cursor get_source_planned_item IS
842: select csi.item_supplied,csc.source_organization_id,csc.supply_level,csc.source_subinventory
843: from csp_supersede_items csi,csp_supply_chain csc
844: where csc.organization_id= l_previou_source_org_id
845: and csc.secondary_inventory = nvl(l_source_subinv_code,'-')
846: and csc.inventory_item_id = l_item_id
847: and csc.supply_level = l_supply_level

Line 1074: CSP_SUPERSEDE_ITEMS_PKG.insert_row(px_supersede_id => l_supersede_id

1070: END LOOP;
1071:
1072: --dbms_output.put_line('planned item ' || l_planned_item_id);
1073: l_supersede_id := NULL;
1074: CSP_SUPERSEDE_ITEMS_PKG.insert_row(px_supersede_id => l_supersede_id
1075: ,p_created_by => -1
1076: ,p_creation_date => sysdate
1077: ,p_last_updated_by => -1
1078: ,p_last_update_date=> sysdate

Line 1110: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPERSEDE_ITEMS' ;

1106: l_industry varchar2(10);
1107: l_oracle_schema varchar2(10);
1108: BEGIN
1109: l_get_app_info := fnd_installation.get_app_info('CSP',l_status,l_industry, l_oracle_schema);
1110: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUPERSEDE_ITEMS' ;
1111: END PURGE_OLD_SUPERSEDE_DATA;
1112: PROCEDURE BUILD_NOT_IN_CONDITION(p_master_org NUMBER,p_inventory_item_id NUMBER, x_where_string OUT NOCOPY varchar2)
1113: IS
1114: l_temp_replaced_item NUMBER;