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 841: -- 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)));

837: l_tax_slab_5 := l_slab_5 * l_count_175;
838: l_tax_slab_6 := l_slab_6 * l_count_200 + l_slab_6_2 * l_count_300;
839:
840: -- Writing to file the calculated PT paid in each slab
841: -- 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)));
842: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
843: 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)));
844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: 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)));

Line 843: 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)));

839:
840: -- Writing to file the calculated PT paid in each slab
841: -- 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)));
842: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
843: 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)));
844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: 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)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: 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)));

Line 845: 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)));

841: -- 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)));
842: -- dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
843: 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)));
844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: 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)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: 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)));
848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
849: 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 847: 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)));

843: 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)));
844: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
845: 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)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: 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)));
848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
849: 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)));
850: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
851:

Line 849: 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)));

845: 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)));
846: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
847: 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)));
848: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
849: 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)));
850: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
851:
852: pay_in_utils.set_location(g_debug,l_procedure, 130);
853:

Line 870: 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)));

866: pay_in_utils.trace('Excess Tax ',l_excess_tax);
867: END IF;
868:
869:
870: 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)));
871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
872:
873: 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)));
874: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 873: 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)));

869:
870: 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)));
871: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
872:
873: 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)));
874: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
875:
876: 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)));
877: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 876: 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)));

872:
873: 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)));
874: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
875:
876: 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)));
877: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
878:
879: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
880:

Line 881: 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)));

877: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
878:
879: l_net_amount := l_tax_amount - l_excess_tax + l_interest_amount;
880:
881: 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)));
882: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
883:
884: l_tag := pay_in_xml_utils.getTag('c_total_amount_words', initcap(pay_in_utils.number_to_words(l_net_amount)));
885: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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

1281: WRITE_TAG('C_REP_PIN',l_rep_pin);
1282: WRITE_TAG('C_REP_TEL',l_rep_teL);
1283: WRITE_TAG('C_REP_FAX',l_rep_fax);
1284:
1285: WRITE_TAG('C_TOT_AMT_PAID',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tot_income));
1286: WRITE_TAG('C_TDS',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tds));
1287: WRITE_TAG('C_TOT_EMP',l_tot_emp);
1288:
1289: WRITE_TAG('C_ASSESS_YEAR',l_year);

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

1282: WRITE_TAG('C_REP_TEL',l_rep_teL);
1283: WRITE_TAG('C_REP_FAX',l_rep_fax);
1284:
1285: WRITE_TAG('C_TOT_AMT_PAID',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tot_income));
1286: WRITE_TAG('C_TDS',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_tds));
1287: WRITE_TAG('C_TOT_EMP',l_tot_emp);
1288:
1289: WRITE_TAG('C_ASSESS_YEAR',l_year);
1290: WRITE_TAG('C_REP_NAME',l_rep_name);

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

1871: l_org_pension_ytd := l_org_pension_ytd + child_asg_rec.pension;
1872:
1873: --Annual Wages
1874: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf';
1875: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(asg_sum,0));
1876: l_count := l_count + 1;
1877: --Pension YTD
1878: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
1879: 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 1879: 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));

1875: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,NVL(asg_sum,0));
1876: l_count := l_count + 1;
1877: --Pension YTD
1878: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
1879: 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));
1880: l_count := l_count + 1;
1881:
1882: IF g_debug THEN
1883: pay_in_utils.trace('PF Wages ',asg_sum);

Line 1933: 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));

1929: pay_in_xml_utils.gXMLTable.delete;
1930:
1931: l_count:=1;
1932: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_wage_ytd';
1933: 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));
1934: l_count := l_count + 1;
1935: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
1936: 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));
1937: l_count := l_count + 1;

Line 1936: 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));

1932: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_wage_ytd';
1933: 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));
1934: l_count := l_count + 1;
1935: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
1936: 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));
1937: l_count := l_count + 1;
1938: pay_in_xml_utils.multiColumnar('sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
1939:
1940: IF g_debug THEN

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

1997:
1998: l_count:=1;
1999: --Pension Fund Total
2000: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org_total';
2001: pay_in_xml_utils.gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(l_bg_id,l_pension_total);
2002: l_count := l_count + 1;
2003:
2004: --No of employees in Form 8
2005: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_emp_no';

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

2891: l_count := l_count + 1;
2892: --Annual Wages
2893: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf';
2894: pay_in_xml_utils.gXMLTable(l_count).Value :=
2895: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pf_ytd,0));
2896: l_count := l_count + 1;
2897: --Total Employee PF Contribution YTD
2898: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf';
2899: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

2896: l_count := l_count + 1;
2897: --Total Employee PF Contribution YTD
2898: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf';
2899: pay_in_xml_utils.gXMLTable(l_count).Value :=
2900: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.employee,0));
2901: l_count := l_count + 1;
2902: --Employer Contribution Towards PF YTD
2903: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_diff';
2904: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

2901: l_count := l_count + 1;
2902: --Employer Contribution Towards PF YTD
2903: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_diff';
2904: pay_in_xml_utils.gXMLTable(l_count).Value :=
2905: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.employer,0));
2906: l_count := l_count + 1;
2907: --Pension YTD
2908: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
2909: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

2906: l_count := l_count + 1;
2907: --Pension YTD
2908: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension';
2909: pay_in_xml_utils.gXMLTable(l_count).Value :=
2910: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(child_asg_rec.pension,0));
2911: l_count := l_count + 1;
2912:
2913: l_org_pf_ytd := l_org_pf_ytd + child_asg_rec.pf_ytd;
2914: l_org_employer := l_org_employer + child_asg_rec.employer;

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

2974: pay_in_xml_utils.gXMLTable.delete;
2975: l_count:=1;
2976: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_wage_ytd';
2977: pay_in_xml_utils.gXMLTable(l_count).Value :=
2978: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pf_ytd,0));
2979: l_count := l_count + 1;
2980: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_ytd';
2981: pay_in_xml_utils.gXMLTable(l_count).Value :=
2982: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employee,0));

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

2978: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pf_ytd,0));
2979: l_count := l_count + 1;
2980: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_ytd';
2981: pay_in_xml_utils.gXMLTable(l_count).Value :=
2982: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employee,0));
2983: l_count := l_count + 1;
2984: pay_in_xml_utils.gXMLTable(l_count).Name := 'diff_ytd';
2985: pay_in_xml_utils.gXMLTable(l_count).Value :=
2986: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employer,0));

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

2982: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employee,0));
2983: l_count := l_count + 1;
2984: pay_in_xml_utils.gXMLTable(l_count).Name := 'diff_ytd';
2985: pay_in_xml_utils.gXMLTable(l_count).Value :=
2986: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employer,0));
2987: l_count := l_count + 1;
2988: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
2989: pay_in_xml_utils.gXMLTable(l_count).Value :=
2990: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pension,0));

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

2986: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_employer,0));
2987: l_count := l_count + 1;
2988: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_ytd';
2989: pay_in_xml_utils.gXMLTable(l_count).Value :=
2990: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(l_org_pension,0));
2991: l_count := l_count + 1;
2992: pay_in_xml_utils.multiColumnar('sum',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
2993:
2994: pay_in_xml_utils.gXMLTable.delete;

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

3046: l_count:=1;
3047: --EPF Contributions Total
3048: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_epf_org_total';
3049: pay_in_xml_utils.gXMLTable(l_count).Value :=
3050: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_epf_total);
3051: l_count := l_count + 1;
3052: --Pension Fund Total
3053: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org_total';
3054: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

3051: l_count := l_count + 1;
3052: --Pension Fund Total
3053: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_org_total';
3054: pay_in_xml_utils.gXMLTable(l_count).Value :=
3055: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_pension_total);
3056: l_count := l_count + 1;
3057: --DLI Contribution Total
3058: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_dli_pf_org_total';
3059: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

3056: l_count := l_count + 1;
3057: --DLI Contribution Total
3058: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_dli_pf_org_total';
3059: pay_in_xml_utils.gXMLTable(l_count).Value :=
3060: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_dli_total);
3061: l_count := l_count + 1;
3062: --Adm.Charges Total
3063: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_admin_pf_total';
3064: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

3061: l_count := l_count + 1;
3062: --Adm.Charges Total
3063: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_admin_pf_total';
3064: pay_in_xml_utils.gXMLTable(l_count).Value :=
3065: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_admn_total);
3066: l_count := l_count + 1;
3067: --EDLI ADm.Charges Total
3068: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_edli_org_total';
3069: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

3066: l_count := l_count + 1;
3067: --EDLI ADm.Charges Total
3068: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_edli_org_total';
3069: pay_in_xml_utils.gXMLTable(l_count).Value :=
3070: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_edli_adm_total);
3071: l_count := l_count + 1;
3072: --Col 5,6,7 Summation Aggregate
3073: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_total_annual';
3074: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

3071: l_count := l_count + 1;
3072: --Col 5,6,7 Summation Aggregate
3073: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_total_annual';
3074: pay_in_xml_utils.gXMLTable(l_count).Value :=
3075: pay_us_employee_payslip_web.get_format_value(l_bg_id,l_summation);
3076: l_count := l_count + 1;
3077: --No of employees in Form 6A
3078: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_emp_no';
3079:

Line 3548: 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));

3544: ,p_effective_end_date
3545: ,p_contribution_period)
3546: LOOP
3547: --PF Salary Annual Value
3548: 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));
3549: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3550: -- Employee Total Contribution
3551: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
3552: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

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

3547: --PF Salary Annual Value
3548: 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));
3549: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3550: -- Employee Total Contribution
3551: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
3552: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3553: -- Employer Total Contribution
3554: 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));
3555: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 3554: 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));

3550: -- Employee Total Contribution
3551: l_tag :=pay_in_xml_utils.getTag('c_epf_ytd',pay_us_employee_payslip_web.get_format_value(l_bg_id,c_sum.employee));
3552: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3553: -- Employer Total Contribution
3554: 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));
3555: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3556: -- Pension
3557: 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));
3558: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 3557: 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));

3553: -- Employer Total Contribution
3554: 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));
3555: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3556: -- Pension
3557: 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));
3558: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3559: --Total Employee Employer Contr
3560: 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));
3561: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);

Line 3560: 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));

3556: -- Pension
3557: 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));
3558: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3559: --Total Employee Employer Contr
3560: 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));
3561: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3562: END LOOP;
3563: pay_in_utils.set_location(g_debug,l_procedure, 110);
3564: --Current Date

Line 4085: 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));

4081: l_count := l_count + 1;
4082:
4083: -- Annual PF Wages
4084: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pf_salary_ytd';
4085: 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));
4086: l_count := l_count + 1;
4087: -- Annual Pension Contr
4088: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund_ytd';
4089: pay_in_xml_utils.gXMLTable(l_count).Value :=

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

4086: l_count := l_count + 1;
4087: -- Annual Pension Contr
4088: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_pension_fund_ytd';
4089: pay_in_xml_utils.gXMLTable(l_count).Value :=
4090: pay_us_employee_payslip_web.get_format_value(l_bg_id,nvl(to_char(l_total_pension),0));
4091: l_count := l_count + 1;
4092:
4093: -- Hire Date
4094: pay_in_xml_utils.gXMLTable(l_count).Name := 'c_hire_date';

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

5033: l_tag :=pay_in_xml_utils.getTag('c_insurance_number',l_insurance_no);
5034: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5035: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5037: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5039: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5041: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);

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

5035: l_tag :=pay_in_xml_utils.getTag('c_full_name',l_full_name);
5036: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5037: l_tag :=pay_in_xml_utils.getTag('c_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_actual_salary));
5038: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5039: l_tag :=pay_in_xml_utils.getTag('c_employee_contr',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_contr));
5040: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5041: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5043: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);

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

5041: l_tag :=pay_in_xml_utils.getTag('c_esi_coverage',l_esi_coverage);
5042: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5043: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5045: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5047: 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));
5048: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5049: l_tag :='';

Line 5047: 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));

5043: l_tag :=pay_in_xml_utils.getTag('c_remarks',l_remarks);
5044: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5045: l_tag :=pay_in_xml_utils.getTag('c_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days));
5046: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5047: 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));
5048: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5049: l_tag :='';
5050: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5051: l_count := l_count + 1;

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

5054: l_days_tot := l_days_tot + nvl(l_days,0);
5055: END IF;
5056: END LOOP;
5057:
5058: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5059: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5060: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5062: 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 5060: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));

5056: END LOOP;
5057:
5058: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5059: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5060: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5062: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5064:

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

5058: l_tag :=pay_in_xml_utils.getTag('c_total_con',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_con_tot));
5059: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5060: l_tag :=pay_in_xml_utils.getTag('c_total_wages',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_wages_tot));
5061: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5062: l_tag :=pay_in_xml_utils.getTag('c_total_days',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_days_tot));
5063: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
5064:
5065: dbms_lob.close(l_xml_data);
5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);

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

5065: dbms_lob.close(l_xml_data);
5066: dbms_lob.createtemporary(l_xml_data,FALSE,DBMS_LOB.CALL);
5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5068: --Employer Share, Employee Share and Total Contribution
5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5072: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5073: 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 5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));

5067: dbms_lob.open(l_xml_data,dbms_lob.lob_readwrite);
5068: --Employer Share, Employee Share and Total Contribution
5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5072: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5073: 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));
5074: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5075: --Challan Details

Line 5073: 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));

5069: l_tag :=pay_in_xml_utils.getTag('c_employer_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employer_total));
5070: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5071: l_tag :=pay_in_xml_utils.getTag('c_employee_share',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_employee_total));
5072: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5073: 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));
5074: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5075: --Challan Details
5076: l_count := 1;
5077: l_challan_tot := 0;

Line 5095: 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));

5091: l_tag :=pay_in_xml_utils.getTag('c_month',c_challan_rec.month);
5092: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5093: l_tag :=pay_in_xml_utils.getTag('c_challan_date',c_challan_rec.challan_date);
5094: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5095: 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));
5096: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5097: l_tag :=pay_in_xml_utils.getTag('c_challan_bank',c_challan_rec.challan_bank);
5098: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5099: l_tag :=pay_in_xml_utils.getTag('c_challan_branch',l_bank_branch_name);

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

5102: l_count := l_count + 1;
5103: l_tag :='';
5104: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5105: END LOOP;
5106: l_tag :=pay_in_xml_utils.getTag('c_challan_total',pay_us_employee_payslip_web.get_format_value(l_bg_id,l_challan_tot));
5107: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5108:
5109:
5110: --Declaration Details

Line 5141: 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));

5137: l_tag := pay_in_xml_utils.getTag('c_accidents_reported',l_accidents_reported);
5138: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5139: l_tag := pay_in_xml_utils.getTag('c_direct_covered_employees',l_direct_covered_employees);
5140: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5141: 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));
5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5143: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5145: 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 5145: 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));

5141: 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));
5142: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5143: l_tag := pay_in_xml_utils.getTag('c_direct_not_covered_employees',l_direct_not_covered_employees);
5144: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5145: 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));
5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5147: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5149: 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 5149: 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));

5145: 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));
5146: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5147: l_tag := pay_in_xml_utils.getTag('c_immediate_employer_covered',l_immediate_employer_covered);
5148: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5149: 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));
5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5151: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5153: 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 5153: 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));

5149: 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));
5150: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5151: l_tag := pay_in_xml_utils.getTag('c_immediate_emplr_not_covered',l_immediate_emplr_not_covered);
5152: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5153: 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));
5154: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5155: l_tag := '';
5156: dbms_lob.writeAppend(l_xml_data, length(l_tag), l_tag);
5157: