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_BILL_API dependencies on BOM_BILL_OF_MTLS_INTERFACE

Line 72: FROM bom_bill_of_mtls_interface

68: bill_sequence_id BSI, common_bill_sequence_id CBSI,
69: revision R, last_update_date LUD, last_updated_by LUB,
70: creation_date CD, created_by CB, last_update_login LUL,
71: transaction_type A, assembly_type AST
72: FROM bom_bill_of_mtls_interface
73: WHERE process_flag = 1
74: AND transaction_type = G_Insert
75: AND (all_org = 1
76: OR

Line 93: FROM bom_bill_of_mtls_interface

89: bill_sequence_id BSI, common_bill_sequence_id CBSI,
90: revision R, last_update_date LUD, last_updated_by LUB,
91: creation_date CD, created_by CB, last_update_login LUL,
92: transaction_type A, assembly_type AST
93: FROM bom_bill_of_mtls_interface
94: WHERE process_flag = 1
95: AND transaction_type in (G_Update, G_Delete)
96: AND (all_org = 1
97: OR

Line 105: UPDATE bom_bill_of_mtls_interface

101: BEGIN
102: /** G_INSERT is 'CREATE'. Update 'INSERT' to 'CREATE' **/
103: stmt_num := 0.5 ;
104: LOOP
105: UPDATE bom_bill_of_mtls_interface
106: SET transaction_type = G_Insert
107: WHERE process_flag = 1
108: AND upper(transaction_type) = 'INSERT'
109: AND rownum < G_rows_to_commit;

Line 119: UPDATE bom_bill_of_mtls_interface ori

115: ** ALL RECORDS - Assign Org Id
116: */
117: stmt_num := 1;
118: LOOP
119: UPDATE bom_bill_of_mtls_interface ori
120: SET organization_id = (SELECT organization_id
121: FROM mtl_parameters a
122: WHERE a.organization_code = ori.organization_code)
123: WHERE process_flag = 1

Line 140: UPDATE bom_bill_of_mtls_interface ori

136: ** FOR ALL - Assign transaction ids and bill sequence ids
137: */
138: stmt_num := 2;
139: LOOP
140: UPDATE bom_bill_of_mtls_interface ori
141: SET transaction_id = mtl_system_items_interface_s.nextval,
142: transaction_type = upper(transaction_type),
143: bill_sequence_id = decode(upper(transaction_type), G_Insert,
144: bom_inventory_components_s.nextval,

Line 177: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

173: prog_id => prog_id,
174: req_id => req_id,
175: trans_id => c1rec.TI,
176: error_text => err_text,
177: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
178: msg_name => 'BOM_ORG_ID_MISSING',
179: err_text => err_text);
180: UPDATE bom_bill_of_mtls_interface
181: SET process_flag = 3

Line 180: UPDATE bom_bill_of_mtls_interface

176: error_text => err_text,
177: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
178: msg_name => 'BOM_ORG_ID_MISSING',
179: err_text => err_text);
180: UPDATE bom_bill_of_mtls_interface
181: SET process_flag = 3
182: WHERE transaction_id = c1rec.TI;
183:
184: GOTO continue_loop1;

Line 208: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

204: prog_id => prog_id,
205: req_id => req_id,
206: trans_id => c1rec.TI,
207: error_text => err_text,
208: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
209: msg_name => 'BOM_ASSY_ITEM_MISSING',
210: err_text => err_text);
211: UPDATE bom_bill_of_mtls_interface
212: SET process_flag = 3

Line 211: UPDATE bom_bill_of_mtls_interface

207: error_text => err_text,
208: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
209: msg_name => 'BOM_ASSY_ITEM_MISSING',
210: err_text => err_text);
211: UPDATE bom_bill_of_mtls_interface
212: SET process_flag = 3
213: WHERE transaction_id = c1rec.TI;
214:
215: IF (ret_code <> 0) THEN

Line 246: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

242: prog_id => prog_id,
243: req_id => req_id,
244: trans_id => c1rec.TI,
245: error_text => err_text,
246: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
247: msg_name => 'BOM_ASSY_ITEM_MISSING',
248: err_text => err_text);
249: UPDATE bom_bill_of_mtls_interface
250: SET process_flag = 3

Line 249: UPDATE bom_bill_of_mtls_interface

245: error_text => err_text,
246: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
247: msg_name => 'BOM_ASSY_ITEM_MISSING',
248: err_text => err_text);
249: UPDATE bom_bill_of_mtls_interface
250: SET process_flag = 3
251: WHERE transaction_id = c1rec.TI;
252:
253: IF (ret_code <> 0) THEN

Line 300: UPDATE bom_bill_of_mtls_interface

296: sysdate);
297: END IF;
298:
299: stmt_num := 5.3;
300: UPDATE bom_bill_of_mtls_interface
301: SET organization_id = nvl(organization_id, c1rec.OI),
302: assembly_item_id = nvl(assembly_item_id, c1rec.AII),
303: alternate_bom_designator = null,
304: specific_assembly_comment = null,

Line 346: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

342: prog_id => prog_id,
343: req_id => req_id,
344: trans_id => c1rec.TI,
345: error_text => err_text,
346: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
347: msg_name => 'BOM_COMMON_ORG_MISSING',
348: err_text => err_text);
349: UPDATE bom_bill_of_mtls_interface
350: SET process_flag = 3

Line 349: UPDATE bom_bill_of_mtls_interface

345: error_text => err_text,
346: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
347: msg_name => 'BOM_COMMON_ORG_MISSING',
348: err_text => err_text);
349: UPDATE bom_bill_of_mtls_interface
350: SET process_flag = 3
351: WHERE transaction_id = c1rec.TI;
352:
353: IF (ret_code <> 0) THEN

Line 380: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

376: prog_id => prog_id,
377: req_id => req_id,
378: trans_id => c1rec.TI,
379: error_text => err_text,
380: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
381: msg_name => 'BOM_COMMON_ORG_MISSING',
382: err_text => err_text);
383: UPDATE bom_bill_of_mtls_interface
384: SET process_flag = 3

Line 383: UPDATE bom_bill_of_mtls_interface

379: error_text => err_text,
380: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
381: msg_name => 'BOM_COMMON_ORG_MISSING',
382: err_text => err_text);
383: UPDATE bom_bill_of_mtls_interface
384: SET process_flag = 3
385: WHERE transaction_id = c1rec.TI;
386:
387: IF (ret_code <> 0) THEN

Line 419: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

415: prog_id => prog_id,
416: req_id => req_id,
417: trans_id => c1rec.TI,
418: error_text => err_text,
419: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
420: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
421: err_text => err_text);
422: UPDATE bom_bill_of_mtls_interface
423: SET process_flag = 3

Line 422: UPDATE bom_bill_of_mtls_interface

418: error_text => err_text,
419: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
420: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
421: err_text => err_text);
422: UPDATE bom_bill_of_mtls_interface
423: SET process_flag = 3
424: WHERE transaction_id = c1rec.TI;
425:
426: IF (ret_code <> 0) THEN

Line 459: FROM bom_bill_of_mtls_interface

455: stmt_num := 9;
456: BEGIN
457: SELECT bill_sequence_id
458: INTO c1rec.CBSI
459: FROM bom_bill_of_mtls_interface
460: WHERE organization_id = nvl(c1rec.COI, c1rec.OI)
461: AND transaction_type = G_Insert
462: AND assembly_item_id = c1rec.CAII
463: AND nvl(alternate_bom_designator, 'NONE') =

Line 478: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

474: prog_id => prog_id,
475: req_id => req_id,
476: trans_id => c1rec.TI,
477: error_text => err_text,
478: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
479: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
480: err_text => err_text);
481:
482: UPDATE bom_bill_of_mtls_interface

Line 482: UPDATE bom_bill_of_mtls_interface

478: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
479: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
480: err_text => err_text);
481:
482: UPDATE bom_bill_of_mtls_interface
483: SET process_flag = 3
484: WHERE transaction_id = c1rec.TI;
485:
486: IF (ret_code <> 0) THEN

Line 509: FROM bom_bill_of_mtls_interface

505: stmt_num := 11;
506: BEGIN
507: SELECT assembly_item_id, organization_id
508: INTO c1rec.CAII, c1rec.COI
509: FROM bom_bill_of_mtls_interface
510: WHERE bill_sequence_id = c1rec.CBSI
511: AND transaction_type = G_Insert
512: AND process_flag not in (3,7)
513: AND rownum = 1;

Line 525: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

521: prog_id => prog_id,
522: req_id => req_id,
523: trans_id => c1rec.TI,
524: error_text => err_text,
525: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
526: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
527: err_text => err_text);
528: UPDATE bom_bill_of_mtls_interface
529: SET process_flag = 3

Line 528: UPDATE bom_bill_of_mtls_interface

524: error_text => err_text,
525: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
526: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
527: err_text => err_text);
528: UPDATE bom_bill_of_mtls_interface
529: SET process_flag = 3
530: WHERE transaction_id = c1rec.TI;
531:
532: IF (ret_code <> 0) THEN

Line 586: UPDATE bom_bill_of_mtls_interface

582: sysdate);
583: END IF;
584:
585: stmt_num := 13;
586: UPDATE bom_bill_of_mtls_interface
587: SET organization_id = nvl(organization_id, c1rec.OI),
588: assembly_item_id = nvl(assembly_item_id, c1rec.AII),
589: common_bill_sequence_id = c1rec.CBSI,
590: common_organization_id = c1rec.COI,

Line 650: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

646: prog_id => prog_id,
647: req_id => req_id,
648: trans_id => c2rec.TI,
649: error_text => err_text,
650: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
651: msg_name => 'BOM_ORG_ID_MISSING',
652: err_text => err_text);
653: UPDATE bom_bill_of_mtls_interface
654: SET process_flag = 3

Line 653: UPDATE bom_bill_of_mtls_interface

649: error_text => err_text,
650: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
651: msg_name => 'BOM_ORG_ID_MISSING',
652: err_text => err_text);
653: UPDATE bom_bill_of_mtls_interface
654: SET process_flag = 3
655: WHERE transaction_id = c2rec.TI;
656:
657: IF (ret_code <> 0) THEN

Line 683: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

679: prog_id => prog_id,
680: req_id => req_id,
681: trans_id => c2rec.TI,
682: error_text => err_text,
683: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
684: msg_name => 'BOM_INV_ITEM_ID_MISSING',
685: err_text => err_text);
686: UPDATE bom_bill_of_mtls_interface
687: SET process_flag = 3

Line 686: UPDATE bom_bill_of_mtls_interface

682: error_text => err_text,
683: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
684: msg_name => 'BOM_INV_ITEM_ID_MISSING',
685: err_text => err_text);
686: UPDATE bom_bill_of_mtls_interface
687: SET process_flag = 3
688: WHERE transaction_id = c2rec.TI;
689:
690: IF (ret_code <> 0) THEN

Line 723: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

719: prog_id => prog_id,
720: req_id => req_id,
721: trans_id => c2rec.TI,
722: error_text => err_text,
723: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
724: msg_name => 'BOM_BILL_SEQ_MISSING',
725: err_text => err_text);
726: UPDATE bom_bill_of_mtls_interface
727: SET process_flag = 3

Line 726: UPDATE bom_bill_of_mtls_interface

722: error_text => err_text,
723: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
724: msg_name => 'BOM_BILL_SEQ_MISSING',
725: err_text => err_text);
726: UPDATE bom_bill_of_mtls_interface
727: SET process_flag = 3
728: WHERE transaction_id = c2rec.TI;
729:
730: IF (ret_code <> 0) THEN

Line 762: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

758: prog_id => prog_id,
759: req_id => req_id,
760: trans_id => c2rec.TI,
761: error_text => err_text,
762: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
763: msg_name => 'BOM_BILL_SEQ_MISSING',
764: err_text => err_text);
765: UPDATE bom_bill_of_mtls_interface
766: SET process_flag = 3

Line 765: UPDATE bom_bill_of_mtls_interface

761: error_text => err_text,
762: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
763: msg_name => 'BOM_BILL_SEQ_MISSING',
764: err_text => err_text);
765: UPDATE bom_bill_of_mtls_interface
766: SET process_flag = 3
767: WHERE transaction_id = c2rec.TI;
768:
769: IF (ret_code <> 0) THEN

Line 784: UPDATE bom_bill_of_mtls_interface

780: /*
781: ** For Product Families
782: */
783: IF (x_bom_item_type = G_ProductFamily) THEN
784: UPDATE bom_bill_of_mtls_interface
785: SET organization_id = c2rec.OI,
786: assembly_item_id = c2rec.AII,
787: alternate_bom_designator = c2rec.ABD,
788: bill_sequence_id = c2rec.BSI,

Line 826: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

822: prog_id => prog_id,
823: req_id => req_id,
824: trans_id => c2rec.TI,
825: error_text => err_text,
826: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
827: msg_name => 'BOM_COMMON_ORG_MISSING',
828: err_text => err_text);
829: UPDATE bom_bill_of_mtls_interface
830: SET process_flag = 3

Line 829: UPDATE bom_bill_of_mtls_interface

825: error_text => err_text,
826: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
827: msg_name => 'BOM_COMMON_ORG_MISSING',
828: err_text => err_text);
829: UPDATE bom_bill_of_mtls_interface
830: SET process_flag = 3
831: WHERE transaction_id = c2rec.TI;
832:
833: IF (ret_code <> 0) THEN

Line 866: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

862: prog_id => prog_id,
863: req_id => req_id,
864: trans_id => c2rec.TI,
865: error_text => err_text,
866: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
867: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
868: err_text => err_text);
869: UPDATE bom_bill_of_mtls_interface
870: SET process_flag = 3

Line 869: UPDATE bom_bill_of_mtls_interface

865: error_text => err_text,
866: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
867: msg_name => 'BOM_CMN_ASSY_ITEM_INVALID',
868: err_text => err_text);
869: UPDATE bom_bill_of_mtls_interface
870: SET process_flag = 3
871: WHERE transaction_id = c2rec.TI;
872:
873: IF (ret_code <> 0) THEN

Line 905: FROM bom_bill_of_mtls_interface

901: stmt_num := 22;
902: BEGIN
903: SELECT bill_sequence_id
904: INTO c2rec.CBSI
905: FROM bom_bill_of_mtls_interface
906: WHERE organization_id = nvl(c2rec.COI, c2rec.OI)
907: AND transaction_type = G_Insert
908: AND assembly_item_id = c2rec.CAII
909: AND nvl(alternate_bom_designator, 'NONE') =

Line 924: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

920: prog_id => prog_id,
921: req_id => req_id,
922: trans_id => c2rec.TI,
923: error_text => err_text,
924: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
925: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
926: err_text => err_text);
927:
928: UPDATE bom_bill_of_mtls_interface

Line 928: UPDATE bom_bill_of_mtls_interface

924: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
925: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
926: err_text => err_text);
927:
928: UPDATE bom_bill_of_mtls_interface
929: SET process_flag = 3
930: WHERE transaction_id = c2rec.TI;
931:
932: IF (ret_code <> 0) THEN

Line 958: FROM bom_bill_of_mtls_interface

954: stmt_num := 24;
955: BEGIN
956: SELECT assembly_item_id, organization_id
957: INTO c2rec.CAII, c2rec.COI
958: FROM bom_bill_of_mtls_interface
959: WHERE bill_sequence_id = c2rec.CBSI
960: AND transaction_type = G_Insert
961: AND process_flag not in (3,7)
962: AND rownum = 1;

Line 974: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

970: prog_id => prog_id,
971: req_id => req_id,
972: trans_id => c2rec.TI,
973: error_text => err_text,
974: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
975: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
976: err_text => err_text);
977: UPDATE bom_bill_of_mtls_interface
978: SET process_flag = 3

Line 977: UPDATE bom_bill_of_mtls_interface

973: error_text => err_text,
974: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
975: msg_name => 'BOM_CMN_BILL_SEQ_MISSING',
976: err_text => err_text);
977: UPDATE bom_bill_of_mtls_interface
978: SET process_flag = 3
979: WHERE transaction_id = c2rec.TI;
980:
981: IF (ret_code <> 0) THEN

Line 990: UPDATE bom_bill_of_mtls_interface

986: END IF;
987:
988: <>
989: stmt_num := 25;
990: UPDATE bom_bill_of_mtls_interface
991: SET organization_id = c2rec.OI,
992: assembly_item_id = c2rec.AII,
993: alternate_bom_designator = c2rec.ABD,
994: bill_sequence_id = c2rec.BSI,

Line 1014: UPDATE bom_bill_of_mtls_interface

1010: RETURN(SQLCODE);
1011: END IF;
1012: ELSIF (c2rec.A = G_Delete) THEN
1013: stmt_num := 26;
1014: UPDATE bom_bill_of_mtls_interface
1015: SET organization_id = c2rec.OI,
1016: assembly_item_id = c2rec.AII,
1017: alternate_bom_designator = c2rec.ABD,
1018: assembly_type = c2rec.AST,

Line 1107: FROM bom_bill_of_mtls_interface

1103: */
1104: stmt_num := 2;
1105: SELECT count(*)
1106: INTO cnt
1107: FROM bom_bill_of_mtls_interface
1108: WHERE bill_sequence_id = bom_seq_id
1109: AND transaction_type = G_Insert
1110: AND process_flag = 4;
1111:

Line 1204: FROM bom_bill_of_mtls_interface

1200: stmt_num := 2;
1201: BEGIN
1202: SELECT 1
1203: INTO cnt
1204: FROM bom_bill_of_mtls_interface
1205: WHERE organization_id = org_id
1206: AND assembly_item_id = assy_id
1207: AND nvl(alternate_bom_designator, 'NONE') =
1208: nvl(alt_desg, 'NONE')

Line 1249: FROM bom_bill_of_mtls_interface

1245: stmt_num := 4;
1246: BEGIN
1247: SELECT bill_sequence_id
1248: INTO cnt
1249: FROM bom_bill_of_mtls_interface
1250: WHERE organization_id = org_id
1251: AND assembly_item_id = assy_id
1252: AND alternate_bom_designator is null
1253: AND ((assy_type = 2)

Line 1377: FROM bom_bill_of_mtls_interface

1373:
1374: stmt_num := 3;
1375: SELECT bill_sequence_id
1376: INTO cnt
1377: FROM bom_bill_of_mtls_interface
1378: WHERE bill_sequence_id = cmn_bom_id
1379: AND assembly_item_id = cmn_item_id
1380: AND organization_id = cmn_org_id
1381: AND nvl(alternate_bom_designator, 'NONE') = nvl(alt_desg, 'NONE')

Line 1560: FROM bom_bill_of_mtls_interface

1556: common_assembly_item_id CAII, assembly_type AST,
1557: common_organization_id COI, transaction_type A,
1558: alternate_bom_designator ABD, transaction_id TI,
1559: pending_from_ecn PFE
1560: FROM bom_bill_of_mtls_interface
1561: WHERE process_flag = 2
1562: AND transaction_type = G_Insert
1563: AND rownum < G_rows_to_commit;
1564:

Line 1583: FROM bom_bill_of_mtls_interface

1579: attribute11 A11, attribute12 A12, attribute13 A13,
1580: attribute14 A14,attribute15 A15, pending_from_ecn PFE,
1581: request_id RI, program_application_id PAI, program_id PI,
1582: program_update_date PUD
1583: FROM bom_bill_of_mtls_interface
1584: WHERE process_flag = 2
1585: AND transaction_type in (G_Update, G_Delete)
1586: AND rownum < G_rows_to_commit;
1587: /*

Line 1596: FROM bom_bill_of_mtls_interface

1592: assembly_item_id AII, common_bill_sequence_id CBSI,
1593: common_assembly_item_id CAII, assembly_type AST,
1594: common_organization_id COI, transaction_type A,
1595: alternate_bom_designator ABD, transaction_id TI
1596: FROM bom_bill_of_mtls_interface
1597: WHERE process_flag = 99
1598: AND transaction_type = G_Update
1599: AND rownum < G_rows_to_commit;
1600:

Line 1666: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1662: prog_id => prog_id,
1663: req_id => req_id,
1664: trans_id => c1rec.TI,
1665: error_text => err_text,
1666: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1667: msg_name => 'BOM_INVALID_ORG_ID',
1668: err_text => err_text);
1669: UPDATE bom_bill_of_mtls_interface
1670: SET process_flag = 3

Line 1669: UPDATE bom_bill_of_mtls_interface

1665: error_text => err_text,
1666: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1667: msg_name => 'BOM_INVALID_ORG_ID',
1668: err_text => err_text);
1669: UPDATE bom_bill_of_mtls_interface
1670: SET process_flag = 3
1671: WHERE transaction_id = c1rec.TI;
1672:
1673: IF (ret_code <> 0) THEN

Line 1703: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1699: prog_id => prog_id,
1700: req_id => req_id,
1701: trans_id => c1rec.TI,
1702: error_text => err_text,
1703: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1704: msg_name => 'BOM_ASSY_ITEM_MISSING',
1705: err_text => err_text);
1706: UPDATE bom_bill_of_mtls_interface
1707: SET process_flag = 3

Line 1706: UPDATE bom_bill_of_mtls_interface

1702: error_text => err_text,
1703: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1704: msg_name => 'BOM_ASSY_ITEM_MISSING',
1705: err_text => err_text);
1706: UPDATE bom_bill_of_mtls_interface
1707: SET process_flag = 3
1708: WHERE transaction_id = c1rec.TI;
1709:
1710: IF (ret_code <> 0) THEN

Line 1741: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1737: prog_id => prog_id,
1738: req_id => req_id,
1739: trans_id => c1rec.TI,
1740: error_text => err_text,
1741: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1742: msg_name => 'BOM_INVALID_ALTERNATE',
1743: err_text => err_text);
1744: UPDATE bom_bill_of_mtls_interface
1745: SET process_flag = 3

Line 1744: UPDATE bom_bill_of_mtls_interface

1740: error_text => err_text,
1741: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1742: msg_name => 'BOM_INVALID_ALTERNATE',
1743: err_text => err_text);
1744: UPDATE bom_bill_of_mtls_interface
1745: SET process_flag = 3
1746: WHERE transaction_id = c1rec.TI;
1747:
1748: IF (ret_code <> 0) THEN

Line 1775: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1771: prog_id => prog_id,
1772: req_id => req_id,
1773: trans_id => c1rec.TI,
1774: error_text => err_text,
1775: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1776: msg_name => 'BOM_ASSEMBLY_ITEM_INVALID',
1777: err_text => err_text);
1778: UPDATE bom_bill_of_mtls_interface
1779: SET process_flag = 3

Line 1778: UPDATE bom_bill_of_mtls_interface

1774: error_text => err_text,
1775: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1776: msg_name => 'BOM_ASSEMBLY_ITEM_INVALID',
1777: err_text => err_text);
1778: UPDATE bom_bill_of_mtls_interface
1779: SET process_flag = 3
1780: WHERE transaction_id = c1rec.TI;
1781:
1782: IF (ret_code <> 0) THEN

Line 1810: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1806: prog_id => prog_id,
1807: req_id => req_id,
1808: trans_id => c1rec.TI,
1809: error_text => err_text,
1810: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1811: msg_name => 'ENG_PARENTECO_NOT_EXIST',
1812: err_text => err_text);
1813: UPDATE bom_bill_of_mtls_interface
1814: SET process_flag = 3

Line 1813: UPDATE bom_bill_of_mtls_interface

1809: error_text => err_text,
1810: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1811: msg_name => 'ENG_PARENTECO_NOT_EXIST',
1812: err_text => err_text);
1813: UPDATE bom_bill_of_mtls_interface
1814: SET process_flag = 3
1815: WHERE transaction_id = c1rec.TI;
1816:
1817: IF (ret_code <> 0) THEN

Line 1838: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1834: prog_id => prog_id,
1835: req_id => req_id,
1836: trans_id => c1rec.TI,
1837: error_text => err_text,
1838: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1839: msg_name => 'BOM_ASSEMBLY_TYPE_INVALID',
1840: err_text => err_text);
1841: UPDATE bom_bill_of_mtls_interface
1842: SET process_flag = 3

Line 1841: UPDATE bom_bill_of_mtls_interface

1837: error_text => err_text,
1838: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1839: msg_name => 'BOM_ASSEMBLY_TYPE_INVALID',
1840: err_text => err_text);
1841: UPDATE bom_bill_of_mtls_interface
1842: SET process_flag = 3
1843: WHERE transaction_id = c1rec.TI;
1844:
1845: IF (ret_code <> 0) THEN

Line 1869: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1865: prog_id => prog_id,
1866: req_id => req_id,
1867: trans_id => c1rec.TI,
1868: error_text => err_text,
1869: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1870: msg_name => 'BOM_DUPLICATE_BILL',
1871: err_text => err_text);
1872: UPDATE bom_bill_of_mtls_interface
1873: SET process_flag = 3

Line 1872: UPDATE bom_bill_of_mtls_interface

1868: error_text => err_text,
1869: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1870: msg_name => 'BOM_DUPLICATE_BILL',
1871: err_text => err_text);
1872: UPDATE bom_bill_of_mtls_interface
1873: SET process_flag = 3
1874: WHERE transaction_id = c1rec.TI;
1875:
1876: IF (ret_code <> 0) THEN

Line 1903: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1899: prog_id => prog_id,
1900: req_id => req_id,
1901: trans_id => c1rec.TI,
1902: error_text => err_text,
1903: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1904: msg_name => 'BOM_BILL_VALIDATION_ERR',
1905: err_text => err_text);
1906: UPDATE bom_bill_of_mtls_interface
1907: SET process_flag = 3

Line 1906: UPDATE bom_bill_of_mtls_interface

1902: error_text => err_text,
1903: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1904: msg_name => 'BOM_BILL_VALIDATION_ERR',
1905: err_text => err_text);
1906: UPDATE bom_bill_of_mtls_interface
1907: SET process_flag = 3
1908: WHERE transaction_id = c1rec.TI;
1909:
1910: IF (ret_code <> 0) THEN

Line 1948: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1944: prog_id => prog_id,
1945: req_id => req_id,
1946: trans_id => c1rec.TI,
1947: error_text => err_text,
1948: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1949: msg_name => 'BOM_ASSY_TYPE_ERR',
1950: err_text => err_text);
1951: UPDATE bom_bill_of_mtls_interface
1952: SET process_flag = 3

Line 1951: UPDATE bom_bill_of_mtls_interface

1947: error_text => err_text,
1948: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1949: msg_name => 'BOM_ASSY_TYPE_ERR',
1950: err_text => err_text);
1951: UPDATE bom_bill_of_mtls_interface
1952: SET process_flag = 3
1953: WHERE transaction_id = c1rec.TI;
1954:
1955: IF (ret_code <> 0) THEN

Line 1981: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

1977: prog_id => prog_id,
1978: req_id => req_id,
1979: trans_id => c1rec.TI,
1980: error_text => err_text,
1981: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1982: msg_name => 'BOM_COMMON_BILL_NOT_EXIST',
1983: err_text => err_text);
1984: UPDATE bom_bill_of_mtls_interface
1985: SET process_flag = 3

Line 1984: UPDATE bom_bill_of_mtls_interface

1980: error_text => err_text,
1981: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
1982: msg_name => 'BOM_COMMON_BILL_NOT_EXIST',
1983: err_text => err_text);
1984: UPDATE bom_bill_of_mtls_interface
1985: SET process_flag = 3
1986: WHERE transaction_id = c1rec.TI;
1987:
1988: IF (ret_code <> 0) THEN

Line 2017: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

2013: prog_id => prog_id,
2014: req_id => req_id,
2015: trans_id => c1rec.TI,
2016: error_text => err_text,
2017: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2018: msg_name => 'BOM_COMMON_BOM_ERROR',
2019: err_text => err_text);
2020: UPDATE bom_bill_of_mtls_interface
2021: SET process_flag = 3

Line 2020: UPDATE bom_bill_of_mtls_interface

2016: error_text => err_text,
2017: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2018: msg_name => 'BOM_COMMON_BOM_ERROR',
2019: err_text => err_text);
2020: UPDATE bom_bill_of_mtls_interface
2021: SET process_flag = 3
2022: WHERE transaction_id = c1rec.TI;
2023:
2024: IF (ret_code <> 0) THEN

Line 2036: UPDATE bom_bill_of_mtls_interface

2032: */
2033:
2034: <>
2035: stmt_num := 10;
2036: UPDATE bom_bill_of_mtls_interface
2037: SET process_flag = 4
2038: WHERE transaction_id = c1rec.TI;
2039:
2040: <>

Line 2111: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

2107: prog_id => prog_id,
2108: req_id => req_id,
2109: trans_id => c2rec.TI,
2110: error_text => err_text,
2111: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2112: msg_name => 'BOM_BILL_RECORD_MISSING',
2113: err_text => err_text);
2114:
2115: UPDATE bom_bill_of_mtls_interface

