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.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 5: TYPE effective_report_date_list IS TABLE OF per_assignment_extra_info.aei_information2%TYPE;

1: PACKAGE PER_ES_SS_REP_ARCHIVE_PKG AUTHID CURRENT_USER AS
2: /* $Header: peesssar.pkh 115.6 2004/04/15 03:06:14 viviswan noship $ */
3:
4: level_cnt NUMBER;
5: TYPE effective_report_date_list IS TABLE OF per_assignment_extra_info.aei_information2%TYPE;
6: TYPE event_list IS TABLE OF per_assignment_extra_info.aei_information3%TYPE;
7: TYPE value_list IS TABLE OF per_assignment_extra_info.aei_information4%TYPE;
8: TYPE action_type_list IS TABLE OF per_assignment_extra_info.aei_information6%TYPE;
9: TYPE first_changed_date_list IS TABLE OF per_assignment_extra_info.aei_information7%TYPE;

Line 6: TYPE event_list IS TABLE OF per_assignment_extra_info.aei_information3%TYPE;

2: /* $Header: peesssar.pkh 115.6 2004/04/15 03:06:14 viviswan noship $ */
3:
4: level_cnt NUMBER;
5: TYPE effective_report_date_list IS TABLE OF per_assignment_extra_info.aei_information2%TYPE;
6: TYPE event_list IS TABLE OF per_assignment_extra_info.aei_information3%TYPE;
7: TYPE value_list IS TABLE OF per_assignment_extra_info.aei_information4%TYPE;
8: TYPE action_type_list IS TABLE OF per_assignment_extra_info.aei_information6%TYPE;
9: TYPE first_changed_date_list IS TABLE OF per_assignment_extra_info.aei_information7%TYPE;
10: TYPE csr_event_values IS REF CURSOR;

Line 7: TYPE value_list IS TABLE OF per_assignment_extra_info.aei_information4%TYPE;

3:
4: level_cnt NUMBER;
5: TYPE effective_report_date_list IS TABLE OF per_assignment_extra_info.aei_information2%TYPE;
6: TYPE event_list IS TABLE OF per_assignment_extra_info.aei_information3%TYPE;
7: TYPE value_list IS TABLE OF per_assignment_extra_info.aei_information4%TYPE;
8: TYPE action_type_list IS TABLE OF per_assignment_extra_info.aei_information6%TYPE;
9: TYPE first_changed_date_list IS TABLE OF per_assignment_extra_info.aei_information7%TYPE;
10: TYPE csr_event_values IS REF CURSOR;
11: --------------------------------------------------------------------------------

Line 8: TYPE action_type_list IS TABLE OF per_assignment_extra_info.aei_information6%TYPE;

4: level_cnt NUMBER;
5: TYPE effective_report_date_list IS TABLE OF per_assignment_extra_info.aei_information2%TYPE;
6: TYPE event_list IS TABLE OF per_assignment_extra_info.aei_information3%TYPE;
7: TYPE value_list IS TABLE OF per_assignment_extra_info.aei_information4%TYPE;
8: TYPE action_type_list IS TABLE OF per_assignment_extra_info.aei_information6%TYPE;
9: TYPE first_changed_date_list IS TABLE OF per_assignment_extra_info.aei_information7%TYPE;
10: TYPE csr_event_values IS REF CURSOR;
11: --------------------------------------------------------------------------------
12: CURSOR CSR_SS_REP_HEADER_FOOTER IS

Line 9: TYPE first_changed_date_list IS TABLE OF per_assignment_extra_info.aei_information7%TYPE;

5: TYPE effective_report_date_list IS TABLE OF per_assignment_extra_info.aei_information2%TYPE;
6: TYPE event_list IS TABLE OF per_assignment_extra_info.aei_information3%TYPE;
7: TYPE value_list IS TABLE OF per_assignment_extra_info.aei_information4%TYPE;
8: TYPE action_type_list IS TABLE OF per_assignment_extra_info.aei_information6%TYPE;
9: TYPE first_changed_date_list IS TABLE OF per_assignment_extra_info.aei_information7%TYPE;
10: TYPE csr_event_values IS REF CURSOR;
11: --------------------------------------------------------------------------------
12: CURSOR CSR_SS_REP_HEADER_FOOTER IS
13: SELECT ('AUTHORIZATION_KEY=P'), LPAD(NVL(pact.action_information1,'0'), 8, '0'),