eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_COMPONENT_API dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 11: | BOM_INVENTORY_COMPS_INTERFACE table. |

7: | |
8: | File Name : BOMOICMB.pls |
9: | DESCRIPTION : This package contains functions used to assign, validate |
10: | and transact Compoennt data in the |
11: | BOM_INVENTORY_COMPS_INTERFACE table. |
12: | Parameters: org_id organization_id |
13: | all_org process all orgs or just current org |
14: | 1 - all orgs |
15: | 2 - only org_id |

Line 34: BOM_INVENTORY_COMPS_INTERFACE

30: Assign defaults and ID's to Component record in the interface table
31: REQUIRES
32: err_text out buffer to return error message
33: MODIFIES
34: BOM_INVENTORY_COMPS_INTERFACE
35: MTL_INTERFACE_ERRORS
36: RETURNS
37: 0 if successful
38: SQLCODE if unsuccessful

Line 81: FROM bom_inventory_comps_interface

77: operation_seq_num OSN,
78: to_char(effectivity_date, 'YYYY/MM/DD HH24:MI:SS') ED,
79: bom_item_type BIT, transaction_type A, WIP_SUPPLY_TYPE WST,
80: supply_subinventory SS
81: FROM bom_inventory_comps_interface
82: WHERE process_flag = 1
83: AND transaction_type = G_Insert
84: AND (UPPER(interface_entity_type) = 'BILL'
85: OR interface_entity_type is null)

Line 104: FROM bom_inventory_comps_interface

100: location_name LN, supply_locator_id SLI,
101: operation_seq_num OSN, assembly_type AST,
102: to_char(effectivity_date, 'YYYY/MM/DD HH24:MI:SS') ED,
103: bom_item_type BIT, transaction_type A
104: FROM bom_inventory_comps_interface
105: WHERE process_flag = 1
106: AND transaction_type in (G_UPDATE, G_DELETE)
107: AND (UPPER(interface_entity_type) = 'BILL'
108: OR interface_entity_type is null)

Line 118: UPDATE bom_inventory_comps_interface

114: BEGIN
115: /** G_INSERT is 'CREATE'. Update 'INSERT' to 'CREATE' **/
116: stmt_num := 0.5 ;
117: LOOP
118: UPDATE bom_inventory_comps_interface
119: SET transaction_type = G_Insert
120: WHERE process_flag = 1
121: AND upper(transaction_type) = 'INSERT'
122: AND rownum < G_rows_to_commit;

Line 132: UPDATE bom_inventory_comps_interface ori

128: ** ALL RECORDS - Assign Org Id
129: */
130: stmt_num := 1;
131: LOOP
132: UPDATE bom_inventory_comps_interface ori
133: SET organization_id = (SELECT organization_id
134: FROM mtl_parameters a
135: WHERE a.organization_code = ori.organization_code)
136: WHERE process_flag = 1

Line 155: UPDATE bom_inventory_comps_interface

151: ** FOR INSERTS - Assign transaction ids
152: */
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

Line 176: UPDATE bom_inventory_comps_interface

172: ** FOR UPDATES and DELETES - Assign transaction ids
173: */
174: stmt_num := 1;
175: LOOP
176: UPDATE bom_inventory_comps_interface
177: SET transaction_id = mtl_system_items_interface_s.nextval,
178: transaction_type = upper(transaction_type)
179: WHERE transaction_id is null
180: AND process_flag = 1

Line 218: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

214: prog_id => prog_id,
215: req_id => req_id,
216: trans_id => c1rec.TI,
217: error_text => err_text,
218: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
219: msg_name => 'BOM_ORG_ID_MISSING',
220: err_text => err_text);
221: UPDATE bom_inventory_comps_interface
222: SET process_flag = 3

Line 221: UPDATE bom_inventory_comps_interface

217: error_text => err_text,
218: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
219: msg_name => 'BOM_ORG_ID_MISSING',
220: err_text => err_text);
221: UPDATE bom_inventory_comps_interface
222: SET process_flag = 3
223: WHERE transaction_id = c1rec.TI;
224:
225: GOTO continue_loop;

Line 251: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

247: prog_id => prog_id,
248: req_id => req_id,
249: trans_id => c1rec.TI,
250: error_text => err_text,
251: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
252: msg_name => 'BOM_ASSY_ITEM_MISSING',
253: err_text => err_text);
254: UPDATE bom_inventory_comps_interface
255: SET process_flag = 3

Line 254: UPDATE bom_inventory_comps_interface

250: error_text => err_text,
251: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
252: msg_name => 'BOM_ASSY_ITEM_MISSING',
253: err_text => err_text);
254: UPDATE bom_inventory_comps_interface
255: SET process_flag = 3
256: WHERE transaction_id = c1rec.TI;
257:
258: IF (ret_code <> 0) THEN

Line 293: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

289: prog_id => prog_id,
290: req_id => req_id,
291: trans_id => c1rec.TI,
292: error_text => err_text,
293: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
294: msg_name => 'BOM_BILL_SEQ_MISSING',
295: err_text => err_text);
296: UPDATE bom_inventory_comps_interface
297: SET process_flag = 3

Line 296: UPDATE bom_inventory_comps_interface

292: error_text => err_text,
293: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
294: msg_name => 'BOM_BILL_SEQ_MISSING',
295: err_text => err_text);
296: UPDATE bom_inventory_comps_interface
297: SET process_flag = 3
298: WHERE transaction_id = c1rec.TI;
299:
300: IF (ret_code <> 0) THEN

Line 332: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

328: prog_id => prog_id,
329: req_id => req_id,
330: trans_id => c1rec.TI,
331: error_text => err_text,
332: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
333: msg_name => 'BOM_BILL_SEQ_MISSING',
334: err_text => err_text);
335: UPDATE bom_inventory_comps_interface
336: SET process_flag = 3

Line 335: UPDATE bom_inventory_comps_interface

331: error_text => err_text,
332: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
333: msg_name => 'BOM_BILL_SEQ_MISSING',
334: err_text => err_text);
335: UPDATE bom_inventory_comps_interface
336: SET process_flag = 3
337: WHERE transaction_id = c1rec.TI;
338:
339: IF (ret_code <> 0) THEN

Line 365: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

361: prog_id => prog_id,
362: req_id => req_id,
363: trans_id => c1rec.TI,
364: error_text => err_text,
365: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
366: msg_name => 'BOM_COMP_ID_MISSING',
367: err_text => err_text);
368: UPDATE bom_inventory_comps_interface
369: SET process_flag = 3

Line 368: UPDATE bom_inventory_comps_interface

364: error_text => err_text,
365: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
366: msg_name => 'BOM_COMP_ID_MISSING',
367: err_text => err_text);
368: UPDATE bom_inventory_comps_interface
369: SET process_flag = 3
370: WHERE transaction_id = c1rec.TI;
371:
372: IF (ret_code <> 0) THEN

Line 416: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

412: prog_id => prog_id,
413: req_id => req_id,
414: trans_id => c1rec.TI,
415: error_text => err_text,
416: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
417: msg_name => 'BOM_COMP_ID_MISSING',
418: err_text => err_text);
419:
420: UPDATE bom_inventory_comps_interface

Line 420: UPDATE bom_inventory_comps_interface

416: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
417: msg_name => 'BOM_COMP_ID_MISSING',
418: err_text => err_text);
419:
420: UPDATE bom_inventory_comps_interface
421: SET process_flag = 3
422: WHERE transaction_id = c1rec.TI;
423: IF (ret_code <> 0) THEN
424: RETURN(ret_code);

Line 461: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

457: prog_id => prog_id,
458: req_id => req_id,
459: trans_id => c1rec.TI,
460: error_text => err_text,
461: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
462: msg_name => 'BOM_COMP_ID_MISSING',
463: err_text => err_text);
464: UPDATE bom_inventory_comps_interface
465: SET process_flag = 3

Line 464: UPDATE bom_inventory_comps_interface

460: error_text => err_text,
461: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
462: msg_name => 'BOM_COMP_ID_MISSING',
463: err_text => err_text);
464: UPDATE bom_inventory_comps_interface
465: SET process_flag = 3
466: WHERE transaction_id = c1rec.TI;
467:
468: IF (ret_code <> 0) THEN

Line 497: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

493: prog_id => prog_id,
494: req_id => req_id,
495: trans_id => c1rec.TI,
496: error_text => err_text,
497: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
498: msg_name => 'BOM_EFF_DATE_MISSING',
499: err_text => err_text);
500: UPDATE bom_inventory_comps_interface
501: SET process_flag = 3

Line 500: UPDATE bom_inventory_comps_interface

496: error_text => err_text,
497: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
498: msg_name => 'BOM_EFF_DATE_MISSING',
499: err_text => err_text);
500: UPDATE bom_inventory_comps_interface
501: SET process_flag = 3
502: WHERE transaction_id = c1rec.TI;
503:
504: GOTO continue_loop;

Line 528: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

524: prog_id => prog_id,
525: req_id => req_id,
526: trans_id => c1rec.TI,
527: error_text => err_text,
528: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
529: msg_name => 'BOM_LOCATION_NAME_INVALID',
530: err_text => err_text);
531: UPDATE bom_inventory_comps_interface
532: SET process_flag = 3

Line 531: UPDATE bom_inventory_comps_interface

527: error_text => err_text,
528: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
529: msg_name => 'BOM_LOCATION_NAME_INVALID',
530: err_text => err_text);
531: UPDATE bom_inventory_comps_interface
532: SET process_flag = 3
533: WHERE transaction_id = c1rec.TI;
534:
535: IF (ret_code <> 0) THEN

Line 561: UPDATE bom_inventory_comps_interface

557: x_check_atp_default := 1;
558: END IF;
559:
560: /* end Bug 2243418 */
561: UPDATE bom_inventory_comps_interface
562: SET component_item_id = nvl(component_item_id, c1rec.CII),
563: item_num = nvl(item_num, 1),
564: component_quantity = nvl(component_quantity, 1),
565: component_yield_factor = nvl(component_yield_factor, 1),

Line 615: UPDATE bom_inventory_comps_interface

611: x_check_atp_default := 2;
612: END IF;
613: stmt_num := 11.1;
614:
615: UPDATE bom_inventory_comps_interface
616: SET component_item_id = nvl(component_item_id, c1rec.CII),
617: bill_sequence_id = nvl(bill_Sequence_id, c1rec.BSI),
618: assembly_item_id = nvl(assembly_item_id, c1rec.AII),
619: alternate_bom_designator = nvl(alternate_bom_designator,

Line 709: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

705: prog_id => prog_id,
706: req_id => req_id,
707: trans_id => c2rec.TI,
708: error_text => err_text,
709: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
710: msg_name => 'BOM_ORG_ID_MISSING',
711: err_text => err_text);
712: UPDATE bom_inventory_comps_interface
713: SET process_flag = 3

Line 712: UPDATE bom_inventory_comps_interface

708: error_text => err_text,
709: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
710: msg_name => 'BOM_ORG_ID_MISSING',
711: err_text => err_text);
712: UPDATE bom_inventory_comps_interface
713: SET process_flag = 3
714: WHERE transaction_id = c2rec.TI;
715:
716: IF (ret_code <> 0) THEN

Line 744: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

740: prog_id => prog_id,
741: req_id => req_id,
742: trans_id => c2rec.TI,
743: error_text => err_text,
744: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
745: msg_name => 'BOM_INV_ITEM_ID_MISSING',
746: err_text => err_text);
747: UPDATE bom_inventory_comps_interface
748: SET process_flag = 3

Line 747: UPDATE bom_inventory_comps_interface

743: error_text => err_text,
744: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
745: msg_name => 'BOM_INV_ITEM_ID_MISSING',
746: err_text => err_text);
747: UPDATE bom_inventory_comps_interface
748: SET process_flag = 3
749: WHERE transaction_id = c2rec.TI;
750:
751: IF (ret_code <> 0) THEN

Line 784: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

780: prog_id => prog_id,
781: req_id => req_id,
782: trans_id => c2rec.TI,
783: error_text => err_text,
784: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
785: msg_name => 'BOM_BILL_SEQ_MISSING',
786: err_text => err_text);
787: UPDATE bom_inventory_comps_interface
788: SET process_flag = 3

Line 787: UPDATE bom_inventory_comps_interface

783: error_text => err_text,
784: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
785: msg_name => 'BOM_BILL_SEQ_MISSING',
786: err_text => err_text);
787: UPDATE bom_inventory_comps_interface
788: SET process_flag = 3
789: WHERE transaction_id = c2rec.TI;
790:
791: IF (ret_code <> 0) THEN

Line 823: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

819: prog_id => prog_id,
820: req_id => req_id,
821: trans_id => c2rec.TI,
822: error_text => err_text,
823: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
824: msg_name => 'BOM_BILL_SEQ_MISSING',
825: err_text => err_text);
826: UPDATE bom_inventory_comps_interface
827: SET process_flag = 3

Line 826: UPDATE bom_inventory_comps_interface

822: error_text => err_text,
823: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
824: msg_name => 'BOM_BILL_SEQ_MISSING',
825: err_text => err_text);
826: UPDATE bom_inventory_comps_interface
827: SET process_flag = 3
828: WHERE transaction_id = c2rec.TI;
829:
830: IF (ret_code <> 0) THEN

Line 856: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

852: prog_id => prog_id,
853: req_id => req_id,
854: trans_id => c2rec.TI,
855: error_text => err_text,
856: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
857: msg_name => 'BOM_COMP_ID_MISSING',
858: err_text => err_text);
859: UPDATE bom_inventory_comps_interface
860: SET process_flag = 3

Line 859: UPDATE bom_inventory_comps_interface

855: error_text => err_text,
856: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
857: msg_name => 'BOM_COMP_ID_MISSING',
858: err_text => err_text);
859: UPDATE bom_inventory_comps_interface
860: SET process_flag = 3
861: WHERE transaction_id = c2rec.TI;
862:
863: IF (ret_code <> 0) THEN

Line 894: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

890: prog_id => prog_id,
891: req_id => req_id,
892: trans_id => c2rec.TI,
893: error_text => err_text,
894: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
895: msg_name => 'BOM_COMP_SEQ_MISSING',
896: err_text => err_text);
897: UPDATE bom_inventory_comps_interface
898: SET process_flag = 3

Line 897: UPDATE bom_inventory_comps_interface

893: error_text => err_text,
894: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
895: msg_name => 'BOM_COMP_SEQ_MISSING',
896: err_text => err_text);
897: UPDATE bom_inventory_comps_interface
898: SET process_flag = 3
899: WHERE transaction_id = c2rec.TI;
900:
901: IF (ret_code <> 0) THEN

Line 935: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

931: prog_id => prog_id,
932: req_id => req_id,
933: trans_id => c2rec.TI,
934: error_text => err_text,
935: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
936: msg_name => 'BOM_COMP_SEQ_MISSING',
937: err_text => err_text);
938: UPDATE bom_inventory_comps_interface
939: SET process_flag = 3

Line 938: UPDATE bom_inventory_comps_interface

934: error_text => err_text,
935: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
936: msg_name => 'BOM_COMP_SEQ_MISSING',
937: err_text => err_text);
938: UPDATE bom_inventory_comps_interface
939: SET process_flag = 3
940: WHERE transaction_id = c2rec.TI;
941:
942: IF (ret_code <> 0) THEN

Line 957: UPDATE bom_inventory_comps_interface

953: ** For Product Family Members
954: */
955: IF (x_bom_item_type = G_ProductFamily) THEN
956: stmt_num := 10.1;
957: UPDATE bom_inventory_comps_interface
958: SET component_sequence_id = c2rec.CSI,
959: component_item_id = c2rec.CII,
960: bill_sequence_id = c2rec.BSI,
961: organization_id = c2rec.OI,

Line 1005: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

1001: prog_id => prog_id,
1002: req_id => req_id,
1003: trans_id => c2rec.TI,
1004: error_text => err_text,
1005: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1006: msg_name => 'BOM_LOCATION_NAME_INVALID',
1007: err_text => err_text);
1008: UPDATE bom_inventory_comps_interface
1009: SET process_flag = 3

Line 1008: UPDATE bom_inventory_comps_interface

1004: error_text => err_text,
1005: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
1006: msg_name => 'BOM_LOCATION_NAME_INVALID',
1007: err_text => err_text);
1008: UPDATE bom_inventory_comps_interface
1009: SET process_flag = 3
1010: WHERE transaction_id = c2rec.TI;
1011:
1012: IF (ret_code <> 0) THEN

Line 1023: UPDATE bom_inventory_comps_interface

1019: /*
1020: ** Update "Update" record
1021: */
1022: stmt_num := 11;
1023: UPDATE bom_inventory_comps_interface
1024: SET component_sequence_id = c2rec.CSI,
1025: component_item_id = c2rec.CII,
1026: bill_sequence_id = c2rec.BSI,
1027: organization_id = c2rec.OI,

Line 1051: UPDATE bom_inventory_comps_interface

1047: RETURN(SQLCODE);
1048: END IF;
1049: ELSIF (c2rec.A = G_DELETE) THEN
1050: stmt_num := 8;
1051: UPDATE bom_inventory_comps_interface
1052: SET component_sequence_id = c2rec.CSI,
1053: component_item_id = c2rec.CII,
1054: bill_sequence_id = c2rec.BSI,
1055: organization_id = c2rec.OI,

Line 1119: FROM bom_inventory_comps_interface

1115: COMPONENT_SEQUENCE_ID,
1116: 1,
1117: G_Insert,
1118: COMPONENT_QUANTITY
1119: FROM bom_inventory_comps_interface
1120: WHERE process_flag = 2
1121: AND transaction_type = G_Insert
1122: AND (UPPER(interface_entity_type) = 'BILL'
1123: OR interface_entity_type is null)

Line 1162: FROM bom_inventory_comps_interface

1158: NVL(PROGRAM_UPDATE_DATE, sysdate),
1159: COMPONENT_SEQUENCE_ID,
1160: G_Insert,
1161: 1
1162: FROM bom_inventory_comps_interface
1163: WHERE process_flag = 2
1164: AND transaction_type = G_Insert
1165: AND (UPPER(interface_entity_type) = 'BILL'
1166: OR interface_entity_type is null)

Line 1273: FROM bom_inventory_comps_interface

1269: */
1270: stmt_num := 2;
1271: SELECT count(*)
1272: INTO dummy
1273: FROM bom_inventory_comps_interface
1274: WHERE component_sequence_id = cmp_seq_id
1275: AND (UPPER(interface_entity_type) = 'BILL'
1276: OR interface_entity_type is null)
1277: AND process_flag = 4;

Line 1369: FROM bom_inventory_comps_interface

1365: stmt_num := 2;
1366: BEGIN
1367: SELECT component_sequence_id
1368: INTO cnt
1369: FROM bom_inventory_comps_interface
1370: WHERE bill_sequence_id = bill_seq_id
1371: AND effectivity_date = to_date(eff_date,'YYYY/MM/DD HH24:MI:SS')
1372: AND component_item_id = cmp_item_id
1373: AND operation_seq_num = op_seq

Line 1453: FROM bom_inventory_comps_interface

1449: AND to_date(eff_date,'YYYY/MM/DD HH24:MI:SS') <
1450: nvl(disable_date,to_date(eff_date,'YYYY/MM/DD HH24:MI:SS')+1)))
1451: AND not exists -- Added for Bug 1929222
1452: ( SELECT null
1453: FROM bom_inventory_comps_interface
1454: WHERE bill_sequence_id = bom_id
1455: AND process_flag = 4
1456: AND component_item_id = cmp_id
1457: AND operation_seq_num = op_num

Line 1471: FROM bom_inventory_comps_interface

1467:
1468: stmt_num := 2;
1469: SELECT count(*)
1470: INTO dummy
1471: FROM bom_inventory_comps_interface
1472: WHERE bill_sequence_id = bom_id
1473: AND process_flag = 4
1474: AND transaction_type in (G_Insert, G_UPDATE)
1475: AND (UPPER(interface_entity_type) = 'BILL'

Line 1928: bom_inventory_comps_interface ici

1924: msia.atp_components_flag ACF,
1925: msic.ato_forecast_control AFC
1926: FROM mtl_system_items msic,
1927: mtl_system_items msia,
1928: bom_inventory_comps_interface ici
1929: WHERE process_flag = 2
1930: AND transaction_type = G_Insert
1931: AND (UPPER(ici.interface_entity_type) = 'BILL'
1932: OR ici.interface_entity_type is null)

Line 1985: bom_inventory_comps_interface ici

1981: msia.atp_components_flag ACF,
1982: msic.ato_forecast_control AFC
1983: FROM mtl_system_items msic,
1984: mtl_system_items msia,
1985: bom_inventory_comps_interface ici
1986: WHERE process_flag = 2
1987: AND transaction_type in (G_UPDATE, G_DELETE)
1988: AND (UPPER(ici.interface_entity_type) = 'BILL'
1989: OR ici.interface_entity_type is null)

Line 2025: bom_inventory_comps_interface ici

2021: msia.atp_components_flag ACF,
2022: msic.ato_forecast_control AFC
2023: FROM mtl_system_items msic,
2024: mtl_system_items msia,
2025: bom_inventory_comps_interface ici
2026: WHERE ici.process_flag = 99
2027: AND ici.transaction_type = G_Update
2028: AND (UPPER(ici.interface_entity_type) = 'BILL'
2029: OR ici.interface_entity_type is null)

Line 2106: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2102: prog_id => prog_id,
2103: req_id => req_id,
2104: trans_id => c2rec.TI,
2105: error_text => err_text,
2106: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2107: msg_name => 'BOM_COMP_RECORD_MISSING',
2108: err_text => err_text);
2109:
2110: UPDATE bom_inventory_comps_interface

Line 2110: UPDATE bom_inventory_comps_interface

2106: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2107: msg_name => 'BOM_COMP_RECORD_MISSING',
2108: err_text => err_text);
2109:
2110: UPDATE bom_inventory_comps_interface
2111: SET process_flag = 3
2112: WHERE transaction_id = c2rec.TI;
2113:
2114: IF (ret_code <> 0) THEN

Line 2149: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2145: prog_id => prog_id,
2146: req_id => req_id,
2147: trans_id => c2rec.TI,
2148: error_text => err_text,
2149: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2150: msg_name => 'BOM_ITEM_NUM_INVALID',
2151: err_text => err_text);
2152:
2153: UPDATE bom_inventory_comps_interface

Line 2153: UPDATE bom_inventory_comps_interface

2149: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2150: msg_name => 'BOM_ITEM_NUM_INVALID',
2151: err_text => err_text);
2152:
2153: UPDATE bom_inventory_comps_interface
2154: SET process_flag = 3
2155: WHERE transaction_id = c2rec.TI;
2156:
2157: IF (ret_code <> 0) THEN

Line 2214: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2210: prog_id => prog_id,
2211: req_id => req_id,
2212: trans_id => c2rec.TI,
2213: error_text => err_text,
2214: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2215: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2216: err_text => err_text);
2217:
2218: UPDATE bom_inventory_comps_interface

Line 2218: UPDATE bom_inventory_comps_interface

2214: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2215: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2216: err_text => err_text);
2217:
2218: UPDATE bom_inventory_comps_interface
2219: SET process_flag = 3
2220: WHERE transaction_id = c2rec.TI;
2221:
2222: IF (ret_code <> 0) THEN

Line 2233: UPDATE bom_inventory_comps_interface

2229: /*
2230: ** Update interface record with production record's values
2231: */
2232: stmt_num := 6;
2233: UPDATE bom_inventory_comps_interface
2234: SET operation_seq_num = X_operation_seq_num,
2235: component_item_id = X_component_item_id,
2236: creation_date = X_creation_date,
2237: created_by = X_created_by,

Line 2343: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2339: prog_id => prog_id,
2340: req_id => req_id,
2341: trans_id => c2rec.TI,
2342: error_text => err_text,
2343: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2344: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2345: err_text => err_text);
2346:
2347: UPDATE bom_inventory_comps_interface

Line 2347: UPDATE bom_inventory_comps_interface

2343: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2344: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2345: err_text => err_text);
2346:
2347: UPDATE bom_inventory_comps_interface
2348: SET process_flag = 3
2349: WHERE transaction_id = c2rec.TI;
2350:
2351: IF (ret_code <> 0) THEN

Line 2361: UPDATE bom_inventory_comps_interface

2357: /*
2358: ** Update interface record with production record's values
2359: */
2360: stmt_num := 6;
2361: UPDATE bom_inventory_comps_interface
2362: SET operation_seq_num = nvl(c2rec.NOSN, X_operation_seq_num),
2363: component_item_id = X_component_item_id,
2364: creation_date = X_creation_date,
2365: created_by = X_created_by,

Line 2459: UPDATE bom_inventory_comps_interface

2455: /*
2456: ** Set Process Flag to 4 for "Deletes"
2457: */
2458: stmt_num := 10;
2459: UPDATE bom_inventory_comps_interface
2460: SET process_flag = 4
2461: WHERE transaction_id = c2rec.TI;
2462: END IF;
2463: <>

Line 2501: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2497: prog_id => prog_id,
2498: req_id => req_id,
2499: trans_id => c3rec.TI,
2500: error_text => err_text,
2501: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2502: msg_name => 'BOM_COMPONENT_DUPLICATE',
2503: err_text => err_text);
2504: UPDATE bom_inventory_comps_interface
2505: SET process_flag = 3

Line 2504: UPDATE bom_inventory_comps_interface

2500: error_text => err_text,
2501: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2502: msg_name => 'BOM_COMPONENT_DUPLICATE',
2503: err_text => err_text);
2504: UPDATE bom_inventory_comps_interface
2505: SET process_flag = 3
2506: WHERE transaction_id = c3rec.TI;
2507:
2508: IF (ret_code <> 0) THEN

Line 2528: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2524: prog_id => prog_id,
2525: req_id => req_id,
2526: trans_id => c3rec.TI,
2527: error_text => err_text,
2528: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2529: msg_name => 'BOM_ITEM_NUM_INVALID',
2530: err_text => err_text);
2531:
2532: UPDATE bom_inventory_comps_interface

Line 2532: UPDATE bom_inventory_comps_interface

2528: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2529: msg_name => 'BOM_ITEM_NUM_INVALID',
2530: err_text => err_text);
2531:
2532: UPDATE bom_inventory_comps_interface
2533: SET process_flag = 3
2534: WHERE transaction_id = c3rec.TI;
2535:
2536: IF (ret_code <> 0) THEN

Line 2566: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2562: prog_id => prog_id,
2563: req_id => req_id,
2564: trans_id => c3rec.TI,
2565: error_text => err_text,
2566: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2567: msg_name => 'BOM_IMPL_COMP_OVERLAP',
2568: err_text => err_text);
2569: UPDATE bom_inventory_comps_interface
2570: SET process_flag = 3

Line 2569: UPDATE bom_inventory_comps_interface

2565: error_text => err_text,
2566: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2567: msg_name => 'BOM_IMPL_COMP_OVERLAP',
2568: err_text => err_text);
2569: UPDATE bom_inventory_comps_interface
2570: SET process_flag = 3
2571: WHERE transaction_id = c3rec.TI;
2572:
2573: IF (ret_code <> 0) THEN

Line 2594: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2590: prog_id => prog_id,
2591: req_id => req_id,
2592: trans_id => c3rec.TI,
2593: error_text => err_text,
2594: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2595: msg_name => 'BOM_EFFECTIVE_DATE_ERR',
2596: err_text => err_text);
2597: UPDATE bom_inventory_comps_interface
2598: SET process_flag = 3

Line 2597: UPDATE bom_inventory_comps_interface

2593: error_text => err_text,
2594: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2595: msg_name => 'BOM_EFFECTIVE_DATE_ERR',
2596: err_text => err_text);
2597: UPDATE bom_inventory_comps_interface
2598: SET process_flag = 3
2599: WHERE transaction_id = c3rec.TI;
2600:
2601: IF (ret_code <> 0) THEN

Line 2621: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2617: prog_id => prog_id,
2618: req_id => req_id,
2619: trans_id => c3rec.TI,
2620: error_text => err_text,
2621: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2622: msg_name => 'BOM_PLANNING_FACTOR',
2623: err_text => err_text);
2624: UPDATE bom_inventory_comps_interface
2625: SET process_flag = 3

Line 2624: UPDATE bom_inventory_comps_interface

2620: error_text => err_text,
2621: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2622: msg_name => 'BOM_PLANNING_FACTOR',
2623: err_text => err_text);
2624: UPDATE bom_inventory_comps_interface
2625: SET process_flag = 3
2626: WHERE transaction_id = c3rec.TI;
2627:
2628: IF (ret_code <> 0) THEN

Line 2648: update bom_inventory_comps_interface

2644: op_seq => c3rec.OSN,
2645: err_text => err_text);
2646:
2647: if(ret_code = 0 and c3rec.BITA <> G_ProductFamily) then -- This code is for bug 1804509
2648: update bom_inventory_comps_interface
2649: set operation_lead_time_percent =
2650: (select operation_lead_time_percent
2651: FROM bom_operation_sequences bos
2652: WHERE c3rec.OSN = bos.operation_seq_num

Line 2684: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2680: prog_id => prog_id,
2681: req_id => req_id,
2682: trans_id => c3rec.TI,
2683: error_text => err_text,
2684: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2685: msg_name => 'BOM_INVALID_OP_SEQ',
2686: err_text => err_text);
2687: UPDATE bom_inventory_comps_interface
2688: SET process_flag = 3

Line 2687: UPDATE bom_inventory_comps_interface

2683: error_text => err_text,
2684: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2685: msg_name => 'BOM_INVALID_OP_SEQ',
2686: err_text => err_text);
2687: UPDATE bom_inventory_comps_interface
2688: SET process_flag = 3
2689: WHERE transaction_id = c3rec.TI;
2690:
2691: IF (ret_code <> 0) THEN

Line 2722: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2718: prog_id => prog_id,
2719: req_id => req_id,
2720: trans_id => c3rec.TI,
2721: error_text => err_text,
2722: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2723: msg_name => 'BOM_PLANNING_FACTOR_ERR',
2724: err_text => err_text);
2725: UPDATE bom_inventory_comps_interface
2726: SET process_flag = 3

Line 2725: UPDATE bom_inventory_comps_interface

2721: error_text => err_text,
2722: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2723: msg_name => 'BOM_PLANNING_FACTOR_ERR',
2724: err_text => err_text);
2725: UPDATE bom_inventory_comps_interface
2726: SET process_flag = 3
2727: WHERE transaction_id = c3rec.TI;
2728:
2729: IF (ret_code <> 0) THEN

Line 2751: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2747: prog_id => prog_id,
2748: req_id => req_id,
2749: trans_id => c3rec.TI,
2750: error_text => err_text,
2751: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2752: msg_name => 'BOM_OPTIONAL_ERR',
2753: err_text => err_text);
2754: UPDATE bom_inventory_comps_interface
2755: SET process_flag = 3

Line 2754: UPDATE bom_inventory_comps_interface

2750: error_text => err_text,
2751: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2752: msg_name => 'BOM_OPTIONAL_ERR',
2753: err_text => err_text);
2754: UPDATE bom_inventory_comps_interface
2755: SET process_flag = 3
2756: WHERE transaction_id = c3rec.TI;
2757:
2758: IF (ret_code <> 0) THEN

Line 2769: UPDATE bom_inventory_comps_interface

2765: ** yield must be 1 and order entry values should be defaulted
2766: */
2767: stmt_num := 13;
2768: IF (c3rec.BITA = 3) THEN
2769: UPDATE bom_inventory_comps_interface
2770: SET component_yield_factor = 1,
2771: check_atp = 2,
2772: include_on_ship_docs = 2,
2773: so_basis = 2,

Line 2925: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

2921: prog_id => prog_id,
2922: req_id => req_id,
2923: trans_id => c3rec.TI,
2924: error_text => err_text,
2925: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2926: msg_name => 'BOM_COMPONENT_ERROR',
2927: err_text => err_text);
2928: UPDATE bom_inventory_comps_interface
2929: SET process_flag = 3

Line 2928: UPDATE bom_inventory_comps_interface

2924: error_text => err_text,
2925: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
2926: msg_name => 'BOM_COMPONENT_ERROR',
2927: err_text => err_text);
2928: UPDATE bom_inventory_comps_interface
2929: SET process_flag = 3
2930: WHERE transaction_id = c3rec.TI;
2931:
2932: IF (ret_code <> 0) THEN

Line 3285: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3281: prog_id => prog_id,
3282: req_id => req_id,
3283: trans_id => c3rec.TI,
3284: error_text => err_text,
3285: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3286: msg_name => 'BOM_QUANTITY_RELATED_INVALID',
3287: err_text => err_text);
3288: UPDATE bom_inventory_comps_interface
3289: SET process_flag = 3

Line 3288: UPDATE bom_inventory_comps_interface

3284: error_text => err_text,
3285: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3286: msg_name => 'BOM_QUANTITY_RELATED_INVALID',
3287: err_text => err_text);
3288: UPDATE bom_inventory_comps_interface
3289: SET process_flag = 3
3290: WHERE transaction_id = c3rec.TI;
3291:
3292: IF (ret_code <> 0) THEN

Line 3318: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3314: prog_id => prog_id,
3315: req_id => req_id,
3316: trans_id => c3rec.TI,
3317: error_text => err_text,
3318: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3319: msg_name => 'BOM_LOCATOR_INVALID',
3320: err_text => err_text);
3321: UPDATE bom_inventory_comps_interface
3322: SET process_flag = 3

Line 3321: UPDATE bom_inventory_comps_interface

3317: error_text => err_text,
3318: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3319: msg_name => 'BOM_LOCATOR_INVALID',
3320: err_text => err_text);
3321: UPDATE bom_inventory_comps_interface
3322: SET process_flag = 3
3323: WHERE transaction_id = c3rec.TI;
3324:
3325: IF (ret_code <> 0) THEN

Line 3339: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3335: prog_id => prog_id,
3336: req_id => req_id,
3337: trans_id => c3rec.TI,
3338: error_text => err_text,
3339: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3340: msg_name => 'BOM_SUBINV_INVALID',
3341: err_text => err_text);
3342: UPDATE bom_inventory_comps_interface
3343: SET process_flag = 3

Line 3342: UPDATE bom_inventory_comps_interface

3338: error_text => err_text,
3339: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3340: msg_name => 'BOM_SUBINV_INVALID',
3341: err_text => err_text);
3342: UPDATE bom_inventory_comps_interface
3343: SET process_flag = 3
3344: WHERE transaction_id = c3rec.TI;
3345:
3346: IF (ret_code <> 0) THEN

Line 3352: UPDATE bom_inventory_comps_interface

3348: END IF;
3349:
3350: WHEN Update_Comp THEN
3351: stmt_num := 29;
3352: UPDATE bom_inventory_comps_interface
3353: SET process_flag = 4
3354: WHERE transaction_id = c3rec.TI;
3355:
3356: WHEN Continue_Loop2 THEN

Line 3393: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3389: prog_id => prog_id,
3390: req_id => req_id,
3391: trans_id => c1rec.TI,
3392: error_text => err_text,
3393: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3394: msg_name => 'BOM_COMP_COUNT_EXCEEDS_LIMIT',
3395: err_text => err_text);
3396: UPDATE bom_inventory_comps_interface
3397: SET process_flag = 3

Line 3396: UPDATE bom_inventory_comps_interface

3392: error_text => err_text,
3393: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3394: msg_name => 'BOM_COMP_COUNT_EXCEEDS_LIMIT',
3395: err_text => err_text);
3396: UPDATE bom_inventory_comps_interface
3397: SET process_flag = 3
3398: WHERE transaction_id = c1rec.TI;
3399:
3400: IF (ret_code <> 0) THEN

Line 3422: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3418: prog_id => prog_id,
3419: req_id => req_id,
3420: trans_id => c1rec.TI,
3421: error_text => err_text,
3422: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3423: msg_name => 'BOM_COMP_SEQ_ID_DUPLICATE',
3424: err_text => err_text);
3425: UPDATE bom_inventory_comps_interface
3426: SET process_flag = 3

Line 3425: UPDATE bom_inventory_comps_interface

3421: error_text => err_text,
3422: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3423: msg_name => 'BOM_COMP_SEQ_ID_DUPLICATE',
3424: err_text => err_text);
3425: UPDATE bom_inventory_comps_interface
3426: SET process_flag = 3
3427: WHERE transaction_id = c1rec.TI;
3428:
3429: IF (ret_code <> 0) THEN

Line 3456: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3452: prog_id => prog_id,
3453: req_id => req_id,
3454: trans_id => c1rec.TI,
3455: error_text => err_text,
3456: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3457: msg_name => 'BOM_COMPONENT_DUPLICATE',
3458: err_text => err_text);
3459: UPDATE bom_inventory_comps_interface
3460: SET process_flag = 3

Line 3459: UPDATE bom_inventory_comps_interface

3455: error_text => err_text,
3456: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3457: msg_name => 'BOM_COMPONENT_DUPLICATE',
3458: err_text => err_text);
3459: UPDATE bom_inventory_comps_interface
3460: SET process_flag = 3
3461: WHERE transaction_id = c1rec.TI;
3462:
3463: IF (ret_code <> 0) THEN

Line 3493: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3489: prog_id => prog_id,
3490: req_id => req_id,
3491: trans_id => c1rec.TI,
3492: error_text => err_text,
3493: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3494: msg_name => 'BOM_IMPL_COMP_OVERLAP',
3495: err_text => err_text);
3496: UPDATE bom_inventory_comps_interface
3497: SET process_flag = 3

Line 3496: UPDATE bom_inventory_comps_interface

3492: error_text => err_text,
3493: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3494: msg_name => 'BOM_IMPL_COMP_OVERLAP',
3495: err_text => err_text);
3496: UPDATE bom_inventory_comps_interface
3497: SET process_flag = 3
3498: WHERE transaction_id = c1rec.TI;
3499:
3500: IF (ret_code <> 0) THEN

Line 3521: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3517: prog_id => prog_id,
3518: req_id => req_id,
3519: trans_id => c1rec.TI,
3520: error_text => err_text,
3521: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3522: msg_name => 'BOM_EFFECTIVE_DATE_ERR',
3523: err_text => err_text);
3524: UPDATE bom_inventory_comps_interface
3525: SET process_flag = 3

Line 3524: UPDATE bom_inventory_comps_interface

3520: error_text => err_text,
3521: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3522: msg_name => 'BOM_EFFECTIVE_DATE_ERR',
3523: err_text => err_text);
3524: UPDATE bom_inventory_comps_interface
3525: SET process_flag = 3
3526: WHERE transaction_id = c1rec.TI;
3527:
3528: IF (ret_code <> 0) THEN

Line 3562: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3558: prog_id => prog_id,
3559: req_id => req_id,
3560: trans_id => c1rec.TI,
3561: error_text => err_text,
3562: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3563: msg_name => 'BOM_ASSY_ITEM_MISSING',
3564: err_text => err_text);
3565: UPDATE bom_bill_of_mtls_interface
3566: SET process_flag = 3

Line 3591: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3587: prog_id => prog_id,
3588: req_id => req_id,
3589: trans_id => c1rec.TI,
3590: error_text => err_text,
3591: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3592: msg_name => 'BOM_PLANNING_FACTOR',
3593: err_text => err_text);
3594: UPDATE bom_inventory_comps_interface
3595: SET process_flag = 3

Line 3594: UPDATE bom_inventory_comps_interface

3590: error_text => err_text,
3591: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3592: msg_name => 'BOM_PLANNING_FACTOR',
3593: err_text => err_text);
3594: UPDATE bom_inventory_comps_interface
3595: SET process_flag = 3
3596: WHERE transaction_id = c1rec.TI;
3597:
3598: IF (ret_code <> 0) THEN

Line 3636: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3632: prog_id => prog_id,
3633: req_id => req_id,
3634: trans_id => c1rec.TI,
3635: error_text => err_text,
3636: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3637: msg_name => 'BOM_INVALID_ITEM_ATTRIBUTES',
3638: err_text => err_text);
3639: UPDATE bom_inventory_comps_interface
3640: SET process_flag = 3

Line 3639: UPDATE bom_inventory_comps_interface

3635: error_text => err_text,
3636: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3637: msg_name => 'BOM_INVALID_ITEM_ATTRIBUTES',
3638: err_text => err_text);
3639: UPDATE bom_inventory_comps_interface
3640: SET process_flag = 3
3641: WHERE transaction_id = c1rec.TI;
3642:
3643: IF (ret_code <> 0) THEN

Line 3674: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3670: prog_id => prog_id,
3671: req_id => req_id,
3672: trans_id => c1rec.TI,
3673: error_text => err_text,
3674: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3675: msg_name => 'BOM_COMMON_COMP',
3676: err_text => err_text);
3677: UPDATE bom_inventory_comps_interface
3678: SET process_flag = 3

Line 3677: UPDATE bom_inventory_comps_interface

3673: error_text => err_text,
3674: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3675: msg_name => 'BOM_COMMON_COMP',
3676: err_text => err_text);
3677: UPDATE bom_inventory_comps_interface
3678: SET process_flag = 3
3679: WHERE transaction_id = c1rec.TI;
3680:
3681: IF (ret_code <> 0) THEN

Line 3726: UPDATE bom_inventory_comps_interface

3722: error_text => err_text,
3723: tbl_name => 'BOM_INV_COMPS_INTERFACE',
3724: msg_name => 'BOM_COMP_COMMON_INVALID',
3725: err_text => err_text);
3726: UPDATE bom_inventory_comps_interface
3727: SET process_flag = 3
3728: WHERE transaction_id = c1rec.TI;
3729:
3730: IF (ret_code <> 0) THEN

Line 3772: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3768: prog_id => prog_id,
3769: req_id => req_id,
3770: trans_id => c1rec.TI,
3771: error_text => err_text,
3772: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3773: msg_name => 'BOM_INVALID_ITEM_ATTRIBUTES',
3774: err_text => err_text);
3775: UPDATE bom_inventory_comps_interface
3776: SET process_flag = 3

Line 3775: UPDATE bom_inventory_comps_interface

3771: error_text => err_text,
3772: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3773: msg_name => 'BOM_INVALID_ITEM_ATTRIBUTES',
3774: err_text => err_text);
3775: UPDATE bom_inventory_comps_interface
3776: SET process_flag = 3
3777: WHERE transaction_id = c1rec.TI;
3778:
3779: IF (ret_code <> 0) THEN

Line 3796: update bom_inventory_comps_interface

3792: op_seq => c1rec.OSN,
3793: err_text => err_text);
3794: --bugFix 1851537 Begin
3795: if (ret_code=0) then
3796: update bom_inventory_comps_interface
3797: set operation_lead_time_percent =
3798: (select operation_lead_time_percent
3799: FROM bom_operation_sequences bos
3800: WHERE c1rec.OSN = bos.operation_seq_num

Line 3833: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3829: prog_id => prog_id,
3830: req_id => req_id,
3831: trans_id => c1rec.TI,
3832: error_text => err_text,
3833: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3834: msg_name => 'BOM_INVALID_OP_SEQ',
3835: err_text => err_text);
3836: UPDATE bom_inventory_comps_interface
3837: SET process_flag = 3

Line 3836: UPDATE bom_inventory_comps_interface

3832: error_text => err_text,
3833: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3834: msg_name => 'BOM_INVALID_OP_SEQ',
3835: err_text => err_text);
3836: UPDATE bom_inventory_comps_interface
3837: SET process_flag = 3
3838: WHERE transaction_id = c1rec.TI;
3839:
3840: IF (ret_code <> 0) THEN

Line 3871: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3867: prog_id => prog_id,
3868: req_id => req_id,
3869: trans_id => c1rec.TI,
3870: error_text => err_text,
3871: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3872: msg_name => 'BOM_PLANNING_FACTOR_ERR',
3873: err_text => err_text);
3874: UPDATE bom_inventory_comps_interface
3875: SET process_flag = 3

Line 3874: UPDATE bom_inventory_comps_interface

3870: error_text => err_text,
3871: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3872: msg_name => 'BOM_PLANNING_FACTOR_ERR',
3873: err_text => err_text);
3874: UPDATE bom_inventory_comps_interface
3875: SET process_flag = 3
3876: WHERE transaction_id = c1rec.TI;
3877:
3878: IF (ret_code <> 0) THEN

Line 3908: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3904: prog_id => prog_id,
3905: req_id => req_id,
3906: trans_id => c1rec.TI,
3907: error_text => err_text,
3908: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3909: msg_name => 'ENG_PARENTECO_NOT_EXIST',
3910: err_text => err_text);
3911: UPDATE bom_inventory_comps_interface
3912: SET process_flag = 3

Line 3911: UPDATE bom_inventory_comps_interface

3907: error_text => err_text,
3908: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3909: msg_name => 'ENG_PARENTECO_NOT_EXIST',
3910: err_text => err_text);
3911: UPDATE bom_inventory_comps_interface
3912: SET process_flag = 3
3913: WHERE transaction_id = c1rec.TI;
3914:
3915: IF (ret_code <> 0) THEN

Line 3939: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

3935: prog_id => prog_id,
3936: req_id => req_id,
3937: trans_id => c1rec.TI,
3938: error_text => err_text,
3939: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3940: msg_name => 'BOM_OPTIONAL_ERR',
3941: err_text => err_text);
3942: UPDATE bom_inventory_comps_interface
3943: SET process_flag = 3

Line 3942: UPDATE bom_inventory_comps_interface

3938: error_text => err_text,
3939: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
3940: msg_name => 'BOM_OPTIONAL_ERR',
3941: err_text => err_text);
3942: UPDATE bom_inventory_comps_interface
3943: SET process_flag = 3
3944: WHERE transaction_id = c1rec.TI;
3945:
3946: IF (ret_code <> 0) THEN

Line 3957: UPDATE bom_inventory_comps_interface

3953: ** yield must be 1 and order entry values should be defaulted
3954: */
3955: stmt_num := 13;
3956: IF (c1rec.BITA = 3) THEN
3957: UPDATE bom_inventory_comps_interface
3958: SET component_yield_factor = 1,
3959: check_atp = 2,
3960: include_on_ship_docs = 2,
3961: so_basis = 2,

Line 4115: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

4111: prog_id => prog_id,
4112: req_id => req_id,
4113: trans_id => c1rec.TI,
4114: error_text => err_text,
4115: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
4116: msg_name => 'BOM_COMPONENT_ERROR',
4117: err_text => err_text);
4118: UPDATE bom_inventory_comps_interface
4119: SET process_flag = 3

Line 4118: UPDATE bom_inventory_comps_interface

4114: error_text => err_text,
4115: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
4116: msg_name => 'BOM_COMPONENT_ERROR',
4117: err_text => err_text);
4118: UPDATE bom_inventory_comps_interface
4119: SET process_flag = 3
4120: WHERE transaction_id = c1rec.TI;
4121:
4122: IF (ret_code <> 0) THEN

Line 4457: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

4453: prog_id => prog_id,
4454: req_id => req_id,
4455: trans_id => c1rec.TI,
4456: error_text => err_text,
4457: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
4458: msg_name => 'BOM_LOCATOR_INVALID',
4459: err_text => err_text);
4460: UPDATE bom_inventory_comps_interface
4461: SET process_flag = 3

Line 4460: UPDATE bom_inventory_comps_interface

4456: error_text => err_text,
4457: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
4458: msg_name => 'BOM_LOCATOR_INVALID',
4459: err_text => err_text);
4460: UPDATE bom_inventory_comps_interface
4461: SET process_flag = 3
4462: WHERE transaction_id = c1rec.TI;
4463:
4464: IF (ret_code <> 0) THEN

Line 4478: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',

4474: prog_id => prog_id,
4475: req_id => req_id,
4476: trans_id => c1rec.TI,
4477: error_text => err_text,
4478: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
4479: msg_name => 'BOM_SUBINV_INVALID',
4480: err_text => err_text);
4481: UPDATE bom_inventory_comps_interface
4482: SET process_flag = 3

Line 4481: UPDATE bom_inventory_comps_interface

4477: error_text => err_text,
4478: tbl_name => 'BOM_INVENTORY_COMPS_INTERFACE',
4479: msg_name => 'BOM_SUBINV_INVALID',
4480: err_text => err_text);
4481: UPDATE bom_inventory_comps_interface
4482: SET process_flag = 3
4483: WHERE transaction_id = c1rec.TI;
4484:
4485: IF (ret_code <> 0) THEN

Line 4491: UPDATE bom_inventory_comps_interface

4487: END IF;
4488:
4489: WHEN Update_Comp THEN
4490: stmt_num := 29;
4491: UPDATE bom_inventory_comps_interface
4492: SET process_flag = 4
4493: WHERE transaction_id = c1rec.TI;
4494:
4495: WHEN Continue_Loop THEN

Line 4520: table, BOM_INVENTORY_COMPS_INTERFACE, into the production table,

4516: NAME
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

Line 4530: BOM_INVENTORY_COMPS_INTERFACE

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
4534: NOTES

Line 4599: bom_inventory_comps_interface bic

4595: FROM
4596: bom_bill_of_materials bom,
4597: mtl_system_items msi1,
4598: mtl_system_items msi2,
4599: bom_inventory_comps_interface bic
4600: WHERE bic.process_flag = 4
4601: AND bic.transaction_type = G_Insert
4602: AND rownum < G_rows_to_commit
4603: AND (UPPER(bic.interface_entity_type) = 'BILL'

Line 4634: FROM bom_inventory_comps_interface

4630: attribute11 A11, attribute12 A12, attribute13 A13,
4631: attribute14 A14, attribute15 A15, request_id RI,
4632: program_application_id PAI, program_id PI,
4633: program_update_date PUD, transaction_id TI
4634: FROM bom_inventory_comps_interface
4635: WHERE process_flag = 4
4636: AND transaction_type = G_UPDATE
4637: AND (UPPER(interface_entity_type) = 'BILL'
4638: OR interface_entity_type is null)

Line 4652: bom_inventory_comps_interface bic

4648: msi.bom_item_type BIT, msic.bom_item_type BITC,
4649: bic.component_item_id CII
4650: FROM mtl_system_items msi,
4651: mtl_system_items msic,
4652: bom_inventory_comps_interface bic
4653: WHERE bic.process_flag = 4
4654: AND bic.transaction_type = G_DELETE
4655: AND (UPPER(bic.interface_entity_type) = 'BILL'
4656: OR bic.interface_entity_type is null)

Line 4800: UPDATE bom_inventory_comps_interface

4796: AND organization_id = c0rec.OI;
4797: END;
4798: END IF;
4799:
4800: UPDATE bom_inventory_comps_interface
4801: SET process_flag = 7
4802: WHERE transaction_id = c0rec.TI;
4803: END LOOP;
4804:

Line 4872: UPDATE bom_inventory_comps_interface

4868: program_update_date = c1rec.PUD
4869: WHERE component_sequence_id = c1rec.CSI;
4870:
4871: stmt_num := 64;
4872: UPDATE bom_inventory_comps_interface
4873: SET process_flag = 7
4874: WHERE transaction_id = c1rec.TI;
4875: END LOOP;
4876:

Line 4983: UPDATE bom_inventory_comps_interface

4979: err_text => err_text);
4980: END IF; -- Check if Member or Component
4981:
4982: stmt_num := 34;
4983: UPDATE bom_inventory_comps_interface
4984: SET process_flag = 7
4985: WHERE transaction_id = c2rec.TI;
4986: END LOOP;
4987:

Line 5014: interface table, BOM_INVENTORY_COMPS_INTERFACE.

5010: NAME
5011: Import_Component
5012: DESCRIPTION
5013: Assign, Validate, and Transact the Component record in the
5014: interface table, BOM_INVENTORY_COMPS_INTERFACE.
5015: REQUIRES
5016: err_text out buffer to return error message
5017: MODIFIES
5018: RETURNS

Line 5093: DELETE from bom_inventory_comps_interface

5089:
5090: stmt_num := 4;
5091: IF (del_rec_flag = 1) THEN
5092: LOOP
5093: DELETE from bom_inventory_comps_interface
5094: WHERE process_flag = 7
5095: AND (UPPER(interface_entity_type) = 'BILL'
5096: OR interface_entity_type is null)
5097: AND rownum < G_rows_to_commit;