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

Line 1388: write_tag('Q1_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr1_tax_deduct_amt));

1384: THEN
1385: l_qtr_start := to_date('01-04-'||to_char(to_number(substr(g_assessment_year, 1,4))-1),'dd-mm-yyyy');
1386: l_qtr_end := to_date('30-06-'||to_char(to_number(substr(g_assessment_year, 1,4))-1),'dd-mm-yyyy');
1387: l_qtr1_tax_deduct_amt := get_qtr_tax_deducted(l_assignment_id,g_org_id,l_qtr_start,l_qtr_end);
1388: write_tag('Q1_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr1_tax_deduct_amt));
1389: ELSIF (i = 2)
1390: THEN
1391: l_qtr_start := to_date('01-07-'||to_char(to_number(substr(g_assessment_year, 1,4))-1),'dd-mm-yyyy');
1392: l_qtr_end := to_date('30-09-'||to_char(to_number(substr(g_assessment_year, 1,4))-1),'dd-mm-yyyy');

Line 1397: write_tag('Q2_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr2_tax_deduct_amt));

1393: l_qtr2_tax_deduct_amt := get_qtr_tax_deducted(l_assignment_id,g_org_id,l_qtr_start,l_qtr_end);
1394: IF l_qtr2_tax_deduct_amt > 0 THEN
1395: l_qtr2_tax_deduct_amt := l_qtr2_tax_deduct_amt - l_qtr1_tax_deduct_amt;
1396: END IF;
1397: write_tag('Q2_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr2_tax_deduct_amt));
1398: ELSIF (i = 3)
1399: THEN
1400: l_qtr_start := to_date('01-10-'||to_char(to_number(substr(g_assessment_year, 1,4))-1),'dd-mm-yyyy');
1401: l_qtr_end := to_date('31-12-'||to_char(to_number(substr(g_assessment_year, 1,4))-1),'dd-mm-yyyy');

Line 1406: write_tag('Q3_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr3_tax_deduct_amt));

1402: l_qtr3_tax_deduct_amt := get_qtr_tax_deducted(l_assignment_id,g_org_id,l_qtr_start,l_qtr_end);
1403: IF l_qtr3_tax_deduct_amt > 0 THEN
1404: l_qtr3_tax_deduct_amt := l_qtr3_tax_deduct_amt - (l_qtr1_tax_deduct_amt + l_qtr2_tax_deduct_amt);
1405: END IF;
1406: write_tag('Q3_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr3_tax_deduct_amt));
1407: ELSE
1408: l_qtr_start := to_date('01-01-'||to_char(to_number(substr(g_assessment_year, 6,4))-1),'dd-mm-yyyy');
1409: l_qtr_end := to_date('31-03-'||to_char(to_number(substr(g_assessment_year, 6,4))-1),'dd-mm-yyyy');
1410: l_qtr4_tax_deduct_amt := get_qtr_tax_deducted(l_assignment_id,g_org_id,l_qtr_start,l_qtr_end);

Line 1414: write_tag('Q4_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr4_tax_deduct_amt));

1410: l_qtr4_tax_deduct_amt := get_qtr_tax_deducted(l_assignment_id,g_org_id,l_qtr_start,l_qtr_end);
1411: IF l_qtr4_tax_deduct_amt > 0 THEN
1412: l_qtr4_tax_deduct_amt := l_qtr4_tax_deduct_amt - (l_qtr1_tax_deduct_amt + l_qtr2_tax_deduct_amt + l_qtr3_tax_deduct_amt);
1413: END IF;
1414: write_tag('Q4_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr4_tax_deduct_amt));
1415: END IF;
1416: END LOOP;
1417:
1418: FOR k in 1..qtr_index

Line 1431: write_tag('Q1_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));

1427: IF (g_qtr_action_id_details(k).Quarter ='Q1')
1428: THEN
1429: write_tag('QR1',g_qtr_action_id_details(k).Nature);
1430: write_tag('Q1_RCPT',g_qtr_action_id_details(k).Receipt);
1431: write_tag('Q1_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));
1432: l_tot_24q_deposited := l_tot_24q_deposited + l_tax_deposited;
1433: ELSIF (g_qtr_action_id_details(k).Quarter ='Q2')
1434: THEN
1435: write_tag('QR2',g_qtr_action_id_details(k).Nature);

Line 1437: write_tag('Q2_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));

1433: ELSIF (g_qtr_action_id_details(k).Quarter ='Q2')
1434: THEN
1435: write_tag('QR2',g_qtr_action_id_details(k).Nature);
1436: write_tag('Q2_RCPT',g_qtr_action_id_details(k).Receipt);
1437: write_tag('Q2_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));
1438: l_tot_24q_deposited := l_tot_24q_deposited + l_tax_deposited;
1439: ELSIF (g_qtr_action_id_details(k).Quarter ='Q3')
1440: THEN
1441: write_tag('QR3',g_qtr_action_id_details(k).Nature);

Line 1443: write_tag('Q3_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));

1439: ELSIF (g_qtr_action_id_details(k).Quarter ='Q3')
1440: THEN
1441: write_tag('QR3',g_qtr_action_id_details(k).Nature);
1442: write_tag('Q3_RCPT',g_qtr_action_id_details(k).Receipt);
1443: write_tag('Q3_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));
1444: l_tot_24q_deposited := l_tot_24q_deposited + l_tax_deposited;
1445: ELSE
1446: write_tag('QR4',g_qtr_action_id_details(k).Nature);
1447: write_tag('Q4_RCPT',g_qtr_action_id_details(k).Receipt);

Line 1448: write_tag('Q4_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));

1444: l_tot_24q_deposited := l_tot_24q_deposited + l_tax_deposited;
1445: ELSE
1446: write_tag('QR4',g_qtr_action_id_details(k).Nature);
1447: write_tag('Q4_RCPT',g_qtr_action_id_details(k).Receipt);
1448: write_tag('Q4_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tax_deposited));
1449: l_tot_24q_deposited := l_tot_24q_deposited + l_tax_deposited;
1450: l_last_quarter := 'Y';
1451: END IF;
1452: ELSE

Line 1462: write_tag('QC1_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));

1458: IF (g_qtr_action_id_details(k).Quarter ='Q1' AND l_24qc_tax_deposited IS NOT NULL)
1459: THEN
1460: write_tag('QC1',g_qtr_action_id_details(k).Nature);
1461: write_tag('QC1_RCPT',g_qtr_action_id_details(k).Receipt);
1462: write_tag('QC1_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));
1463: l_tot_24qc_deposited:=l_tot_24qc_deposited+l_24qc_tax_deposited;
1464: ELSIF (g_qtr_action_id_details(k).Quarter ='Q2' AND l_24qc_tax_deposited IS NOT NULL)
1465: THEN
1466: write_tag('QC2',g_qtr_action_id_details(k).Nature);

Line 1468: write_tag('QC2_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));

1464: ELSIF (g_qtr_action_id_details(k).Quarter ='Q2' AND l_24qc_tax_deposited IS NOT NULL)
1465: THEN
1466: write_tag('QC2',g_qtr_action_id_details(k).Nature);
1467: write_tag('QC2_RCPT',g_qtr_action_id_details(k).Receipt);
1468: write_tag('QC2_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));
1469: l_tot_24qc_deposited := l_tot_24qc_deposited + l_24qc_tax_deposited;
1470: ELSIF (g_qtr_action_id_details(k).Quarter ='Q3' AND l_24qc_tax_deposited IS NOT NULL)
1471: THEN
1472: write_tag('QC3',g_qtr_action_id_details(k).Nature);

Line 1474: write_tag('QC3_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));

1470: ELSIF (g_qtr_action_id_details(k).Quarter ='Q3' AND l_24qc_tax_deposited IS NOT NULL)
1471: THEN
1472: write_tag('QC3',g_qtr_action_id_details(k).Nature);
1473: write_tag('QC3_RCPT',g_qtr_action_id_details(k).Receipt);
1474: write_tag('QC3_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));
1475: l_tot_24qc_deposited:=l_tot_24qc_deposited+l_24qc_tax_deposited;
1476: ELSE
1477: IF l_24qc_tax_deposited IS NOT NULL THEN
1478: write_tag('QC4',g_qtr_action_id_details(k).Nature);

Line 1480: write_tag('QC4_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));

1476: ELSE
1477: IF l_24qc_tax_deposited IS NOT NULL THEN
1478: write_tag('QC4',g_qtr_action_id_details(k).Nature);
1479: write_tag('QC4_RCPT',g_qtr_action_id_details(k).Receipt);
1480: write_tag('QC4_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_24qc_tax_deposited));
1481: l_tot_24qc_deposited := l_tot_24qc_deposited + l_24qc_tax_deposited;
1482: END IF;
1483: END IF;
1484: END IF;

Line 1491: write_tag('Total_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr1_tax_deduct_amt+l_qtr2_tax_deduct_amt+l_qtr3_tax_deduct_amt+l_qtr4_tax_deduct_amt));

1487: THEN
1488: write_tag('QR4','Not Available as the last Quarterly Statement is yet to be furnished');
1489: write_tag('Q4_Tax_Deposited',' Yet to be deposited');
1490: END IF;
1491: write_tag('Total_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr1_tax_deduct_amt+l_qtr2_tax_deduct_amt+l_qtr3_tax_deduct_amt+l_qtr4_tax_deduct_amt));
1492: write_tag('Total_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_24q_deposited+l_tot_24qc_deposited));
1493:
1494: FOR i IN csr_salary_components
1495: LOOP

Line 1492: write_tag('Total_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_24q_deposited+l_tot_24qc_deposited));

1488: write_tag('QR4','Not Available as the last Quarterly Statement is yet to be furnished');
1489: write_tag('Q4_Tax_Deposited',' Yet to be deposited');
1490: END IF;
1491: write_tag('Total_Tax_Deducted',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qtr1_tax_deduct_amt+l_qtr2_tax_deduct_amt+l_qtr3_tax_deduct_amt+l_qtr4_tax_deduct_amt));
1492: write_tag('Total_Tax_Deposited',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_24q_deposited+l_tot_24qc_deposited));
1493:
1494: FOR i IN csr_salary_components
1495: LOOP
1496: IF i.sort_index <> '0' THEN

Line 1531: write_tag(g_salary_record(i).Name,pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(i).Value));

1527: g_salary_record(21).Value := -l_tax_refundable;
1528: END IF;
1529:
1530: FOR i in 1..22 LOOP
1531: write_tag(g_salary_record(i).Name,pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(i).Value));
1532: END LOOP;
1533: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(22).Value));
1534:
1535: -- g_873 := g_868 + g_872;

Line 1533: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(22).Value));

1529:
1530: FOR i in 1..22 LOOP
1531: write_tag(g_salary_record(i).Name,pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(i).Value));
1532: END LOOP;
1533: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(22).Value));
1534:
1535: -- g_873 := g_868 + g_872;
1536: write_tag('TDS_DEDUCTED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,(NVL(g_salary_record(20).Value,0) + NVL(g_salary_record(22).Value,0))));
1537:

Line 1536: write_tag('TDS_DEDUCTED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,(NVL(g_salary_record(20).Value,0) + NVL(g_salary_record(22).Value,0))));

1532: END LOOP;
1533: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(22).Value));
1534:
1535: -- g_873 := g_868 + g_872;
1536: write_tag('TDS_DEDUCTED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,(NVL(g_salary_record(20).Value,0) + NVL(g_salary_record(22).Value,0))));
1537:
1538: write_tag('TAX_ON_TOT_INCOME',pay_us_employee_payslip_web.get_format_value(g_business_group_id,(NVL(g_salary_record(14).Value,0) + NVL(g_salary_record(15).Value,0) + NVL(g_salary_record(16).Value,0) - l_marginal_relief)));
1539:
1540: OPEN csr_other_components('Previous Employment Earnings');

Line 1538: write_tag('TAX_ON_TOT_INCOME',pay_us_employee_payslip_web.get_format_value(g_business_group_id,(NVL(g_salary_record(14).Value,0) + NVL(g_salary_record(15).Value,0) + NVL(g_salary_record(16).Value,0) - l_marginal_relief)));

1534:
1535: -- g_873 := g_868 + g_872;
1536: write_tag('TDS_DEDUCTED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,(NVL(g_salary_record(20).Value,0) + NVL(g_salary_record(22).Value,0))));
1537:
1538: write_tag('TAX_ON_TOT_INCOME',pay_us_employee_payslip_web.get_format_value(g_business_group_id,(NVL(g_salary_record(14).Value,0) + NVL(g_salary_record(15).Value,0) + NVL(g_salary_record(16).Value,0) - l_marginal_relief)));
1539:
1540: OPEN csr_other_components('Previous Employment Earnings');
1541: FETCH csr_other_components INTO l_prev_earnings;
1542: IF csr_other_components%NOTFOUND THEN

Line 1595: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));

1591: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1592:
1593: write_tag('RN',l_80c_tag_seq);
1594: write_tag('NAME',i.Description_Value);
1595: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1596: l_via_seq_80c_num := l_via_seq_80c_num + 1;
1597: l_tot_80c_gross := l_tot_80c_gross + nvl(i.Gross_Value,0);
1598: l_tot_80c_qual := l_tot_80c_qual + nvl(i.Qualifying_Value,0);
1599: l_open_tag := '';

Line 1606: write_tag('TOT_80C_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));

1602: END LOOP;
1603:
1604: l_tot_80c_qual := LEAST(l_tot_80c_qual,g_80cce_limit);
1605:
1606: write_tag('TOT_80C_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1607: write_tag('TOT_80C_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1608:
1609: FOR i in csr_deduction_via_d_to_u LOOP
1610: IF(l_flag_rep_gen = -1) THEN

Line 1607: write_tag('TOT_80C_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));

1603:
1604: l_tot_80c_qual := LEAST(l_tot_80c_qual,g_80cce_limit);
1605:
1606: write_tag('TOT_80C_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1607: write_tag('TOT_80C_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1608:
1609: FOR i in csr_deduction_via_d_to_u LOOP
1610: IF(l_flag_rep_gen = -1) THEN
1611: l_flag_rep_gen := 1;

Line 1634: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));

1630:
1631: l_qualifying_amt := nvl(i.Qualifying_Value,0);
1632: write_tag('SN',l_80du_tag_seq);
1633: write_tag('NAME',i.Description_Value);
1634: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1635: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1636:
1637: l_open_tag := '';
1638: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

Line 1635: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));

1631: l_qualifying_amt := nvl(i.Qualifying_Value,0);
1632: write_tag('SN',l_80du_tag_seq);
1633: write_tag('NAME',i.Description_Value);
1634: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1635: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1636:
1637: l_open_tag := '';
1638: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1639: l_via_seq_80d_u_num := l_via_seq_80d_u_num +1;

Line 1650: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));

1646: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1647:
1648: write_tag('AS',l_80cce_tag_seq);
1649:
1650: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1651: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1652:
1653: l_via_seq_80cce_num := l_via_seq_80cce_num + 1;
1654:

Line 1651: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));

1647:
1648: write_tag('AS',l_80cce_tag_seq);
1649:
1650: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1651: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1652:
1653: l_via_seq_80cce_num := l_via_seq_80cce_num + 1;
1654:
1655: l_open_tag := '';

Line 1668: write_tag('VIACCE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));

1664: l_tot_80ccc_gross := l_tot_80ccc_gross + l_tot_80c_gross;
1665: l_tot_80ccc_qual := l_tot_80ccc_qual + l_tot_80c_qual;
1666:
1667: IF (l_via_cce_flag <> 1 ) THEN
1668: write_tag('VIACCE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1669: END IF;
1670: write_tag('SEC80CCE',l_via_cce_flag);
1671: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1672: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));

Line 1671: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));

1667: IF (l_via_cce_flag <> 1 ) THEN
1668: write_tag('VIACCE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1669: END IF;
1670: write_tag('SEC80CCE',l_via_cce_flag);
1671: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1672: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));
1673:
1674: IF (l_via_oth_flag <> 1)THEN
1675: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));

Line 1672: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));

1668: write_tag('VIACCE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1669: END IF;
1670: write_tag('SEC80CCE',l_via_cce_flag);
1671: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1672: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));
1673:
1674: IF (l_via_oth_flag <> 1)THEN
1675: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1676: END IF;

Line 1675: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));

1671: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1672: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));
1673:
1674: IF (l_via_oth_flag <> 1)THEN
1675: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1676: END IF;
1677:
1678: write_tag('TOTAL_V1A',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_total_via));
1679: /* Chapter VIA End */

Line 1678: write_tag('TOTAL_V1A',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_total_via));

1674: IF (l_via_oth_flag <> 1)THEN
1675: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1676: END IF;
1677:
1678: write_tag('TOTAL_V1A',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_total_via));
1679: /* Chapter VIA End */
1680:
1681:
1682: /* Check for Form Generation and Other Income Start*/

Line 1733: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(1)));

1729: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1730:
1731: IF (i=1 )THEN
1732: write_tag('NAME','Business and Profession Gains');
1733: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(1)));
1734: ELSIF (i=2 ) THEN
1735: write_tag('NAME','Long Term Capital Gains');
1736: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(2)));
1737: ELSIF (i=3) THEN

Line 1736: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(2)));

1732: write_tag('NAME','Business and Profession Gains');
1733: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(1)));
1734: ELSIF (i=2 ) THEN
1735: write_tag('NAME','Long Term Capital Gains');
1736: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(2)));
1737: ELSIF (i=3) THEN
1738: write_tag('NAME','Short Term Capital Gains');
1739: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(3)));
1740: ELSIF (i=4) THEN

Line 1739: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(3)));

1735: write_tag('NAME','Long Term Capital Gains');
1736: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(2)));
1737: ELSIF (i=3) THEN
1738: write_tag('NAME','Short Term Capital Gains');
1739: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(3)));
1740: ELSIF (i=4) THEN
1741: write_tag('NAME','Other Sources of Income');
1742: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(4)));
1743: ELSIF (i=5) THEN

Line 1742: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(4)));

1738: write_tag('NAME','Short Term Capital Gains');
1739: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(3)));
1740: ELSIF (i=4) THEN
1741: write_tag('NAME','Other Sources of Income');
1742: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(4)));
1743: ELSIF (i=5) THEN
1744: write_tag('NAME','Loss From House Property');
1745: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0-t_table_1(5)));
1746: END IF;

Line 1745: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0-t_table_1(5)));

1741: write_tag('NAME','Other Sources of Income');
1742: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(4)));
1743: ELSIF (i=5) THEN
1744: write_tag('NAME','Loss From House Property');
1745: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0-t_table_1(5)));
1746: END IF;
1747:
1748:
1749: l_open_tag := '';

Line 1759: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));

1755:
1756: l_open_tag := '';
1757: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1758: write_tag('SECTION','(h) 80C');
1759: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1760: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1761: l_open_tag := '';
1762: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1763:

Line 1760: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));

1756: l_open_tag := '';
1757: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1758: write_tag('SECTION','(h) 80C');
1759: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1760: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1761: l_open_tag := '';
1762: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1763:
1764: l_count :=0;

Line 1770: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));

1766: FOR rec_deduction_via_d_to_u IN csr_deduction_via_d_to_u
1767: LOOP
1768: IF (rec_deduction_via_d_to_u.Description_Value NOT IN ('TOTAL_V1A','X')) THEN
1769: IF rec_deduction_via_d_to_u.Description_Value = '80CCC' THEN
1770: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1771: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1772: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1773: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1774: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

Line 1771: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1767: LOOP
1768: IF (rec_deduction_via_d_to_u.Description_Value NOT IN ('TOTAL_V1A','X')) THEN
1769: IF rec_deduction_via_d_to_u.Description_Value = '80CCC' THEN
1770: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1771: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1772: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1773: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1774: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1775: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN

Line 1773: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));

1769: IF rec_deduction_via_d_to_u.Description_Value = '80CCC' THEN
1770: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1771: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1772: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1773: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1774: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1775: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1776: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1777: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

Line 1774: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1770: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1771: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1772: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1773: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1774: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1775: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1776: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1777: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1778: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN

Line 1776: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));

1772: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1773: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1774: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1775: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1776: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1777: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1778: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1779: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1780: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

Line 1777: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1773: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1774: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1775: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1776: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1777: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1778: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1779: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1780: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1781: ELSE

Line 1779: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));

1775: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1776: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1777: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1778: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1779: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1780: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1781: ELSE
1782:
1783:

Line 1780: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1776: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1777: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1778: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1779: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1780: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1781: ELSE
1782:
1783:
1784: l_count := l_count + 1;

Line 1796: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));

1792:
1793: l_open_tag := '';
1794: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1795: write_tag('SECTION','('||l_seq||') '||rec_deduction_via_d_to_u.Description_Value);
1796: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1797: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1798: l_open_tag := '';
1799: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1800: END IF ;

Line 1797: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1793: l_open_tag := '';
1794: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1795: write_tag('SECTION','('||l_seq||') '||rec_deduction_via_d_to_u.Description_Value);
1796: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1797: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1798: l_open_tag := '';
1799: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1800: END IF ;
1801: END IF ;

Line 1819: write_tag('OI_HOUSE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_loss_from_house));

1815:
1816: END IF;
1817: END LOOP;
1818:
1819: write_tag('OI_HOUSE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_loss_from_house));
1820: write_tag('OI_OTHER',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_other_income));
1821:
1822: END IF ;
1823:

Line 1820: write_tag('OI_OTHER',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_other_income));

1816: END IF;
1817: END LOOP;
1818:
1819: write_tag('OI_HOUSE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_loss_from_house));
1820: write_tag('OI_OTHER',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_other_income));
1821:
1822: END IF ;
1823:
1824: t_table_1.DELETE;

Line 1834: write_tag('EE_INCOME',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(10).Value - g_salary_record(2).Value));

1830: ) THEN
1831: l_flag_for_12ba :=1; --Eligible for 12BA
1832: END IF;
1833:
1834: write_tag('EE_INCOME',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(10).Value - g_salary_record(2).Value));
1835: write_tag('C_16AA_FLAG',p_flag_for_16aa );
1836: write_tag('C_12BA_FLAG',l_flag_for_12ba );
1837:
1838: l_tax_in_words := pay_in_utils.number_to_words(g_salary_record(20).Value);

Line 1874: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_Non_Taxable_Amt));

1870: l_open_tag := '';
1871: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1872:
1873: write_tag('NAME',i.Allowance_Name);
1874: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_Non_Taxable_Amt));
1875:
1876: l_open_tag := '';
1877: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1878:

Line 1949: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds+l_emp_sur+l_emp_cess));

1945: dbms_lob.writeAppend(g_tmp_clob,LENGTH(l_open_tag),l_open_tag);
1946: write_tag('SNO',l_serial_number);
1947: l_serial_number := l_serial_number + 1;
1948: IF (g_tax_start_date >= TO_DATE('01/04/2009','DD/MM/YYYY')) THEN
1949: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds+l_emp_sur+l_emp_cess));
1950: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1951: ELSE
1952: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1953: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));

Line 1950: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));

1946: write_tag('SNO',l_serial_number);
1947: l_serial_number := l_serial_number + 1;
1948: IF (g_tax_start_date >= TO_DATE('01/04/2009','DD/MM/YYYY')) THEN
1949: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds+l_emp_sur+l_emp_cess));
1950: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1951: ELSE
1952: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1953: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1954: END IF ;

Line 1952: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));

1948: IF (g_tax_start_date >= TO_DATE('01/04/2009','DD/MM/YYYY')) THEN
1949: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds+l_emp_sur+l_emp_cess));
1950: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1951: ELSE
1952: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1953: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1954: END IF ;
1955: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1956: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));

Line 1953: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));

1949: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds+l_emp_sur+l_emp_cess));
1950: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1951: ELSE
1952: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1953: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1954: END IF ;
1955: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1956: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));
1957: write_tag('PYMT_DATE',to_char(g_Bank_Details_tbl(i).VDate,'DD/MM/RRRR'));

Line 1955: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));

1951: ELSE
1952: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1953: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1954: END IF ;
1955: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1956: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));
1957: write_tag('PYMT_DATE',to_char(g_Bank_Details_tbl(i).VDate,'DD/MM/RRRR'));
1958: write_tag('BANK_BRANCH',g_Bank_Details_tbl(i).Bank);
1959: write_tag('VOUCHER_NUM',g_Bank_Details_tbl(i).VNumber);

Line 1956: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));

1952: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1953: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1954: END IF ;
1955: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1956: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));
1957: write_tag('PYMT_DATE',to_char(g_Bank_Details_tbl(i).VDate,'DD/MM/RRRR'));
1958: write_tag('BANK_BRANCH',g_Bank_Details_tbl(i).Bank);
1959: write_tag('VOUCHER_NUM',g_Bank_Details_tbl(i).VNumber);
1960: write_tag('CHEQUE_DD_NUMBER',g_Bank_Details_tbl(i).DDCheque_Num);

Line 1968: write_tag('TDS_TOTAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tds_total));

1964: l_tds_total := l_tds_total + l_emp_tds + l_emp_cess;
1965: END IF;
1966:
1967: END LOOP;
1968: write_tag('TDS_TOTAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tds_total));
1969:
1970: END IF;
1971: /* Challan End */
1972: IF g_debug THEN

Line 2100: , p_tag_value => pay_us_employee_payslip_web.get_format_value

2096: FOR i in 1..18
2097: LOOP
2098:
2099: write_tag( p_tag_name => 'P' || i || '_V3'
2100: , p_tag_value => pay_us_employee_payslip_web.get_format_value
2101: ( g_business_group_id
2102: , g_perq_record(i).perq_value1
2103: )
2104: );

Line 2106: , p_tag_value => pay_us_employee_payslip_web.get_format_value

2102: , g_perq_record(i).perq_value1
2103: )
2104: );
2105: write_tag( p_tag_name => 'P' || i || '_V2'
2106: , p_tag_value => pay_us_employee_payslip_web.get_format_value
2107: ( g_business_group_id
2108: , g_perq_record(i).perq_value2
2109: )
2110: );

Line 2112: , p_tag_value => pay_us_employee_payslip_web.get_format_value

2108: , g_perq_record(i).perq_value2
2109: )
2110: );
2111: write_tag( p_tag_name => 'P' || i || '_V1'
2112: , p_tag_value => pay_us_employee_payslip_web.get_format_value
2113: ( g_business_group_id
2114: , g_perq_record(i).perq_value1 + g_perq_record(i).perq_value2
2115: )
2116: );

Line 2480: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));

2476: ELSE
2477: write_tag('REPORT_DATE_TIME',TO_CHAR(TO_DATE(sysdate,'DD-MM-RRRR HH24:MI:SS'),'DD-Mon-YYYY HH24:MI:SS'));
2478: END IF;
2479:
2480: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
2481: /* The following call gets the GRE Related Data to generate the report*/
2482: l_open_tag := '';
2483: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2484: