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_REPORTS_PKG dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 131: -- pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(,0));

127: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
128:
129: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
130:
131: -- pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(,0));
132:
133: pay_in_xml_utils.gXMLTable.delete;
134: l_count:=1;
135: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_sl';

Line 147: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_epf_org,0));

143: END IF;
144: l_count := l_count + 1;
145: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_org';
146: pay_in_xml_utils.gXMLTable(l_count).Value :=
147: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_epf_org,0));
148: l_count := l_count + 1;
149: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org';
150: pay_in_xml_utils.gXMLTable(l_count).Value :=
151: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_org,0));

Line 151: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_org,0));

147: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_epf_org,0));
148: l_count := l_count + 1;
149: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org';
150: pay_in_xml_utils.gXMLTable(l_count).Value :=
151: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_org,0));
152: l_count := l_count + 1;
153: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_dli_pf_org';
154: pay_in_xml_utils.gXMLTable(l_count).Value :=
155: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_dli_contr,0));

Line 155: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_dli_contr,0));

151: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_org,0));
152: l_count := l_count + 1;
153: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_dli_pf_org';
154: pay_in_xml_utils.gXMLTable(l_count).Value :=
155: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_dli_contr,0));
156: l_count := l_count + 1;
157: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_admin_pf';
158: pay_in_xml_utils.gXMLTable(l_count).Value :=
159: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_admin_chrg,0));

Line 159: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_admin_chrg,0));

155: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_dli_contr,0));
156: l_count := l_count + 1;
157: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_admin_pf';
158: pay_in_xml_utils.gXMLTable(l_count).Value :=
159: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_admin_chrg,0));
160: l_count := l_count + 1;
161: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_edli_adm';
162: pay_in_xml_utils.gXMLTable(l_count).Value :=
163: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_edli_adm,0));

Line 163: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_edli_adm,0));

159: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_admin_chrg,0));
160: l_count := l_count + 1;
161: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_edli_adm';
162: pay_in_xml_utils.gXMLTable(l_count).Value :=
163: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_edli_adm,0));
164: l_count := l_count + 1;
165: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_total';
166: pay_in_xml_utils.gXMLTable(l_count).Value :=
167: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_total,0));

Line 167: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_total,0));

163: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_edli_adm,0));
164: l_count := l_count + 1;
165: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_total';
166: pay_in_xml_utils.gXMLTable(l_count).Value :=
167: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_total,0));
168: l_count := l_count + 1;
169: pay_in_xml_utils.multiColumnar('monthly',pay_in_xml_utils.gXMLTable,l_count,p_xml_data);
170: pay_in_xml_utils.gXMLTable.delete;
171:

Line 223: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pf_salary_ptd,0));

219: l_count:=1;
220: --PF Salary _ASG_ORG_PTD
221: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf_salary_ptd';
222: pay_in_xml_utils.gXMLTable(l_count).Value :=
223: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pf_salary_ptd,0));
224: l_count := l_count + 1;
225: --Total Employee Contr
226: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf';
227: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 228: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_epf,0));

224: l_count := l_count + 1;
225: --Total Employee Contr
226: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf';
227: pay_in_xml_utils.gXMLTable(l_count).Value :=
228: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_epf,0));
229: l_count := l_count + 1;
230: --Employer Contr towards PF
231: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_difference';
232: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 233: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_epf_diff,0));

229: l_count := l_count + 1;
230: --Employer Contr towards PF
231: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_difference';
232: pay_in_xml_utils.gXMLTable(l_count).Value :=
233: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_epf_diff,0));
234: l_count := l_count + 1;
235: --Employer Contr towards Pension
236: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund';
237: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 238: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_fund,0));

234: l_count := l_count + 1;
235: --Employer Contr towards Pension
236: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund';
237: pay_in_xml_utils.gXMLTable(l_count).Value :=
238: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_fund,0));
239: l_count := l_count + 1;
240: --Absence
241: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_absence';
242: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 243: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_absence,0));

239: l_count := l_count + 1;
240: --Absence
241: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_absence';
242: pay_in_xml_utils.gXMLTable(l_count).Value :=
243: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_absence,0));
244: l_count := l_count + 1;
245: --Remarks
246: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_remarks';
247: pay_in_xml_utils.gXMLTable(l_count).Value := (p_remarks);

Line 301: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,p_pension_org);

297: l_bg_id:=fnd_profile.value('PER_BUSINESS_GROUP_ID');
298: l_count:=1;
299:
300: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org'||p_row_num;
301: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,p_pension_org);
302: l_count := l_count + 1;
303:
304: pay_in_xml_utils.multiColumnar('monthly',pay_in_xml_utils.gXMLTable,l_count,p_xml_data);
305: pay_in_xml_utils.gXMLTable.DELETE;

Line 353: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pf_salary_ptd,0));

349: l_bg_id:= fnd_profile.value('PER_BUSINESS_GROUP_ID');
350: l_count:=1;
351: --PF Salary _ASG_ORG_PTD
352: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf_salary_ptd';
353: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pf_salary_ptd,0));
354: l_count := l_count + 1;
355:
356: --Employer Contr towards Pension
357: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund';

Line 358: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_fund,0));

354: l_count := l_count + 1;
355:
356: --Employer Contr towards Pension
357: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund';
358: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(p_pension_fund,0));
359: l_count := l_count + 1;
360: --Absence
361: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_absence';
362: pay_in_xml_utils.gXMLTable(l_count).Value := nvl(p_absence,0);

Line 907: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));

903: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
904: ELSE
905: l_tag := pay_in_xml_utils.getTag('c_rs1', 'Rs.');
906: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
907: l_tag := pay_in_xml_utils.getTag('c_tax_slab_3', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_3,0)));
908: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
909: END IF;
910:
911: IF l_cnt_120 = 0 THEN

Line 919: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));

915: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
916: ELSE
917: l_tag := pay_in_xml_utils.getTag('c_rs2', 'Rs.');
918: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
919: l_tag := pay_in_xml_utils.getTag('c_tax_slab_4', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_4,0)));
920: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
921: END IF;
922:
923:

Line 925: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));

921: END IF;
922:
923:
924: -- Writing to file the calculated PT paid in each slab
925: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));
926: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
927: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
928: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
929: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));

Line 927: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));

923:
924: -- Writing to file the calculated PT paid in each slab
925: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));
926: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
927: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
928: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
929: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
930: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
931:

Line 929: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));

925: -- l_tag := pay_in_xml_utils.getTag('c_tax_slab_2', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_2,0)));
926: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
927: l_tag := pay_in_xml_utils.getTag('c_tax_slab_5', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_5,0)));
928: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
929: l_tag := pay_in_xml_utils.getTag('c_tax_slab_6', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_slab_6,0)));
930: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
931:
932: pay_in_utils.set_location(g_debug,l_procedure, 130);
933:

Line 950: l_tag := pay_in_xml_utils.getTag('c_tax_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_amount,0)));

946: pay_in_utils.trace('Excess Tax ',l_excess_tax);
947: END IF;
948:
949:
950: l_tag := pay_in_xml_utils.getTag('c_tax_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_amount,0)));
951: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
952:
953: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
954: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 953: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));

949:
950: l_tag := pay_in_xml_utils.getTag('c_tax_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_tax_amount,0)));
951: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
952:
953: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
954: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
955:
956: l_tag := pay_in_xml_utils.getTag('c_excess_tax', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_excess_tax,0)));
957: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 956: l_tag := pay_in_xml_utils.getTag('c_excess_tax', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_excess_tax,0)));

952:
953: l_tag := pay_in_xml_utils.getTag('c_interest_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_interest_amount,0)));
954: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
955:
956: l_tag := pay_in_xml_utils.getTag('c_excess_tax', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_excess_tax,0)));
957: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
958:
959: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
960:

Line 961: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));

957: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
958:
959: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
960:
961: l_tag := pay_in_xml_utils.getTag('c_net_amount', pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_net_amount,0)));
962: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
963:
964: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
965: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 1365: WRITE_TAG('C_TOT_AMT_PAID',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tot_income));

1361: WRITE_TAG('C_REP_PIN',l_rep_pin);
1362: WRITE_TAG('C_REP_TEL',l_rep_teL);
1363: WRITE_TAG('C_REP_FAX',l_rep_fax);
1364:
1365: WRITE_TAG('C_TOT_AMT_PAID',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tot_income));
1366: WRITE_TAG('C_TDS',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tds));
1367: WRITE_TAG('C_TOT_EMP',l_tot_emp);
1368:
1369: WRITE_TAG('C_ASSESS_YEAR',l_year);

Line 1366: WRITE_TAG('C_TDS',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tds));

1362: WRITE_TAG('C_REP_TEL',l_rep_teL);
1363: WRITE_TAG('C_REP_FAX',l_rep_fax);
1364:
1365: WRITE_TAG('C_TOT_AMT_PAID',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tot_income));
1366: WRITE_TAG('C_TDS',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tds));
1367: WRITE_TAG('C_TOT_EMP',l_tot_emp);
1368:
1369: WRITE_TAG('C_ASSESS_YEAR',l_year);
1370: WRITE_TAG('C_REP_NAME',l_rep_name);

Line 2456: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(asg_sum,0));

2452: l_org_pension_ytd := l_org_pension_ytd + child_asg_rec.pension;
2453:
2454: --Annual Wages
2455: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf';
2456: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(asg_sum,0));
2457: l_count := l_count + 1;
2458: --Pension YTD
2459: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
2460: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pension,0));

Line 2460: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pension,0));

2456: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(asg_sum,0));
2457: l_count := l_count + 1;
2458: --Pension YTD
2459: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
2460: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pension,0));
2461: l_count := l_count + 1;
2462:
2463: IF g_debug THEN
2464: pay_in_utils.trace('PF Wages ',asg_sum);

Line 2514: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(l_org_pf_ytd,0));

2510: pay_in_xml_utils.gXMLTable.delete;
2511:
2512: l_count:=1;
2513: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_wage_ytd';
2514: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(l_org_pf_ytd,0));
2515: l_count := l_count + 1;
2516: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
2517: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(l_org_pension_ytd,0));
2518: l_count := l_count + 1;

Line 2517: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(l_org_pension_ytd,0));

2513: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_wage_ytd';
2514: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(l_org_pf_ytd,0));
2515: l_count := l_count + 1;
2516: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
2517: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(l_org_pension_ytd,0));
2518: l_count := l_count + 1;
2519: pay_in_xml_utils.multiColumnar('sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
2520:
2521: IF g_debug THEN

Line 2582: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,l_pension_total);

2578:
2579: l_count:=1;
2580: --Pension Fund Total
2581: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org_total';
2582: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,l_pension_total);
2583: l_count := l_count + 1;
2584:
2585: --No of employees in Form 8
2586: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_emp_no';

Line 3524: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pf_ytd,0));

3520: l_count := l_count + 1;
3521: --Annual Wages
3522: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf';
3523: pay_in_xml_utils.gXMLTable(l_count).Value :=
3524: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pf_ytd,0));
3525: l_count := l_count + 1;
3526: --Total Employee PF Contribution YTD
3527: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf';
3528: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3529: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.employee,0));

3525: l_count := l_count + 1;
3526: --Total Employee PF Contribution YTD
3527: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf';
3528: pay_in_xml_utils.gXMLTable(l_count).Value :=
3529: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.employee,0));
3530: l_count := l_count + 1;
3531: --Employer Contribution Towards PF YTD
3532: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_diff';
3533: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3534: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.employer,0));

3530: l_count := l_count + 1;
3531: --Employer Contribution Towards PF YTD
3532: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_diff';
3533: pay_in_xml_utils.gXMLTable(l_count).Value :=
3534: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.employer,0));
3535: l_count := l_count + 1;
3536: --Pension YTD
3537: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
3538: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3539: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pension,0));

3535: l_count := l_count + 1;
3536: --Pension YTD
3537: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
3538: pay_in_xml_utils.gXMLTable(l_count).Value :=
3539: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pension,0));
3540: l_count := l_count + 1;
3541:
3542: l_org_pf_ytd := l_org_pf_ytd + child_asg_rec.pf_ytd;
3543: l_org_employer := l_org_employer + child_asg_rec.employer;

Line 3610: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pf_ytd,0));

3606: pay_in_xml_utils.gXMLTable.delete;
3607: l_count:=1;
3608: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_wage_ytd';
3609: pay_in_xml_utils.gXMLTable(l_count).Value :=
3610: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pf_ytd,0));
3611: l_count := l_count + 1;
3612: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_ytd';
3613: pay_in_xml_utils.gXMLTable(l_count).Value :=
3614: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employee,0));

Line 3614: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employee,0));

3610: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pf_ytd,0));
3611: l_count := l_count + 1;
3612: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_ytd';
3613: pay_in_xml_utils.gXMLTable(l_count).Value :=
3614: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employee,0));
3615: l_count := l_count + 1;
3616: pay_in_xml_utils.gXMLTable(l_count).Name := 'diff_ytd';
3617: pay_in_xml_utils.gXMLTable(l_count).Value :=
3618: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employer,0));

Line 3618: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employer,0));

3614: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employee,0));
3615: l_count := l_count + 1;
3616: pay_in_xml_utils.gXMLTable(l_count).Name := 'diff_ytd';
3617: pay_in_xml_utils.gXMLTable(l_count).Value :=
3618: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employer,0));
3619: l_count := l_count + 1;
3620: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
3621: pay_in_xml_utils.gXMLTable(l_count).Value :=
3622: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pension,0));

Line 3622: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pension,0));

3618: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employer,0));
3619: l_count := l_count + 1;
3620: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
3621: pay_in_xml_utils.gXMLTable(l_count).Value :=
3622: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pension,0));
3623: l_count := l_count + 1;
3624: pay_in_xml_utils.multiColumnar('sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
3625:
3626: pay_in_xml_utils.gXMLTable.delete;

Line 3682: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_epf_total);

3678: l_count:=1;
3679: --EPF Contributions Total
3680: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_org_total';
3681: pay_in_xml_utils.gXMLTable(l_count).Value :=
3682: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_epf_total);
3683: l_count := l_count + 1;
3684: --Pension Fund Total
3685: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org_total';
3686: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3687: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_pension_total);

3683: l_count := l_count + 1;
3684: --Pension Fund Total
3685: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org_total';
3686: pay_in_xml_utils.gXMLTable(l_count).Value :=
3687: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_pension_total);
3688: l_count := l_count + 1;
3689: --DLI Contribution Total
3690: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_dli_pf_org_total';
3691: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3692: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_dli_total);

3688: l_count := l_count + 1;
3689: --DLI Contribution Total
3690: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_dli_pf_org_total';
3691: pay_in_xml_utils.gXMLTable(l_count).Value :=
3692: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_dli_total);
3693: l_count := l_count + 1;
3694: --Adm.Charges Total
3695: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_admin_pf_total';
3696: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3697: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_admn_total);

3693: l_count := l_count + 1;
3694: --Adm.Charges Total
3695: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_admin_pf_total';
3696: pay_in_xml_utils.gXMLTable(l_count).Value :=
3697: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_admn_total);
3698: l_count := l_count + 1;
3699: --EDLI ADm.Charges Total
3700: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_edli_org_total';
3701: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3702: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_edli_adm_total);

3698: l_count := l_count + 1;
3699: --EDLI ADm.Charges Total
3700: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_edli_org_total';
3701: pay_in_xml_utils.gXMLTable(l_count).Value :=
3702: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_edli_adm_total);
3703: l_count := l_count + 1;
3704: --Col 5,6,7 Summation Aggregate
3705: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_total_annual';
3706: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 3707: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_summation);

3703: l_count := l_count + 1;
3704: --Col 5,6,7 Summation Aggregate
3705: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_total_annual';
3706: pay_in_xml_utils.gXMLTable(l_count).Value :=
3707: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_summation);
3708: l_count := l_count + 1;
3709: --No of employees in Form 6A
3710: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_emp_no';
3711:

Line 4264: l_tag :=pay_in_xml_utils.getTag('c_pf_salary_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pf_ytd));

4260: ,p_effective_end_date
4261: ,p_contribution_period)
4262: LOOP
4263: --PF Salary Annual Value
4264: l_tag :=pay_in_xml_utils.getTag('c_pf_salary_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pf_ytd));
4265: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4266: -- Employee Total Contribution
4267: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
4268: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4267: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));

4263: --PF Salary Annual Value
4264: l_tag :=pay_in_xml_utils.getTag('c_pf_salary_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pf_ytd));
4265: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4266: -- Employee Total Contribution
4267: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
4268: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4269: -- Employer Total Contribution
4270: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
4271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4270: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));

4266: -- Employee Total Contribution
4267: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
4268: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4269: -- Employer Total Contribution
4270: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
4271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4272: -- Pension
4273: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
4274: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4273: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));

4269: -- Employer Total Contribution
4270: l_tag :=pay_in_xml_utils.getTag('c_epf_difference_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employer));
4271: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4272: -- Pension
4273: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
4274: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4275: --Total Employee Employer Contr
4276: l_tag :=pay_in_xml_utils.getTag('c_employer_employee_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.total));
4277: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 4276: l_tag :=pay_in_xml_utils.getTag('c_employer_employee_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.total));

4272: -- Pension
4273: l_tag :=pay_in_xml_utils.getTag('c_pension_fund_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.pension));
4274: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4275: --Total Employee Employer Contr
4276: l_tag :=pay_in_xml_utils.getTag('c_employer_employee_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.total));
4277: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4278: END LOOP;
4279: pay_in_utils.set_location(g_debug,l_procedure, 110);
4280: --Current Date

Line 4804: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(to_char(l_total_pf_wages),0));

4800: l_count := l_count + 1;
4801:
4802: -- Annual PF Wages
4803: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf_salary_ytd';
4804: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(to_char(l_total_pf_wages),0));
4805: l_count := l_count + 1;
4806: -- Annual Pension Contr
4807: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund_ytd';
4808: pay_in_xml_utils.gXMLTable(l_count).Value :=

Line 4809: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(to_char(l_total_pension),0));

4805: l_count := l_count + 1;
4806: -- Annual Pension Contr
4807: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund_ytd';
4808: pay_in_xml_utils.gXMLTable(l_count).Value :=
4809: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(to_char(l_total_pension),0));
4810: l_count := l_count + 1;
4811:
4812: -- Hire Date
4813: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_hire_date';

Line 5756: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));

5752: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5753: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5754: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5756: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5758: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5760: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);

Line 5758: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));

5754: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5755: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5756: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5757: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5758: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5759: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5760: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5762: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);

Line 5764: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));

5760: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5761: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5762: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5764: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5766: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5768: l_tag :='';

Line 5766: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));

5762: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5763: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5764: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5765: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5766: l_tag :=pay_in_xml_utils.getTag('c_avg_daily_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_avg_daily_wage));
5767: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5768: l_tag :='';
5769: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5770: l_count := l_count + 1;

Line 5777: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));

5773: l_days_tot := l_days_tot + nvl(l_days,0);
5774: END IF;
5775: END LOOP;
5776:
5777: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5778: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5779: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));

Line 5779: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));

5775: END LOOP;
5776:
5777: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5778: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5779: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5783:

Line 5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));

5777: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5778: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5779: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5780: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5781: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5782: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5783:
5784: dbms_lob.close(l_xml_data);
5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);

Line 5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));

5784: dbms_lob.close(l_xml_data);
5785: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5787: --Employer Share, Employee Share and Total Contribution
5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5791: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5792: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));

Line 5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));

5786: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5787: --Employer Share, Employee Share and Total Contribution
5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5791: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5792: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5793: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5794: --Challan Details

Line 5792: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));

5788: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5789: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5790: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5791: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5792: l_tag :=pay_in_xml_utils.getTag('c_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total + l_employer_total));
5793: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5794: --Challan Details
5795: l_count := 1;
5796: l_challan_tot := 0;

Line 5814: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));

5810: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5811: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5812: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5813: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5814: l_tag :=pay_in_xml_utils.getTag('c_challan_paid',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_challan_rec.challan_amt));
5815: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5816: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5817: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5818: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);

Line 5825: l_tag :=pay_in_xml_utils.getTag('c_challan_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_challan_tot));

5821: l_count := l_count + 1;
5822: l_tag :='';
5823: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5824: END LOOP;
5825: l_tag :=pay_in_xml_utils.getTag('c_challan_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_challan_tot));
5826: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5827:
5828:
5829: --Declaration Details

Line 5860: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));

5856: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5857: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5858: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5859: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5860: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5862: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));

Line 5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));

5860: l_tag := pay_in_xml_utils.getTag('c_direct_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_covered_wages));
5861: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5862: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5863: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5866: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));

Line 5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));

5864: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_direct_not_covered_wages));
5865: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5866: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5867: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5870: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5872: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));

Line 5872: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));

5868: l_tag := pay_in_xml_utils.getTag('c_wages_immediate_emplr_cover',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immediate_emplr_cover));
5869: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5870: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5871: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5872: l_tag := pay_in_xml_utils.getTag('c_wages_immd_emplr_not_covered',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_immd_emplr_not_covered));
5873: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5874: l_tag := '';
5875: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5876: