DBA Data[Home] [Help]

APPS.CSD_ESTIMATES_FROM_BOM_PVT dependencies on CSD_BOM_EXPL_TEMP

Line 120: delete from csd_bom_expl_temp;

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

Line 121: INSERT INTO csd_bom_expl_temp (

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

Line 272: DELETE FROM csd_bom_expl_temp;

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

Line 279: INSERT INTO csd_bom_expl_temp (

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