[Home] [Help]
145:
146: CURSOR c_details (p_dashboard_id IN NUMBER ) IS
147: SELECT
148: dashboard_detail_id,row_number,column_number,content_id,width
149: FROM QPR_DASHBOARD_DETAILS
150: WHERE dashboard_id = p_dashboard_id;
151:
152: BEGIN
153:
162: WHERE report_type_header_id = l_content_id
163: and user_id = p_user_id
164: and plan_id = p_plan_id
165: and Seeded_Report_Flag = 'Y';
166: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO n_dashboard_detail_id FROM DUAL;
167:
168: UPDATE QPR_DASHBOARD_DETAILS
169: SET DASHBOARD_ID = n_dashboard_id,
170: DASHBOARD_DETAIL_ID = n_dashboard_detail_id,
164: and plan_id = p_plan_id
165: and Seeded_Report_Flag = 'Y';
166: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO n_dashboard_detail_id FROM DUAL;
167:
168: UPDATE QPR_DASHBOARD_DETAILS
169: SET DASHBOARD_ID = n_dashboard_id,
170: DASHBOARD_DETAIL_ID = n_dashboard_detail_id,
171: CONTENT_ID = l_report_header_id
172: WHERE DASHBOARD_DETAIL_ID = l_dashboard_detail_id;
285: );
286:
287: FOR i in 0..(p_dsb_table.count - 1)
288: LOOP
289: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO l_dashboard_detail_id FROM
290: DUAL;
291: INSERT INTO QPR_DASHBOARD_DETAILS
292: ( DASHBOARD_DETAIL_ID
293: , DASHBOARD_ID
287: FOR i in 0..(p_dsb_table.count - 1)
288: LOOP
289: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO l_dashboard_detail_id FROM
290: DUAL;
291: INSERT INTO QPR_DASHBOARD_DETAILS
292: ( DASHBOARD_DETAIL_ID
293: , DASHBOARD_ID
294: , ROW_NUMBER
295: , COLUMN_NUMBER
340: l_detail_id NUMBER;
341: CURSOR Get_Dashboard_Details_C(c_price_plan_id NUMBER)
342: IS
343: SELECT DT.DASHBOARD_DETAIL_ID
344: FROM QPR_DASHBOARD_DETAILS DT
345: ,QPR_DASHBOARD_MASTER_B DMB
346: WHERE DMB.DASHBOARD_ID = DT.DASHBOARD_ID
347: AND DMB.PLAN_ID = c_price_plan_id;
348:
356: THEN
357: EXIT;
358: END IF;
359:
360: DELETE FROM QPR_DASHBOARD_DETAILS
361: WHERE DASHBOARD_DETAIL_ID = l_detail_id;
362: END LOOP;
363: CLOSE Get_Dashboard_Details_C;
364: