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.

[Home] [Help]

APPS.BOMPVALR dependencies on BOM_OP_SEQUENCES_INTERFACE

Line 763: from bom_op_sequences_interface

759: to_char(effectivity_date,'YYYY/MM/DD HH24:MI') ED,
760: to_char(disable_date,'YYYY/MM/DD HH24:MI') DD,
761: **/ operation_seq_num OSN,
762: organization_id OI
763: from bom_op_sequences_interface
764: where process_flag = 2
765: and rownum < 500;
766:
767: BEGIN

Line 786: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

782: prog_id => prog_id,
783: req_id => request_id,
784: trans_id => c1rec.TI,
785: error_text => err_text,
786: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
787: msg_name => 'BOM_OP_SEQ_NUM_MISSING',
788: err_text => err_text);
789: update bom_op_sequences_interface set
790: process_flag = 3

Line 789: update bom_op_sequences_interface set

785: error_text => err_text,
786: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
787: msg_name => 'BOM_OP_SEQ_NUM_MISSING',
788: err_text => err_text);
789: update bom_op_sequences_interface set
790: process_flag = 3
791: where transaction_id = c1rec.TI;
792:
793: if (ret_code <> 0) then

Line 816: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

812: prog_id => prog_id,
813: req_id => request_id,
814: trans_id => c1rec.TI,
815: error_text => err_text,
816: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
817: msg_name => 'BOM_OP_SEQ_ID_DUPLICATE',
818: err_text => err_text);
819: update bom_op_sequences_interface set
820: process_flag = 3

Line 819: update bom_op_sequences_interface set

815: error_text => err_text,
816: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
817: msg_name => 'BOM_OP_SEQ_ID_DUPLICATE',
818: err_text => err_text);
819: update bom_op_sequences_interface set
820: process_flag = 3
821: where transaction_id = c1rec.TI;
822:
823: if (ret_code <> 0) then

Line 847: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

843: prog_id => prog_id,
844: req_id => request_id,
845: trans_id => c1rec.TI,
846: error_text => err_text,
847: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
848: msg_name => 'BOM_OPERATION_DUPLICATE',
849: err_text => err_text);
850: update bom_op_sequences_interface set
851: process_flag = 3

Line 850: update bom_op_sequences_interface set

846: error_text => err_text,
847: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
848: msg_name => 'BOM_OPERATION_DUPLICATE',
849: err_text => err_text);
850: update bom_op_sequences_interface set
851: process_flag = 3
852: where transaction_id = c1rec.TI;
853:
854: if (ret_code <> 0) then

Line 877: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

873: prog_id => prog_id,
874: req_id => request_id,
875: trans_id => c1rec.TI,
876: error_text => err_text,
877: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
878: msg_name => 'BOM_RTG_SEQ_INVALID',
879: err_text => err_text);
880: update bom_op_sequences_interface set
881: process_flag = 3

Line 880: update bom_op_sequences_interface set

876: error_text => err_text,
877: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
878: msg_name => 'BOM_RTG_SEQ_INVALID',
879: err_text => err_text);
880: update bom_op_sequences_interface set
881: process_flag = 3
882: where transaction_id = c1rec.TI;
883:
884: if (ret_code <> 0) then

Line 909: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

905: prog_id => prog_id,
906: req_id => request_id,
907: trans_id => c1rec.TI,
908: error_text => err_text,
909: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
910: msg_name => 'BOM_IMPL_OP_OVERLAP',
911: err_text => err_text);
912: update bom_op_sequences_interface set
913: process_flag = 3

Line 912: update bom_op_sequences_interface set

908: error_text => err_text,
909: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
910: msg_name => 'BOM_IMPL_OP_OVERLAP',
911: err_text => err_text);
912: update bom_op_sequences_interface set
913: process_flag = 3
914: where transaction_id = c1rec.TI;
915:
916: if (ret_code <> 0) then

Line 940: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

936: prog_id => prog_id,
937: req_id => request_id,
938: trans_id => c1rec.TI,
939: error_text => err_text,
940: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
941: msg_name => 'BOM_DEPT_ID_INVALID',
942: err_text => err_text);
943: update bom_op_sequences_interface set
944: process_flag = 3

Line 943: update bom_op_sequences_interface set

939: error_text => err_text,
940: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
941: msg_name => 'BOM_DEPT_ID_INVALID',
942: err_text => err_text);
943: update bom_op_sequences_interface set
944: process_flag = 3
945: where transaction_id = c1rec.TI;
946:
947: if (ret_code <> 0) then

Line 973: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

969: prog_id => prog_id,
970: req_id => request_id,
971: trans_id => c1rec.TI,
972: error_text => err_text,
973: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
974: msg_name => 'BOM_COMMON_OP',
975: err_text => err_text);
976: update bom_op_sequences_interface set
977: process_flag = 3

Line 976: update bom_op_sequences_interface set

972: error_text => err_text,
973: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
974: msg_name => 'BOM_COMMON_OP',
975: err_text => err_text);
976: update bom_op_sequences_interface set
977: process_flag = 3
978: where transaction_id = c1rec.TI;
979:
980: if (ret_code <> 0) then

Line 1005: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

1001: prog_id => prog_id,
1002: req_id => request_id,
1003: trans_id => c1rec.TI,
1004: error_text => err_text,
1005: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1006: msg_name => 'BOM_COMMON_OP',
1007: err_text => err_text);
1008: update bom_op_sequences_interface set
1009: process_flag = 3

Line 1008: update bom_op_sequences_interface set

1004: error_text => err_text,
1005: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1006: msg_name => 'BOM_COMMON_OP',
1007: err_text => err_text);
1008: update bom_op_sequences_interface set
1009: process_flag = 3
1010: where transaction_id = c1rec.TI;
1011:
1012: if (ret_code <> 0) then

Line 1067: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',

1063: prog_id => prog_id,
1064: req_id => request_id,
1065: trans_id => c1rec.TI,
1066: error_text => err_text,
1067: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1068: msg_name => 'BOM_OPERATION_ERROR',
1069: err_text => err_text);
1070: update bom_op_sequences_interface set
1071: process_flag = 3

Line 1070: update bom_op_sequences_interface set

1066: error_text => err_text,
1067: tbl_name => 'BOM_OP_SEQUENCES_INTERFACE',
1068: msg_name => 'BOM_OPERATION_ERROR',
1069: err_text => err_text);
1070: update bom_op_sequences_interface set
1071: process_flag = 3
1072: where transaction_id = c1rec.TI;
1073:
1074: if (ret_code <> 0) then

Line 1080: update bom_op_sequences_interface

1076: end if;
1077: goto continue_loop;
1078: end if;
1079:
1080: update bom_op_sequences_interface
1081: set process_flag = 4
1082: where transaction_id = c1rec.TI;
1083:
1084: <>

Line 1247: from bom_op_sequences_interface

1243: */
1244: begin
1245: select department_id, effectivity_date
1246: into dept_id, dummy_eff
1247: from bom_op_sequences_interface
1248: where operation_sequence_id = c1rec.OSI
1249: and process_flag = 4;
1250: exception
1251: when NO_DATA_FOUND then

Line 2630: from bom_op_sequences_interface

2626: ** check in interface table
2627: */
2628: select count(*)
2629: into cnt
2630: from bom_op_sequences_interface
2631: where operation_sequence_id = op_seq_id
2632: and process_flag = 4;
2633:
2634: if (cnt = 0) then

Line 2716: from bom_op_sequences_interface

2712:
2713: begin
2714: select operation_sequence_id
2715: into cnt
2716: from bom_op_sequences_interface
2717: where routing_sequence_id = rtg_seq_id
2718: and to_char(effectivity_date,'YYYY/MM/DD HH24:MI:SS') = eff_date -- Changed for bug 2647027
2719: -- and to_char(effectivity_date,'YYYY/MM/DD HH24:MI') = eff_date
2720: and operation_seq_num = op_seq

Line 2799: from bom_op_sequences_interface

2795: ** search in interface tables
2796: */
2797: select count(*)
2798: into cnt
2799: from bom_op_sequences_interface
2800: where routing_sequence_id = rtg_id
2801: and operation_seq_num = op_num
2802: and process_flag = 4
2803: and ((dis_date is null