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 34: pay_payroll_actions void_pa

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

Line 93: bgid pay_payroll_actions.business_group_id%TYPE;

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

Line 94: csid pay_payroll_actions.consolidation_set_id%TYPE;

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

Line 95: pid pay_payroll_actions.payroll_id%TYPE;

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

Line 96: ovn pay_payroll_actions.object_version_number%TYPE;

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

Line 97: action_type pay_payroll_actions.action_type%TYPE;

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

Line 127: FROM pay_payroll_actions

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

Line 161: INSERT INTO pay_payroll_actions

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

Line 176: ( pay_payroll_actions_s.nextval, -- payroll_action_id

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

Line 238: pay_payroll_actions_s.currval, -- payroll_action_id

234: action_sequence,
235: tax_unit_id ) VALUES
236: ( pay_assignment_actions_s.nextval, -- assignment_action_id
237: void_row.assignment_id, -- assignment_id
238: pay_payroll_actions_s.currval, -- payroll_action_id
239: 'C', -- action_status
240: void_row.cheque_number, -- serial_number
241: void_row.object_version_number, -- object_version_number
242: pay_assignment_actions_s.nextval,