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 4049: psp_matrix_driver_pkg.set_runid;

4045:
4046: recno INTEGER;
4047: -- End of bug fix 3970852
4048: BEGIN
4049: psp_matrix_driver_pkg.set_runid;
4050: l_run_id := psp_matrix_driver_pkg.get_run_id;
4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||

Line 4050: l_run_id := psp_matrix_driver_pkg.get_run_id;

4046: recno INTEGER;
4047: -- End of bug fix 3970852
4048: BEGIN
4049: psp_matrix_driver_pkg.set_runid;
4050: l_run_id := psp_matrix_driver_pkg.get_run_id;
4051:
4052: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering ' || l_proc_name);
4053: hr_utility.trace('p_assignment_id: ' || fnd_number.number_to_canonical(p_assignment_id) ||
4054: ' p_element_type_id: ' || fnd_number.number_to_canonical(p_element_type_id) ||

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

4362: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
4363: CLOSE ls_hier_cur;
4364:
4365: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4366: psp_matrix_driver_pkg.clear_table('REFRESH');
4367: psp_matrix_driver_pkg.purge_table;
4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4369:
4370: DELETE psp_matrix_driver

Line 4367: psp_matrix_driver_pkg.purge_table;

4363: CLOSE ls_hier_cur;
4364:
4365: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4366: psp_matrix_driver_pkg.clear_table('REFRESH');
4367: psp_matrix_driver_pkg.purge_table;
4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4369:
4370: DELETE psp_matrix_driver
4371: WHERE run_id = l_run_id

Line 4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4364:
4365: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4366: psp_matrix_driver_pkg.clear_table('REFRESH');
4367: psp_matrix_driver_pkg.purge_table;
4368: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4369:
4370: DELETE psp_matrix_driver
4371: WHERE run_id = l_run_id
4372: AND (period_start_date > l_max_end_date

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

4754: RPAD(r_enc_period.r_reason_code(recno), 50, ' '));
4755: END LOOP;
4756: hr_utility.trace('Element Group Processing ...');
4757:
4758: psp_matrix_driver_pkg.clear_table('REFRESH');
4759: psp_matrix_driver_pkg.purge_table;
4760: l_period_count := r_enc_period.r_time_period_id.COUNT;
4761: OPEN eg_hier_cur;
4762: LOOP

Line 4759: psp_matrix_driver_pkg.purge_table;

4755: END LOOP;
4756: hr_utility.trace('Element Group Processing ...');
4757:
4758: psp_matrix_driver_pkg.clear_table('REFRESH');
4759: psp_matrix_driver_pkg.purge_table;
4760: l_period_count := r_enc_period.r_time_period_id.COUNT;
4761: OPEN eg_hier_cur;
4762: LOOP
4763: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;

Line 4767: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

4763: FETCH eg_hier_cur INTO l_schedule_hierarchy_id;
4764: EXIT WHEN eg_hier_cur%NOTFOUND;
4765:
4766: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
4767: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
4768:
4769: DELETE psp_matrix_driver
4770: WHERE run_id = l_run_id
4771: AND (period_start_date > l_max_end_date

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

5152: RPAD(r_enc_period_tmp1.r_reason_code(recno), 50, ' '));
5153: END LOOP;
5154: hr_utility.trace('Assignment Processing ...');
5155:
5156: psp_matrix_driver_pkg.clear_table('REFRESH');
5157: psp_matrix_driver_pkg.purge_table;
5158: l_period_count := r_enc_period.r_time_period_id.COUNT;
5159: OPEN ls_hier_cur('A');
5160: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;

Line 5157: psp_matrix_driver_pkg.purge_table;

5153: END LOOP;
5154: hr_utility.trace('Assignment Processing ...');
5155:
5156: psp_matrix_driver_pkg.clear_table('REFRESH');
5157: psp_matrix_driver_pkg.purge_table;
5158: l_period_count := r_enc_period.r_time_period_id.COUNT;
5159: OPEN ls_hier_cur('A');
5160: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5161: CLOSE ls_hier_cur;

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

5160: FETCH ls_hier_cur INTO l_schedule_hierarchy_id;
5161: CLOSE ls_hier_cur;
5162:
5163: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5164: psp_matrix_driver_pkg.clear_table('REFRESH');
5165: psp_matrix_driver_pkg.purge_table;
5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5167:
5168: DELETE psp_matrix_driver

Line 5165: psp_matrix_driver_pkg.purge_table;

5161: CLOSE ls_hier_cur;
5162:
5163: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5164: psp_matrix_driver_pkg.clear_table('REFRESH');
5165: psp_matrix_driver_pkg.purge_table;
5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5167:
5168: DELETE psp_matrix_driver
5169: WHERE run_id = l_run_id

Line 5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);

5162:
5163: /***** Commented for bug fix 3970852 to resolve issues when schedule dates equal default end date
5164: psp_matrix_driver_pkg.clear_table('REFRESH');
5165: psp_matrix_driver_pkg.purge_table;
5166: psp_matrix_driver_pkg.load_table(l_schedule_hierarchy_id);
5167:
5168: DELETE psp_matrix_driver
5169: WHERE run_id = l_run_id
5170: AND (period_start_date > l_max_end_date

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

5522: r_enc_period_tmp1.r_effective_date.DELETE;
5523: l_rec_no := 1;
5524: l_proc_step := 130;
5525:
5526: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5527: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5528:
5529: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5530: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||

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

5523: l_rec_no := 1;
5524: l_proc_step := 130;
5525:
5526: -- psp_matrix_driver_pkg.clear_table('REFRESH'); Commented for bug fix 3970852
5527: -- psp_matrix_driver_pkg.purge_table; Commented for bug fix 3970852
5528:
5529: hr_utility.trace('Dumping Assignment Chunk After Assignment Processing ...');
5530: hr_utility.trace(LPAD('Chunk Pointer', 13, ' ') || ' ' ||
5531: LPAD('Time Period Id', 14, ' ') || ' ' || RPAD('Period Start Date', 17, ' ') || ' ' ||