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 1271: write_tag(g_salary_record(i).Name,pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(i).Value));

1267: g_salary_record(21).Value := -l_tax_refundable;
1268: END IF;
1269:
1270: FOR i in 1..22 LOOP
1271: write_tag(g_salary_record(i).Name,pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(i).Value));
1272: END LOOP;
1273: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(22).Value));
1274:
1275: -- g_873 := g_868 + g_872;

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

1269:
1270: FOR i in 1..22 LOOP
1271: write_tag(g_salary_record(i).Name,pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(i).Value));
1272: END LOOP;
1273: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(22).Value));
1274:
1275: -- g_873 := g_868 + g_872;
1276: 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))));
1277:

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

1272: END LOOP;
1273: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,g_salary_record(22).Value));
1274:
1275: -- g_873 := g_868 + g_872;
1276: 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))));
1277:
1278: 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)));
1279:
1280: OPEN csr_other_components('Previous Employment Earnings');

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

1274:
1275: -- g_873 := g_868 + g_872;
1276: 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))));
1277:
1278: 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)));
1279:
1280: OPEN csr_other_components('Previous Employment Earnings');
1281: FETCH csr_other_components INTO l_prev_earnings;
1282: IF csr_other_components%NOTFOUND THEN

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

1331: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1332:
1333: write_tag('RN',l_80c_tag_seq);
1334: write_tag('NAME',i.Description_Value);
1335: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1336: l_via_seq_80c_num := l_via_seq_80c_num + 1;
1337: l_tot_80c_gross := l_tot_80c_gross + nvl(i.Gross_Value,0);
1338: l_tot_80c_qual := l_tot_80c_qual + nvl(i.Qualifying_Value,0);
1339: l_open_tag := '';

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

1342: END LOOP;
1343:
1344: l_tot_80c_qual := LEAST(l_tot_80c_qual,g_80cce_limit);
1345:
1346: write_tag('TOT_80C_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1347: write_tag('TOT_80C_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1348:
1349: FOR i in csr_deduction_via_d_to_u LOOP
1350: IF(l_flag_rep_gen = -1) THEN

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

1343:
1344: l_tot_80c_qual := LEAST(l_tot_80c_qual,g_80cce_limit);
1345:
1346: write_tag('TOT_80C_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1347: write_tag('TOT_80C_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1348:
1349: FOR i in csr_deduction_via_d_to_u LOOP
1350: IF(l_flag_rep_gen = -1) THEN
1351: l_flag_rep_gen := 1;

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

1369:
1370: l_qualifying_amt := nvl(i.Qualifying_Value,0);
1371: write_tag('SN',l_80du_tag_seq);
1372: write_tag('NAME',i.Description_Value);
1373: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1374: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1375:
1376: l_open_tag := '';
1377: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

1370: l_qualifying_amt := nvl(i.Qualifying_Value,0);
1371: write_tag('SN',l_80du_tag_seq);
1372: write_tag('NAME',i.Description_Value);
1373: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1374: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1375:
1376: l_open_tag := '';
1377: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1378: l_via_seq_80d_u_num := l_via_seq_80d_u_num +1;

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

1385: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1386:
1387: write_tag('AS',l_80cce_tag_seq);
1388:
1389: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1390: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1391:
1392: l_via_seq_80cce_num := l_via_seq_80cce_num + 1;
1393:

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

1386:
1387: write_tag('AS',l_80cce_tag_seq);
1388:
1389: write_tag('GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,nvl(i.Gross_Value,0)));
1390: write_tag('QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_qualifying_amt));
1391:
1392: l_via_seq_80cce_num := l_via_seq_80cce_num + 1;
1393:
1394: l_open_tag := '';

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

1403: l_tot_80ccc_gross := l_tot_80ccc_gross + l_tot_80c_gross;
1404: l_tot_80ccc_qual := l_tot_80ccc_qual + l_tot_80c_qual;
1405:
1406: IF (l_via_cce_flag <> 1 ) THEN
1407: write_tag('VIACCE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1408: END IF;
1409: write_tag('SEC80CCE',l_via_cce_flag);
1410: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1411: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));

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

1406: IF (l_via_cce_flag <> 1 ) THEN
1407: write_tag('VIACCE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1408: END IF;
1409: write_tag('SEC80CCE',l_via_cce_flag);
1410: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1411: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));
1412:
1413: IF (l_via_oth_flag <> 1)THEN
1414: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));

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

1407: write_tag('VIACCE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1408: END IF;
1409: write_tag('SEC80CCE',l_via_cce_flag);
1410: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1411: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));
1412:
1413: IF (l_via_oth_flag <> 1)THEN
1414: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1415: END IF;

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

1410: write_tag('TOT_80CCC_GR',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_gross));
1411: write_tag('TOT_80CCC_QA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80ccc_qual));
1412:
1413: IF (l_via_oth_flag <> 1)THEN
1414: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1415: END IF;
1416:
1417: write_tag('TOTAL_V1A',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_total_via));
1418: /* Chapter VIA End */

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

1413: IF (l_via_oth_flag <> 1)THEN
1414: write_tag('VIAOTH',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
1415: END IF;
1416:
1417: write_tag('TOTAL_V1A',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_total_via));
1418: /* Chapter VIA End */
1419:
1420:
1421: /* Check for Form Generation and Other Income Start*/

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

1468: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1469:
1470: IF (i=1 )THEN
1471: write_tag('NAME','Business and Profession Gains');
1472: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(1)));
1473: ELSIF (i=2 ) THEN
1474: write_tag('NAME','Long Term Capital Gains');
1475: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(2)));
1476: ELSIF (i=3) THEN

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

1471: write_tag('NAME','Business and Profession Gains');
1472: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(1)));
1473: ELSIF (i=2 ) THEN
1474: write_tag('NAME','Long Term Capital Gains');
1475: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(2)));
1476: ELSIF (i=3) THEN
1477: write_tag('NAME','Short Term Capital Gains');
1478: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(3)));
1479: ELSIF (i=4) THEN

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

1474: write_tag('NAME','Long Term Capital Gains');
1475: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(2)));
1476: ELSIF (i=3) THEN
1477: write_tag('NAME','Short Term Capital Gains');
1478: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(3)));
1479: ELSIF (i=4) THEN
1480: write_tag('NAME','Other Sources of Income');
1481: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(4)));
1482: ELSIF (i=5) THEN

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

1477: write_tag('NAME','Short Term Capital Gains');
1478: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(3)));
1479: ELSIF (i=4) THEN
1480: write_tag('NAME','Other Sources of Income');
1481: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(4)));
1482: ELSIF (i=5) THEN
1483: write_tag('NAME','Loss From House Property');
1484: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0-t_table_1(5)));
1485: END IF;

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

1480: write_tag('NAME','Other Sources of Income');
1481: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,t_table_1(4)));
1482: ELSIF (i=5) THEN
1483: write_tag('NAME','Loss From House Property');
1484: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0-t_table_1(5)));
1485: END IF;
1486:
1487:
1488: l_open_tag := '';

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

1494:
1495: l_open_tag := '';
1496: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1497: write_tag('SECTION','(h) 80C');
1498: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1499: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1500: l_open_tag := '';
1501: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1502:

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

1495: l_open_tag := '';
1496: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1497: write_tag('SECTION','(h) 80C');
1498: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_gross));
1499: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_tot_80c_qual));
1500: l_open_tag := '';
1501: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1502:
1503: l_count :=0;

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

1505: FOR rec_deduction_via_d_to_u IN csr_deduction_via_d_to_u
1506: LOOP
1507: IF (rec_deduction_via_d_to_u.Description_Value NOT IN ('TOTAL_V1A','X')) THEN
1508: IF rec_deduction_via_d_to_u.Description_Value = '80CCC' THEN
1509: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1510: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1511: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1512: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1513: 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 1510: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1506: LOOP
1507: IF (rec_deduction_via_d_to_u.Description_Value NOT IN ('TOTAL_V1A','X')) THEN
1508: IF rec_deduction_via_d_to_u.Description_Value = '80CCC' THEN
1509: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1510: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1511: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1512: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1513: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1514: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN

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

1508: IF rec_deduction_via_d_to_u.Description_Value = '80CCC' THEN
1509: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1510: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1511: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1512: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1513: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1514: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1515: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1516: 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 1513: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1509: write_tag('SEC80CCC',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1510: write_tag('SEC80CCC_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1511: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1512: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1513: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1514: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1515: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1516: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1517: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN

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

1511: ELSIF rec_deduction_via_d_to_u.Description_Value = '80D' THEN
1512: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1513: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1514: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1515: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1516: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1517: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1518: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1519: 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 1516: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));

1512: write_tag('SEC80D',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1513: write_tag('SEC80D_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1514: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1515: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1516: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1517: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1518: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1519: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1520: ELSE

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

1514: ELSIF rec_deduction_via_d_to_u.Description_Value = '80E' THEN
1515: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1516: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1517: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1518: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1519: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1520: ELSE
1521:
1522:

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

1515: write_tag('SEC80E',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1516: write_tag('SEC80E_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1517: ELSIF rec_deduction_via_d_to_u.Description_Value = '80G' THEN
1518: write_tag('SEC80G',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1519: write_tag('SEC80G_QAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1520: ELSE
1521:
1522:
1523: l_count := l_count + 1;

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

1531:
1532: l_open_tag := '';
1533: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1534: write_tag('SECTION','('||l_seq||') '||rec_deduction_via_d_to_u.Description_Value);
1535: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1536: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1537: l_open_tag := '';
1538: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1539: END IF ;

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

1532: l_open_tag := '';
1533: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1534: write_tag('SECTION','('||l_seq||') '||rec_deduction_via_d_to_u.Description_Value);
1535: write_tag('SEC_GROSS',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Gross_Value));
1536: write_tag('SEC_QUAL',pay_us_employee_payslip_web.get_format_value(g_business_group_id,rec_deduction_via_d_to_u.Qualifying_Value));
1537: l_open_tag := '';
1538: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1539: END IF ;
1540: END IF ;

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

1554:
1555: END IF;
1556: END LOOP;
1557:
1558: write_tag('OI_HOUSE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_loss_from_house));
1559: write_tag('OI_OTHER',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_other_income));
1560:
1561: END IF ;
1562:

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

1555: END IF;
1556: END LOOP;
1557:
1558: write_tag('OI_HOUSE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_loss_from_house));
1559: write_tag('OI_OTHER',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_other_income));
1560:
1561: END IF ;
1562:
1563: t_table_1.DELETE;

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

1569: ) THEN
1570: l_flag_for_12ba :=1; --Eligible for 12BA
1571: END IF;
1572:
1573: 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));
1574: write_tag('C_16AA_FLAG',p_flag_for_16aa );
1575: write_tag('C_12BA_FLAG',l_flag_for_12ba );
1576:
1577: l_tax_in_words := pay_in_utils.number_to_words(g_salary_record(20).Value);

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

1590: l_open_tag := '';
1591: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1592:
1593: write_tag('NAME',i.Allowance_Name);
1594: write_tag('VALUE',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_Non_Taxable_Amt));
1595:
1596: l_open_tag := '';
1597: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1598:

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

1658: l_open_tag := '';
1659: dbms_lob.writeAppend(g_tmp_clob,LENGTH(l_open_tag),l_open_tag);
1660: write_tag('SNO',l_serial_number);
1661: l_serial_number := l_serial_number + 1;
1662: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1663: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1664: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1665: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));
1666: write_tag('PYMT_DATE',g_Bank_Details_tbl(i).VDate);

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

1659: dbms_lob.writeAppend(g_tmp_clob,LENGTH(l_open_tag),l_open_tag);
1660: write_tag('SNO',l_serial_number);
1661: l_serial_number := l_serial_number + 1;
1662: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1663: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1664: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1665: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));
1666: write_tag('PYMT_DATE',g_Bank_Details_tbl(i).VDate);
1667: write_tag('BANK_BRANCH',g_Bank_Details_tbl(i).Bank);

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

1660: write_tag('SNO',l_serial_number);
1661: l_serial_number := l_serial_number + 1;
1662: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1663: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1664: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1665: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));
1666: write_tag('PYMT_DATE',g_Bank_Details_tbl(i).VDate);
1667: write_tag('BANK_BRANCH',g_Bank_Details_tbl(i).Bank);
1668: write_tag('VOUCHER_NUM',g_Bank_Details_tbl(i).VNumber);

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

1661: l_serial_number := l_serial_number + 1;
1662: write_tag('TDS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_tds));
1663: write_tag('SURCHARGE_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_sur));
1664: write_tag('ECESS_PERIOD',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_cess));
1665: write_tag('TAX_DEPOSITED',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount));
1666: write_tag('PYMT_DATE',g_Bank_Details_tbl(i).VDate);
1667: write_tag('BANK_BRANCH',g_Bank_Details_tbl(i).Bank);
1668: write_tag('VOUCHER_NUM',g_Bank_Details_tbl(i).VNumber);
1669: write_tag('CHEQUE_DD_NUMBER',g_Bank_Details_tbl(i).DDCheque_Num);

Line 1711: write_tag('TDS_PERIOD_AA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount_16aa));

1707:
1708: IF l_entry_exists_16aa = 1 THEN
1709: l_open_tag := '';
1710: dbms_lob.writeAppend(g_tmp_clob,LENGTH(l_open_tag),l_open_tag);
1711: write_tag('TDS_PERIOD_AA',pay_us_employee_payslip_web.get_format_value(g_business_group_id,l_emp_amount_16aa));
1712: write_tag('PYMT_DATE_AA',g_Bank_Details_tbl_16aa(i).VDate);
1713: write_tag('BANK_BRANCH_AA',g_Bank_Details_tbl_16aa(i).Bank);
1714: l_open_tag := '';
1715: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

Line 1853: , p_tag_value => pay_us_employee_payslip_web.get_format_value

1849: FOR i in 1..18
1850: LOOP
1851:
1852: write_tag( p_tag_name => 'P' || i || '_V3'
1853: , p_tag_value => pay_us_employee_payslip_web.get_format_value
1854: ( g_business_group_id
1855: , g_perq_record(i).perq_value1
1856: )
1857: );

Line 1859: , p_tag_value => pay_us_employee_payslip_web.get_format_value

1855: , g_perq_record(i).perq_value1
1856: )
1857: );
1858: write_tag( p_tag_name => 'P' || i || '_V2'
1859: , p_tag_value => pay_us_employee_payslip_web.get_format_value
1860: ( g_business_group_id
1861: , g_perq_record(i).perq_value2
1862: )
1863: );

Line 1865: , p_tag_value => pay_us_employee_payslip_web.get_format_value

1861: , g_perq_record(i).perq_value2
1862: )
1863: );
1864: write_tag( p_tag_name => 'P' || i || '_V1'
1865: , p_tag_value => pay_us_employee_payslip_web.get_format_value
1866: ( g_business_group_id
1867: , g_perq_record(i).perq_value1 + g_perq_record(i).perq_value2
1868: )
1869: );

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

2155: write_tag('REPORT_DATE',TO_CHAR(TRUNC(SYSDATE),'DD-MM-YYYY'));
2156: write_tag('ASSESS_YR',SUBSTR(g_assessment_year,1,5) || SUBSTR(g_assessment_year,8,2));
2157: write_tag('FIN_YEAR',g_tax_year);
2158: write_tag('REPORT_DATE_TIME',to_char(SYSDATE,'DD-Mon-YYYY HH24:MI:SS'));
2159: -- write_tag('DUMMY',pay_us_employee_payslip_web.get_format_value(g_business_group_id,0));
2160: /* The following call gets the GRE Related Data to generate the report*/
2161: l_open_tag := '';
2162: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2163: