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 136: g_payroll_Action_id pay_payroll_actions.payroll_action_id%TYPE;

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

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

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

Line 162: 'pay_payroll_actions ppa ' ||

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

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

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

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

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

Line 203: v_business_group_id pay_payroll_actions.business_group_id%TYPE;

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

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

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

Line 230: FROM pay_payroll_actions

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

Line 236: ( c_business_group_id pay_payroll_actions.business_group_id%TYPE,

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

Line 242: FROM pay_payroll_actions ppa,

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

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

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

Line 275: c_business_group_id pay_payroll_actions.business_group_id%TYPE,

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

Line 281: pay_payroll_actions pa,

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

Line 295: pay_payroll_actions ppai,

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

Line 296: pay_payroll_actions ppaa,

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

Line 958: pay_payroll_actions ppa

954: FROM pay_assignment_actions paa
955: WHERE paa.assignment_id = c_assignment_id
956: and paa.action_sequence = (select max(paa2.action_sequence)
957: from pay_assignment_actions paa2,
958: pay_payroll_actions ppa
959: where paa2.assignment_id = c_assignment_id
960: and ppa.payroll_action_id = paa2.payroll_action_id
961: and paa2.action_status = 'C'
962: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V')

Line 1562: v_archive_date pay_payroll_actions.effective_date%TYPE;

1558: v_assignment_id per_all_assignments_f.assignment_id%TYPE;
1559: v_business_group_id hr_organization_units.business_group_id%TYPE;
1560: v_legal_entity_id pay_assignment_actions.tax_unit_id%TYPE;
1561: v_reporting_year varchar2(4);
1562: v_archive_date pay_payroll_actions.effective_date%TYPE;
1563:
1564: CURSOR archive_parameters
1565: (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
1566: IS

Line 1573: FROM pay_payroll_actions ppa,

1569: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
1570: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa.legislative_parameters),
1571: pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters),
1572: effective_date
1573: FROM pay_payroll_actions ppa,
1574: pay_assignment_actions pac,
1575: per_assignments_f paa
1576: WHERE pac.assignment_action_id = c_assignment_action_id
1577: AND ppa.payroll_action_id = pac.payroll_action_id

Line 1690: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

1686: FUNCTION SUBMIT_REPORT
1687: (p_archive_or_magtape in varchar2) RETURN Number
1688: IS
1689: l_count NUMBER := 0;
1690: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1691: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;
1692:
1693: l_number_of_copies NUMBER := 0;/*Reverted fix for 2810178 */
1694: l_request_id NUMBER := 0;

Line 1691: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;

1687: (p_archive_or_magtape in varchar2) RETURN Number
1688: IS
1689: l_count NUMBER := 0;
1690: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1691: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;
1692:
1693: l_number_of_copies NUMBER := 0;/*Reverted fix for 2810178 */
1694: l_request_id NUMBER := 0;
1695: l_print_return BOOLEAN;

Line 1710: FROM pay_payroll_actions pact,

1706: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS
1707: SELECT printer,
1708: print_style,
1709: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
1710: FROM pay_payroll_actions pact,
1711: fnd_concurrent_requests fcr
1712: WHERE fcr.request_id = pact.request_id
1713: AND pact.payroll_action_id = p_payroll_action_id;
1714:

Line 1720: pay_payroll_actions ppa, -- Magtape payroll action

1716:
1717: cursor get_archive_id is
1718: select distinct ppa3.payroll_action_id
1719: from
1720: pay_payroll_actions ppa, -- Magtape payroll action
1721: pay_payroll_actions ppa2, -- Report payroll action
1722: pay_payroll_actions ppa3 -- Archive payroll action
1723: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1724: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)

Line 1721: pay_payroll_actions ppa2, -- Report payroll action

1717: cursor get_archive_id is
1718: select distinct ppa3.payroll_action_id
1719: from
1720: pay_payroll_actions ppa, -- Magtape payroll action
1721: pay_payroll_actions ppa2, -- Report payroll action
1722: pay_payroll_actions ppa3 -- Archive payroll action
1723: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1724: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1725: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);

Line 1722: pay_payroll_actions ppa3 -- Archive payroll action

1718: select distinct ppa3.payroll_action_id
1719: from
1720: pay_payroll_actions ppa, -- Magtape payroll action
1721: pay_payroll_actions ppa2, -- Report payroll action
1722: pay_payroll_actions ppa3 -- Archive payroll action
1723: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
1724: and ppa2.payroll_action_id =pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
1725: and ppa3.payroll_action_id =pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters);
1726: