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_US_PAYMENT_PKG dependencies on HR_UTILITY

Line 159: -- hr_utility.trace_on (NULL, 'PYMT');

155:
156: l_override_date pay_payroll_actions.overriding_dd_date%TYPE;
157: l_table_count NUMBER;
158: BEGIN
159: -- hr_utility.trace_on (NULL, 'PYMT');
160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);
161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);

Line 160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);

156: l_override_date pay_payroll_actions.overriding_dd_date%TYPE;
157: l_table_count NUMBER;
158: BEGIN
159: -- hr_utility.trace_on (NULL, 'PYMT');
160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);
161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);

Line 161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);

157: l_table_count NUMBER;
158: BEGIN
159: -- hr_utility.trace_on (NULL, 'PYMT');
160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);
161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);

Line 162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);

158: BEGIN
159: -- hr_utility.trace_on (NULL, 'PYMT');
160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);
161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);

Line 163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);

159: -- hr_utility.trace_on (NULL, 'PYMT');
160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);
161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);

Line 164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);

160: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 10);
161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);

Line 165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);

161: hr_utility.TRACE ('p_business_group_id: ' || p_business_group_id);
162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);
169: hr_utility.TRACE ('p_override_date: ' || p_override_date);

Line 166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);

162: hr_utility.TRACE ('p_payroll_action_id: ' || p_payroll_action_id);
163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);
169: hr_utility.TRACE ('p_override_date: ' || p_override_date);
170: hr_utility.TRACE ('p_pre_payment_id: ' || p_pre_payment_id);

Line 167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);

163: hr_utility.TRACE ('p_assignment_action_id: ' || p_assignment_action_id);
164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);
169: hr_utility.TRACE ('p_override_date: ' || p_override_date);
170: hr_utility.TRACE ('p_pre_payment_id: ' || p_pre_payment_id);
171: hr_utility.TRACE ('p_payment_date: ' || p_payment_date);

Line 168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);

164: hr_utility.TRACE ('p_payroll_id: ' || p_payroll_id);
165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);
169: hr_utility.TRACE ('p_override_date: ' || p_override_date);
170: hr_utility.TRACE ('p_pre_payment_id: ' || p_pre_payment_id);
171: hr_utility.TRACE ('p_payment_date: ' || p_payment_date);
172:

Line 169: hr_utility.TRACE ('p_override_date: ' || p_override_date);

165: hr_utility.TRACE ('p_consolidation_set_id: ' || p_consolidation_set_id);
166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);
169: hr_utility.TRACE ('p_override_date: ' || p_override_date);
170: hr_utility.TRACE ('p_pre_payment_id: ' || p_pre_payment_id);
171: hr_utility.TRACE ('p_payment_date: ' || p_payment_date);
172:
173: IF p_override_date IS NOT NULL

Line 170: hr_utility.TRACE ('p_pre_payment_id: ' || p_pre_payment_id);

166: hr_utility.TRACE ('p_org_payment_method_id: ' || p_org_payment_method_id);
167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);
169: hr_utility.TRACE ('p_override_date: ' || p_override_date);
170: hr_utility.TRACE ('p_pre_payment_id: ' || p_pre_payment_id);
171: hr_utility.TRACE ('p_payment_date: ' || p_payment_date);
172:
173: IF p_override_date IS NOT NULL
174: THEN

Line 171: hr_utility.TRACE ('p_payment_date: ' || p_payment_date);

167: hr_utility.TRACE ('p_effective_date: ' || p_effective_date);
168: hr_utility.TRACE ('p_date_earned: ' || p_date_earned);
169: hr_utility.TRACE ('p_override_date: ' || p_override_date);
170: hr_utility.TRACE ('p_pre_payment_id: ' || p_pre_payment_id);
171: hr_utility.TRACE ('p_payment_date: ' || p_payment_date);
172:
173: IF p_override_date IS NOT NULL
174: THEN
175: l_override_date := p_override_date;

Line 187: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date',

183: IF ltr_override_date_table (j).payroll_action_id =
184: p_payroll_action_id
185: THEN
186: l_override_date := ltr_override_date_table (j).override_date;
187: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date',
188: 20
189: );
190: EXIT;
191: END IF;

Line 210: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 30);

206: INTO l_override_date;
207:
208: CLOSE c_get_override_date;
209:
210: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 30);
211: l_table_count := ltr_override_date_table.COUNT;
212: ltr_override_date_table (l_table_count).payroll_action_id :=
213: p_payroll_action_id;
214: ltr_override_date_table (l_table_count).override_date :=

Line 223: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 40);

219: THEN
220: IF p_payment_date IS NOT NULL
221: THEN
222: l_override_date := p_payment_date;
223: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 40);
224: ELSIF p_pre_payment_id IS NOT NULL
225: THEN
226: /* Just fetch prepayment action's effective_date with pre_payment_id.
227: This improves performance by not checking for interlocks */

Line 235: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 50);

231: INTO l_override_date;
232:
233: CLOSE c_get_pymt_date_with_prepay_id;
234:
235: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 50);
236: ELSE
237: /* With the help of interlocks, get prepayment effective_date */
238: OPEN c_get_pymt_effective_date (p_business_group_id,
239: p_payroll_action_id,

Line 254: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 60);

250: INTO l_override_date;
251:
252: CLOSE c_get_pymt_effective_date;
253:
254: hr_utility.set_location ('pay_us_payment_pkg.get_trx_date', 60);
255: END IF; -- if p_payment_date is not null
256: END IF; -- if l_override_date is null
257: END IF;
258: