APPS.BOM_SUBSTITUTE_COMPONENT_API dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 664: FROM bom_substitute_components a, bom_sub_comps_interface b

660: stmt_num := 1;
661: BEGIN
662: SELECT 1
663: INTO dummy
664: FROM bom_substitute_components a, bom_sub_comps_interface b
665: WHERE b.transaction_id = trans_id
666: AND (UPPER(b.interface_entity_type) = 'BILL'
667: OR b.interface_entity_type is null)
668: AND (b.transaction_type = G_Insert

Line 889: FROM bom_substitute_components bsc,

885: X_attribute10, X_attribute11, X_attribute12, X_attribute13,
886: X_attribute14, X_attribute15, X_request_id,
887: X_program_application_id, X_program_id,
888: X_program_update_date
889: FROM bom_substitute_components bsc,
890: bom_inventory_components bic
891: WHERE bsc.component_sequence_id = c2rec.CSI
892: AND bsc.substitute_component_id = c2rec.SCI
893: AND bsc.component_sequence_id = bic.component_sequence_id

Line 1378: BOM_SUBSTITUTE_COMPONENTS.

1374: Transact_Substitute_Component
1375: DESCRIPTION
1376: Insert, update and delete substitute component data from the interface
1377: table, BOM_SUB_COMPS_INTERFACE, into the production table,
1378: BOM_SUBSTITUTE_COMPONENTS.
1379: REQUIRES
1380: prog_appid Program application id
1381: prog_id Program id
1382: req_id Request id

Line 1447: INSERT into BOM_SUBSTITUTE_COMPONENTS

1443: ** Insert Substitute Components
1444: */
1445: stmt_num := 1;
1446: LOOP
1447: INSERT into BOM_SUBSTITUTE_COMPONENTS
1448: (
1449: SUBSTITUTE_COMPONENT_ID,
1450: LAST_UPDATE_DATE,
1451: LAST_UPDATED_BY,

Line 1527: FROM bom_substitute_components bsc

1523: AND (UPPER(bsi.interface_entity_type) = 'BILL'
1524: OR bsi.interface_entity_type is null)
1525: AND exists
1526: (SELECT null
1527: FROM bom_substitute_components bsc
1528: WHERE bsc.component_sequence_id = bsi.component_sequence_id
1529: AND bsc.substitute_component_id = bsi.substitute_component_id
1530: AND nvl(bsc.acd_type,999) = nvl(bsi.acd_type,999));
1531: COMMIT;

Line 1543: UPDATE bom_substitute_components

1539: WHILE continue_loop LOOP
1540: commit_cnt := 0;
1541: FOR c1rec IN c1 LOOP
1542: commit_cnt := commit_cnt + 1;
1543: UPDATE bom_substitute_components
1544: SET substitute_component_id = nvl(c1rec.NSCI, c1rec.SCI),
1545: substitute_item_quantity = c1rec.SIQ,
1546: last_update_date = c1rec.LUD,
1547: last_updated_by = c1rec.LUB,

Line 1595: DELETE FROM bom_substitute_components

1591: WHILE continue_loop LOOP
1592: commit_cnt := 0;
1593: FOR c2rec IN c2 LOOP
1594: commit_cnt := commit_cnt + 1;
1595: DELETE FROM bom_substitute_components
1596: WHERE component_sequence_id = c2rec.CSI
1597: AND substitute_component_id = c2rec.SCI;
1598:
1599: stmt_num := 7;