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_IN_SOE_PKG dependencies on PAY_IN_UTILS

Line 52: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

48:
49: BEGIN
50:
51: l_procedure := g_package || 'get_employee';
52: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
53:
54: OPEN csr_reg_legal_name;
55: FETCH csr_reg_legal_name INTO l_reg_legal_name;
56: CLOSE csr_reg_legal_name;

Line 122: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

118: AND hl.lookup_type (+) =''NATIONALITY''
119: AND hl.lookup_code (+) =peo.nationality';
120: --
121:
122: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
123:
124: RETURN g_sql;
125:
126: END get_employee;

Line 148: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

144:
145: BEGIN
146:
147: l_procedure := g_package || 'get_fur_person_info';
148: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
149:
150: g_sql :=
151: 'SELECT TO_CHAR(paf.date_of_birth,''DD-MON-YYYY'') COL01
152: ,TO_CHAR(paf.original_date_of_hire,''DD-MON-YYYY'') COL02

Line 168: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

164: AND asg.person_id = paf.person_id
165: AND :effective_date
166: BETWEEN paf.effective_start_date AND paf.effective_end_date';
167:
168: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
169:
170: RETURN g_sql;
171:
172: END get_fur_person_info;

Line 205: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

201:
202: BEGIN
203:
204: l_procedure := g_package || 'get_period';
205: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
206:
207: open periodDates;
208: fetch periodDates into l_action_type;
209: close periodDates;

Line 270: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

266: and aa.assignment_action_id = :assignment_action_id';
267: end if;
268: --
269:
270: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
271:
272: RETURN g_sql;
273:
274: END get_period;

Line 298: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

294:
295: BEGIN
296:
297: l_procedure := g_package || 'getelements';
298: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
299:
300: IF (p_classification_name = 'Earnings') THEN
301: g_sql:=' SELECT DECODE(classification_name,
302: ''Earnings'', element_reporting_name,

Line 323: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

319: AND classification_name = ''' || p_classification_name || '''
320: AND amount <> 0
321: ORDER BY element_reporting_name';
322: END IF;
323: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
324: RETURN g_sql;
325: --
326: END getelements;
327:

Line 347: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

343:
344: BEGIN
345:
346: l_procedure := g_package || 'get_earnings';
347: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
348:
349: RETURN getElements(p_assignment_action_id => p_assignment_action_id
350: ,p_classification_name => 'Earnings'
351: );

Line 353: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

349: RETURN getElements(p_assignment_action_id => p_assignment_action_id
350: ,p_classification_name => 'Earnings'
351: );
352:
353: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
354:
355: END get_earnings;
356:
357: --------------------------------------------------------------------------

Line 376: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

372:
373: BEGIN
374:
375: l_procedure := g_package || 'get_deductions';
376: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
377:
378: RETURN getElements( p_assignment_action_id => p_assignment_action_id
379: , p_classification_name => 'Deductions'
380: );

Line 382: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

378: RETURN getElements( p_assignment_action_id => p_assignment_action_id
379: , p_classification_name => 'Deductions'
380: );
381:
382: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
383:
384: END get_deductions;
385:
386:

Line 405: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

401: l_procedure VARCHAR2(50);
402: BEGIN
403:
404: l_procedure := g_package || 'get_advances';
405: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
406:
407: RETURN getElements( p_assignment_action_id => p_assignment_action_id
408: , p_classification_name => 'Advances'
409: );

Line 411: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

407: RETURN getElements( p_assignment_action_id => p_assignment_action_id
408: , p_classification_name => 'Advances'
409: );
410:
411: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
412:
413: END get_advances;
414:
415: --------------------------------------------------------------------------

Line 433: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

429: l_procedure VARCHAR2(50);
430: BEGIN
431:
432: l_procedure := g_package || 'get_fringe_benefits';
433: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
434:
435: RETURN getElements( p_assignment_action_id => p_assignment_action_id
436: , p_classification_name => 'Fringe Benefits'
437: );

Line 439: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

435: RETURN getElements( p_assignment_action_id => p_assignment_action_id
436: , p_classification_name => 'Fringe Benefits'
437: );
438:
439: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
440:
441: END get_fringe_benefits;
442:
443:

Line 462: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

458: l_procedure VARCHAR2(50);
459: BEGIN
460:
461: l_procedure := g_package || 'get_perquisites';
462: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
463:
464: RETURN getElements( p_assignment_action_id => p_assignment_action_id
465: , p_classification_name => 'Perquisites'
466: );

Line 468: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

464: RETURN getElements( p_assignment_action_id => p_assignment_action_id
465: , p_classification_name => 'Perquisites'
466: );
467:
468: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
469:
470: END get_perquisites;
471:
472: --------------------------------------------------------------------------

Line 491: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

487: l_procedure VARCHAR2(50);
488: BEGIN
489:
490: l_procedure := g_package || 'get_employer_charges';
491: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
492:
493: RETURN getElements( p_assignment_action_id => p_assignment_action_id
494: , p_classification_name => 'Employer Charges'
495: );

Line 497: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

493: RETURN getElements( p_assignment_action_id => p_assignment_action_id
494: , p_classification_name => 'Employer Charges'
495: );
496:
497: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
498:
499: END get_employer_charges;
500:
501: --------------------------------------------------------------------------

Line 520: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

516: l_procedure VARCHAR2(50);
517: BEGIN
518:
519: l_procedure := g_package || 'get_term_payments';
520: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
521:
522: RETURN getElements( p_assignment_action_id => p_assignment_action_id
523: , p_classification_name => 'Termination Payments'
524: );

Line 526: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

522: RETURN getElements( p_assignment_action_id => p_assignment_action_id
523: , p_classification_name => 'Termination Payments'
524: );
525:
526: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
527:
528: END get_term_payments;
529:
530: --------------------------------------------------------------------------

Line 567: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

563:
564: BEGIN
565:
566: l_procedure := g_package || 'get_balances';
567: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
568:
569: OPEN csr_get_tax_till_date;
570: FETCH csr_get_tax_till_date INTO l_tax_till_date;
571: CLOSE csr_get_tax_till_date;

Line 616: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

612: , ''F16 Total Tax payable'',10
613: , ''F16 Income Tax till Date'',11
614: , ''F16 Balance Tax'',12,999))';
615:
616: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
617:
618: RETURN g_sql;
619:
620: END get_balances;

Line 642: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

638:
639: BEGIN
640:
641: l_procedure := g_package || 'get_payment_details';
642: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
643:
644: g_sql := 'SELECT org_payment_method_name COL01
645: , pay_soe_util.getBankDetails('':legislation_code''
646: ,NVL(ppm.external_account_id,opm.external_account_id)

Line 683: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

679: AND opm.effective_end_date
680: AND opm.payment_type_id = pt.payment_type_id
681: AND pt.language = USERENV(''LANG'')';
682: --
683: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
684:
685: RETURN g_sql;
686:
687: END get_payment_details;

Line 727: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

723:
724: BEGIN
725:
726: l_procedure := g_package || 'get_other_element_information';
727: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
728:
729: OPEN csr_prepayment;
730: FETCH csr_prepayment INTO l_assignment_action_id;
731: CLOSE csr_prepayment;

Line 758: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

754: AND prv.input_value_id = org.org_information3
755: AND prv.result_value IS NOT NULL
756: ORDER BY org.org_information7';
757:
758: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
759:
760: RETURN g_sql;
761:
762: END get_other_element_information;

Line 810: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

806:
807: BEGIN
808:
809: l_procedure := g_package || 'get_other_balance_information';
810: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
811:
812: OPEN csr_get_date_earned;
813: FETCH csr_get_date_earned INTO l_date_earned, l_business_group_id;
814: CLOSE csr_get_date_earned;

Line 832: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

828: AND org.org_information1 = ''BALANCE''
829: AND pdb.balance_type_id = org.org_information4
830: AND pdb.balance_dimension_id = org.org_information5';
831:
832: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
833:
834: RETURN g_sql;
835:
836: END get_other_balance_information;

Line 920: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

916:
917: BEGIN
918:
919: l_procedure := g_package || 'get_annual_leave_information';
920: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
921:
922: OPEN csr_prepayment;
923: FETCH csr_prepayment INTO l_assignment_action_id;
924: CLOSE csr_prepayment;

Line 970: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

966: , ''' || l_uom || ''' COL02
967: , TO_CHAR(' || l_annual_leave_balance|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
968: FROM DUAL';
969:
970: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
971: ELSE
972: CLOSE csr_get_annual_leave_details;
973: END IF;
974:

Line 1006: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

1002:
1003: BEGIN
1004:
1005: l_procedure := g_package || 'get_leave_taken';
1006: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
1007:
1008: OPEN csr_prepayment;
1009: FETCH csr_prepayment INTO l_assignment_action_id;
1010: CLOSE csr_prepayment;

Line 1055: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

1051: AND pee.effective_end_date
1052: AND ppa.effective_date BETWEEN piv.effective_start_date
1053: AND piv.effective_end_date';
1054:
1055: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
1056:
1057: RETURN g_sql;
1058:
1059: END get_leave_taken;

Line 1089: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);

1085: BEGIN
1086:
1087: l_procedure := g_package || 'get_messages';
1088:
1089: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
1090:
1091: OPEN csr_prepayment;
1092: FETCH csr_prepayment INTO l_assignment_action_id;
1093: CLOSE csr_prepayment;

Line 1105: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

1101: , pay_assignment_actions paa
1102: WHERE ppa.payroll_action_id = paa.payroll_action_id
1103: AND paa.assignment_action_id = ' || l_assignment_action_id;
1104:
1105: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
1106:
1107: RETURN g_sql;
1108:
1109: END get_messages;