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.BOMPASGR dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 36: BOM_OP_SEQUENCES_INTERFACE

32: REQUIRES
33: err_text out buffer to return error message
34: MODIFIES
35: BOM_OP_ROUTINGS_INTERFACE
36: BOM_OP_SEQUENCES_INTERFACE
37: BOM_OP_RESOURCES_INTERFACE
38: MTL_RTG_ITEM_REVS_INTERFACE
39: MTL_INTERFACE_ERRORS
40: RETURNS

Line 73: update bom_op_sequences_interface ori

69: end loop;
70:
71: stmt_num := 2;
72: loop
73: update bom_op_sequences_interface ori
74: set organization_id = (select organization_id from
75: mtl_parameters a
76: where a.organization_code = ori.organization_code)
77: where process_flag = 1

Line 787: BOM_OP_SEQUENCES_INTERFACE. If any application error occurs, it

783: /* NAME
784: bmasopd_assign_operation_data - assign operation data
785: DESCRIPTION
786: assign defaults and various ids in the interface table
787: BOM_OP_SEQUENCES_INTERFACE. If any application error occurs, it
788: inserts record into MTL_INTERFACE_ERRORS.
789:
790: REQUIRES
791: err_text out buffer to return error message

Line 793: BOM_OP_SEQUENCES_INTERFACE

789:
790: REQUIRES
791: err_text out buffer to return error message
792: MODIFIES
793: BOM_OP_SEQUENCES_INTERFACE
794: MTL_INTERFACE_ERRORS
795: RETURNS
796: 0 if successful
797: SQLCODE if unsuccessful

Line 856: from bom_op_sequences_interface

852: attribute1 A1, attribute1 A2, attribute1 A3,
853: attribute1 A4,attribute1 A5,attribute1 A6,attribute1 A7,
854: attribute1 A8,attribute1 A9,attribute1 A10,attribute1 A11,
855: attribute1 A12,attribute1 A13,attribute1 A14,attribute1 A15
856: from bom_op_sequences_interface
857: where process_flag = 1
858: and (all_org = 1
859: or
860: (all_org = 2 and organization_id = org_id)

Line 872: update bom_op_sequences_interface

868: /*
869: ** assign transaction ids to all rows first
870: */
871: loop
872: update bom_op_sequences_interface
873: set transaction_id = mtl_system_items_interface_s.nextval,
874: operation_sequence_id = nvl(operation_sequence_id,
875: bom_operation_sequences_s.nextval)
876: where transaction_id is null

Line 901: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

897: prog_id => prog_id,
898: req_id => req_id,
899: trans_id => c1rec.TI,
900: error_text => err_text,
901: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
902: msg_name => 'BOM_ORG_ID_MISSING',
903: err_text => err_text);
904: update bom_op_sequences_interface set
905: process_flag = 3

Line 904: update bom_op_sequences_interface set

900: error_text => err_text,
901: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
902: msg_name => 'BOM_ORG_ID_MISSING',
903: err_text => err_text);
904: update bom_op_sequences_interface set
905: process_flag = 3
906: where transaction_id = c1rec.TI;
907:
908: goto continue_loop;

Line 922: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

918: prog_id => prog_id,
919: req_id => req_id,
920: trans_id => c1rec.TI,
921: error_text => err_text,
922: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
923: msg_name => 'BOM_EFF_DATE_MISSING',
924: err_text => err_text);
925: update bom_op_sequences_interface set
926: process_flag = 3

Line 925: update bom_op_sequences_interface set

921: error_text => err_text,
922: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
923: msg_name => 'BOM_EFF_DATE_MISSING',
924: err_text => err_text);
925: update bom_op_sequences_interface set
926: process_flag = 3
927: where transaction_id = c1rec.TI;
928:
929: goto continue_loop;

Line 952: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

948: prog_id => prog_id,
949: req_id => req_id,
950: trans_id => c1rec.TI,
951: error_text => err_text,
952: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
953: msg_name => 'BOM_ASSY_ITEM_MISSING',
954: err_text => err_text);
955: update bom_op_sequences_interface set
956: process_flag = 3

Line 955: update bom_op_sequences_interface set

