APPS.QPR_USER_PLAN_INIT_PVT dependencies on QPR_REPORT_LINES

Line 309: insert into qpr_report_lines

305: where RHT.report_header_id = RHB.report_header_id
306: and RHT.LANGUAGE = L.LANGUAGE_CODE);
307:
308:
309: insert into qpr_report_lines
310: (
311: REPORT_LINE_ID
312: ,REPORT_HEADER_ID
313: ,REPORT_TYPE_LINE_ID

Line 331: qpr_report_lines_s.nextval report_line_id

327: ,PROGRAM_APPLICATION_ID
328: ,REQUEST_ID
329: )
330: select
331: qpr_report_lines_s.nextval report_line_id
332: ,rhb.report_header_id
333: ,rtl.report_type_line_id
334: ,rtl.report_type_line_name
335: ,qpr_user_plan_init_pvt.g_folder_name

Line 358: from qpr_report_lines rl1

354: rta.report_type_header_id = rhb.report_type_header_id
355: and rtl.report_type_line_id = rta.report_type_line_id
356: and rhb.report_header_id not in
357: (select report_header_id
358: from qpr_report_lines rl1
359: );
360:
361: END Initialize_reports;
362:

Line 380: update qpr_report_lines rl

376: set report_valid_flag = G_REPORT_REFRESH_FLAG
377: where rh.user_id = p_user_id
378: and rh.plan_id = p_plan_id;
379:
380: update qpr_report_lines rl
381: set report_line_valid_flag = G_REPORT_REFRESH_FLAG
382: where rl.report_header_id in
383: (select report_header_id
384: from QPR_REPORT_TYPE_HDRS_B rth

Line 393: update qpr_report_lines rl

389: update QPR_REPORT_HDRS_B rh
390: set report_valid_flag = G_REPORT_REFRESH_FLAG
391: where rh.plan_id = p_plan_id;
392:
393: update qpr_report_lines rl
394: set report_line_valid_flag = G_REPORT_REFRESH_FLAG
395: where rl.report_header_id in
396: (select report_header_id
397: from QPR_REPORT_HDRS_B rh