Line 2115: UPDATE bom_bill_of_mtls_interface

2111: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2112: msg_name => 'BOM_BILL_RECORD_MISSING',
2113: err_text => err_text);
2114:
2115: UPDATE bom_bill_of_mtls_interface
2116: SET process_flag = 3
2117: WHERE transaction_id = c2rec.TI;
2118:
2119: IF (ret_code <> 0) THEN

Line 2147: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

2143: prog_id => prog_id,
2144: req_id => req_id,
2145: trans_id => c2rec.TI,
2146: error_text => err_text,
2147: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2148: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2149: err_text => err_text);
2150:
2151: UPDATE bom_bill_of_mtls_interface

Line 2151: UPDATE bom_bill_of_mtls_interface

2147: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2148: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2149: err_text => err_text);
2150:
2151: UPDATE bom_bill_of_mtls_interface
2152: SET process_flag = 3
2153: WHERE transaction_id = c2rec.TI;
2154:
2155: IF (ret_code <> 0) THEN

Line 2165: UPDATE bom_bill_of_mtls_interface

2161: ** Update interface record with production record's values
2162: */
2163:
2164: stmt_num := 14;
2165: UPDATE bom_bill_of_mtls_interface
2166: SET creation_date = X_creation_date,
2167: created_by = X_created_by,
2168: assembly_type = X_assembly_type,
2169: next_explode_date = X_next_explode_date,