951: error_text => err_text,
952: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
953: msg_name => 'BOM_ASSY_ITEM_MISSING',
954: err_text => err_text);
955: update bom_op_sequences_interface set
956: process_flag = 3
957: where transaction_id = c1rec.TI;
958:
959: if (ret_code <> 0) then

Line 984: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

980: prog_id => prog_id,
981: req_id => req_id,
982: trans_id => c1rec.TI,
983: error_text => err_text,
984: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
985: msg_name => 'BOM_RTG_SEQ_INVALID',
986: err_text => err_text);
987: update bom_op_sequences_interface set
988: process_flag = 3

Line 987: update bom_op_sequences_interface set

983: error_text => err_text,
984: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
985: msg_name => 'BOM_RTG_SEQ_INVALID',
986: err_text => err_text);
987: update bom_op_sequences_interface set
988: process_flag = 3
989: where transaction_id = c1rec.TI;
990:
991: if (ret_code <> 0) then

Line 1013: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

1009: prog_id => prog_id,
1010: req_id => req_id,
1011: trans_id => c1rec.TI,
1012: error_text => err_text,
1013: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1014: msg_name => 'BOM_RTG_SEQ_INVALID',
1015: err_text => err_text);
1016: update bom_op_sequences_interface set
1017: process_flag = 3

Line 1016: update bom_op_sequences_interface set

1012: error_text => err_text,
1013: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1014: msg_name => 'BOM_RTG_SEQ_INVALID',
1015: err_text => err_text);
1016: update bom_op_sequences_interface set
1017: process_flag = 3
1018: where transaction_id = c1rec.TI;
1019:
1020: if (ret_code <> 0) then

Line 1044: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

1040: prog_id => prog_id,
1041: req_id => req_id,
1042: trans_id => c1rec.TI,
1043: error_text => err_text,
1044: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1045: msg_name => 'BOM_STD_OP_CODE_INVALID',
1046: err_text => err_text);
1047: update bom_op_sequences_interface set
1048: process_flag = 3

Line 1047: update bom_op_sequences_interface set

1043: error_text => err_text,
1044: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1045: msg_name => 'BOM_STD_OP_CODE_INVALID',
1046: err_text => err_text);
1047: update bom_op_sequences_interface set
1048: process_flag = 3
1049: where transaction_id = c1rec.TI;
1050:
1051: if (ret_code <> 0) then

Line 1075: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

1071: prog_id => prog_id,
1072: req_id => req_id,
1073: trans_id => c1rec.TI,
1074: error_text => err_text,
1075: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1076: msg_name => 'BOM_DEPT_CODE_INVALID',
1077: err_text => err_text);
1078: update bom_op_sequences_interface set
1079: process_flag = 3

Line 1078: update bom_op_sequences_interface set

1074: error_text => err_text,
1075: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1076: msg_name => 'BOM_DEPT_CODE_INVALID',
1077: err_text => err_text);
1078: update bom_op_sequences_interface set
1079: process_flag = 3
1080: where transaction_id = c1rec.TI;
1081:
1082: if (ret_code <> 0) then

Line 1121: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

1117: prog_id => prog_id,
1118: req_id => req_id,
1119: trans_id => c1rec.TI,
1120: error_text => err_text,
1121: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1122: msg_name => 'BOM_STD_OP_ID_INVALID',
1123: err_text => err_text);
1124: update bom_op_sequences_interface set
1125: process_flag = 3

Line 1124: update bom_op_sequences_interface set

1120: error_text => err_text,
1121: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1122: msg_name => 'BOM_STD_OP_ID_INVALID',
1123: err_text => err_text);
1124: update bom_op_sequences_interface set
1125: process_flag = 3
1126: where transaction_id = c1rec.TI;
1127:
1128: if (ret_code <> 0) then

Line 1226: update bom_op_sequences_interface set

1222: end if;
1223:
1224:
1225: stmt_num := 7;
1226: update bom_op_sequences_interface set
1227: department_id = nvl(department_id, c1rec.DI),
1228: organization_id = nvl(organization_id, c1rec.OI),
1229: assembly_item_id = nvl(assembly_item_id, c1rec.AII),
1230: process_flag = 2,

Line 1503: from bom_op_sequences_interface

1499: sysdate,
1500: user_id,
1501: sysdate,
1502: user_id
1503: from bom_op_sequences_interface
1504: where process_flag = 2
1505: and (all_org = 1
1506: or
1507: (all_org = 2 and organization_id = org_id)

Line 1534: from bom_op_sequences_interface

1530: sysdate,
1531: user_id,
1532: sysdate,
1533: user_id
1534: from bom_op_sequences_interface
1535: where process_flag = 2
1536: and (all_org = 1
1537: or
1538: (all_org = 2 and organization_id = org_id)

Line 1565: from bom_op_sequences_interface

1561: sysdate,
1562: user_id,
1563: sysdate,
1564: user_id
1565: from bom_op_sequences_interface
1566: where process_flag = 2
1567: and (all_org = 1
1568: or
1569: (all_org = 2 and organization_id = org_id)

Line 1766: from bom_op_sequences_interface bosi,

1762:
1763: begin
1764: select bori.organization_id
1765: into dummy_org_id
1766: from bom_op_sequences_interface bosi,
1767: bom_op_routings_interface bori
1768: where operation_sequence_id = c2rec.OSI
1769: and bosi.process_flag <>3 and bosi.process_flag <>7
1770: and bori.process_flag <>3 and bori.process_flag <>7

Line 1782: from bom_op_sequences_interface bosi,

1778:
1779: begin
1780: select bor.organization_id
1781: into dummy_org_id
1782: from bom_op_sequences_interface bosi,
1783: bom_operational_routings bor
1784: where operation_sequence_id = c2rec.OSI
1785: and bosi.process_flag <> 3 and bosi.process_flag <> 7
1786: and bosi.routing_sequence_id = bor.routing_sequence_id

Line 1929: from bom_op_sequences_interface

1925:
1926: BEGIN
1927: select department_id
1928: into dummy_dept
1929: from bom_op_sequences_interface
1930: where operation_sequence_id = c2rec.OSI
1931: and process_flag <>3 and process_flag <> 7
1932: and rownum = 1;
1933:

Line 2212: from bom_op_sequences_interface

2208: END;
2209:
2210: select operation_sequence_id
2211: into op_seq_id
2212: from bom_op_sequences_interface
2213: where routing_sequence_id = rtg_seq_id
2214: and operation_seq_num = op_seq
2215: and to_char(effectivity_date,'YYYY/MM/DD HH24:MI:SS') = eff_date -- Changed for bug 2647027
2216: -- and to_char(effectivity_date,'YYYY/MM/DD HH24:MI') = eff_date

Line 2326: update bom_op_sequences_interface set

2322: IS
2323: stmt_num NUMBER := 1;
2324: BEGIN
2325: loop
2326: update bom_op_sequences_interface set
2327: routing_sequence_id = rtg_id
2328: where process_flag = 1
2329: and organization_id = org_id
2330: and assembly_item_id = assy_id

Line 2514: BOM_OP_SEQUENCES_INTERFACE

2510: REQUIRES
2511: err_text out buffer to return error message
2512: MODIFIES
2513: BOM_OP_ROUTINGS_INTERFACE
2514: BOM_OP_SEQUENCES_INTERFACE
2515: BOM_OP_RESOURCES_INTERFACE
2516: MTL_INTERFACE_ERRORS
2517: RETURNS
2518: 0 if successful

Line 2531: From bom_op_sequences_interface bos

2527: ) return INTEGER IS
2528:
2529: Cursor GetOps is
2530: Select bos.rowid row_id
2531: From bom_op_sequences_interface bos
2532: where bos.process_flag = 1
2533: and bos.assembly_item_id is null
2534: and bos.organization_id = org_id
2535: and bos.assembly_item_number = item_num

Line 2548: update bom_op_sequences_interface

2544: and bor.routing_sequence_id is null;
2545:
2546: BEGIN
2547: For X_Operation in GetOps loop
2548: update bom_op_sequences_interface
2549: set assembly_item_id = item_id
2550: where rowid = X_Operation.row_id;
2551: If mod(GetOps%rowcount, 500) = 0 then
2552: commit;