APPS.QPR_REPORT_ENTITIES_PVT dependencies on QPR_REPORT_HDRS_TL

Line 26: DELETE FROM QPR_REPORT_HDRS_TL

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;
28:
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30: EXCEPTION

Line 85: DELETE FROM QPR_REPORT_HDRS_TL

81:
82: DELETE FROM QPR_REPORT_RELNS
83: WHERE PARENT_REPORT_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;

Line 158: DELETE FROM QPR_REPORT_HDRS_TL WHERE REPORT_HEADER_ID IN

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);
160:
161: DELETE FROM QPR_REPORT_LINES WHERE REPORT_HEADER_ID IN
162: (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);

Line 231: DELETE FROM QPR_REPORT_HDRS_TL

227: FROM QPR_REPORT_HDRS_B
228: WHERE PLAN_ID = p_price_plan_id
229: );
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