APPS.ENG_CANCEL_ECO dependencies on ENG_REVISED_COMPONENTS

Line 193: ** insert the cancelled rev components into eng_revised_components

189: AND IC.IMPLEMENTATION_DATE IS NULL);
190: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted in brd');
191:
192: /*
193: ** insert the cancelled rev components into eng_revised_components
194: */
195: stmt_num := 40;
196: INSERT INTO ENG_REVISED_COMPONENTS (
197: COMPONENT_SEQUENCE_ID,

Line 196: INSERT INTO ENG_REVISED_COMPONENTS (

192: /*
193: ** insert the cancelled rev components into eng_revised_components
194: */
195: stmt_num := 40;
196: INSERT INTO ENG_REVISED_COMPONENTS (
197: COMPONENT_SEQUENCE_ID,
198: COMPONENT_ITEM_ID,
199: OPERATION_SEQUENCE_NUM,
200: BILL_SEQUENCE_ID,

Line 867: ** insert the cancelled rev components into eng_revised_components

863: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
864: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from brd');
865:
866: /*
867: ** insert the cancelled rev components into eng_revised_components
868: */
869: stmt_num := 40;
870: INSERT INTO ENG_REVISED_COMPONENTS (
871: COMPONENT_SEQUENCE_ID,

Line 870: INSERT INTO ENG_REVISED_COMPONENTS (

866: /*
867: ** insert the cancelled rev components into eng_revised_components
868: */
869: stmt_num := 40;
870: INSERT INTO ENG_REVISED_COMPONENTS (
871: COMPONENT_SEQUENCE_ID,
872: COMPONENT_ITEM_ID,
873: OPERATION_SEQUENCE_NUM,
874: BILL_SEQUENCE_ID,

Line 1121: ** insert the cancelled rev components into eng_revised_components

1117: FROM bom_components_b
1118: WHERE common_component_sequence_id = comp_seq_id;
1119: Begin
1120: /*
1121: ** insert the cancelled rev components into eng_revised_components
1122: */
1123: stmt_num := 10;
1124: INSERT INTO ENG_REVISED_COMPONENTS (
1125: COMPONENT_SEQUENCE_ID,

Line 1124: INSERT INTO ENG_REVISED_COMPONENTS (

1120: /*
1121: ** insert the cancelled rev components into eng_revised_components
1122: */
1123: stmt_num := 10;
1124: INSERT INTO ENG_REVISED_COMPONENTS (
1125: COMPONENT_SEQUENCE_ID,
1126: COMPONENT_ITEM_ID,
1127: OPERATION_SEQUENCE_NUM,
1128: BILL_SEQUENCE_ID,