DBA Data[Home] [Help]

APPS.PAY_IN_SOE dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 328: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(

324: pay_in_utils.trace('This Pay : ',rec.amt);
325: pay_in_utils.set_location(g_debug,l_procedure,40);
326:
327: append_tag('Description',rec.ename);
328: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
329: g_business_group_id
330: ,rec.amt));
331:
332: close_tag(l_classification_tag || 'Element');

Line 350: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(

346: pay_in_utils.trace('This Pay : ',rec.amt);
347: pay_in_utils.set_location(g_debug,l_procedure,40);
348:
349: append_tag('Description',rec.ename);
350: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
351: g_business_group_id
352: ,rec.amt));
353:
354: close_tag(l_classification_tag || 'Element');

Line 374: append_tag(l_classification_tag || 'Total',pay_us_employee_payslip_web.get_format_value(

370: close_tag(l_classification_tag || 'Element');
371: --
372: END IF;
373:
374: append_tag(l_classification_tag || 'Total',pay_us_employee_payslip_web.get_format_value(
375: g_business_group_id
376: ,l_total));
377:
378: close_tag(l_classification_tag);

Line 469: append_tag('GrossEarnings',pay_us_employee_payslip_web.get_format_value(

465:
466: pay_in_utils.trace('l_gross_earnings : ',l_gross_earnings);
467: pay_in_utils.set_location(g_debug,l_procedure,20);
468:
469: append_tag('GrossEarnings',pay_us_employee_payslip_web.get_format_value(
470: g_business_group_id
471: ,l_gross_earnings));
472:
473:

Line 483: append_tag('GrossDeductions',pay_us_employee_payslip_web.get_format_value(

479: l_gross_deductions := NVL(l_gross_deductions,0);
480: pay_in_utils.trace('l_gross_deductions ',l_gross_deductions);
481: pay_in_utils.set_location(g_debug,l_procedure,30);
482:
483: append_tag('GrossDeductions',pay_us_employee_payslip_web.get_format_value(
484: g_business_group_id
485: ,l_gross_deductions));
486:
487: l_net_pay:=l_gross_earnings - l_gross_deductions;

Line 492: append_tag('Pay',pay_us_employee_payslip_web.get_format_value(

488:
489: pay_in_utils.trace('l_net_pay ',l_net_pay);
490: pay_in_utils.set_location(g_debug,l_procedure,30);
491:
492: append_tag('Pay',pay_us_employee_payslip_web.get_format_value(
493: g_business_group_id
494: ,l_net_pay));
495:
496:

Line 568: append_tag('YTD',pay_us_employee_payslip_web.get_format_value(

564: pay_in_utils.trace('YTD : ',rec.ytd);
565: pay_in_utils.set_location(g_debug,l_procedure,30);
566:
567: append_tag('Description',rec.bname);
568: append_tag('YTD',pay_us_employee_payslip_web.get_format_value(
569: g_business_group_id
570: ,rec.ytd));
571:
572: close_tag('Balance');

Line 652: append_tag('Value',pay_us_employee_payslip_web.get_format_value(

648:
649: append_tag('Description',rec.narrative);
650:
651: BEGIN
652: append_tag('Value',pay_us_employee_payslip_web.get_format_value(
653: g_business_group_id
654: ,rec.amount));
655: EXCEPTION
656: WHEN num_char THEN

Line 751: append_tag('Balance',pay_us_employee_payslip_web.get_format_value(

747:
748: /* Bug 4218967 Changed the tag AccrBalance to Balance */
749: append_tag('PlanName',rec.plan_name);
750: append_tag('UOM',rec.uom);
751: append_tag('Balance',pay_us_employee_payslip_web.get_format_value(
752: g_business_group_id
753: ,rec.balance));
754:
755: close_tag('AccrualPlan');

Line 850: append_tag('ThisPay',pay_us_employee_payslip_web.get_format_value(

846:
847: append_tag('AbsenceName',rec.absence_name);
848: append_tag('StartDate',to_char(rec.start_date,'DD-MON-YYYY'));
849: append_tag('EndDate',to_char(rec.end_date,'DD-MON-YYYY'));
850: append_tag('ThisPay',pay_us_employee_payslip_web.get_format_value(
851: g_business_group_id
852: ,rec.absence_value));
853:
854: close_tag('Absence');

Line 1018: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(

1014: pay_in_utils.set_location(g_debug,l_procedure,30);
1015:
1016:
1017: append_tag('Description',rec.narrative);
1018: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
1019: g_business_group_id
1020: ,rec.value));
1021:
1022: close_tag('EMEABalance');

Line 1116: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(

1112:
1113: append_tag('PaymentType',rec.payment_method);
1114: append_tag('Bank',rec.bank_name);
1115: append_tag('AccountNumber',rec.account_number);
1116: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
1117: g_business_group_id
1118: ,rec.value));
1119:
1120: close_tag('Payment');

Line 1295: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob

1291: l_stmt := ' SELECT piaav.assignment_action_id action_context_id
1292: ,peaiv.action_information10 employee_number
1293: ,peaiv.action_information14 assignment_number
1294: ,peaiv.action_information18 gre_name
1295: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob
1296: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date
1297: ,peaiv.action_information8 ptn
1298: ,peaiv.action_information24 pf_number
1299: ,peaiv.action_information6 esi_number

Line 1296: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date

1292: ,peaiv.action_information10 employee_number
1293: ,peaiv.action_information14 assignment_number
1294: ,peaiv.action_information18 gre_name
1295: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob
1296: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date
1297: ,peaiv.action_information8 ptn
1298: ,peaiv.action_information24 pf_number
1299: ,peaiv.action_information6 esi_number
1300: ,peaiv.action_information1 emp_name