APPS.BOMPNORD dependencies on BOM_EXPLOSIONS

Line 59: DELETE from bom_explosions

55: IS
56: pragma AUTONOMOUS_TRANSACTION;
57:
58: BEGIN
59: DELETE from bom_explosions
60: WHERE top_bill_sequence_id = top_bill_id
61: AND explosion_type = arg_expl_type;
62: COMMIT;
63: END Delete_Bom_Expl;

Line 115: FROM bom_explosions be

111: FROM sys.dual;
112:
113: Cursor Check_Flag is
114: Select 1
115: FROM bom_explosions be
116: WHERE be.top_bill_sequence_id = X_TOP_BILL_ID
117: AND be.explosion_type = EXPL_TYPE
118: and be.rexplode_flag = 1
119: and rownum = 1;

Line 123: from bom_explosions

119: and rownum = 1;
120:
121: Cursor Get_Eff_Date is
122: select to_date(to_char(effectivity_date,'YYYY/MM/DD HH24:MI'),'YYYY/MM/DD HH24:MI') effectivity_date
123: from bom_explosions
124: where top_bill_sequence_id = X_TOP_BILL_ID
125: AND explosion_type = EXPL_TYPE
126: and sort_order = lpad('1', X_SortWidth, '0');
127:

Line 185: -- Check if any rexplode flag is set for the bill in bom_explosions.

181: IF x_top_bill_id < 0 THEN
182: raise x_no_top_assy;
183: END IF;
184:
185: -- Check if any rexplode flag is set for the bill in bom_explosions.
186:
187: stmt_num := 30;
188: For X_Explosion in Check_Flag loop
189: X_ReExplode := true;

Line 193: -- Check if any rows exist in bom_explosions where component is effective

189: X_ReExplode := true;
190: End loop;
191:
192:
193: -- Check if any rows exist in bom_explosions where component is effective
194: -- before requested date. If none then set re-explosion flag to ensure it
195: -- explodes again to cover earlier revisions
196: --
197: -- Also check for duplicate explosions. If duplicate found, then re-explode.

Line 394: FROM bom_explosions

390: DISABLE_DATE,
391: IMPLEMENTATION_DATE,
392: REXPLODE_FLAG,
393: COMMON_BILL_SEQUENCE_ID
394: FROM bom_explosions
395: WHERE top_bill_sequence_id = X_TOP_BILL_ID
396: AND explosion_type = EXPL_TYPE
397: AND plan_level > 0
398: AND effectivity_date <= X_REVISION_DATE