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

Line 152: hr_utility.trace('Entering:' || 'pay_hk_soe.total_balances');

148:
149: begin
150:
151: IF g_debug THEN
152: hr_utility.trace('Entering:' || 'pay_hk_soe.total_balances');
153: END IF;
154:
155:
156: /*------------- for payment values -----------------*/

Line 191: hr_utility.trace('_PAYMENTS balances');

187: v_direct_pay_this_run := p_result_table(6).balance_value;
188: v_total_pay_this_run := p_result_table(7).balance_value;
189:
190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

Line 192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);

188: v_total_pay_this_run := p_result_table(7).balance_value;
189:
190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

Line 193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);

189:
190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:

Line 194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);

190: if g_debug THEN
191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

Line 195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

191: hr_utility.trace('_PAYMENTS balances');
192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

Line 196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

192: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
193: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
200: end if;

Line 198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

194: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
200: end if;
201:
202:

Line 199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

195: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
196: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
197:
198: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
199: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
200: end if;
201:
202:
203: /*----------------------------------- for YTD values --------------------*/

Line 233: hr_utility.trace('_ASG_LE_YTD balances');

229: v_direct_pay_ytd := p_result_table(6).balance_value;
230: v_total_pay_ytd := p_result_table(7).balance_value;
231:
232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

Line 234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);

230: v_total_pay_ytd := p_result_table(7).balance_value;
231:
232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

Line 235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);

231:
232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

Line 236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);

232: if g_debug THEN
233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

Line 237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);

233: hr_utility.trace('_ASG_LE_YTD balances');
234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;

Line 238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);

234: hr_utility.trace('GROSS_PAY-->' || p_result_table(1).balance_value);
235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;
242:

Line 239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);

235: hr_utility.trace('MANDATORY_DEDUCTIONS-->' || p_result_table(2).balance_value);
236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;
242:
243:

Line 240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);

236: hr_utility.trace('INVOLUNTARY_DEDUCTIONS-->' || p_result_table(3).balance_value);
237: hr_utility.trace('VOLUNTARY_DEDUCTIONS-->' || p_result_table(4).balance_value);
238: hr_utility.trace('NET-->' || p_result_table(5).balance_value);
239: hr_utility.trace('DIRECT_PAYMENTS-->' || p_result_table(6).balance_value);
240: hr_utility.trace('TOTAL_PAYMENTS-->' || p_result_table(7).balance_value);
241: end if;
242:
243:
244: -- Set the output balance amounts.

Line 264: hr_utility.trace('Leaving:' || 'pay_hk_soe.total_balances');

260: p_total_payment_ytd := v_total_pay_ytd;
261:
262:
263: if g_debug then
264: hr_utility.trace('Leaving:' || 'pay_hk_soe.total_balances');
265: end if;
266:
267: end balance_totals;
268:

Line 295: hr_utility.trace('Entering: ' || 'pay_hk_soe.getelements');

291: WHERE locking_action_id = p_assignment_action_id;
292:
293: BEGIN
294:
295: hr_utility.trace('Entering: ' || 'pay_hk_soe.getelements');
296:
297: OPEN csr_locked_action_id;
298: FETCH csr_locked_action_id INTO l_assignment_action_id;
299: CLOSE csr_locked_action_id;

Line 324: hr_utility.trace ('Leaving: ' || 'pay_hk_soe.getelements');

320: ORDER BY phaev.element_reporting_name';
321:
322: END IF;
323:
324: hr_utility.trace ('Leaving: ' || 'pay_hk_soe.getelements');
325: RETURN g_sql;
326: --
327: END getelements;
328:

Line 347: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_earnings');

343: IS
344:
345: BEGIN
346:
347: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_earnings');
348: RETURN getElements(p_assignment_action_id => p_assignment_action_id
349: ,p_classification_name => 'Earnings'
350: );
351:

Line 371: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_deductions');

367: IS
368:
369: BEGIN
370:
371: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_deductions');
372: RETURN getElements(p_assignment_action_id => p_assignment_action_id
373: ,p_classification_name => 'Deductions'
374: );
375:

Line 396: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_employer_liabilities');

392: IS
393:
394: BEGIN
395:
396: hr_utility.trace ('Entering: ' || 'pay_hk_soe.get_employer_liabilities');
397: RETURN getElements(p_assignment_action_id => p_assignment_action_id
398: ,p_classification_name => 'Employer Liabilities'
399: );
400:

Line 439: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_balances');

435: AND paa.assignment_action_id = p_assignment_action_id;
436:
437: BEGIN
438:
439: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_balances');
440:
441: OPEN csr_locked_action_id;
442: FETCH csr_locked_action_id INTO l_assignment_action_id;
443: CLOSE csr_locked_action_id;

Line 508: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_balances');

504: , ''NET'',5
505: , ''DIRECT_PAYMENTS'',6
506: , ''TOTAL_PAYMENTS'',7)';
507:
508: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_balances');
509:
510: RETURN g_sql;
511:
512: END get_balances;

Line 530: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_payment_methods');

526: RETURN LONG
527: IS
528: BEGIN
529:
530: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_payment_methods');
531:
532: g_sql := 'SELECT /*+
533: INDEX(opm PAY_ORG_PAYMENT_METHODS_F_PK) */
534: org_payment_method_name COL01

Line 563: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_payment_methods');

559: AND opm.effective_end_date
560: AND opm.payment_type_id = pt.payment_type_id
561: AND pt.language = USERENV(''LANG'')';
562:
563: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_payment_methods');
564:
565: RETURN g_sql;
566:
567: END get_payment_methods;

Line 605: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_element_information');

601: AND paa.assignment_action_id = p_assignment_action_id;
602:
603: BEGIN
604:
605: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_element_information');
606:
607: OPEN csr_prepayment;
608: FETCH csr_prepayment INTO l_assignment_action_id;
609: CLOSE csr_prepayment;

Line 660: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_element_information');

656: AND prr.element_type_id = org.org_information2
657: AND prv.input_value_id = org.org_information3
658: AND prv.result_value IS NOT NULL';
659:
660: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_element_information');
661:
662: RETURN g_sql;
663:
664: END get_other_element_information;

Line 704: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_balance_information');

700:
701: BEGIN
702:
703:
704: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_balance_information');
705:
706: OPEN csr_locked_action_id;
707: FETCH csr_locked_action_id INTO l_assignment_action_id;
708: CLOSE csr_locked_action_id;

Line 748: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_balance_information');

744: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
745: , NULL
746: , NULL) <> 0';
747:
748: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_balance_information');
749:
750: RETURN g_sql;
751:
752: END get_other_balance_information;

Line 839: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_annual_leave_information');

835:
836: BEGIN
837:
838:
839: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
840:
841: OPEN csr_prepayment;
842: FETCH csr_prepayment INTO l_assignment_action_id;
843: CLOSE csr_prepayment;

Line 893: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_annual_leave_information');

889: , ''' || l_uom || ''' COL03
890: FROM DUAL';
891: END IF;
892:
893: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
894:
895: RETURN g_sql;
896:
897: END get_annual_leave_info;

Line 925: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_leave_taken');

921:
922: BEGIN
923:
924:
925: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_leave_taken');
926:
927: OPEN csr_prepayment;
928: FETCH csr_prepayment INTO l_assignment_action_id;
929: CLOSE csr_prepayment;

Line 974: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_leave_taken');

970: AND ppa.effective_date BETWEEN piv.effective_start_date
971: AND piv.effective_end_date';
972:
973:
974: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_leave_taken');
975:
976: RETURN g_sql;
977:
978: END get_leave_taken;

Line 983: g_debug := hr_utility.debug_enabled;

979:
980: begin
981: g_def_bal_id_populated_payment := FALSE; /* Bug 4210525 */
982: g_def_bal_id_populated_ytd := FALSE; /* Bug 4210525 */
983: g_debug := hr_utility.debug_enabled;
984:
985: end pay_hk_soe_pkg;