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_CHANGED_ASG_HISTORY

Line 7579: INSERT INTO psp_enc_changed_asg_history

7575: WHERE peca2.assignment_id = peca.assignment_id
7576: AND peca2.change_type = 'TR');
7577: END IF;
7578:
7579: INSERT INTO psp_enc_changed_asg_history
7580: (request_id, assignment_id, payroll_id, change_type, processing_module, created_by,
7581: creation_date, processed_flag, reference_id, action_type, payroll_action_id, change_date)
7582: SELECT l_request_id, peca.assignment_id, peca.payroll_id, peca.change_type,
7583: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),

Line 7587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');

7583: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),
7584: NVL(peca.action_type, 'U'), p_payroll_action_id, change_date
7585: FROM psp_enc_changed_assignments peca
7586: WHERE payroll_action_id = p_payroll_action_id;
7587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7588:
7589: DELETE psp_enc_changed_assignments peca
7590: WHERE peca.payroll_action_id = p_payroll_action_id;
7591: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');

Line 9021: SELECT ASSIGNMENT_ID FROM psp_enc_changed_asg_history

9017: and assignment_id IN(SELECT assignment_id from PSP_ENC_PAYROLL_ASSIGNMENT_V
9018: WHERE payroll_id = p_payroll_id
9019: AND exclude = 'Y'
9020: MINUS
9021: SELECT ASSIGNMENT_ID FROM psp_enc_changed_asg_history
9022: WHERE payroll_id = p_payroll_id);
9023:
9024: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Deleted ' || SQL%ROWCOUNT || ' fresh excluded assignments in psp_enc_changed_assignments not to be processed by this Create and Update process');
9025:

Line 9538: FROM psp_enc_changed_asg_history pecah

9534: (request_id, assignment_id, payroll_id, change_type,
9535: processed_flag, reference_id, action_type, change_date)
9536: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
9537: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
9538: FROM psp_enc_changed_asg_history pecah
9539: WHERE payroll_action_id = p_payroll_action_id
9540: AND action_type NOT IN ('CR', 'LQ', 'TR');
9541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9542:

Line 9543: DELETE psp_enc_changed_asg_history

9539: WHERE payroll_action_id = p_payroll_action_id
9540: AND action_type NOT IN ('CR', 'LQ', 'TR');
9541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9542:
9543: DELETE psp_enc_changed_asg_history
9544: WHERE payroll_action_id = p_payroll_action_id;
9545: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9546: ELSE
9547: OPEN asg_cur(p_person_id1, p_assignment_id1);

Line 9659: FROM psp_enc_changed_asg_history pecah

9655: (request_id, assignment_id, payroll_id, change_type,
9656: processed_flag, reference_id, action_type, change_date)
9657: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
9658: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
9659: FROM psp_enc_changed_asg_history pecah
9660: WHERE payroll_action_id = p_payroll_action_id
9661: AND assignment_id = l_assignments(recno)
9662: AND action_type NOT IN ('CR', 'LQ', 'TR');
9663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

Line 9665: DELETE psp_enc_changed_asg_history

9661: AND assignment_id = l_assignments(recno)
9662: AND action_type NOT IN ('CR', 'LQ', 'TR');
9663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9664:
9665: DELETE psp_enc_changed_asg_history
9666: WHERE payroll_action_id = p_payroll_action_id
9667: AND assignment_id = l_assignments(recno);
9668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9669: END LOOP;