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_CREATE_EFF_REPORTS dependencies on PSP_REPORT_ERRORS_S

Line 1350: (select psp_report_errors_s.nextval , p_request_id,

1346: insert into psp_report_errors
1347: (error_sequence_id, request_id, message_level,
1348: source_id, error_message, retry_request_id, pdf_request_id,
1349: source_name, parent_source_id, parent_source_name)
1350: (select psp_report_errors_s.nextval , p_request_id,
1351: 'W', pspt.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1352: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1353: pspt.request_id = p_request_id and skip_reason is not null
1354: AND rowid = (select min(rowid) from psp_selected_persons_t inner

Line 1421: (select psp_report_errors_s.nextval , p_request_id,

1417: insert into psp_report_errors
1418: (error_sequence_id, request_id, message_level,
1419: source_id, error_message, retry_request_id, pdf_request_id,
1420: source_name, parent_source_id, parent_source_name)
1421: (select psp_report_errors_s.nextval , p_request_id,
1422: 'W', skipped_asg_rec.person_id , l_msg_str , p_retry_request_id, null, NULL, NULL, null
1423: from dual);
1424:
1425: end loop;

Line 1441: select psp_report_errors_s.nextval, p_request_id,'W',

1437: insert into psp_report_errors
1438: (error_sequence_id, request_id, message_level,
1439: source_id, error_message, retry_request_id, pdf_request_id,
1440: source_name, parent_source_id, parent_source_name)
1441: select psp_report_errors_s.nextval, p_request_id,'W',
1442: pspt.person_id, l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1443: from psp_selected_persons_t pspt where pspt.person_id between p_start_person
1444: and p_end_person and
1445: pspt.request_id = p_request_id and

Line 1457: select psp_report_errors_s.nextval, p_request_id,'W',

1453: insert into psp_report_errors
1454: (error_sequence_id, request_id, message_level,
1455: source_id, error_message, retry_request_id, pdf_request_id,
1456: source_name, parent_source_id, parent_source_name)
1457: select psp_report_errors_s.nextval, p_request_id,'W',
1458: pspt.person_id , l_msg_str, p_retry_request_id , null, NULL, NULL, NULL
1459: from psp_selected_persons_t pspt where pspt.person_id between p_start_person and p_end_person and
1460: pspt.request_id = p_request_id and
1461: exists (select nvl(person_id,0) from psp_adjustment_lines where effective_date between g_psp_effort_start