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.PAY_SG_IRAS_AMEND_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 23: type t_person_id_tab is table of per_all_people_f.person_id%type index by binary_integer;

19: --
20: ---------------------------------------------------------------------
21: -- 3435334 Record of person_ids with same national identifier
22: ---------------------------------------------------------------------
23: type t_person_id_tab is table of per_all_people_f.person_id%type index by binary_integer;
24: g_person_id_tab t_person_id_tab;
25: --
26: type t_rehire_same_person_record is record
27: (

Line 28: person_id per_all_people_f.person_id%type

24: g_person_id_tab t_person_id_tab;
25: --
26: type t_rehire_same_person_record is record
27: (
28: person_id per_all_people_f.person_id%type
29: );
30: --------------------------------------------------------------------
31: -- Bug 4688761 Record of person_ids with archived person_id
32: --------------------------------------------------------------------

Line 35: person_id per_all_people_f.person_id%type

31: -- Bug 4688761 Record of person_ids with archived person_id
32: --------------------------------------------------------------------
33: type t_archived_person_rec is record
34: (
35: person_id per_all_people_f.person_id%type
36: );
37: type t_archived_person_tab is table of t_archived_person_rec index by binary_integer;
38: t_archived_person t_archived_person_tab;
39:

Line 64: p_start_person_id in per_all_people_f.person_id%type,

60: p_sql out nocopy varchar2 );
61: --
62: procedure assignment_action_code
63: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
64: p_start_person_id in per_all_people_f.person_id%type,
65: p_end_person_id in per_all_people_f.person_id%type,
66: p_chunk in number );
67: --
68: procedure initialization_code

Line 65: p_end_person_id in per_all_people_f.person_id%type,

61: --
62: procedure assignment_action_code
63: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
64: p_start_person_id in per_all_people_f.person_id%type,
65: p_end_person_id in per_all_people_f.person_id%type,
66: p_chunk in number );
67: --
68: procedure initialization_code
69: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type );

Line 83: p_person_id in per_all_people_f.person_id%type,

79: -- process.
80: --------------------------------------------------------------------
81: procedure archive_balances
82: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
83: p_person_id in per_all_people_f.person_id%type,
84: p_business_group_id in hr_organization_units.business_group_id%type,
85: p_tax_unit_id in ff_archive_item_contexts.context%type,
86: p_basis_year in varchar2 );
87: --

Line 93: p_person_id in per_all_people_f.person_id%type,

89: -- Bug #4314453, added legal_entity_id
90: ---------------------------------------------------------------------------
91: procedure archive_shares_details
92: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
93: p_person_id in per_all_people_f.person_id%type,
94: p_tax_unit_id in ff_archive_item_contexts.context%type,
95: p_basis_start in date,
96: p_basis_end in date );
97: --

Line 100: p_person_id in per_all_people_f.person_id%type,

96: p_basis_end in date );
97: --
98: procedure archive_ir8s_c_details
99: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
100: p_person_id in per_all_people_f.person_id%type,
101: p_tax_unit_id in ff_archive_item_contexts.context%type,
102: p_business_group_id in per_assignments_f.business_group_id%type,
103: p_basis_start in date,
104: p_basis_end in date );

Line 108: p_1_person_id in per_all_people_f.person_id%type,

104: p_basis_end in date );
105: --
106: procedure archive_ir8s_c_detail_moas
107: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
108: p_1_person_id in per_all_people_f.person_id%type,
109: p_person_id in per_all_people_f.person_id%type,
110: p_tax_unit_id in ff_archive_item_contexts.context%type,
111: p_business_group_id in per_assignments_f.business_group_id%type,
112: p_basis_start in date,

Line 109: p_person_id in per_all_people_f.person_id%type,

105: --
106: procedure archive_ir8s_c_detail_moas
107: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
108: p_1_person_id in per_all_people_f.person_id%type,
109: p_person_id in per_all_people_f.person_id%type,
110: p_tax_unit_id in ff_archive_item_contexts.context%type,
111: p_business_group_id in per_assignments_f.business_group_id%type,
112: p_basis_start in date,
113: p_basis_end in date );

Line 138: p_person_id in per_all_people_f.person_id%type,

134: -- with pre-processor
135: -------------------------------------------------------------------------------
136: function employee_if_latest
137: ( p_national_identifier in varchar2,
138: p_person_id in per_all_people_f.person_id%type,
139: p_setup_action_id in pay_payroll_actions.payroll_action_id%type,
140: p_report_type in varchar2 ) return boolean ;
141: --
142: ----------------------------------------------------------------------------

Line 145: function person_if_archived (p_person_id in per_all_people_f.person_id%type) return boolean;

141: --
142: ----------------------------------------------------------------------------
143: -- Bug 4688761 - New function to check if the person_id has been archived once
144: ----------------------------------------------------------------------------
145: function person_if_archived (p_person_id in per_all_people_f.person_id%type) return boolean;
146: --
147: ----------------------------------------------------------------------------
148: -- Bug 4890964 - The function to get the LE if it is with the latest primary
149: -- assignment for multi-LEs.

Line 152: ( p_person_id in per_all_people_f.person_id%type

148: -- Bug 4890964 - The function to get the LE if it is with the latest primary
149: -- assignment for multi-LEs.
150: ----------------------------------------------------------------------------
151: function pri_if_latest
152: ( p_person_id in per_all_people_f.person_id%type
153: , p_tax_unit_id in ff_archive_item_contexts.context%type
154: , p_basis_start in date
155: , p_basis_end in date) return boolean;
156: --

Line 162: ( p_person_id in per_all_people_f.person_id%type

158: -- Bug 4890964 - The function to get the assignment with LE if its the
159: -- latest primary assignment
160: ----------------------------------------------------------------------------
161: function pri_LE_if_latest
162: ( p_person_id in per_all_people_f.person_id%type
163: , p_tax_unit_id in ff_archive_item_contexts.context%type
164: , p_basis_start in date
165: , p_basis_end in date) return number;
166: --

Line 172: ( p_person_id in per_all_people_f.person_id%type

168: -- Bug 4890964 - The function to get the assignment with LE if its the
169: -- latest assignment without primay flag defined.
170: ----------------------------------------------------------------------------
171: function id_LE_if_latest
172: ( p_person_id in per_all_people_f.person_id%type
173: , p_tax_unit_id in ff_archive_item_contexts.context%type
174: , p_basis_start in date
175: , p_basis_end in date) return number;
176: --