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

Line 38: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

34: -- Action.
35: -- Core Payroll recommends the select has minimal restrictions.
36: ------------------------------------------------------------------------
37: procedure range_code
38: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
39: p_sql out nocopy varchar2) is
40: begin
41: --hr_utility.trace_on(null, 'pay_hk_ir56_report');
42: hr_utility.set_location('Start of range_code',1);

Line 46: 'pay_payroll_actions ppa ' ||

42: hr_utility.set_location('Start of range_code',1);
43:
44: p_sql := 'select distinct person_id ' ||
45: 'from per_people_f ppf, ' ||
46: 'pay_payroll_actions ppa ' ||
47: 'where ppa.payroll_action_id = :payroll_action_id ' ||
48: 'and ppa.business_group_id = ppf.business_group_id ' ||
49: 'order by ppf.person_id';
50:

Line 64: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

60: -- re-report a person, they must ROLLBACK the magtape first, or use the
61: -- standard Re-try, Rollback payroll process.
62: ------------------------------------------------------------------------
63: procedure assignment_action_code
64: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
65: p_start_person_id in per_all_people_f.person_id%type,
66: p_end_person_id in per_all_people_f.person_id%type,
67: p_chunk in number) is
68:

Line 86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

82: --
83: -- Cursor to select the parameters for the current IR56B run.
84: --
85: cursor get_full_or_partial
86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters),
88: pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters),
89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)
90: from pay_payroll_actions ppa, -- report payroll action

Line 90: from pay_payroll_actions ppa, -- report payroll action

86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters),
88: pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters),
89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)
90: from pay_payroll_actions ppa, -- report payroll action
91: pay_payroll_actions ppa2 -- archive payroll action
92: where ppa.payroll_action_id = c_payroll_action_id
93: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters);
94: --

Line 91: pay_payroll_actions ppa2 -- archive payroll action

87: select pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters),
88: pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters),
89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)
90: from pay_payroll_actions ppa, -- report payroll action
91: pay_payroll_actions ppa2 -- archive payroll action
92: where ppa.payroll_action_id = c_payroll_action_id
93: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters);
94: --
95: -- Cursor to check if there are any other FULL runs.

Line 98: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

94: --
95: -- Cursor to check if there are any other FULL runs.
96: --
97: cursor get_full_report_runs
98: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
99: c_reporting_year in varchar2,
100: c_legal_entity_id in number) is
101: select 1
102: from pay_payroll_actions ppa, -- report payroll action

Line 102: from pay_payroll_actions ppa, -- report payroll action

98: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
99: c_reporting_year in varchar2,
100: c_legal_entity_id in number) is
101: select 1
102: from pay_payroll_actions ppa, -- report payroll action
103: pay_payroll_actions ppa2 -- archive payroll action
104: where pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters) = 'FULL'
105: and ppa.action_type = 'X'
106: and ppa.action_status = 'C'

Line 103: pay_payroll_actions ppa2 -- archive payroll action

99: c_reporting_year in varchar2,
100: c_legal_entity_id in number) is
101: select 1
102: from pay_payroll_actions ppa, -- report payroll action
103: pay_payroll_actions ppa2 -- archive payroll action
104: where pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters) = 'FULL'
105: and ppa.action_type = 'X'
106: and ppa.action_status = 'C'
107: and ppa.report_type = 'HK_IR56B_REPORT'

Line 116: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

112: --
113: -- Cursor to process all assignments.
114: --
115: cursor process_assignments
116: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
117: c_start_person_id in per_all_people_f.person_id%type,
118: c_end_person_id in per_all_people_f.person_id%type) is
119: select distinct paaf.assignment_id,
120: paa.assignment_action_id,

Line 125: pay_payroll_actions ppa, -- report payroll action

121: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters) archive_action_id,
122: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) legal_entity_id
123: from per_assignments_f paaf,
124: per_people_f papf,
125: pay_payroll_actions ppa, -- report payroll action
126: pay_payroll_actions ppa2, -- archive payroll action
127: pay_assignment_actions paa
128: where ppa.payroll_action_id = c_payroll_action_id
129: and papf.person_id between c_start_person_id and c_end_person_id

Line 126: pay_payroll_actions ppa2, -- archive payroll action

122: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) legal_entity_id
123: from per_assignments_f paaf,
124: per_people_f papf,
125: pay_payroll_actions ppa, -- report payroll action
126: pay_payroll_actions ppa2, -- archive payroll action
127: pay_assignment_actions paa
128: where ppa.payroll_action_id = c_payroll_action_id
129: and papf.person_id between c_start_person_id and c_end_person_id
130: and papf.person_id = paaf.person_id

Line 253: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

249: -----------------------------------------------------------------------------
250: procedure submit_report is
251:
252: l_count NUMBER := 0;
253: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
254: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;
255: l_full_or_partial varchar2(15);
256: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
257:

Line 254: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;

250: procedure submit_report is
251:
252: l_count NUMBER := 0;
253: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
254: l_archive_action_id pay_payroll_actions.payroll_action_id%TYPE;
255: l_full_or_partial varchar2(15);
256: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
257:
258: l_number_of_copies NUMBER := 0; /*Reverted fix for 2810178 */

Line 275: FROM pay_payroll_actions pact,

271: cursor csr_get_print_options(p_payroll_action_id NUMBER) IS
272: SELECT printer,
273: print_style,
274: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
275: FROM pay_payroll_actions pact,
276: fnd_concurrent_requests fcr
277: WHERE fcr.request_id = pact.request_id
278: AND pact.payroll_action_id = p_payroll_action_id;
279: