APPS.QPR_REPORT_ENTITIES_PVT dependencies on QPR_REPORT_LINES

Line 60: FROM QPR_REPORT_LINES

56:
57: CURSOR Get_Report_Lines(p_report_id NUMBER)
58: IS
59: SELECT REPORT_LINE_ID
60: FROM QPR_REPORT_LINES
61: WHERE REPORT_HEADER_ID = p_report_id;
62:
63: BEGIN
64:

Line 79: DELETE FROM QPR_REPORT_LINES

75: WHERE OBJECT_NAME LIKE 'qpr'||l_report_line_id||'q%';*/
76: END LOOP;
77: CLOSE Get_Report_Lines;
78:
79: DELETE FROM QPR_REPORT_LINES
80: WHERE REPORT_HEADER_ID = p_report_id;
81:
82: DELETE FROM QPR_REPORT_RELNS
83: WHERE PARENT_REPORT_ID = p_report_id;

Line 123: FROM QPR_REPORT_LINES

119:
120: CURSOR Get_Report_Lines(p_parent_report_id NUMBER)
121: IS
122: SELECT REPORT_LINE_ID
123: FROM QPR_REPORT_LINES
124: WHERE REPORT_HEADER_ID = p_parent_report_id;
125:
126: CURSOR Get_Related_Reports(p_parent_report_id NUMBER)
127: IS

Line 161: DELETE FROM QPR_REPORT_LINES WHERE REPORT_HEADER_ID IN

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);
163:
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:

Line 197: QPR_REPORT_LINES QRL

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
201:

Line 217: DELETE FROM QPR_REPORT_LINES

213:
214: END LOOP;
215: CLOSE Get_Report_Lines;
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