DBA Data[Home] [Help]

APPS.PAY_IN_SOE dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

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

609: pay_in_utils.trace('This Pay : ',rec.amt);
610: pay_in_utils.set_location(g_debug,l_procedure,40);
611:
612: append_tag('Description',rec.ename);
613: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
614: g_business_group_id
615: ,rec.amt));
616:
617: close_tag(l_classification_tag || 'Element');

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

631: pay_in_utils.trace('This Pay : ',rec.amt);
632: pay_in_utils.set_location(g_debug,l_procedure,40);
633:
634: append_tag('Description',rec.ename);
635: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
636: g_business_group_id
637: ,rec.amt));
638:
639: close_tag(l_classification_tag || 'Element');

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

655: close_tag(l_classification_tag || 'Element');
656: --
657: END IF;
658:
659: append_tag(l_classification_tag || 'Total',pay_us_employee_payslip_web.get_format_value(
660: g_business_group_id
661: ,l_total));
662:
663: close_tag(l_classification_tag);

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

750:
751: pay_in_utils.trace('l_gross_earnings : ',l_gross_earnings);
752: pay_in_utils.set_location(g_debug,l_procedure,20);
753:
754: append_tag('GrossEarnings',pay_us_employee_payslip_web.get_format_value(
755: g_business_group_id
756: ,l_gross_earnings));
757:
758:

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

764: l_gross_deductions := NVL(l_gross_deductions,0);
765: pay_in_utils.trace('l_gross_deductions ',l_gross_deductions);
766: pay_in_utils.set_location(g_debug,l_procedure,30);
767:
768: append_tag('GrossDeductions',pay_us_employee_payslip_web.get_format_value(
769: g_business_group_id
770: ,l_gross_deductions));
771:
772: l_net_pay:=l_gross_earnings - l_gross_deductions;

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

773:
774: pay_in_utils.trace('l_net_pay ',l_net_pay);
775: pay_in_utils.set_location(g_debug,l_procedure,30);
776:
777: append_tag('Pay',pay_us_employee_payslip_web.get_format_value(
778: g_business_group_id
779: ,l_net_pay));
780:
781:

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

849: pay_in_utils.trace('YTD : ',rec.ytd);
850: pay_in_utils.set_location(g_debug,l_procedure,30);
851:
852: append_tag('Description',rec.bname);
853: append_tag('YTD',pay_us_employee_payslip_web.get_format_value(
854: g_business_group_id
855: ,rec.ytd));
856:
857: close_tag('Balance');

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

933:
934: append_tag('Description',rec.narrative);
935:
936: BEGIN
937: append_tag('Value',pay_us_employee_payslip_web.get_format_value(
938: g_business_group_id
939: ,rec.amount));
940: EXCEPTION
941: WHEN num_char THEN

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

1032:
1033: /* Bug 4218967 Changed the tag AccrBalance to Balance */
1034: append_tag('PlanName',rec.plan_name);
1035: append_tag('UOM',rec.uom);
1036: append_tag('Balance',pay_us_employee_payslip_web.get_format_value(
1037: g_business_group_id
1038: ,rec.balance));
1039:
1040: close_tag('AccrualPlan');

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

1131:
1132: append_tag('AbsenceName',rec.absence_name);
1133: append_tag('StartDate',to_char(rec.start_date,'DD-MON-YYYY'));
1134: append_tag('EndDate',to_char(rec.end_date,'DD-MON-YYYY'));
1135: append_tag('ThisPay',pay_us_employee_payslip_web.get_format_value(
1136: g_business_group_id
1137: ,rec.absence_value));
1138:
1139: close_tag('Absence');

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

1316: pay_in_utils.set_location(g_debug,l_procedure,30);
1317:
1318:
1319: append_tag('Description',rec.narrative);
1320: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
1321: g_business_group_id
1322: ,rec.value));
1323:
1324: close_tag('EMEABalance');

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

1414:
1415: append_tag('PaymentType',rec.payment_method);
1416: append_tag('Bank',rec.bank_name);
1417: append_tag('AccountNumber',rec.account_number);
1418: append_tag('Amount',pay_us_employee_payslip_web.get_format_value(
1419: g_business_group_id
1420: ,rec.value));
1421:
1422: close_tag('Payment');

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

1602: l_stmt := ' SELECT piaav.assignment_action_id action_context_id
1603: ,peaiv.action_information10 employee_number
1604: ,peaiv.action_information14 assignment_number
1605: ,peaiv.action_information18 gre_name
1606: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob
1607: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date
1608: ,peaiv.action_information8 ptn
1609: ,peaiv.action_information24 pf_number
1610: ,peaiv.action_information6 esi_number

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

1603: ,peaiv.action_information10 employee_number
1604: ,peaiv.action_information14 assignment_number
1605: ,peaiv.action_information18 gre_name
1606: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob
1607: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date
1608: ,peaiv.action_information8 ptn
1609: ,peaiv.action_information24 pf_number
1610: ,peaiv.action_information6 esi_number
1611: ,peaiv.action_information1 emp_name

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

2004: l_stmt := ' SELECT piaav.assignment_action_id action_context_id
2005: ,peaiv.action_information10 employee_number
2006: ,peaiv.action_information14 assignment_number
2007: ,peaiv.action_information18 gre_name
2008: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob
2009: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date
2010: ,peaiv.action_information8 ptn
2011: ,peaiv.action_information24 pf_number
2012: ,peaiv.action_information6 esi_number

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

2005: ,peaiv.action_information10 employee_number
2006: ,peaiv.action_information14 assignment_number
2007: ,peaiv.action_information18 gre_name
2008: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information13) dob
2009: ,pay_us_employee_payslip_web.format_to_date(peaiv.action_information11) joining_date
2010: ,peaiv.action_information8 ptn
2011: ,peaiv.action_information24 pf_number
2012: ,peaiv.action_information6 esi_number
2013: ,peaiv.action_information1 emp_name