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_PROCESS_ASSIGNMENTS

Line 6708: INSERT INTO psp_enc_process_assignments

6704: END IF;
6705:
6706: sqlstr := sqlstr || 'payroll_action_id = :payroll_action_id ORDER BY assignment_id';
6707:
6708: INSERT INTO psp_enc_process_assignments
6709: (payroll_action_id, assignment_id, payroll_id,
6710: assignment_status, creation_date, created_by,
6711: last_update_date, last_updated_by, last_update_login)
6712: SELECT DISTINCT pactid, assignment_id, payroll_id,

Line 6850: FROM psp_enc_process_assignments pepa

6846: OR (l_process_mode = 'REGULAR' AND change_type <> 'TR'))
6847: AND payroll_id = NVL(l_payroll_id, payroll_id)
6848: AND NOT EXISTS(
6849: SELECT 1
6850: FROM psp_enc_process_assignments pepa
6851: WHERE pepa.assignment_id = peca.assignment_id
6852: AND assignment_status IN ('S','L')
6853: AND payroll_id = l_payroll_id
6854: )

Line 6857: FROM psp_enc_process_assignments pepa

6853: AND payroll_id = l_payroll_id
6854: )
6855: -- Added the above condition for the bug 13036705
6856: /*AND NOT EXISTS (SELECT 1
6857: FROM psp_enc_process_assignments pepa
6858: WHERE pepa.assignment_id = peca.assignment_id
6859: AND pepa.payroll_action_id = p_payroll_action_id
6860: AND pepa.assignment_status <> 'B')*/;
6861:

Line 7338: from psp_enc_process_assignments

7334: ||' term date: '||t_assignments.term_date_array(k));
7335:
7336: select count(*)
7337: into l_asg_sl_count
7338: from psp_enc_process_assignments
7339: where assignment_id = t_assignments.asg_array(k)
7340: and assignment_status in ('S','L');
7341: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' count: '||l_asg_sl_count);
7342:

Line 7626: UPDATE psp_enc_process_assignments pepa

7622: END IF;
7623: END LOOP;
7624:
7625: FORALL recno IN 1..t_assignments.asg_array.COUNT
7626: UPDATE psp_enc_process_assignments pepa
7627: SET assignment_status = 'B'
7628: WHERE pepa.payroll_action_id = p_payroll_action_id
7629: AND pepa.assignment_id = t_assignments.asg_array(recno)
7630: AND pepa.payroll_id = t_assignments.payroll_array(recno)

Line 7638: UPDATE psp_enc_process_assignments pepa

7634: AND pesl.assignment_id = t_assignments.asg_array(recno)
7635: AND pesl.payroll_id = t_assignments.payroll_array(recno));
7636:
7637: FORALL recno IN 1..t_assignments.asg_array.COUNT
7638: UPDATE psp_enc_process_assignments pepa
7639: SET assignment_status = 'S'
7640: WHERE pepa.payroll_action_id = p_payroll_action_id
7641: AND pepa.assignment_id = t_assignments.asg_array(recno)
7642: AND pepa.payroll_id = t_assignments.payroll_array(recno)

Line 7650: UPDATE psp_enc_process_assignments pepa

7646: AND pesl.assignment_id = t_assignments.asg_array(recno)
7647: AND pesl.payroll_id = t_assignments.payroll_array(recno));
7648:
7649: FORALL recno IN 1..t_assignments.asg_array.COUNT
7650: UPDATE psp_enc_process_assignments pepa
7651: SET assignment_status = 'L'
7652: WHERE pepa.payroll_action_id = p_payroll_action_id
7653: AND pepa.assignment_id = t_assignments.asg_array(recno)
7654: AND pepa.payroll_id = t_assignments.payroll_array(recno)

Line 7820: UPDATE psp_enc_process_assignments pepa

7816: COMMIT;
7817: RAISE fnd_api.g_exc_unexpected_error;
7818: END IF;
7819:
7820: UPDATE psp_enc_process_assignments pepa
7821: SET assignment_status = 'B'
7822: WHERE payroll_action_id = p_payroll_action_id
7823: AND NOT EXISTS (SELECT 1
7824: FROM psp_enc_summary_lines pesl

Line 7830: UPDATE psp_enc_process_assignments pepa

7826: AND pesl.assignment_id = pepa.assignment_id
7827: AND pesl.payroll_id = pepa.payroll_id
7828: AND pesl.status_code = 'N');
7829:
7830: UPDATE psp_enc_process_assignments pepa
7831: SET assignment_status = 'S'
7832: WHERE payroll_action_id = p_payroll_action_id
7833: AND EXISTS (SELECT 1
7834: FROM psp_enc_summary_lines pesl

Line 7841: UPDATE psp_enc_process_assignments pepa

7837: AND pesl.payroll_id = pepa.payroll_id
7838: AND pesl.status_code = 'N'
7839: AND pesl.superceded_line_id IS NULL);
7840:
7841: UPDATE psp_enc_process_assignments pepa
7842: SET assignment_status = 'L'
7843: WHERE payroll_action_id = p_payroll_action_id
7844: AND EXISTS (SELECT 1
7845: FROM psp_enc_summary_lines pesl

Line 8925: FROM psp_enc_process_assignments pepa

8921:
8922: CURSOR in_process_asg_cur IS
8923: SELECT pepa.assignment_id,
8924: pepa.payroll_action_id
8925: FROM psp_enc_process_assignments pepa
8926: WHERE pepa.payroll_id = p_payroll_id
8927: AND pepa.assignment_status NOT IN ('B', 'P');
8928:
8929: l_prev_enc_end_date PSP_ENC_END_DATES_V.prev_enc_end_date%TYPE; -- Bug 7188209

Line 9576: FROM psp_enc_process_assignments pepa

9572: SET payroll_action_id = p_payroll_action_id
9573: WHERE payroll_action_id IS NULL
9574: AND payroll_id = NVL(p_payroll_id, payroll_id)
9575: AND NOT EXISTS (SELECT 1
9576: FROM psp_enc_process_assignments pepa
9577: WHERE pepa.assignment_id = peca.assignment_id
9578: AND pepa.assignment_status NOT IN ('B', 'P')
9579: AND pepa.payroll_id = peca.payroll_id);
9580: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Marked ' || SQL%ROWCOUNT || ' assignments in psp_enc_changed_assignments to be processed by this Create and Update process');

Line 10099: FROM psp_enc_process_assignments pepa,

10095:
10096: CURSOR asg_cur (p_person_id IN NUMBER,
10097: p_assignment_id IN NUMBER) IS
10098: SELECT DISTINCT pepa.assignment_id
10099: FROM psp_enc_process_assignments pepa,
10100: per_all_assignments_f paf
10101: WHERE pepa.payroll_action_id = p_payroll_action_id
10102: AND paf.person_id = p_person_id
10103: AND paf.assignment_id = pepa.assignment_id

Line 10152: UPDATE psp_enc_process_assignments

10148: process_phase = 'rollback'
10149: WHERE payroll_action_id = p_payroll_action_id;
10150: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
10151:
10152: UPDATE psp_enc_process_assignments
10153: SET assignment_status = 'B'
10154: WHERE payroll_action_id = p_payroll_action_id;
10155: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
10156:

Line 10155: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');

10151:
10152: UPDATE psp_enc_process_assignments
10153: SET assignment_status = 'B'
10154: WHERE payroll_action_id = p_payroll_action_id;
10155: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
10156:
10157: UPDATE psp_enc_changed_assignments
10158: SET payroll_action_id = NULL
10159: WHERE payroll_action_id = p_payroll_action_id;

Line 10271: UPDATE psp_enc_process_assignments

10267: WHERE payroll_action_id = p_payroll_action_id
10268: AND source_id = l_assignments(recno);
10269: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
10270:
10271: UPDATE psp_enc_process_assignments
10272: SET assignment_status = 'B'
10273: WHERE payroll_action_id = p_payroll_action_id
10274: AND assignment_id = l_assignments(recno);
10275: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');

Line 10275: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');

10271: UPDATE psp_enc_process_assignments
10272: SET assignment_status = 'B'
10273: WHERE payroll_action_id = p_payroll_action_id
10274: AND assignment_id = l_assignments(recno);
10275: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');
10276:
10277: UPDATE psp_enc_changed_assignments
10278: SET payroll_action_id = NULL
10279: WHERE payroll_action_id = p_payroll_action_id