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 3219: -- psp_enc_controls table.

3215: IF l_encumbrance_amount <> 0 THEN
3216:
3217: -- The following code is used to populate number_of_dr,number_of_cr,total_dr_amount,
3218: -- total_cr_amount,gl_dr_amount,gl_cr_amount,ogm_dr_amount,ogm_cr_amount of
3219: -- psp_enc_controls table.
3220:
3221: -- Check for dr_cr_flag and increment the counter and amount accordingly.
3222: FOR I IN 1..enc_control_tab.r_enc_control_id.COUNT
3223: loop

Line 3244: SELECT psp_enc_controls_s.nextval

3240: enc_control_tab.r_uom(l_rec_no) := g_uom;
3241: /***** Commented the following for Create and Update multi thread enh.
3242: -- Get a number for enc control id
3243: BEGIN
3244: SELECT psp_enc_controls_s.nextval
3245: INTO l_enc_control_id
3246: FROM DUAL;
3247: END;
3248: End of comment for Create and Update multi thread enh. *****/

Line 3359: FROM psp_enc_controls

3355: l_last_updated_by NUMBER DEFAULT NVL(FND_GLOBAL.USER_ID, -1);
3356: l_last_updated_login NUMBER DEFAULT NVL(FND_GLOBAL.LOGIN_ID, -1);
3357: CURSOR get_enc_control_id_cur IS
3358: SELECT enc_control_id
3359: FROM psp_enc_controls
3360: WHERE payroll_action_id = p_payroll_action_id
3361: AND payroll_id = p_payroll_id
3362: AND time_period_id = p_time_period_id
3363: AND uom = g_uom;

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

3372: CLOSE get_enc_control_id_cur;
3373:
3374: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3375: IF (p_enc_control_id IS NULL) THEN
3376: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3377:
3378: INSERT INTO PSP_ENC_CONTROLS
3379: (time_period_id, enc_control_id,
3380: number_of_dr, number_of_cr,

Line 3378: INSERT INTO PSP_ENC_CONTROLS

3374: -- FORALL i IN 1 ..enc_control_tab.r_time_period_id.COUNT
3375: IF (p_enc_control_id IS NULL) THEN
3376: SELECT psp_enc_controls_s.NEXTVAL INTO p_enc_control_id FROM DUAL;
3377:
3378: INSERT INTO PSP_ENC_CONTROLS
3379: (time_period_id, enc_control_id,
3380: number_of_dr, number_of_cr,
3381: total_dr_amount, total_cr_amount,
3382: gl_dr_amount, gl_cr_amount,

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

7536: AND pesl.payroll_id = pepa.payroll_id
7537: AND pesl.status_code = 'N'
7538: AND pesl.superceded_line_id IS NOT NULL);
7539:
7540: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7544:

Line 7545: DELETE FROM psp_enc_controls pec

7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7544:
7545: DELETE FROM psp_enc_controls pec
7546: WHERE pec.payroll_action_id = p_payroll_action_id
7547: AND NOT EXISTS (SELECT 1
7548: FROM psp_enc_lines pel
7549: WHERE pel.enc_control_id = pec.enc_control_id);

Line 7550: 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');

7546: WHERE pec.payroll_action_id = p_payroll_action_id
7547: AND NOT EXISTS (SELECT 1
7548: FROM psp_enc_lines pel
7549: WHERE pel.enc_control_id = pec.enc_control_id);
7550: 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');
7551:
7552: UPDATE psp_enc_controls pec
7553: SET (action_code,
7554: number_of_dr, number_of_cr,

Line 7552: UPDATE psp_enc_controls pec

7548: FROM psp_enc_lines pel
7549: WHERE pel.enc_control_id = pec.enc_control_id);
7550: 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');
7551:
7552: UPDATE psp_enc_controls pec
7553: SET (action_code,
7554: number_of_dr, number_of_cr,
7555: total_dr_amount, total_cr_amount,
7556: gl_dr_amount, gl_cr_amount,

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

7564: SUM(fnd_number.canonical_to_number(DECODE(pel.gl_project_flag, 'P', DECODE(pel.dr_cr_flag, 'C', pel.encumbrance_amount, 0), 0)))
7565: FROM psp_enc_lines pel
7566: WHERE pel.enc_control_id = pec.enc_control_id)
7567: WHERE payroll_action_id = p_payroll_action_id;
7568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');
7569:
7570: IF (l_process_mode = 'TERMINATE') THEN
7571: UPDATE psp_enc_changed_assignments peca
7572: SET payroll_action_id = p_payroll_action_id

Line 8501: FROM psp_enc_controls

8497: l_termination_date5 DATE;
8498:
8499: CURSOR new_cust_cur IS
8500: SELECT COUNT(1)
8501: FROM psp_enc_controls
8502: WHERE ROWNUM = 1;
8503:
8504: CURSOR action_parameters_cur IS
8505: SELECT fnd_number.canonical_to_number(NVL(argument13, '-1')),

Line 9509: DELETE psp_enc_controls

9505: DELETE psp_enc_lines
9506: WHERE payroll_action_id = p_payroll_action_id;
9507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
9508:
9509: DELETE psp_enc_controls
9510: WHERE payroll_action_id = p_payroll_action_id;
9511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9512:
9513: DELETE psp_report_errors

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

9507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
9508:
9509: DELETE psp_enc_controls
9510: WHERE payroll_action_id = p_payroll_action_id;
9511: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9512:
9513: DELETE psp_report_errors
9514: WHERE payroll_action_id = p_payroll_action_id;
9515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');

Line 9629: DELETE psp_enc_controls pec

9625: WHERE payroll_action_id = p_payroll_action_id
9626: AND assignment_id = l_assignments(recno);
9627: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');
9628:
9629: DELETE psp_enc_controls pec
9630: WHERE payroll_action_id = p_payroll_action_id
9631: AND NOT EXISTS (SELECT 1
9632: FROM psp_enc_lines pel
9633: WHERE payroll_action_id = p_payroll_action_id

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

9631: AND NOT EXISTS (SELECT 1
9632: FROM psp_enc_lines pel
9633: WHERE payroll_action_id = p_payroll_action_id
9634: AND pel.enc_control_id = pec.enc_control_id);
9635: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_controls');
9636:
9637: DELETE psp_report_errors
9638: WHERE payroll_action_id = p_payroll_action_id
9639: AND source_id = l_assignments(recno);