APPS.QPR_REPORT_ENTITIES_PVT dependencies on QPR_REPORT_RELNS

Line 82: DELETE FROM QPR_REPORT_RELNS

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;
84:
85: DELETE FROM QPR_REPORT_HDRS_TL
86: WHERE REPORT_HEADER_ID = p_report_id;

Line 129: FROM QPR_REPORT_RELNS

125:
126: CURSOR Get_Related_Reports(p_parent_report_id NUMBER)
127: IS
128: SELECT TARGET_REPORT_ID
129: FROM QPR_REPORT_RELNS
130: WHERE PARENT_REPORT_ID = p_parent_report_id;
131:
132: BEGIN
133:

Line 156: (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);

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);
160:

Line 159: (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);

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);
163:

Line 162: (SELECT TARGET_REPORT_ID FROM QPR_REPORT_RELNS WHERE PARENT_REPORT_ID = p_parent_report_id);

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:
166: EXCEPTION

Line 224: DELETE FROM QPR_REPORT_RELNS

220: FROM QPR_REPORT_HDRS_B
221: WHERE PLAN_ID = p_price_plan_id
222: );
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