[Home] [Help]
59: -- fnd_file.put_line(fnd_file.log,'order_by_2 ===='||l_psp_order_by2);
60: -- fnd_file.put_line(fnd_file.log,'layout ===='||l_psp_report_layout);
61:
62:
63: /* insert record in psp_report_templates_h */
64:
65: insert into psp_report_templates_h(request_id, template_id, template_name,
66: business_group_id, set_of_books_id, report_type, period_frequency_id,
67: report_template_code, display_all_emp_distrib_flag,
61:
62:
63: /* insert record in psp_report_templates_h */
64:
65: insert into psp_report_templates_h(request_id, template_id, template_name,
66: business_group_id, set_of_books_id, report_type, period_frequency_id,
67: report_template_code, display_all_emp_distrib_flag,
68: manual_entry_override_flag, approval_type, custom_approval_code,
69: sup_levels, preview_effort_report_flag, notification_reminder_in_days, parameter_name_1, parameter_name_2, parameter_name_3, parameter_name_4, parameter_name_5,
88: 'ORDER_BY4', NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, l_psp_template_id, l_psp_effort_start, l_psp_effort_end, l_psp_report_layout, l_psp_sort_option1, l_psp_order_by1,
89: l_psp_sort_option2, l_psp_order_by2, l_psp_sort_option3, l_psp_order_by3, l_psp_sort_option4, l_psp_order_by4, NULL, NULL, NULL
90: , NULL, NULL, NULL, NULL, NULL, sysdate, fnd_global.employee_id, NULL,
91: NULL, NULL, sprcd_tolerance_amt, sprcd_tolerance_percent, description, legislation_code,
92: p_payroll_action_id, last_update_date, last_updated_by, last_update_login, created_by, creation_date, hundred_pcent_eff_at_per_asg,selection_match_level from psp_report_templates where template_id = l_psp_template_id);
93:
94:
95: insert into psp_report_template_details_h (request_id, template_detail_id, criteria_lookup_type,
96: criteria_lookup_code, include_exclude_flag, criteria_value1, criteria_value2, criteria_value3,
104: COMMIT;
105:
106: EXCEPTION WHEN OTHERS THEN
107:
108: l_sqlerrm := 'Error inserting into psp_report_templates_history '|| substr(sqlerrm,1,180);
109:
110: /* Removed payroll_action_id to make it independent of payroll_action_id */
111: -- psp_general.add_report_error(p_request_id, 'E',null, l_sqlerrm, p_payroll_action_id, l_return_status);
112: psp_general.add_report_error
288:
289: CURSOR get_template_selection
290: IS
291: SELECT template_id, parameter_value_2, parameter_value_3, business_group_id, set_of_books_id, selection_match_level
292: from psp_report_templates_h
293: where request_id = p_request_id;
294:
295: l_template_id NUMBER;
296: l_count NUMBER;