Line 2246: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

2242: prog_id => prog_id,
2243: req_id => req_id,
2244: trans_id => c2rec.TI,
2245: error_text => err_text,
2246: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2247: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2248: err_text => err_text);
2249:
2250: UPDATE bom_bill_of_mtls_interface

Line 2250: UPDATE bom_bill_of_mtls_interface

2246: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2247: msg_name => 'BOM_COLUMN_NOT_UPDATABLE',
2248: err_text => err_text);
2249:
2250: UPDATE bom_bill_of_mtls_interface
2251: SET process_flag = 3
2252: WHERE transaction_id = c2rec.TI;
2253:
2254: IF (ret_code <> 0) THEN

Line 2265: UPDATE bom_bill_of_mtls_interface

2261: ** Update interface record with production record's values
2262: */
2263:
2264: stmt_num := 14;
2265: UPDATE bom_bill_of_mtls_interface
2266: SET creation_date = X_creation_date,
2267: created_by = X_created_by,
2268: assembly_type = X_assembly_type,
2269: next_explode_date = X_next_explode_date,

Line 2323: UPDATE bom_bill_of_mtls_interface

2319: /*
2320: ** Set Process Flag to 4 for "Deletes"
2321: */
2322: stmt_num := 15;
2323: UPDATE bom_bill_of_mtls_interface
2324: SET process_flag = 4
2325: WHERE transaction_id = c2rec.TI;
2326: END IF;
2327: <>

Line 2369: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

2365: prog_id => prog_id,
2366: req_id => req_id,
2367: trans_id => c3rec.TI,
2368: error_text => err_text,
2369: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2370: msg_name => 'BOM_COMMON_BILL_NOT_EXIST',
2371: err_text => err_text);
2372: UPDATE bom_bill_of_mtls_interface
2373: SET process_flag = 3

Line 2372: UPDATE bom_bill_of_mtls_interface

2368: error_text => err_text,
2369: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2370: msg_name => 'BOM_COMMON_BILL_NOT_EXIST',
2371: err_text => err_text);
2372: UPDATE bom_bill_of_mtls_interface
2373: SET process_flag = 3
2374: WHERE transaction_id = c3rec.TI;
2375:
2376: IF (ret_code <> 0) THEN

Line 2405: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',

2401: prog_id => prog_id,
2402: req_id => req_id,
2403: trans_id => c3rec.TI,
2404: error_text => err_text,
2405: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2406: msg_name => 'BOM_COMMON_BOM_ERROR',
2407: err_text => err_text);
2408: UPDATE bom_bill_of_mtls_interface
2409: SET process_flag = 3

Line 2408: UPDATE bom_bill_of_mtls_interface

2404: error_text => err_text,
2405: tbl_name => 'BOM_BILL_OF_MTLS_INTERFACE',
2406: msg_name => 'BOM_COMMON_BOM_ERROR',
2407: err_text => err_text);
2408: UPDATE bom_bill_of_mtls_interface
2409: SET process_flag = 3
2410: WHERE transaction_id = c3rec.TI;
2411:
2412: IF (ret_code <> 0) THEN

Line 2422: UPDATE bom_bill_of_mtls_interface

2418: /*
2419: ** Set Process Flag to 4
2420: */
2421: stmt_num := 19;
2422: UPDATE bom_bill_of_mtls_interface
2423: SET process_flag = 4
2424: WHERE transaction_id = c3rec.TI;
2425:
2426: <>

Line 2453: table, BOM_BILL_OF_MTLS_INTERFACE, into the production table,

2449: NAME
2450: Transact_Bill
2451: DESCRIPTION
2452: Insert, update and delete bill data from the interface
2453: table, BOM_BILL_OF_MTLS_INTERFACE, into the production table,
2454: BOM_BILL_OF_MATERIALS.
2455: REQUIRES
2456: prog_appid Program application id
2457: prog_id Program id

Line 2463: BOM_BILL_OF_MTLS_INTERFACE

2459: user_id User id
2460: login_id Login id
2461: MODIFIES
2462: BOM_BILL_OF_MATERIALS
2463: BOM_BILL_OF_MTLS_INTERFACE
2464: RETURNS
2465: 0 if successful
2466: SQLCODE if error
2467: NOTES

Line 2505: FROM bom_bill_of_mtls_interface

2501: attribute11 A11, attribute12 A12, attribute13 A13,
2502: attribute14 A14, attribute15 A15, request_id RI,
2503: program_application_id PAI, program_id PI,
2504: program_update_date PUD, transaction_id TI
2505: FROM bom_bill_of_mtls_interface
2506: WHERE process_flag = 4
2507: AND transaction_type = G_Update
2508: AND rownum < G_rows_to_commit;
2509: /*

Line 2516: FROM bom_bill_of_mtls_interface

2512: CURSOR c2 IS
2513: SELECT bill_sequence_id BSI, assembly_type AST, organization_id OI,
2514: assembly_item_id AII, alternate_bom_designator ABD,
2515: transaction_id TI
2516: FROM bom_bill_of_mtls_interface
2517: WHERE process_flag = 4
2518: AND transaction_type = G_Delete
2519: AND rownum < G_rows_to_commit;
2520: BEGIN

Line 2599: FROM bom_bill_of_mtls_interface

2595: program_id,
2596: program_update_date,
2597: common_organization_id,
2598: next_explode_date
2599: FROM bom_bill_of_mtls_interface
2600: WHERE process_flag = 4
2601: AND transaction_type = G_Insert
2602: AND rownum < 500;
2603:

Line 2607: UPDATE bom_bill_of_mtls_interface bi

2603:
2604: EXIT when SQL%NOTFOUND;
2605:
2606: stmt_num := 2;
2607: UPDATE bom_bill_of_mtls_interface bi
2608: SET process_flag = 7
2609: WHERE process_flag = 4
2610: AND transaction_type = G_Insert
2611: AND exists (SELECT null

Line 2658: UPDATE bom_bill_of_mtls_interface

2654: common_organization_id = c1rec.COI
2655: WHERE bill_sequence_id = c1rec.BSI;
2656:
2657: stmt_num := 5;
2658: UPDATE bom_bill_of_mtls_interface
2659: SET process_flag = 7
2660: WHERE transaction_id = c1rec.TI;
2661: END LOOP;
2662:

Line 2760: UPDATE bom_bill_of_mtls_interface

2756: RETURN(ret_code);
2757: END IF;
2758:
2759: stmt_num := 11;
2760: UPDATE bom_bill_of_mtls_interface
2761: SET process_flag = 7
2762: WHERE transaction_id = c2rec.TI;
2763:
2764: END LOOP;

Line 2793: interface table, BOM_BILL_OF_MTLS_INTERFACE.

2789: NAME
2790: Import_Bill
2791: DESCRIPTION
2792: Assign, Validate, and Transact the Bill of Material record in the
2793: interface table, BOM_BILL_OF_MTLS_INTERFACE.
2794: REQUIRES
2795: err_text out buffer to return error message
2796: MODIFIES
2797: RETURNS

Line 2872: DELETE from bom_bill_of_mtls_interface

2868:
2869: stmt_num := 4;
2870: IF (del_rec_flag = 1) THEN
2871: LOOP
2872: DELETE from bom_bill_of_mtls_interface
2873: WHERE process_flag = 7
2874: AND rownum < G_rows_to_commit;
2875:
2876: EXIT when SQL%NOTFOUND;