DBA Data[Home] [Help]

APPS.QPR_DASHBOARD_UTIL dependencies on QPR_DASHBOARD_DETAILS_S

Line 166: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO n_dashboard_detail_id FROM DUAL;

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,

Line 289: SELECT QPR_DASHBOARD_DETAILS_S.NEXTVAL INTO l_dashboard_detail_id FROM

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