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

Line 10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

6: c_package constant varchar2(31) := 'pay_jp_pre_tax_archive.';
7: --
8: -- Global Variables
9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_business_group_id pay_payroll_actions.business_group_id%TYPE;
12: g_start_date pay_payroll_actions.effective_date%TYPE;
13: g_effective_date pay_payroll_actions.effective_date%TYPE;
14: g_payroll_id pay_payroll_actions.payroll_id%TYPE;

Line 11: g_business_group_id pay_payroll_actions.business_group_id%TYPE;

7: --
8: -- Global Variables
9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_business_group_id pay_payroll_actions.business_group_id%TYPE;
12: g_start_date pay_payroll_actions.effective_date%TYPE;
13: g_effective_date pay_payroll_actions.effective_date%TYPE;
14: g_payroll_id pay_payroll_actions.payroll_id%TYPE;
15: g_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;

Line 12: g_start_date pay_payroll_actions.effective_date%TYPE;

8: -- Global Variables
9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_business_group_id pay_payroll_actions.business_group_id%TYPE;
12: g_start_date pay_payroll_actions.effective_date%TYPE;
13: g_effective_date pay_payroll_actions.effective_date%TYPE;
14: g_payroll_id pay_payroll_actions.payroll_id%TYPE;
15: g_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
16: g_legislation_code per_business_groups.legislation_code%TYPE;

Line 13: g_effective_date pay_payroll_actions.effective_date%TYPE;

9: --
10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_business_group_id pay_payroll_actions.business_group_id%TYPE;
12: g_start_date pay_payroll_actions.effective_date%TYPE;
13: g_effective_date pay_payroll_actions.effective_date%TYPE;
14: g_payroll_id pay_payroll_actions.payroll_id%TYPE;
15: g_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
16: g_legislation_code per_business_groups.legislation_code%TYPE;
17: --

Line 14: g_payroll_id pay_payroll_actions.payroll_id%TYPE;

10: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
11: g_business_group_id pay_payroll_actions.business_group_id%TYPE;
12: g_start_date pay_payroll_actions.effective_date%TYPE;
13: g_effective_date pay_payroll_actions.effective_date%TYPE;
14: g_payroll_id pay_payroll_actions.payroll_id%TYPE;
15: g_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
16: g_legislation_code per_business_groups.legislation_code%TYPE;
17: --
18: -- |-------------------------------------------------------------------|

Line 15: g_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;

11: g_business_group_id pay_payroll_actions.business_group_id%TYPE;
12: g_start_date pay_payroll_actions.effective_date%TYPE;
13: g_effective_date pay_payroll_actions.effective_date%TYPE;
14: g_payroll_id pay_payroll_actions.payroll_id%TYPE;
15: g_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE;
16: g_legislation_code per_business_groups.legislation_code%TYPE;
17: --
18: -- |-------------------------------------------------------------------|
19: -- |-----------------------< remove_interlocks >-----------------------|

Line 21: procedure remove_interlocks(p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)

17: --
18: -- |-------------------------------------------------------------------|
19: -- |-----------------------< remove_interlocks >-----------------------|
20: -- |-------------------------------------------------------------------|
21: procedure remove_interlocks(p_payroll_action_id in pay_payroll_actions.payroll_action_id%type)
22: is
23: --
24: begin
25: --

Line 39: procedure initialization_code(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE)

35: --
36: -- |-------------------------------------------------------------------|
37: -- |----------------------< initialization_code >----------------------|
38: -- |-------------------------------------------------------------------|
39: procedure initialization_code(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE)
40: is
41: c_proc constant varchar2(61) := c_package || 'initialization_code';
42: cursor csr is
43: select business_group_id,

Line 47: from pay_payroll_actions

43: select business_group_id,
44: start_date,
45: effective_date,
46: legislative_parameters
47: from pay_payroll_actions
48: where payroll_action_id = p_payroll_action_id;
49: l_rec csr%rowtype;
50: begin
51: hr_utility.set_location('Entering: ' || c_proc, 10);

Line 95: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

91: -- |-------------------------------------------------------------------|
92: -- |--------------------------< range_code >---------------------------|
93: -- |-------------------------------------------------------------------|
94: procedure range_code(
95: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
96: p_sqlstr out nocopy varchar2)
97: is
98: c_proc constant varchar2(61) := c_package || 'range_code';
99: begin

Line 109: pay_payroll_actions ppa

105: --
106: p_sqlstr :=
107: 'select distinct per.person_id
108: from per_all_people_f per,
109: pay_payroll_actions ppa
110: where ppa.payroll_action_id = :payroll_action_id
111: and ppa.business_group_id + 0 = per.business_group_id
112: order by per.person_id';
113: --

Line 120: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

116: -- |-------------------------------------------------------------------|
117: -- |--------------------< assignment_action_code >---------------------|
118: -- |-------------------------------------------------------------------|
119: procedure assignment_action_code(
120: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
121: p_start_person_id in number,
122: p_end_person_id in number,
123: p_chunk_number in pay_assignment_actions.chunk_number%TYPE)
124: is

Line 130: p_business_group_id pay_payroll_actions.business_group_id%TYPE,

126: l_locking_action_id number;
127: l_assignment_id number;
128: --
129: cursor csr_assact(
130: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
131: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
132: p_start_date pay_payroll_actions.effective_date%TYPE,
133: p_effective_date pay_payroll_actions.effective_date%TYPE,
134: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is

Line 131: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,

127: l_assignment_id number;
128: --
129: cursor csr_assact(
130: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
131: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
132: p_start_date pay_payroll_actions.effective_date%TYPE,
133: p_effective_date pay_payroll_actions.effective_date%TYPE,
134: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
135:

Line 132: p_start_date pay_payroll_actions.effective_date%TYPE,

128: --
129: cursor csr_assact(
130: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
131: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
132: p_start_date pay_payroll_actions.effective_date%TYPE,
133: p_effective_date pay_payroll_actions.effective_date%TYPE,
134: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
135:
136: select /* Removed the hint as per Bug# 4767118 */

Line 133: p_effective_date pay_payroll_actions.effective_date%TYPE,

129: cursor csr_assact(
130: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
131: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
132: p_start_date pay_payroll_actions.effective_date%TYPE,
133: p_effective_date pay_payroll_actions.effective_date%TYPE,
134: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
135:
136: select /* Removed the hint as per Bug# 4767118 */
137: paa.assignment_id,

Line 134: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is

130: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
131: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
132: p_start_date pay_payroll_actions.effective_date%TYPE,
133: p_effective_date pay_payroll_actions.effective_date%TYPE,
134: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
135:
136: select /* Removed the hint as per Bug# 4767118 */
137: paa.assignment_id,
138: paa.assignment_action_id

Line 150: pay_payroll_actions ppa

146: and pds.business_group_id + 0 = p_business_group_id
147: and asg.period_of_service_id = pds.period_of_service_id
148: ) v,
149: pay_assignment_actions paa,
150: pay_payroll_actions ppa
151: where paa.assignment_id = v.assignment_id
152: and paa.action_status = 'C'
153: and ppa.payroll_action_id = paa.payroll_action_id
154: and (ppa.consolidation_set_id = p_consolidation_set_id or p_consolidation_set_id is null)

Line 164: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */

160: select /*+ ORDERED
161: USE_NL(PAAA PPAA)
162: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)
163: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
164: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
165: null
166: from pay_action_interlocks xpai,
167: pay_assignment_actions xpaa,
168: pay_payroll_actions xppa

Line 168: pay_payroll_actions xppa

164: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
165: null
166: from pay_action_interlocks xpai,
167: pay_assignment_actions xpaa,
168: pay_payroll_actions xppa
169: where xpai.locked_action_id = paa.assignment_action_id
170: and xpaa.assignment_action_id = xpai.locking_action_id
171: and xppa.payroll_action_id = xpaa.payroll_action_id
172: and xppa.action_type = 'X'

Line 230: p_effective_date in pay_payroll_actions.effective_date%TYPE)

226: -- |-------------------------< archive_code >--------------------------|
227: -- |-------------------------------------------------------------------|
228: procedure archive_code(
229: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
230: p_effective_date in pay_payroll_actions.effective_date%TYPE)
231: is
232: c_proc constant varchar2(61) := c_package || 'archive_code';
233: l_errbuf varchar2(2000);
234: l_retcode varchar2(10);

Line 268: procedure deinitialization_code(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE)

264: end archive_code;
265: -- |-------------------------------------------------------------------|
266: -- |---------------------< deinitialization_code >---------------------|
267: -- |-------------------------------------------------------------------|
268: procedure deinitialization_code(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE)
269: is
270: c_proc constant varchar2(61) := c_package || 'deinitialization_code';
271: l_dummy varchar2(1);
272: cursor csr_remove_actions is