APPS.ENG_CANCEL_ECO dependencies on ENG_REVISED_COMPONENTS

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

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

Line 201: INSERT INTO ENG_REVISED_COMPONENTS (

197: /*
198: ** insert the cancelled rev components into eng_revised_components
199: */
200: stmt_num := 40;
201: INSERT INTO ENG_REVISED_COMPONENTS (
202: COMPONENT_SEQUENCE_ID,
203: COMPONENT_ITEM_ID,
204: OPERATION_SEQUENCE_NUM,
205: BILL_SEQUENCE_ID,

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

888: WHERE IC.REVISED_ITEM_SEQUENCE_ID = rev_item_seq);
889: -- dbms_output.put_line(SQL%ROWCOUNT || ' rows deleted from brd');
890:
891: /*
892: ** insert the cancelled rev components into eng_revised_components
893: */
894: stmt_num := 40;
895: INSERT INTO ENG_REVISED_COMPONENTS (
896: COMPONENT_SEQUENCE_ID,

Line 895: INSERT INTO ENG_REVISED_COMPONENTS (

891: /*
892: ** insert the cancelled rev components into eng_revised_components
893: */
894: stmt_num := 40;
895: INSERT INTO ENG_REVISED_COMPONENTS (
896: COMPONENT_SEQUENCE_ID,
897: COMPONENT_ITEM_ID,
898: OPERATION_SEQUENCE_NUM,
899: BILL_SEQUENCE_ID,

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

1149: FROM bom_components_b
1150: WHERE common_component_sequence_id = comp_seq_id;
1151: Begin
1152: /*
1153: ** insert the cancelled rev components into eng_revised_components
1154: */
1155: stmt_num := 10;
1156: INSERT INTO ENG_REVISED_COMPONENTS (
1157: COMPONENT_SEQUENCE_ID,

Line 1156: INSERT INTO ENG_REVISED_COMPONENTS (

1152: /*
1153: ** insert the cancelled rev components into eng_revised_components
1154: */
1155: stmt_num := 10;
1156: INSERT INTO ENG_REVISED_COMPONENTS (
1157: COMPONENT_SEQUENCE_ID,
1158: COMPONENT_ITEM_ID,
1159: OPERATION_SEQUENCE_NUM,
1160: BILL_SEQUENCE_ID,