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 90: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4391: argument6 => 'P_PERSON_ID=' || g_person_id,
4392: argument7 => 'P_BASIS_START=' || g_basis_start,
4393: argument8 => 'P_BASIS_END=' || g_basis_end );
4394: elsif l_report_type = 'SG_IRAS_ARCHIVE' then
4395: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
4396: into v_setup_action
4397: from pay_payroll_actions
4398: where payroll_action_id = p_payroll_action_id ;
4399: -------------------------------------------------------