APPS.BOM_REFERENCE_DESIGNATOR_API dependencies on BOM_REFERENCE_DESIGNATORS

Line 516: FROM bom_reference_designators a, bom_ref_desgs_interface b

512: stmt_num := 1;
513: BEGIN
514: SELECT 1
515: INTO dummy
516: FROM bom_reference_designators a, bom_ref_desgs_interface b
517: WHERE b.transaction_id = trans_id
518: AND (b.transaction_type = G_Insert
519: OR (b.transaction_type= G_Update
520: AND b.new_designator is not null))

Line 614: FROM bom_reference_designators

610:
611: stmt_num := 1;
612: SELECT count(*)
613: INTO ref_qty
614: FROM bom_reference_designators
615: WHERE component_sequence_id = cmp_seq_id;
616:
617: stmt_num := 2;
618: SELECT count(*)

Line 807: FROM bom_reference_designators brd,

803: X_attribute14, X_attribute15, X_request_id,
804: X_program_application_id, X_program_id,
805: X_program_update_date, X_quantity_related,
806: X_component_quantity
807: FROM bom_reference_designators brd,
808: bom_inventory_components bic
809: WHERE brd.component_sequence_id = c2rec.CSI
810: AND brd.component_reference_designator = c2rec.CRD
811: AND brd.component_sequence_id = bic.component_sequence_id

Line 1241: BOM_REFERENCE_DESIGNATORS.

1237: Transact_Reference_Designator
1238: DESCRIPTION
1239: Insert, update and delete reference designator data from the interface
1240: table, BOM_REF_DESGS_INTERFACE, into the production table,
1241: BOM_REFERENCE_DESIGNATORS.
1242: REQUIRES
1243: prog_appid Program application id
1244: prog_id Program id
1245: req_id Request id

Line 1249: BOM_REFERENCE_DESIGNATORS

1245: req_id Request id
1246: user_id User id
1247: login_id Login id
1248: MODIFIES
1249: BOM_REFERENCE_DESIGNATORS
1250: BOM_REF_DESGS_INTERFACE
1251: RETURNS
1252: 0 if successful
1253: SQLCODE if error

Line 1309: INSERT into BOM_REFERENCE_DESIGNATORS

1305: ** Insert Reference Designators
1306: */
1307: stmt_num := 1;
1308: LOOP
1309: INSERT into BOM_REFERENCE_DESIGNATORS
1310: (
1311: COMPONENT_REFERENCE_DESIGNATOR,
1312: LAST_UPDATE_DATE,
1313: LAST_UPDATED_BY,

Line 1389: FROM bom_reference_designators brd

1385: AND (UPPER(interface_entity_type) = 'BILL'
1386: OR interface_entity_type is null)
1387: AND exists
1388: (SELECT null
1389: FROM bom_reference_designators brd
1390: WHERE brd.component_sequence_id = brdi.component_sequence_id
1391: AND brd.component_reference_designator =
1392: brdi.component_reference_designator
1393: AND nvl(brd.acd_type,999) = nvl(brdi.acd_type,999));

Line 1409: The 11.0 bug fix uses a HINT on BOM_REFERENCE_DESIGNATORS Table in the

1405: which is not required.
1406: So moving this outside the loop, this ensures that the process flag is
1407: updated to 7 for all processed rows only once after all the rows
1408: are inserted.
1409: The 11.0 bug fix uses a HINT on BOM_REFERENCE_DESIGNATORS Table in the
1410: update stmt to force the Unique Index. This might not be acceptable in 11.5
1411: given the difference in the optimizer. This is therefore removed in 11.5.
1412: If the 11.5 instance faces performance issues, this hint can be introduced
1413: to see if there is any performance benefit.

Line 1425: UPDATE bom_reference_designators

1421: WHILE continue_loop LOOP
1422: commit_cnt := 0;
1423: FOR c1rec IN c1 LOOP
1424: commit_cnt := commit_cnt + 1;
1425: UPDATE bom_reference_designators
1426: SET component_reference_designator = nvl(c1rec.ND, c1rec.CRD),
1427: ref_designator_comment = c1rec.RDC,
1428: last_update_date = c1rec.LUD,
1429: last_updated_by = c1rec.LUB,

Line 1477: DELETE FROM bom_reference_designators

1473: WHILE continue_loop LOOP
1474: commit_cnt := 0;
1475: FOR c2rec IN c2 LOOP
1476: commit_cnt := commit_cnt + 1;
1477: DELETE FROM bom_reference_designators
1478: WHERE component_sequence_id = c2rec.CSI
1479: AND component_reference_designator = c2rec.CRD;
1480:
1481: stmt_num := 7;