eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_ENC_CREATE_LINES dependencies on PSP_MATRIX_DRIVER_PKG

Line 4285: psp_matrix_driver_pkg.set_runid;

4281:
4282: recno INTEGER;
4283: -- End of bug fix 3970852
4284: BEGIN
4285: psp_matrix_driver_pkg.set_runid;
4286: l_run_id := psp_matrix_driver_pkg.get_run_id;
4287:
4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||

Line 4286: l_run_id := psp_matrix_driver_pkg.get_run_id;

4282: recno INTEGER;
4283: -- End of bug fix 3970852
4284: BEGIN
4285: psp_matrix_driver_pkg.set_runid;
4286: l_run_id := psp_matrix_driver_pkg.get_run_id;
4287:
4288: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4289: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4290: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||

Line 4602: psp_matrix_driver_pkg.clear_table('REFRESH');

4598: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
4599: CLOSE ls_hier_cur;
4600:
4601: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4602: psp_matrix_driver_pkg.clear_table('REFRESH');
4603: psp_matrix_driver_pkg.purge_table;
4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4605:
4606: DELETE psp_matrix_driver

Line 4603: psp_matrix_driver_pkg.purge_table;

4599: CLOSE ls_hier_cur;
4600:
4601: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4602: psp_matrix_driver_pkg.clear_table('REFRESH');
4603: psp_matrix_driver_pkg.purge_table;
4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4605:
4606: DELETE psp_matrix_driver
4607: WHERE run_id = l_run_id

Line 4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4600:
4601: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4602: psp_matrix_driver_pkg.clear_table('REFRESH');
4603: psp_matrix_driver_pkg.purge_table;
4604: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4605:
4606: DELETE psp_matrix_driver
4607: WHERE run_id = l_run_id
4608: AND (period_start_date > l_max_end_date

Line 4994: psp_matrix_driver_pkg.clear_table('REFRESH');

4990: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
4991: END LOOP;
4992: hr_utility.trace('Element Group Processing ...');
4993:
4994: psp_matrix_driver_pkg.clear_table('REFRESH');
4995: psp_matrix_driver_pkg.purge_table;
4996: l_period_count := r_enc_period.r_time_period_id.COUNT;
4997: OPEN eg_hier_cur;
4998: LOOP

Line 4995: psp_matrix_driver_pkg.purge_table;

4991: END LOOP;
4992: hr_utility.trace('Element Group Processing ...');
4993:
4994: psp_matrix_driver_pkg.clear_table('REFRESH');
4995: psp_matrix_driver_pkg.purge_table;
4996: l_period_count := r_enc_period.r_time_period_id.COUNT;
4997: OPEN eg_hier_cur;
4998: LOOP
4999: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;

Line 5003: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4999: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;
5000: EXIT WHEN eg_hier_cur%NOTFOUND;
5001:
5002: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5003: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5004:
5005: DELETE psp_matrix_driver
5006: WHERE run_id = l_run_id
5007: AND (period_start_date > l_max_end_date

Line 5392: psp_matrix_driver_pkg.clear_table('REFRESH');

5388: RPAD(r_enc_period_tmp1.r_reason_code(recno), 50, ' '));
5389: END LOOP;
5390: hr_utility.trace('Assignment Processing ...');
5391:
5392: psp_matrix_driver_pkg.clear_table('REFRESH');
5393: psp_matrix_driver_pkg.purge_table;
5394: l_period_count := r_enc_period.r_time_period_id.COUNT;
5395: OPEN ls_hier_cur('A');
5396: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;

Line 5393: psp_matrix_driver_pkg.purge_table;

5389: END LOOP;
5390: hr_utility.trace('Assignment Processing ...');
5391:
5392: psp_matrix_driver_pkg.clear_table('REFRESH');
5393: psp_matrix_driver_pkg.purge_table;
5394: l_period_count := r_enc_period.r_time_period_id.COUNT;
5395: OPEN ls_hier_cur('A');
5396: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5397: CLOSE ls_hier_cur;

Line 5400: psp_matrix_driver_pkg.clear_table('REFRESH');

5396: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5397: CLOSE ls_hier_cur;
5398:
5399: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5400: psp_matrix_driver_pkg.clear_table('REFRESH');
5401: psp_matrix_driver_pkg.purge_table;
5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5403:
5404: DELETE psp_matrix_driver

Line 5401: psp_matrix_driver_pkg.purge_table;

5397: CLOSE ls_hier_cur;
5398:
5399: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5400: psp_matrix_driver_pkg.clear_table('REFRESH');
5401: psp_matrix_driver_pkg.purge_table;
5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5403:
5404: DELETE psp_matrix_driver
5405: WHERE run_id = l_run_id

Line 5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

5398:
5399: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5400: psp_matrix_driver_pkg.clear_table('REFRESH');
5401: psp_matrix_driver_pkg.purge_table;
5402: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5403:
5404: DELETE psp_matrix_driver
5405: WHERE run_id = l_run_id
5406: AND (period_start_date > l_max_end_date

Line 5762: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852

5758: r_enc_period_tmp1.r_effective_date.DELETE;
5759: l_rec_no := 1;
5760: l_proc_step := 130;
5761:
5762: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5763: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5764:
5765: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5766: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||

Line 5763: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852

5759: l_rec_no := 1;
5760: l_proc_step := 130;
5761:
5762: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5763: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5764:
5765: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5766: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5767: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||