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_ENC_CONTROLS

Line 3450: -- psp_enc_controls table.

3446: IF l_encumbrance_amount <> 0 THEN
3447:
3448: -- The following code is used to populate number_of_dr,number_of_cr,total_dr_amount,
3449: -- total_cr_amount,gl_dr_amount,gl_cr_amount,ogm_dr_amount,ogm_cr_amount of
3450: -- psp_enc_controls table.
3451:
3452: -- Check for dr_cr_flag and increment the counter and amount accordingly.
3453: FOR I IN 1..enc_control_tab.r_enc_control_id.COUNT
3454: loop

Line 3475: SELECT psp_enc_controls_s.nextval

3471: enc_control_tab.r_uom(l_rec_no) := g_uom;
3472: /***** Commented the following for Create and Update multi thread enh.
3473: -- Get a number for enc control id
3474: BEGIN
3475: SELECT psp_enc_controls_s.nextval
3476: INTO l_enc_control_id
3477: FROM DUAL;
3478: END;
3479: End of comment for Create and Update multi thread enh. *****/

Line 3591: FROM psp_enc_controls

3587: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3588: l_last_updated_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3589: CURSOR get_enc_control_id_cur IS
3590: SELECT enc_control_id
3591: FROM psp_enc_controls
3592: WHERE payroll_action_id = p_payroll_action_id
3593: AND payroll_id = p_payroll_id
3594: AND time_period_id = p_time_period_id
3595: AND uom = g_uom;

Line 3608: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;

3604: CLOSE get_enc_control_id_cur;
3605:
3606: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3607: IF (p_enc_control_id IS NULL) THEN
3608: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3609:
3610: INSERT INTO PSP_ENC_CONTROLS
3611: (time_period_id, enc_control_id,
3612: number_of_dr, number_of_cr,

Line 3610: INSERT INTO PSP_ENC_CONTROLS

3606: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3607: IF (p_enc_control_id IS NULL) THEN
3608: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3609:
3610: INSERT INTO PSP_ENC_CONTROLS
3611: (time_period_id, enc_control_id,
3612: number_of_dr, number_of_cr,
3613: total_dr_amount, total_cr_amount,
3614: gl_dr_amount, gl_cr_amount,

Line 7852: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');

7848: AND pesl.payroll_id = pepa.payroll_id
7849: AND pesl.status_code = 'N'
7850: AND pesl.superceded_line_id IS NOT NULL);
7851:
7852: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7853: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7854: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7856:

Line 7857: DELETE FROM psp_enc_controls pec

7853: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7854: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7855: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7856:
7857: DELETE FROM psp_enc_controls pec
7858: WHERE pec.payroll_action_id = p_payroll_action_id
7859: AND NOT EXISTS (SELECT 1
7860: FROM psp_enc_lines pel
7861: WHERE pel.enc_control_id = pec.enc_control_id);

Line 7862: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines in psp_enc_controls which doesnt have a line in psp_enc_lines');

7858: WHERE pec.payroll_action_id = p_payroll_action_id
7859: AND NOT EXISTS (SELECT 1
7860: FROM psp_enc_lines pel
7861: WHERE pel.enc_control_id = pec.enc_control_id);
7862: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines in psp_enc_controls which doesnt have a line in psp_enc_lines');
7863:
7864: UPDATE psp_enc_controls pec
7865: SET (action_code,
7866: number_of_dr, number_of_cr,

Line 7864: UPDATE psp_enc_controls pec

7860: FROM psp_enc_lines pel
7861: WHERE pel.enc_control_id = pec.enc_control_id);
7862: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted lines in psp_enc_controls which doesnt have a line in psp_enc_lines');
7863:
7864: UPDATE psp_enc_controls pec
7865: SET (action_code,
7866: number_of_dr, number_of_cr,
7867: total_dr_amount, total_cr_amount,
7868: gl_dr_amount, gl_cr_amount,

Line 7880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');

7876: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7877: FROM psp_enc_lines pel
7878: WHERE pel.enc_control_id = pec.enc_control_id)
7879: WHERE payroll_action_id = p_payroll_action_id;
7880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');
7881:
7882: IF (l_process_mode = 'TERMINATE') THEN
7883: UPDATE psp_enc_changed_assignments peca
7884: SET payroll_action_id = p_payroll_action_id

Line 8825: FROM psp_enc_controls

8821:
8822:
8823: CURSOR new_cust_cur IS
8824: SELECT COUNT(1)
8825: FROM psp_enc_controls
8826: WHERE ROWNUM = 1;
8827:
8828: CURSOR action_parameters_cur IS
8829: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),

Line 10138: DELETE psp_enc_controls

10134: DELETE psp_enc_lines
10135: WHERE payroll_action_id = p_payroll_action_id;
10136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
10137:
10138: DELETE psp_enc_controls
10139: WHERE payroll_action_id = p_payroll_action_id;
10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10141:
10142: DELETE psp_report_errors

Line 10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');

10136: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
10137:
10138: DELETE psp_enc_controls
10139: WHERE payroll_action_id = p_payroll_action_id;
10140: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10141:
10142: DELETE psp_report_errors
10143: WHERE payroll_action_id = p_payroll_action_id;
10144: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');

Line 10258: DELETE psp_enc_controls pec

10254: WHERE payroll_action_id = p_payroll_action_id
10255: AND assignment_id = l_assignments(recno);
10256: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
10257:
10258: DELETE psp_enc_controls pec
10259: WHERE payroll_action_id = p_payroll_action_id
10260: AND NOT EXISTS (SELECT 1
10261: FROM psp_enc_lines pel
10262: WHERE payroll_action_id = p_payroll_action_id

Line 10264: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');

10260: AND NOT EXISTS (SELECT 1
10261: FROM psp_enc_lines pel
10262: WHERE payroll_action_id = p_payroll_action_id
10263: AND pel.enc_control_id = pec.enc_control_id);
10264: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
10265:
10266: DELETE psp_report_errors
10267: WHERE payroll_action_id = p_payroll_action_id
10268: AND source_id = l_assignments(recno);