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 835: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);

831: AND pdb.balance_type_id = org.org_information4
832: AND pdb.balance_dimension_id = org.org_information5
833: ORDER BY lpad(org.org_information8,4,0)'; /* Bug 13638866 - Added lpad in ORDER BY clause */
834:
835: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
836:
837: RETURN g_sql;
838:
839: END get_other_balance_information;

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

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

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

985: END IF;
986:
987: /* End of Bug 13021890 - To display multiple accrual plans */
988:
989: pay_in_utils.set_location (g_debug, 'Leaving ' || l_procedure,20);
990:
991: END LOOP;
992:
993: CLOSE csr_get_annual_leave_details;

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

1022:
1023: BEGIN
1024:
1025: l_procedure := g_package || 'get_leave_taken';
1026: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
1027:
1028: OPEN csr_prepayment;
1029: FETCH csr_prepayment INTO l_assignment_action_id;
1030: CLOSE csr_prepayment;

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

1071: AND pee.effective_end_date
1072: AND ppa.effective_date BETWEEN piv.effective_start_date
1073: AND piv.effective_end_date';
1074:
1075: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
1076:
1077: RETURN g_sql;
1078:
1079: END get_leave_taken;

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

1105: BEGIN
1106:
1107: l_procedure := g_package || 'get_messages';
1108:
1109: pay_in_utils.set_location (g_debug,'Entering ' || l_procedure,10);
1110:
1111: OPEN csr_prepayment;
1112: FETCH csr_prepayment INTO l_assignment_action_id;
1113: CLOSE csr_prepayment;

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

1121: , pay_assignment_actions paa
1122: WHERE ppa.payroll_action_id = paa.payroll_action_id
1123: AND paa.assignment_action_id = ' || l_assignment_action_id;
1124:
1125: pay_in_utils.set_location (g_debug,'Leaving ' || l_procedure,20);
1126:
1127: RETURN g_sql;
1128:
1129: END get_messages;