APPS.CSD_ESTIMATES_FROM_BOM_PVT dependencies on CSD_BOM_EXPL_TEMP

Line 121: delete from csd_bom_expl_temp;

117: raise exploder_error;
118: end if;
119: if l_err_code = 0 or l_err_code = null then
120:
121: delete from csd_bom_expl_temp;
122: INSERT INTO csd_bom_expl_temp (
123: TOP_BILL_SEQUENCE_ID ,
124: BILL_SEQUENCE_ID ,
125: COMMON_BILL_SEQUENCE_ID ,

Line 122: INSERT INTO csd_bom_expl_temp (

118: end if;
119: if l_err_code = 0 or l_err_code = null then
120:
121: delete from csd_bom_expl_temp;
122: INSERT INTO csd_bom_expl_temp (
123: TOP_BILL_SEQUENCE_ID ,
124: BILL_SEQUENCE_ID ,
125: COMMON_BILL_SEQUENCE_ID ,
126: ORGANIZATION_ID ,

Line 273: DELETE FROM csd_bom_expl_temp;

269: l_count := l_bom_exp_tab.COUNT;
270:
271: -- clear the temp table.
272:
273: DELETE FROM csd_bom_expl_temp;
274:
275: /*FOR i IN 1 ..l_count
276: LOOP
277:

Line 280: INSERT INTO csd_bom_expl_temp (

276: LOOP
277:
278: -- Insert the values into the temp table.
279:
280: INSERT INTO csd_bom_expl_temp (
281: top_bill_sequence_id,
282: bill_sequence_id,
283: organization_id,
284: component_sequence_id,