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 6452: INSERT INTO psp_enc_process_assignments

6448: END IF;
6449:
6450: sqlstr := sqlstr || 'payroll_action_id = :payroll_action_id ORDER BY assignment_id';
6451:
6452: INSERT INTO psp_enc_process_assignments
6453: (payroll_action_id, assignment_id, payroll_id,
6454: assignment_status, creation_date, created_by,
6455: last_update_date, last_updated_by, last_update_login)
6456: SELECT DISTINCT pactid, assignment_id, payroll_id,

Line 6592: FROM psp_enc_process_assignments pepa

6588: AND ( (l_process_mode = 'TERMINATE' AND change_type = 'TR')
6589: OR (l_process_mode = 'REGULAR' AND change_type <> 'TR'))
6590: AND payroll_id = NVL(l_payroll_id, payroll_id)
6591: /*AND NOT EXISTS (SELECT 1
6592: FROM psp_enc_process_assignments pepa
6593: WHERE pepa.assignment_id = peca.assignment_id
6594: AND pepa.payroll_action_id = p_payroll_action_id
6595: AND pepa.assignment_status <> 'B')*/;
6596:

Line 7315: UPDATE psp_enc_process_assignments pepa

7311: END IF;
7312: END LOOP;
7313:
7314: FORALL recno IN 1..t_assignments.asg_array.COUNT
7315: UPDATE psp_enc_process_assignments pepa
7316: SET assignment_status = 'B'
7317: WHERE pepa.payroll_action_id = p_payroll_action_id
7318: AND pepa.assignment_id = t_assignments.asg_array(recno)
7319: AND pepa.payroll_id = t_assignments.payroll_array(recno)

Line 7327: UPDATE psp_enc_process_assignments pepa

7323: AND pesl.assignment_id = t_assignments.asg_array(recno)
7324: AND pesl.payroll_id = t_assignments.payroll_array(recno));
7325:
7326: FORALL recno IN 1..t_assignments.asg_array.COUNT
7327: UPDATE psp_enc_process_assignments pepa
7328: SET assignment_status = 'S'
7329: WHERE pepa.payroll_action_id = p_payroll_action_id
7330: AND pepa.assignment_id = t_assignments.asg_array(recno)
7331: AND pepa.payroll_id = t_assignments.payroll_array(recno)

Line 7339: UPDATE psp_enc_process_assignments pepa

7335: AND pesl.assignment_id = t_assignments.asg_array(recno)
7336: AND pesl.payroll_id = t_assignments.payroll_array(recno));
7337:
7338: FORALL recno IN 1..t_assignments.asg_array.COUNT
7339: UPDATE psp_enc_process_assignments pepa
7340: SET assignment_status = 'L'
7341: WHERE pepa.payroll_action_id = p_payroll_action_id
7342: AND pepa.assignment_id = t_assignments.asg_array(recno)
7343: AND pepa.payroll_id = t_assignments.payroll_array(recno)

Line 7508: UPDATE psp_enc_process_assignments pepa

7504: COMMIT;
7505: RAISE fnd_api.g_exc_unexpected_error;
7506: END IF;
7507:
7508: UPDATE psp_enc_process_assignments pepa
7509: SET assignment_status = 'B'
7510: WHERE payroll_action_id = p_payroll_action_id
7511: AND NOT EXISTS (SELECT 1
7512: FROM psp_enc_summary_lines pesl

Line 7518: UPDATE psp_enc_process_assignments pepa

7514: AND pesl.assignment_id = pepa.assignment_id
7515: AND pesl.payroll_id = pepa.payroll_id
7516: AND pesl.status_code = 'N');
7517:
7518: UPDATE psp_enc_process_assignments pepa
7519: SET assignment_status = 'S'
7520: WHERE payroll_action_id = p_payroll_action_id
7521: AND EXISTS (SELECT 1
7522: FROM psp_enc_summary_lines pesl

Line 7529: UPDATE psp_enc_process_assignments pepa

7525: AND pesl.payroll_id = pepa.payroll_id
7526: AND pesl.status_code = 'N'
7527: AND pesl.superceded_line_id IS NULL);
7528:
7529: UPDATE psp_enc_process_assignments pepa
7530: SET assignment_status = 'L'
7531: WHERE payroll_action_id = p_payroll_action_id
7532: AND EXISTS (SELECT 1
7533: FROM psp_enc_summary_lines pesl

Line 8601: FROM psp_enc_process_assignments pepa

8597:
8598: CURSOR in_process_asg_cur IS
8599: SELECT pepa.assignment_id,
8600: pepa.payroll_action_id
8601: FROM psp_enc_process_assignments pepa
8602: WHERE pepa.payroll_id = p_payroll_id
8603: AND pepa.assignment_status NOT IN ('B', 'P');
8604:
8605: l_prev_enc_end_date PSP_ENC_END_DATES_V.prev_enc_end_date%TYPE; -- Bug 7188209

Line 9007: FROM psp_enc_process_assignments pepa

9003: SET payroll_action_id = p_payroll_action_id
9004: WHERE payroll_action_id IS NULL
9005: AND payroll_id = NVL(p_payroll_id, payroll_id)
9006: AND NOT EXISTS (SELECT 1
9007: FROM psp_enc_process_assignments pepa
9008: WHERE pepa.assignment_id = peca.assignment_id
9009: AND pepa.assignment_status NOT IN ('B', 'P')
9010: AND pepa.payroll_id = peca.payroll_id);
9011: 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 9470: FROM psp_enc_process_assignments pepa,

9466:
9467: CURSOR asg_cur (p_person_id IN NUMBER,
9468: p_assignment_id IN NUMBER) IS
9469: SELECT DISTINCT pepa.assignment_id
9470: FROM psp_enc_process_assignments pepa,
9471: per_all_assignments_f paf
9472: WHERE pepa.payroll_action_id = p_payroll_action_id
9473: AND paf.person_id = p_person_id
9474: AND paf.assignment_id = pepa.assignment_id

Line 9523: UPDATE psp_enc_process_assignments

9519: process_phase = 'rollback'
9520: WHERE payroll_action_id = p_payroll_action_id;
9521: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
9522:
9523: UPDATE psp_enc_process_assignments
9524: SET assignment_status = 'B'
9525: WHERE payroll_action_id = p_payroll_action_id;
9526: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
9527:

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

9522:
9523: UPDATE psp_enc_process_assignments
9524: SET assignment_status = 'B'
9525: WHERE payroll_action_id = p_payroll_action_id;
9526: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
9527:
9528: UPDATE psp_enc_changed_assignments
9529: SET payroll_action_id = NULL
9530: WHERE payroll_action_id = p_payroll_action_id;

Line 9642: UPDATE psp_enc_process_assignments

9638: WHERE payroll_action_id = p_payroll_action_id
9639: AND source_id = l_assignments(recno);
9640: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9641:
9642: UPDATE psp_enc_process_assignments
9643: SET assignment_status = 'B'
9644: WHERE payroll_action_id = p_payroll_action_id
9645: AND assignment_id = l_assignments(recno);
9646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');

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

9642: UPDATE psp_enc_process_assignments
9643: SET assignment_status = 'B'
9644: WHERE payroll_action_id = p_payroll_action_id
9645: AND assignment_id = l_assignments(recno);
9646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');
9647:
9648: UPDATE psp_enc_changed_assignments
9649: SET payroll_action_id = NULL
9650: WHERE payroll_action_id = p_payroll_action_id