APPS.BOM_COMPONENT_API dependencies on BOM_INVENTORY_COMPONENTS

Line 157: component_sequence_id = bom_inventory_components_s.nextval,

153: stmt_num := 1;
154: LOOP
155: UPDATE bom_inventory_comps_interface
156: SET transaction_id = mtl_system_items_interface_s.nextval,
157: component_sequence_id = bom_inventory_components_s.nextval,
158: transaction_type = upper(transaction_type)
159: WHERE transaction_id is null
160: AND process_flag = 1
161: AND upper(transaction_type) = G_Insert

Line 876: FROM bom_inventory_components

872: stmt_num := 10;
873: BEGIN
874: SELECT component_sequence_id
875: INTO c2rec.CSI
876: FROM bom_inventory_components
877: WHERE bill_sequence_id = c2rec.BSI
878: AND component_item_id = c2rec.CII
879: AND operation_seq_num = decode(x_bom_item_type,
880: G_ProductFamily, 1, c2rec.OSN)

Line 919: bom_inventory_components bic

915: INTO c2rec.AII, c2rec.OI, c2rec.BSI, c2rec.ABD, c2rec.AST,
916: c2rec.CII, x_bom_item_type
917: FROM mtl_system_items msi,
918: bom_bill_of_materials bbom,
919: bom_inventory_components bic
920: WHERE bbom.bill_sequence_id = bic.bill_sequence_id
921: AND bic.component_sequence_id = c2rec.CSI
922: AND msi.organization_id = bbom.organization_id
923: AND msi.inventory_item_id = bbom.assembly_item_id;

Line 1192: SELECT count(*) INTO l_total FROM bom_inventory_components WHERE

1188: l_total NUMBER := 0;
1189:
1190: BEGIN
1191:
1192: SELECT count(*) INTO l_total FROM bom_inventory_components WHERE
1193: bill_sequence_id = bill_seq_id;
1194:
1195: IF l_total > 9999 THEN
1196: err_text := 'Bom_Component_Api(ComponentCount): Total number of components exceeds 9999 for this bill';

Line 1246: FROM bom_inventory_components

1242: stmt_num := 1;
1243: BEGIN
1244: SELECT 1
1245: INTO dummy
1246: FROM bom_inventory_components
1247: WHERE component_sequence_id = cmp_seq_id;
1248:
1249: IF (exist_flag = 1) THEN
1250: RETURN(0);

Line 1348: FROM bom_inventory_components

1344: stmt_num := 1;
1345: BEGIN
1346: SELECT component_sequence_id
1347: INTO cnt
1348: FROM bom_inventory_components
1349: WHERE bill_sequence_id = bill_seq_id
1350: AND effectivity_date = to_date(eff_date,'YYYY/MM/DD HH24:MI:SS')
1351: AND component_item_id = cmp_item_id
1352: AND operation_seq_num = op_seq

Line 1435: FROM bom_inventory_components

1431: BEGIN
1432: stmt_num := 1;
1433: SELECT count(*)
1434: INTO dummy
1435: FROM bom_inventory_components
1436: WHERE bill_sequence_id = bom_id
1437: AND component_item_id = cmp_id
1438: AND operation_seq_num = op_num
1439: AND implementation_date is not null

Line 2092: FROM bom_inventory_components

2088: X_pick_components, X_supply_subinventory,
2089: X_supply_locator_id, X_operation_lead_time_percent,
2090: X_cost_factor, X_bom_item_type,
2091: X_revised_item_sequence_id, X_bill_sequence_id
2092: FROM bom_inventory_components
2093: WHERE component_sequence_id = c2rec.CSI
2094: AND implementation_date is NOT NULL;
2095: EXCEPTION
2096: WHEN No_Data_Found THEN

Line 4521: BOM_INVENTORY_COMPONENTS.

4517: Transact_Component
4518: DESCRIPTION
4519: Insert, update and delete component data from the interface
4520: table, BOM_INVENTORY_COMPS_INTERFACE, into the production table,
4521: BOM_INVENTORY_COMPONENTS.
4522: REQUIRES
4523: prog_appid Program application id
4524: prog_id Program id
4525: req_id Request id

Line 4529: BOM_INVENTORY_COMPONENTS

4525: req_id Request id
4526: user_id User id
4527: login_id Login id
4528: MODIFIES
4529: BOM_INVENTORY_COMPONENTS
4530: BOM_INVENTORY_COMPS_INTERFACE
4531: RETURNS
4532: 0 if successful
4533: SQLCODE if error

Line 4673: INSERT INTO bom_inventory_components

4669: WHILE continue_loop LOOP
4670: commit_cnt := 0;
4671: FOR c0rec IN c0 LOOP
4672: commit_cnt := commit_cnt + 1;
4673: INSERT INTO bom_inventory_components
4674: (
4675: OPERATION_SEQ_NUM,
4676: COMPONENT_ITEM_ID,
4677: LAST_UPDATE_DATE,

Line 4821: UPDATE bom_inventory_components

4817: WHILE continue_loop LOOP
4818: commit_cnt := 0;
4819: FOR c1rec IN c1 LOOP
4820: commit_cnt := commit_cnt + 1;
4821: UPDATE bom_inventory_components
4822: SET last_update_date = c1rec.LUD,
4823: last_updated_by = c1rec.LUB,
4824: last_update_login = c1rec.LUL,
4825: operation_seq_num = c1rec.OSN,

Line 4900: DELETE FROM bom_inventory_components

4896: ** For Members, delete specific Allocation record.
4897: ** Also null out product family id in item master if
4898: ** this member has no more Allocations for this Product Family.
4899: */
4900: DELETE FROM bom_inventory_components
4901: WHERE component_sequence_id = c2rec.CSI;
4902:
4903: BEGIN
4904: SELECT 'yes'

Line 4906: FROM bom_inventory_components

4902:
4903: BEGIN
4904: SELECT 'yes'
4905: INTO l_members_still_exist
4906: FROM bom_inventory_components
4907: WHERE bill_sequence_id = c2rec.BSI
4908: AND component_item_id = c2rec.CII
4909: AND rownum = 1;
4910: EXCEPTION