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_PROCESSES

Line 6411: INSERT INTO psp_enc_processes

6407: IF (l_process_mode = 'TERMINATE') THEN
6408: l_process_code := 'LET';
6409: END IF;
6410:
6411: INSERT INTO psp_enc_processes
6412: (request_id, process_code, payroll_action_id,
6413: process_status, process_phase, business_group_id,
6414: set_of_books_id, creation_date, created_by,
6415: last_update_date, last_updated_by, last_update_login)

Line 6571: psp_enc_processes pep

6567: CURSOR payroll_id_cur IS
6568: SELECT fnd_number.canonical_to_number(NVL(argument11, -1)),
6569: argument12
6570: FROM fnd_concurrent_requests fcr,
6571: psp_enc_processes pep
6572: WHERE pep.payroll_action_id = p_payroll_action_id
6573: AND fcr.request_id = pep.request_id;
6574:
6575: CURSOR get_asg_id_cur IS

Line 7440: psp_enc_processes pep

7436:
7437: CURSOR payroll_id_cur IS
7438: SELECT argument12
7439: FROM fnd_concurrent_requests fcr,
7440: psp_enc_processes pep
7441: WHERE pep.payroll_action_id = p_payroll_action_id
7442: AND fcr.request_id = pep.request_id;
7443:
7444: CURSOR process_phase_cur IS

Line 7446: FROM psp_enc_processes

7442: AND fcr.request_id = pep.request_id;
7443:
7444: CURSOR process_phase_cur IS
7445: SELECT process_phase
7446: FROM psp_enc_processes
7447: WHERE payroll_action_id = p_payroll_action_id
7448: AND process_code = 'ST';
7449:
7450: CURSOR error_check_cur IS

Line 7593: UPDATE psp_enc_processes

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');
7592:
7593: UPDATE psp_enc_processes
7594: SET process_status = 'P'
7595: WHERE payroll_action_id = p_payroll_action_id;
7596: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7597:

Line 7596: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');

7592:
7593: UPDATE psp_enc_processes
7594: SET process_status = 'P'
7595: WHERE payroll_action_id = p_payroll_action_id;
7596: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7597:
7598: UPDATE psp_enc_processes
7599: SET process_status = 'B',
7600: process_phase = 'no_summarize_transfer'

Line 7598: UPDATE psp_enc_processes

7594: SET process_status = 'P'
7595: WHERE payroll_action_id = p_payroll_action_id;
7596: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_status in psp_enc_processes');
7597:
7598: UPDATE psp_enc_processes
7599: SET process_status = 'B',
7600: process_phase = 'no_summarize_transfer'
7601: WHERE payroll_action_id = p_payroll_action_id
7602: AND NOT EXISTS (SELECT 1

Line 7607: UPDATE psp_enc_processes

7603: FROM psp_enc_summary_lines pesl
7604: WHERE pesl.payroll_action_id = p_payroll_action_id
7605: AND pesl.status_code = 'N');
7606:
7607: UPDATE psp_enc_processes
7608: SET process_phase = 'summarize_transfer'
7609: WHERE payroll_action_id = p_payroll_action_id
7610: AND EXISTS (SELECT 1
7611: FROM psp_enc_summary_lines pesl

Line 7616: UPDATE psp_enc_processes

7612: WHERE pesl.payroll_action_id = p_payroll_action_id
7613: AND pesl.status_code = 'N'
7614: AND pesl.superceded_line_id IS NULL);
7615:
7616: UPDATE psp_enc_processes
7617: SET process_phase = 'liquidate'
7618: WHERE payroll_action_id = p_payroll_action_id
7619: AND EXISTS (SELECT 1
7620: FROM psp_enc_summary_lines pesl

Line 7624: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

7620: FROM psp_enc_summary_lines pesl
7621: WHERE pesl.payroll_action_id = p_payroll_action_id
7622: AND pesl.status_code = 'N'
7623: AND pesl.superceded_line_id is NOT NULL);
7624: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7625: END IF;
7626:
7627: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');
7628: l_set_of_books_id := fnd_profile.value('GL_SET_OF_BKS_ID');

Line 7675: UPDATE psp_enc_processes

7671: fnd_msg_pub.add;
7672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7673: END IF;
7674:
7675: UPDATE psp_enc_processes
7676: SET process_phase = 'deinit_st'
7677: WHERE payroll_action_id = p_payroll_action_id
7678: AND process_code = 'ST';
7679: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

Line 7679: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

7675: UPDATE psp_enc_processes
7676: SET process_phase = 'deinit_st'
7677: WHERE payroll_action_id = p_payroll_action_id
7678: AND process_code = 'ST';
7679: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');
7680:
7681: COMMIT;
7682:
7683: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Waiting for Encumbrance Summarize and Transfer request to complete');

Line 8515: FROM psp_enc_processes pep,

8511: fnd_number.canonical_to_number(NVL(argument19, '-1')),
8512: fnd_date.canonical_to_date(NVL(argument20, fnd_date.date_to_canonical(TRUNC(SYSDATE)))),
8513: fnd_number.canonical_to_number(NVL(argument21, '-1')),
8514: fnd_date.canonical_to_date(NVL(argument22, fnd_date.date_to_canonical(TRUNC(SYSDATE))))
8515: FROM psp_enc_processes pep,
8516: fnd_concurrent_requests fcr
8517: WHERE pep.payroll_action_id = p_payroll_action_id
8518: AND fcr.request_id = pep.request_id;
8519:

Line 8578: FROM psp_enc_processes pep,

8574: WHERE organization_id = l_organization_id;
8575:
8576: CURSOR process_descr_cur IS
8577: SELECT pep.request_id || ': ' || fcpt.user_concurrent_program_name
8578: FROM psp_enc_processes pep,
8579: fnd_concurrent_requests fcr,
8580: fnd_concurrent_programs_tl fcpt
8581: WHERE EXISTS (SELECT 1
8582: FROM psp_enc_summary_lines pesl

Line 9517: UPDATE psp_enc_processes

9513: DELETE psp_report_errors
9514: WHERE payroll_action_id = p_payroll_action_id;
9515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_report_errors');
9516:
9517: UPDATE psp_enc_processes
9518: SET process_status = 'B',
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');

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

9517: UPDATE psp_enc_processes
9518: SET process_status = 'B',
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;

Line 9671: UPDATE psp_enc_processes

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;
9670:
9671: UPDATE psp_enc_processes
9672: SET process_status = 'B',
9673: process_phase = 'rollback'
9674: WHERE payroll_action_id = p_payroll_action_id
9675: AND NOT EXISTS (SELECT 1

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

9674: WHERE payroll_action_id = p_payroll_action_id
9675: AND NOT EXISTS (SELECT 1
9676: FROM psp_enc_summary_lines
9677: WHERE payroll_action_id = p_payroll_action_id);
9678: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
9679: END IF;
9680:
9681: COMMIT;
9682: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);