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_HK_IR56_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 134: g_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE;

130:
131: --* GLobal variables (populated in archive_code procedure)
132: g_assignment_id pay_assignment_actions.assignment_id%TYPE;
133: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
134: g_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE;
135: g_archive_message ff_archive_items.value%TYPE := NULL;
136: g_error_in_quarter BOOLEAN := FALSE;
137: g_business_group_id hr_organization_units.business_group_id%TYPE; -- for submitting the PAYHKCTL report
138:

Line 154: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,

150: --* This procedure returns a sql string to select a range
151: --* of assignments eligible for archival.
152: --------------------------------------------------------------------
153: PROCEDURE range_code
154: (p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE,
155: p_sql OUT nocopy Varchar2) is
156: Begin
157: hr_utility.set_location('Start of range_code',1);
158: p_sql := 'SELECT distinct person_id ' ||

Line 160: 'pay_payroll_actions ppa ' ||

156: Begin
157: hr_utility.set_location('Start of range_code',1);
158: p_sql := 'SELECT distinct person_id ' ||
159: 'FROM per_people_f ppf, ' ||
160: 'pay_payroll_actions ppa ' ||
161: 'WHERE ppa.payroll_action_id = :payroll_action_id ' ||
162: 'AND ppa.business_group_id = ppf.business_group_id ' ||
163: 'ORDER BY ppf.person_id';
164: hr_utility.set_location('End of range_code',2);

Line 175: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) is

171: -- exist in pay_report_format_mappings_f, otherwise the archiver will
172: -- assume that no archival of data is required.
173: ------------------------------------------------------------------------
174: PROCEDURE initialization_code
175: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) is
176: Begin
177: hr_utility.set_location('pyhkirar: Start of initialization_code',6);
178: g_payroll_action_id := p_payroll_action_id;
179: hr_utility.set_location('pyhkirar: End of initialization_code',7);

Line 190: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

186: -- The CURSOR SELECTs the assignments that have had any payroll
187: -- processing for the Legal Entity within the Reporting Year.
188: ------------------------------------------------------------------------
189: PROCEDURE assignment_action_code
190: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
191: p_start_person_id in per_all_people_f.person_id%TYPE,
192: p_end_person_id in per_all_people_f.person_id%TYPE,
193: p_chunk in number)
194: IS

Line 201: v_business_group_id pay_payroll_actions.business_group_id%TYPE;

197:
198: /* Following variables introduced for Bug No : 2740270 */
199: v_fin_start_date date;
200: v_fin_end_date date;
201: v_business_group_id pay_payroll_actions.business_group_id%TYPE;
202: v_legal_entity_id hr_organization_units.organization_id%TYPE;
203: v_reporting_year NUMBER;
204:
205: l_counter number:=1;

Line 219: CURSOR get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

215: FROM dual;
216:
217: /* Introduced the following cursor get_params for Bug No : 2740270 */
218:
219: CURSOR get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
220: IS
221: SELECT to_date('01-04-'|| to_char(to_number(pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters))
222: -1),'DD-MM-YYYY') FINANCIAL_YEAR_START
223: ,to_date('31-03-'||pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters),'DD-MM-YYYY')

Line 228: FROM pay_payroll_actions

224: FINANCIAL_YEAR_END
225: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) BUSINESS_GROUP_ID
226: ,pay_core_utils.get_parameter('LEGAL_ENTITY_ID',legislative_parameters) LEGAL_ENTITY_ID
227: ,pay_core_utils.get_parameter('REPORTING_YEAR',legislative_parameters) REPORTING_YEAR
228: FROM pay_payroll_actions
229: WHERE payroll_action_id = c_payroll_Action_id;
230:
231: /* Bug No : 2740270 - Cursor to get all the assignments in the basis year
232: for whom R,B,I,Q is run */

Line 234: ( c_business_group_id pay_payroll_actions.business_group_id%TYPE,

230:
231: /* Bug No : 2740270 - Cursor to get all the assignments in the basis year
232: for whom R,B,I,Q is run */
233: CURSOR check_run
234: ( c_business_group_id pay_payroll_actions.business_group_id%TYPE,
235: c_legal_entity_id hr_organization_units.organization_id%TYPE,
236: c_fin_start_date date,
237: c_fin_end_date date )
238: IS

Line 240: FROM pay_payroll_actions ppa,

236: c_fin_start_date date,
237: c_fin_end_date date )
238: IS
239: SELECT distinct pac.assignment_id
240: FROM pay_payroll_actions ppa,
241: pay_payrolls_f pay, /* Added for Bug 3916743 - performance fix. */
242: pay_assignment_actions pac
243: WHERE ppa.action_type in ('R','B','I','Q')
244: AND ppa.payroll_action_id = pac.payroll_action_id

Line 268: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

264: for the existance of assignment as of 31 of march. Since terminated employees are not selected, the
265: check for whether IR56F or IR56G is run becomes invalid hence this check is removed. */
266:
267: CURSOR process_assignments
268: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
269: c_start_person_id in per_all_people_f.person_id%TYPE,
270: c_end_person_id in per_all_people_f.person_id%TYPE,
271: c_fin_start_date in date,
272: c_fin_end_date in date,

Line 273: c_business_group_id pay_payroll_actions.business_group_id%TYPE,

