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 85: update pay_payroll_actions

81: --
82:
83: /* Bug 13974619 */
84: if g_payroll_id IS NOT NULL then
85: update pay_payroll_actions
86: set payroll_id=g_payroll_id
87: where payroll_action_id=g_payroll_action_id;
88: end if;
89:

Line 104: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

100: -- |-------------------------------------------------------------------|
101: -- |--------------------------< range_code >---------------------------|
102: -- |-------------------------------------------------------------------|
103: procedure range_code(
104: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
105: p_sqlstr out nocopy varchar2)
106: is
107: c_proc constant varchar2(61) := c_package || 'range_code';
108: begin

Line 118: pay_payroll_actions ppa

114: --
115: p_sqlstr :=
116: 'select distinct per.person_id
117: from per_all_people_f per,
118: pay_payroll_actions ppa
119: where ppa.payroll_action_id = :payroll_action_id
120: and ppa.business_group_id + 0 = per.business_group_id
121: order by per.person_id';
122: --

Line 129: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

125: -- |-------------------------------------------------------------------|
126: -- |--------------------< assignment_action_code >---------------------|
127: -- |-------------------------------------------------------------------|
128: procedure assignment_action_code(
129: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
130: p_start_person_id in number,
131: p_end_person_id in number,
132: p_chunk_number in pay_assignment_actions.chunk_number%TYPE)
133: is

Line 139: p_business_group_id pay_payroll_actions.business_group_id%TYPE,

135: l_locking_action_id number;
136: l_assignment_id number;
137: --
138: cursor csr_assact(
139: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
140: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
141: p_start_date pay_payroll_actions.effective_date%TYPE,
142: p_effective_date pay_payroll_actions.effective_date%TYPE,
143: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is

Line 140: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,

136: l_assignment_id number;
137: --
138: cursor csr_assact(
139: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
140: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
141: p_start_date pay_payroll_actions.effective_date%TYPE,
142: p_effective_date pay_payroll_actions.effective_date%TYPE,
143: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
144:

Line 141: p_start_date pay_payroll_actions.effective_date%TYPE,

137: --
138: cursor csr_assact(
139: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
140: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
141: p_start_date pay_payroll_actions.effective_date%TYPE,
142: p_effective_date pay_payroll_actions.effective_date%TYPE,
143: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
144:
145: select /* Removed the hint as per Bug# 4767118 */

Line 142: p_effective_date pay_payroll_actions.effective_date%TYPE,

138: cursor csr_assact(
139: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
140: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
141: p_start_date pay_payroll_actions.effective_date%TYPE,
142: p_effective_date pay_payroll_actions.effective_date%TYPE,
143: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
144:
145: select /* Removed the hint as per Bug# 4767118 */
146: paa.assignment_id,

Line 143: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is

139: p_business_group_id pay_payroll_actions.business_group_id%TYPE,
140: p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE,
141: p_start_date pay_payroll_actions.effective_date%TYPE,
142: p_effective_date pay_payroll_actions.effective_date%TYPE,
143: p_payroll_id pay_payroll_actions.payroll_id%TYPE) is
144:
145: select /* Removed the hint as per Bug# 4767118 */
146: paa.assignment_id,
147: paa.assignment_action_id

Line 159: pay_payroll_actions ppa

155: and pds.business_group_id + 0 = p_business_group_id
156: and asg.period_of_service_id = pds.period_of_service_id
157: ) v,
158: pay_assignment_actions paa,
159: pay_payroll_actions ppa
160: where paa.assignment_id = v.assignment_id
161: and paa.action_status = 'C'
162: and ppa.payroll_action_id = paa.payroll_action_id
163: and (ppa.consolidation_set_id = p_consolidation_set_id or p_consolidation_set_id is null)

Line 173: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */

169: select /*+ ORDERED
170: USE_NL(PAAA PPAA)
171: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)
172: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
173: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
174: null
175: from pay_action_interlocks xpai,
176: pay_assignment_actions xpaa,
177: pay_payroll_actions xppa

Line 177: pay_payroll_actions xppa

173: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
174: null
175: from pay_action_interlocks xpai,
176: pay_assignment_actions xpaa,
177: pay_payroll_actions xppa
178: where xpai.locked_action_id = paa.assignment_action_id
179: and xpaa.assignment_action_id = xpai.locking_action_id
180: and xppa.payroll_action_id = xpaa.payroll_action_id
181: and xppa.action_type = 'X'

Line 239: p_effective_date in pay_payroll_actions.effective_date%TYPE)

235: -- |-------------------------< archive_code >--------------------------|
236: -- |-------------------------------------------------------------------|
237: procedure archive_code(
238: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
239: p_effective_date in pay_payroll_actions.effective_date%TYPE)
240: is
241: c_proc constant varchar2(61) := c_package || 'archive_code';
242: l_errbuf varchar2(2000);
243: l_retcode varchar2(10);

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

275: end archive_code;
276: -- |-------------------------------------------------------------------|
277: -- |---------------------< deinitialization_code >---------------------|
278: -- |-------------------------------------------------------------------|
279: procedure deinitialization_code(p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE)
280: is
281: c_proc constant varchar2(61) := c_package || 'deinitialization_code';
282: l_dummy varchar2(1);
283: cursor csr_remove_actions is