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 135: FROM psp_enc_processes

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

Line 210: INSERT INTO psp_enc_processes

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

Line 219: FROM psp_enc_processes pep

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

Line 223: FROM psp_enc_processes pep2

219: FROM psp_enc_processes pep
220: WHERE process_code IN ('CEL', 'LET')
221: AND payroll_action_id = p_payroll_action_id
222: AND NOT EXISTS (SELECT 1
223: FROM psp_enc_processes pep2
224: WHERE pep2.payroll_action_id = p_payroll_action_id
225: AND pep2.process_code = 'ST');
226:
227: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted row for process_code ST');

Line 229: UPDATE psp_enc_processes

225: AND pep2.process_code = 'ST');
226:
227: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserted row for process_code ST');
228:
229: UPDATE psp_enc_processes
230: SET process_status = 'S',
231: process_phase = 'completed'
232: WHERE payroll_action_id = p_payroll_action_id
233: AND process_code IN ('CEL', 'LET');

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

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

Line 629: UPDATE psp_enc_processes

625: IF (SQL%ROWCOUNT > 0) THEN
626: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''P'' count'||SQL%ROWCOUNT);
627: END IF;
628:
629: UPDATE psp_enc_processes
630: SET process_status = 'P', process_phase = 'completed'
631: WHERE payroll_action_id = p_payroll_action_id
632: AND process_code = 'ST'
633: AND NOT EXISTS (SELECT 1

Line 641: UPDATE psp_enc_processes

637: IF (SQL%ROWCOUNT > 0) THEN
638: 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');
639: END IF;
640:
641: UPDATE psp_enc_processes
642: SET process_phase = 'summarize_transfer'
643: WHERE payroll_action_id = p_payroll_action_id
644: AND process_code = 'ST'
645: AND EXISTS (SELECT 1

Line 652: UPDATE psp_enc_processes

648: IF (SQL%ROWCOUNT > 0) THEN
649: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to summarize and transfer re-processing');
650: END IF;
651:
652: UPDATE psp_enc_processes
653: SET process_phase = 'liquidate'
654: WHERE payroll_action_id = p_payroll_action_id
655: AND process_code = 'ST'
656: AND EXISTS (SELECT 1

Line 857: UPDATE psp_enc_processes

853: END IF; * /
854: END IF; -- IF PHASES ARE OTHER THAN NULL OR TRANSFER
855: END LOOP;
856:
857: UPDATE psp_enc_processes
858: SET process_status = 'P', process_phase = 'completed'
859: WHERE payroll_action_id = p_payroll_action_id
860: AND NOT EXISTS (SELECT 1
861: FROM psp_enc_summary_lines pesl

Line 866: UPDATE psp_enc_processes

862: WHERE pesl.payroll_action_id = p_payroll_action_id
863: AND pesl.status_code = 'N');
864: 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');
865:
866: UPDATE psp_enc_processes
867: SET process_phase = 'summarize_transfer'
868: WHERE payroll_action_id = p_payroll_action_id
869: AND EXISTS (SELECT 1
870: FROM psp_enc_summary_lines pesl

Line 876: UPDATE psp_enc_processes

872: AND pesl.status_code = 'N'
873: AND pesl.superceded_line_id IS NULL);
874: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to summarize and transfer re-processing');
875:
876: UPDATE psp_enc_processes
877: SET process_phase = 'liquidate'
878: WHERE payroll_action_id = p_payroll_action_id
879: AND EXISTS (SELECT 1
880: FROM psp_enc_summary_lines pesl