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_SUM_TRAN dependencies on PSP_ENC_PROCESSES

Line 133: FROM psp_enc_processes

129: ORDER BY business_group_id;
130:
131: CURSOR liq_check_cur IS
132: SELECT COUNT(1)
133: FROM psp_enc_processes
134: WHERE payroll_action_id = p_payroll_action_id
135: AND process_phase = 'liquidate';
136:
137: CURSOR st_asgs_cur IS

Line 208: INSERT INTO psp_enc_processes

204: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
205: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
206: l_request_id := fnd_global.conc_request_id;
207:
208: INSERT INTO psp_enc_processes
209: (request_id, process_code, payroll_action_id,
210: process_status, process_phase, business_group_id,
211: set_of_books_id, creation_date, created_by,
212: last_update_date, last_updated_by, last_update_login)

Line 217: FROM psp_enc_processes pep

213: SELECT l_request_id, 'ST', p_payroll_action_id,
214: 'I', process_phase, p_business_group_id,
215: p_set_of_books_id, l_last_update_date, l_last_updated_by,
216: l_last_update_date, l_last_updated_by, l_last_updated_login
217: FROM psp_enc_processes pep
218: WHERE process_code IN ('CEL', 'LET')
219: AND payroll_action_id = p_payroll_action_id
220: AND NOT EXISTS (SELECT 1
221: FROM psp_enc_processes pep2

Line 221: FROM psp_enc_processes pep2

217: FROM psp_enc_processes pep
218: WHERE process_code IN ('CEL', 'LET')
219: AND payroll_action_id = p_payroll_action_id
220: AND NOT EXISTS (SELECT 1
221: FROM psp_enc_processes pep2
222: WHERE pep2.payroll_action_id = p_payroll_action_id
223: AND pep2.process_code = 'ST');
224:
225: UPDATE psp_enc_processes

Line 225: UPDATE psp_enc_processes

221: FROM psp_enc_processes pep2
222: WHERE pep2.payroll_action_id = p_payroll_action_id
223: AND pep2.process_code = 'ST');
224:
225: UPDATE psp_enc_processes
226: SET process_status = 'S',
227: process_phase = 'completed'
228: WHERE payroll_action_id = p_payroll_action_id
229: AND process_code IN ('CEL', 'LET');

Line 230: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated original and current process status in psp_enc_processes');

226: SET process_status = 'S',
227: process_phase = 'completed'
228: WHERE payroll_action_id = p_payroll_action_id
229: AND process_code IN ('CEL', 'LET');
230: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated original and current process status in psp_enc_processes');
231:
232: OPEN st_asgs_cur;
233: FETCH st_asgs_cur BULK COLLECT INTO l_asgs.assignment_id, l_asgs.payroll_id;
234: CLOSE st_asgs_cur;

Line 613: UPDATE psp_enc_processes

609: IF (SQL%ROWCOUNT > 0) THEN
610: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''P''');
611: END IF;
612:
613: UPDATE psp_enc_processes
614: SET process_status = 'P', process_phase = 'completed'
615: WHERE payroll_action_id = p_payroll_action_id
616: AND process_code = 'ST'
617: AND NOT EXISTS (SELECT 1

Line 625: UPDATE psp_enc_processes

621: IF (SQL%ROWCOUNT > 0) THEN
622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to completed as no summarize and transfer is required');
623: END IF;
624:
625: UPDATE psp_enc_processes
626: SET process_phase = 'summarize_transfer'
627: WHERE payroll_action_id = p_payroll_action_id
628: AND process_code = 'ST'
629: AND EXISTS (SELECT 1

Line 636: UPDATE psp_enc_processes

632: IF (SQL%ROWCOUNT > 0) THEN
633: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to summarize and transfer re-processing');
634: END IF;
635:
636: UPDATE psp_enc_processes
637: SET process_phase = 'liquidate'
638: WHERE payroll_action_id = p_payroll_action_id
639: AND process_code = 'ST'
640: AND EXISTS (SELECT 1

Line 837: UPDATE psp_enc_processes

833: END IF; * /
834: END IF; -- IF PHASES ARE OTHER THAN NULL OR TRANSFER
835: END LOOP;
836:
837: UPDATE psp_enc_processes
838: SET process_status = 'P', process_phase = 'completed'
839: WHERE payroll_action_id = p_payroll_action_id
840: AND NOT EXISTS (SELECT 1
841: FROM psp_enc_summary_lines pesl

Line 846: UPDATE psp_enc_processes

842: WHERE pesl.payroll_action_id = p_payroll_action_id
843: AND pesl.status_code = 'N');
844: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to completed as no summarize and transfer is required');
845:
846: UPDATE psp_enc_processes
847: SET process_phase = 'summarize_transfer'
848: WHERE payroll_action_id = p_payroll_action_id
849: AND EXISTS (SELECT 1
850: FROM psp_enc_summary_lines pesl

Line 856: UPDATE psp_enc_processes

852: AND pesl.status_code = 'N'
853: AND pesl.superceded_line_id IS NULL);
854: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to summarize and transfer re-processing');
855:
856: UPDATE psp_enc_processes
857: SET process_phase = 'liquidate'
858: WHERE payroll_action_id = p_payroll_action_id
859: AND EXISTS (SELECT 1
860: FROM psp_enc_summary_lines pesl