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_ARCHIVE dependencies on PAY_CORE_UTILS

Line 93: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)

89: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
90: v_assignment_id per_all_assignments_f.assignment_id%type;
91: --
92: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
93: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
94: from pay_payroll_actions
95: where payroll_action_id = c_payroll_Action_id;
96: --
97: cursor next_action_id is

Line 155: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),

151: procedure initialization_code
152: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
153: is
154: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
155: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
156: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
157: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
158: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
159: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

Line 156: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

152: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
153: is
154: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
155: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
156: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
157: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
158: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
159: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
160: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),

Line 157: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

153: is
154: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
155: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
156: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
157: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
158: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
159: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
160: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
161: report_type

Line 158: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

154: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
155: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
156: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
157: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
158: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
159: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
160: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
161: report_type
162: from pay_payroll_actions

Line 159: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

155: select pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
156: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
157: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
158: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
159: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
160: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
161: report_type
162: from pay_payroll_actions
163: where payroll_action_id = c_payroll_action_id;

Line 160: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),

156: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
157: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
158: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
159: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
160: pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters),
161: report_type
162: from pay_payroll_actions
163: where payroll_action_id = c_payroll_action_id;
164: ------------------------------------------------------------------------

Line 173: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)

169: select org_information19
170: from hr_organization_information,
171: pay_payroll_actions
172: where org_information_context ='SG_LEGAL_ENTITY'
173: and organization_id = pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters)
174: and payroll_action_id = p_payroll_action_id;
175: begin
176: if g_debug then
177: hr_utility.set_location('pysgirar: Start of initialization_code',6);

Line 228: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),

224: ----------------------------------------------------------------------------
225: -- Cursor to get the values of archive parameters
226: ----------------------------------------------------------------------------
227: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
228: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
229: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

Line 229: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),

225: -- Cursor to get the values of archive parameters
226: ----------------------------------------------------------------------------
227: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
228: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
229: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
233: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

Line 230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

226: ----------------------------------------------------------------------------
227: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
228: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
229: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
233: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
234: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)

Line 231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

227: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
228: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
229: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
233: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
234: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
235: from pay_payroll_actions

Line 232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

228: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
229: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
233: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
234: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
235: from pay_payroll_actions
236: where payroll_action_id = c_payroll_action_id;

Line 233: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

229: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
233: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
234: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
235: from pay_payroll_actions
236: where payroll_action_id = c_payroll_action_id;
237: ----------------------------------------------------------------------------

Line 234: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)

230: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
231: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
232: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
233: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
234: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters)
235: from pay_payroll_actions
236: where payroll_action_id = c_payroll_action_id;
237: ----------------------------------------------------------------------------
238: -- Cursor Next Assignment Action

Line 338: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),

334: procedure initialization_code_adhoc
335: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
336: is
337: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
338: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
339: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

Line 339: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),

335: ( p_payroll_action_id in pay_payroll_actions.payroll_action_id%type )
336: is
337: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
338: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
339: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
343: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

Line 340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

336: is
337: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
338: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
339: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
343: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
344: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),

Line 341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),

337: cursor get_params( c_payroll_action_id in pay_payroll_actions.payroll_action_id%type ) is
338: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
339: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
343: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
344: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
345: report_type

Line 342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),

338: select pay_core_utils.get_parameter('PERSON_ID',legislative_parameters),
339: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
343: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
344: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
345: report_type
346: from pay_payroll_actions

Line 343: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),

339: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters),
340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
343: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
344: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
345: report_type
346: from pay_payroll_actions
347: where payroll_action_id = c_payroll_action_id;

Line 344: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),

340: to_date('01-01-'||pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
341: to_date('31-12-'|| pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),'DD-MM-YYYY'),
342: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters),
343: pay_core_utils.get_parameter('BASIS_YEAR',legislative_parameters),
344: pay_core_utils.get_parameter('ASSIGNMENT_SET_ID',legislative_parameters),
345: report_type
346: from pay_payroll_actions
347: where payroll_action_id = c_payroll_action_id;
348: --

Line 4655: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)

4651: argument6 => 'P_PERSON_ID=' || g_person_id,
4652: argument7 => 'P_BASIS_START=' || g_basis_start,
4653: argument8 => 'P_BASIS_END=' || g_basis_end );
4654: elsif l_report_type = 'SG_IRAS_ARCHIVE' then
4655: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
4656: into v_setup_action
4657: from pay_payroll_actions
4658: where payroll_action_id = p_payroll_action_id ;
4659: -------------------------------------------------------