269: c_start_person_id in per_all_people_f.person_id%TYPE,
270: c_end_person_id in per_all_people_f.person_id%TYPE,
271: c_fin_start_date in date,
272: c_fin_end_date in date,
273: c_business_group_id pay_payroll_actions.business_group_id%TYPE,
274: c_legal_entity_id hr_organization_units.organization_id%TYPE,
275: c_reporting_year NUMBER)
276: IS
277: SELECT DISTINCT a.assignment_id assignment_id

Line 279: pay_payroll_actions pa,

275: c_reporting_year NUMBER)
276: IS
277: SELECT DISTINCT a.assignment_id assignment_id
278: FROM per_assignments_f a,
279: pay_payroll_actions pa,
280: per_periods_of_service pps
281: WHERE pa.payroll_action_id = c_payroll_action_id
282: AND a.person_id BETWEEN c_start_person_id and c_end_person_id
283: AND a.business_group_id = pa.business_group_id

Line 293: pay_payroll_actions ppai,

289: AND pps.person_id = a.person_id
290: AND NOT EXISTS -- don't produce if they've had ir56b report produced.
291: (SELECT NULL
292: FROM pay_action_interlocks pai,
293: pay_payroll_actions ppai,
294: pay_payroll_actions ppaa,
295: pay_assignment_actions paa
296: WHERE paa.assignment_id = a.assignment_id
297: AND ppaa.action_type='X'

Line 294: pay_payroll_actions ppaa,

290: AND NOT EXISTS -- don't produce if they've had ir56b report produced.
291: (SELECT NULL
292: FROM pay_action_interlocks pai,
293: pay_payroll_actions ppai,
294: pay_payroll_actions ppaa,
295: pay_assignment_actions paa
296: WHERE paa.assignment_id = a.assignment_id
297: AND ppaa.action_type='X'
298: AND ppaa.report_type = 'HK_IR56B_ARCHIVE'

Line 889: pay_payroll_actions ppa

885: FROM pay_assignment_actions paa
886: WHERE paa.assignment_id = c_assignment_id
887: and paa.action_sequence = (select max(paa2.action_sequence)
888: from pay_assignment_actions paa2,
889: pay_payroll_actions ppa
890: where paa2.assignment_id = c_assignment_id
891: and ppa.payroll_action_id = paa2.payroll_action_id
892: and paa2.action_status = 'C'
893: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V')

Line 1493: v_archive_date pay_payroll_actions.effective_date%TYPE;

1489: v_assignment_id per_all_assignments_f.assignment_id%TYPE;
1490: v_business_group_id hr_organization_units.business_group_id%TYPE;
1491: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;
1492: v_reporting_year varchar2(4);
1493: v_archive_date pay_payroll_actions.effective_date%TYPE;
1494:
1495: CURSOR archive_parameters
1496: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1497: IS

Line 1504: FROM pay_payroll_actions ppa,

1500: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1501: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1502: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1503: effective_date
1504: FROM pay_payroll_actions ppa,
1505: pay_assignment_actions pac,
1506: per_assignments_f paa
1507: WHERE pac.assignment_action_id = c_assignment_action_id
1508: AND ppa.payroll_action_id = pac.payroll_action_id

Line 1621: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

1617: FUNCTION SUBMIT_REPORT
1618: (p_archive_or_magtape in varchar2) RETURN Number
1619: IS
1620: l_count NUMBER := 0;
1621: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1622: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;
1623:
1624: l_number_of_copies NUMBER := 0;/*Reverted fix for 2810178 */
1625: l_request_id NUMBER := 0;

Line 1622: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;

1618: (p_archive_or_magtape in varchar2) RETURN Number
1619: IS
1620: l_count NUMBER := 0;
1621: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1622: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;
1623:
1624: l_number_of_copies NUMBER := 0;/*Reverted fix for 2810178 */
1625: l_request_id NUMBER := 0;
1626: l_print_return BOOLEAN;

Line 1641: FROM pay_payroll_actions pact,

1637: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS
1638: SELECT printer,
1639: print_style,
1640: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
1641: FROM pay_payroll_actions pact,
1642: fnd_concurrent_requests fcr
1643: WHERE fcr.request_id = pact.request_id
1644: AND pact.payroll_action_id = p_payroll_action_id;
1645:

Line 1651: pay_payroll_actions ppa, -- Magtape payroll action

1647:
1648: cursor get_archive_id is
1649: select distinct ppa3.payroll_action_id
1650: from
1651: pay_payroll_actions ppa, -- Magtape payroll action
1652: pay_payroll_actions ppa2, -- Report payroll action
1653: pay_payroll_actions ppa3 -- Archive payroll action
1654: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1655: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

Line 1652: pay_payroll_actions ppa2, -- Report payroll action

1648: cursor get_archive_id is
1649: select distinct ppa3.payroll_action_id
1650: from
1651: pay_payroll_actions ppa, -- Magtape payroll action
1652: pay_payroll_actions ppa2, -- Report payroll action
1653: pay_payroll_actions ppa3 -- Archive payroll action
1654: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1655: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1656: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);

Line 1653: pay_payroll_actions ppa3 -- Archive payroll action

1649: select distinct ppa3.payroll_action_id
1650: from
1651: pay_payroll_actions ppa, -- Magtape payroll action
1652: pay_payroll_actions ppa2, -- Report payroll action
1653: pay_payroll_actions ppa3 -- Archive payroll action
1654: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1655: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1656: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);
1657: