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

Line 35: pay_payroll_actions void_pa

31: chq_or_mag_aa.assignment_action_id
32: FROM pay_assignment_actions chq_or_mag_aa,
33: pay_action_interlocks,
34: pay_assignment_actions void_aa,
35: pay_payroll_actions void_pa
36: WHERE chq_or_mag_aa.payroll_action_id = p_payroll_action_id
37: AND ((l_start_cheque is not null
38: AND l_end_cheque is not null
39: AND fnd_number.canonical_to_number(chq_or_mag_aa.serial_number)

Line 94: bgid pay_payroll_actions.business_group_id%TYPE;

90: l_dummy varchar2(1);
91: --
92: overlap_row overlap_csr%ROWTYPE;
93: void_row void_csr%ROWTYPE;
94: bgid pay_payroll_actions.business_group_id%TYPE;
95: csid pay_payroll_actions.consolidation_set_id%TYPE;
96: pid pay_payroll_actions.payroll_id%TYPE;
97: ovn pay_payroll_actions.object_version_number%TYPE;
98: action_type pay_payroll_actions.action_type%TYPE;

Line 95: csid pay_payroll_actions.consolidation_set_id%TYPE;

91: --
92: overlap_row overlap_csr%ROWTYPE;
93: void_row void_csr%ROWTYPE;
94: bgid pay_payroll_actions.business_group_id%TYPE;
95: csid pay_payroll_actions.consolidation_set_id%TYPE;
96: pid pay_payroll_actions.payroll_id%TYPE;
97: ovn pay_payroll_actions.object_version_number%TYPE;
98: action_type pay_payroll_actions.action_type%TYPE;
99: BEGIN

Line 96: pid pay_payroll_actions.payroll_id%TYPE;

92: overlap_row overlap_csr%ROWTYPE;
93: void_row void_csr%ROWTYPE;
94: bgid pay_payroll_actions.business_group_id%TYPE;
95: csid pay_payroll_actions.consolidation_set_id%TYPE;
96: pid pay_payroll_actions.payroll_id%TYPE;
97: ovn pay_payroll_actions.object_version_number%TYPE;
98: action_type pay_payroll_actions.action_type%TYPE;
99: BEGIN
100: hr_utility.set_location ('void_run',1);

Line 97: ovn pay_payroll_actions.object_version_number%TYPE;

93: void_row void_csr%ROWTYPE;
94: bgid pay_payroll_actions.business_group_id%TYPE;
95: csid pay_payroll_actions.consolidation_set_id%TYPE;
96: pid pay_payroll_actions.payroll_id%TYPE;
97: ovn pay_payroll_actions.object_version_number%TYPE;
98: action_type pay_payroll_actions.action_type%TYPE;
99: BEGIN
100: hr_utility.set_location ('void_run',1);
101: --------------------------------------------------------------------------------

Line 98: action_type pay_payroll_actions.action_type%TYPE;

94: bgid pay_payroll_actions.business_group_id%TYPE;
95: csid pay_payroll_actions.consolidation_set_id%TYPE;
96: pid pay_payroll_actions.payroll_id%TYPE;
97: ovn pay_payroll_actions.object_version_number%TYPE;
98: action_type pay_payroll_actions.action_type%TYPE;
99: BEGIN
100: hr_utility.set_location ('void_run',1);
101: --------------------------------------------------------------------------------
102: -- Convert date. NB: This will have to change to generic data format in 10.7

Line 128: FROM pay_payroll_actions

124: payroll_id,
125: object_version_number,
126: action_type
127: INTO bgid,csid,pid,ovn,action_type
128: FROM pay_payroll_actions
129: WHERE payroll_action_id = p_payroll_action_id;
130: --------------------------------------------------------------------------------
131: -- For chequewriter : Check there is no overlap with another void run
132: --------------------------------------------------------------------------------

Line 164: INSERT INTO pay_payroll_actions

160: hr_utility.set_location ('void_run',5);
161: --------------------------------------------------------------------------------
162: -- Create new payroll action for void run
163: --------------------------------------------------------------------------------
164: INSERT INTO pay_payroll_actions
165: ( payroll_action_id,
166: action_type,
167: business_group_id,
168: consolidation_set_id,

Line 179: ( pay_payroll_actions_s.nextval, -- payroll_action_id

175: start_cheque_number,
176: end_cheque_number,
177: request_id,
178: object_version_number ) VALUES
179: ( pay_payroll_actions_s.nextval, -- payroll_action_id
180: 'D', -- action_type
181: bgid, -- business_group_id
182: csid, -- consolidation_set_id
183: pid, -- payroll_id

Line 245: pay_payroll_actions_s.currval, -- payroll_action_id

241: action_sequence,
242: tax_unit_id ) VALUES
243: ( pay_assignment_actions_s.nextval, -- assignment_action_id
244: void_row.assignment_id, -- assignment_id
245: pay_payroll_actions_s.currval, -- payroll_action_id
246: 'C', -- action_status
247: void_row.cheque_number, -- serial_number
248: void_row.object_version_number, -- object_version_number
249: pay_assignment_actions_s.nextval,