19: x_return_status OUT NOCOPY VARCHAR2)
20: IS
21: BEGIN
22:
23: DELETE FROM QPR_REPORT_HDRS_B
24: WHERE REPORT_HEADER_ID = p_report_id;
25:
26: DELETE FROM QPR_REPORT_HDRS_TL
27: WHERE REPORT_HEADER_ID = p_report_id;
84:
85: DELETE FROM QPR_REPORT_HDRS_TL
86: WHERE REPORT_HEADER_ID = p_report_id;
87:
88: DELETE FROM QPR_REPORT_HDRS_B
89: WHERE REPORT_HEADER_ID = p_report_id;
90:
91:
92: EXCEPTION
151: CLOSE Get_Report_Lines;
152: END LOOP;
153: CLOSE Get_Related_Reports;
154:
155: DELETE FROM QPR_REPORT_HDRS_B WHERE REPORT_HEADER_ID IN
156: (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);
157:
158: DELETE FROM QPR_REPORT_HDRS_TL WHERE REPORT_HEADER_ID IN
159: (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);
192:
193: CURSOR Get_Report_Lines(c_price_plan_id NUMBER)
194: IS
195: SELECT QRL.REPORT_LINE_ID
196: FROM QPR_REPORT_HDRS_B QRH,
197: QPR_REPORT_LINES QRL
198: WHERE QRH.REPORT_HEADER_ID = QRL.REPORT_HEADER_ID
199: AND QRH.PLAN_ID = c_price_plan_id;
200: BEGIN
216:
217: DELETE FROM QPR_REPORT_LINES
218: WHERE REPORT_HEADER_ID IN (
219: SELECT REPORT_HEADER_ID
220: FROM QPR_REPORT_HDRS_B
221: WHERE PLAN_ID = p_price_plan_id
222: );
223:
224: DELETE FROM QPR_REPORT_RELNS
223:
224: DELETE FROM QPR_REPORT_RELNS
225: WHERE PARENT_REPORT_ID IN (
226: SELECT REPORT_HEADER_ID
227: FROM QPR_REPORT_HDRS_B
228: WHERE PLAN_ID = p_price_plan_id
229: );
230:
231: DELETE FROM QPR_REPORT_HDRS_TL
230:
231: DELETE FROM QPR_REPORT_HDRS_TL
232: WHERE REPORT_HEADER_ID IN (
233: SELECT REPORT_HEADER_ID
234: FROM QPR_REPORT_HDRS_B
235: WHERE PLAN_ID = p_price_plan_id
236: );
237: DELETE FROM QPR_REPORT_HDRS_B
238: WHERE PLAN_ID = p_price_plan_id;
233: SELECT REPORT_HEADER_ID
234: FROM QPR_REPORT_HDRS_B
235: WHERE PLAN_ID = p_price_plan_id
236: );
237: DELETE FROM QPR_REPORT_HDRS_B
238: WHERE PLAN_ID = p_price_plan_id;
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: EXCEPTION