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_ASSIGNMENT_ACTIONS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 1: PACKAGE BODY PAY_ASSIGNMENT_ACTIONS_PKG AS

1: PACKAGE BODY PAY_ASSIGNMENT_ACTIONS_PKG AS
2: /* $Header: pyasa01t.pkb 120.3.12010000.1 2008/07/27 22:03:38 appldev ship $ */
3: /*
4:
5: PRODUCT

Line 64: update PAY_ASSIGNMENT_ACTIONS

60: procedure update_row(p_rowid in varchar2,
61: p_action_status in varchar2 ) is
62: begin
63: --
64: update PAY_ASSIGNMENT_ACTIONS
65: set ACTION_STATUS = p_action_status
66: where ROWID = p_rowid;
67: --
68: end update_row;

Line 75: delete from PAY_ASSIGNMENT_ACTIONS

71: procedure delete_row(p_rowid in varchar2) is
72: --
73: begin
74: --
75: delete from PAY_ASSIGNMENT_ACTIONS
76: where ROWID = p_rowid;
77: --
78: end delete_row;
79: --

Line 85: from PAY_ASSIGNMENT_ACTIONS

81: p_action_status in varchar2 ) is
82:
83: --
84: cursor C is select *
85: from PAY_ASSIGNMENT_ACTIONS
86: where rowid = p_rowid
87: for update of PAYROLL_ACTION_ID NOWAIT ;
88: --
89: rowinfo C%rowtype;

Line 126: -- from pay_assignment_actions assact,

122: -- -- a status of complete
123: -- --
124: -- cursor c_is_voided ( p_assignment_action_id in number ) is
125: -- select intloc.locking_action_id
126: -- from pay_assignment_actions assact,
127: -- pay_action_interlocks intloc,
128: -- pay_payroll_actions pact
129: -- where intloc.locked_action_id = p_assignment_action_id
130: -- and intloc.locking_action_id = assact.assignment_action_id

Line 138: -- pay_assignment_actions paa

134: -- cursor run_modified (p_assignment_action_id in number ) is
135: -- select paa.assignment_action_id
136: -- from
137: -- pay_payroll_actions ppa,
138: -- pay_assignment_actions paa
139: -- where paa.assignment_action_id = p_assignment_action_id
140: -- and paa.payroll_action_id = ppa.payroll_action_id
141: -- and paa.action_status = 'C'
142: -- and exists (select ''

Line 150: -- from pay_assignment_actions paa1, -- Prepay/Costing

146: -- and ppe.change_type in ('GRE', 'DATE_EARNED', 'DATE_PROCESSED')
147: -- and ppe.status <> 'C'
148: -- )
149: -- and not exists (select ''
150: -- from pay_assignment_actions paa1, -- Prepay/Costing
151: -- pay_action_interlocks pai1,
152: -- pay_assignment_actions paa2,-- Payment/Trans GL
153: -- pay_action_interlocks pai2
154: -- where pai1.locked_action_id = paa.assignment_action_id

Line 152: -- pay_assignment_actions paa2,-- Payment/Trans GL

148: -- )
149: -- and not exists (select ''
150: -- from pay_assignment_actions paa1, -- Prepay/Costing
151: -- pay_action_interlocks pai1,
152: -- pay_assignment_actions paa2,-- Payment/Trans GL
153: -- pay_action_interlocks pai2
154: -- where pai1.locked_action_id = paa.assignment_action_id
155: -- and pai1.locking_action_id = paa1.assignment_action_id
156: -- and pai2.locked_action_id = paa1.assignment_action_id

Line 163: -- pay_assignment_actions paa

159: -- cursor prepay_modified (p_assignment_action_id in number ) is
160: -- select paa.assignment_action_id
161: -- from
162: -- pay_payroll_actions ppa,
163: -- pay_assignment_actions paa
164: -- where paa.assignment_action_id = p_assignment_action_id
165: -- and paa.payroll_action_id = ppa.payroll_action_id
166: -- and paa.action_status = 'C'
167: -- and not exists (select ''

Line 168: -- from pay_assignment_actions paa1, -- Payment/Trans GL

164: -- where paa.assignment_action_id = p_assignment_action_id
165: -- and paa.payroll_action_id = ppa.payroll_action_id
166: -- and paa.action_status = 'C'
167: -- and not exists (select ''
168: -- from pay_assignment_actions paa1, -- Payment/Trans GL
169: -- pay_action_interlocks pai1
170: -- where pai1.locked_action_id = paa.assignment_action_id
171: -- and pai1.locking_action_id = paa1.assignment_action_id)
172: -- and (exists (select ''

Line 182: -- pay_assignment_actions paa2,

178: -- )
179: -- or
180: -- exists (select ''
181: -- from pay_action_interlocks pai,
182: -- pay_assignment_actions paa2,
183: -- pay_payroll_actions ppa2
184: -- where pai.locking_action_id = paa.assignment_action_id
185: -- and pai.locked_action_id = paa2.assignment_action_id
186: -- and paa2.payroll_action_id = ppa2.payroll_action_id

Line 202: -- pay_assignment_actions paa

198: -- cursor cost_modified (p_assignment_action_id in number ) is
199: -- select paa.assignment_action_id
200: -- from
201: -- pay_payroll_actions ppa,
202: -- pay_assignment_actions paa
203: -- where paa.assignment_action_id = p_assignment_action_id
204: -- and paa.payroll_action_id = ppa.payroll_action_id
205: -- and paa.action_status = 'C'
206: -- and not exists (select ''

Line 207: -- from pay_assignment_actions paa1, -- Payment/Trans GL

203: -- where paa.assignment_action_id = p_assignment_action_id
204: -- and paa.payroll_action_id = ppa.payroll_action_id
205: -- and paa.action_status = 'C'
206: -- and not exists (select ''
207: -- from pay_assignment_actions paa1, -- Payment/Trans GL
208: -- pay_action_interlocks pai1
209: -- where pai1.locked_action_id = paa.assignment_action_id
210: -- and pai1.locking_action_id = paa1.assignment_action_id)
211: -- and exists (select ''

Line 220: -- pay_assignment_actions paa2,

216: -- and ppe.status <> 'C'
217: -- )
218: -- and exists (select ''
219: -- from pay_action_interlocks pai,
220: -- pay_assignment_actions paa2,
221: -- pay_payroll_actions ppa2
222: -- where pai.locking_action_id = paa.assignment_action_id
223: -- and pai.locked_action_id = paa2.assignment_action_id
224: -- and paa2.payroll_action_id = ppa2.payroll_action_id

Line 237: -- l_dummy_action_id pay_assignment_actions.assignment_action_id%type ;

233: -- );
234: -- --
235: -- --
236: -- l_return_value hr_lookups.meaning%type ;
237: -- l_dummy_action_id pay_assignment_actions.assignment_action_id%type ;
238: -- ischanged boolean;
239: begin
240: -- --
241: -- if g_action_status_enabled = 'N' then

Line 347: pay_assignment_actions aac,

343: select aac.assignment_action_id,
344: aac.action_status,
345: pac.action_type
346: from pay_payroll_actions pac,
347: pay_assignment_actions aac,
348: pay_action_interlocks loc
349: where loc.locked_action_id = p_assignment_action_id
350: and loc.locking_action_id = aac.assignment_action_id
351: and aac.pre_payment_id = p_pre_payment_id

Line 362: pay_assignment_actions aac,

358: --
359: cursor get_locking_void_action ( p_assignment_action_id number ) is
360: select aac.assignment_action_id
361: from pay_payroll_actions pac,
362: pay_assignment_actions aac,
363: pay_action_interlocks loc
364: where loc.locked_action_id = p_assignment_action_id
365: and loc.locking_action_id = aac.assignment_action_id
366: and aac.payroll_action_id = pac.payroll_action_id

Line 370: l_void_assact pay_assignment_actions.assignment_action_id%type ;

366: and aac.payroll_action_id = pac.payroll_action_id
367: and pac.action_type = 'D' ;
368:
369: status_code hr_lookups.lookup_code%type ;
370: l_void_assact pay_assignment_actions.assignment_action_id%type ;
371: found_payment boolean := FALSE ;
372: found_non_void_action boolean := FALSE ;
373:
374: begin

Line 535: END PAY_ASSIGNMENT_ACTIONS_PKG;

531: return l_date;
532: end archive_person_start_date;
533: --
534:
535: END PAY_ASSIGNMENT_ACTIONS_PKG;