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 DBMS_LOB

Line 483: dbms_lob.writeAppend(g_tmp_clob,length(l_tag),l_tag);

479: l_tag := pay_in_xml_utils.getTag( p_tag_name => p_tag_name
480: , p_tag_value => p_tag_value
481: );
482:
483: dbms_lob.writeAppend(g_tmp_clob,length(l_tag),l_tag);
484: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
485: END write_tag;
486:
487: --------------------------------------------------------------------------

Line 668: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

664: l_last_quarter :='N';
665: FOR i in csr_form24q_receipt
666: LOOP
667: l_open_tag := '';
668: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
669:
670: write_tag('QR',i.Quarter||i.Nature);
671: write_tag('RCPT',i.Receipt);
672: IF i.Quarter = 'Q4' THEN

Line 676: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

672: IF i.Quarter = 'Q4' THEN
673: l_last_quarter := 'Y';
674: END IF;
675: l_open_tag := '';
676: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
677: END LOOP;
678:
679: IF (l_last_quarter = 'N' AND SYSDATE >= g_tax_end_date ) THEN
680:

Line 682: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

678:
679: IF (l_last_quarter = 'N' AND SYSDATE >= g_tax_end_date ) THEN
680:
681: l_open_tag := '';
682: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
683:
684: write_tag('QR','Q4');
685: write_tag('RCPT','Not Available as the last Quarterly Statement is yet to be furnished');
686: l_open_tag := '';

Line 687: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

683:
684: write_tag('QR','Q4');
685: write_tag('RCPT','Not Available as the last Quarterly Statement is yet to be furnished');
686: l_open_tag := '';
687: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
688:
689:
690: END IF;
691:

Line 1331: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1327: IF(i.Description_Value <> 'X')THEN
1328: l_80c_tag_seq := ltrim(lower(to_char(l_via_seq_80c_num,'RM')),' ' )||')';
1329:
1330: l_open_tag := '';
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)));

Line 1340: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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 := '';
1340: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1341: END IF;
1342: END LOOP;
1343:
1344: l_tot_80c_qual := LEAST(l_tot_80c_qual,g_80cce_limit);

Line 1368: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1364: '80U') THEN
1365: l_via_oth_flag := 1;
1366: l_80du_tag_seq := '('||fnd_global.local_chr(l_via_seq_80d_u_num)||')';
1367: l_open_tag := '';
1368: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
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);

Line 1377: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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;
1379: ELSIF i.Description_Value IN('80CCC','80CCD') THEN
1380: l_via_cce_flag := 1;
1381: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';

Line 1385: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1381: l_80cce_tag_seq := '('||fnd_global.local_chr(l_via_seq_80cce_num)||')';
1382: l_qualifying_amt := LEAST(g_80cce_limit,nvl(i.Qualifying_Value,0));
1383: l_tag := substr(i.Description_Value,3);
1384: l_open_tag := '<'||l_tag||'GRP>';
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)));

Line 1395: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1391:
1392: l_via_seq_80cce_num := l_via_seq_80cce_num + 1;
1393:
1394: l_open_tag := '';
1395: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1396: l_tot_80ccc_gross := l_tot_80ccc_gross + nvl(i.Gross_Value,0);
1397: l_tot_80ccc_qual := l_tot_80ccc_qual + l_qualifying_amt;
1398: ELSE
1399: NULL;

Line 1450: dbms_lob.TRIM(g_tmp_clob,emp_pos-1);

1446: IF l_flag_rep_gen = -1 THEN
1447: /* Do not generate any report for this employee */
1448: p_flag_for_16aa := -1;
1449: emp_pos := INSTR(g_tmp_clob,'',-1);
1450: dbms_lob.TRIM(g_tmp_clob,emp_pos-1);
1451: ELSE
1452: /* Generate either 16 /16AA for this employee */
1453: p_flag_for_16aa := 1;
1454:

Line 1468: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1464:
1465: FOR i IN 1..5 LOOP
1466: IF(t_table_1(i) <>0) THEN
1467: l_open_tag := '';
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)));

Line 1489: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1485: END IF;
1486:
1487:
1488: l_open_tag := '';
1489: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1490: END IF;
1491: END LOOP;
1492:
1493: IF p_flag_for_16aa = 1 THEN

Line 1496: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1492:
1493: IF p_flag_for_16aa = 1 THEN
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 := '';

Line 1501: 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;
1504:
1505: FOR rec_deduction_via_d_to_u IN csr_deduction_via_d_to_u

Line 1533: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1529: CONNECT BY LEVEL <= 26 )
1530: WHERE r+64 = 72 + l_count;
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 := '';

Line 1538: 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 ;
1541: END LOOP ;
1542:

Line 1591: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

1587: END IF;
1588: --
1589: IF( l_Non_Taxable_Amt > 0) THEN
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:

Line 1597: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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:
1599: END IF;
1600: --
1601: END LOOP;

Line 1659: dbms_lob.writeAppend(g_tmp_clob,LENGTH(l_open_tag),l_open_tag);

1655: END LOOP;
1656:
1657: IF l_entry_exists = 1 THEN
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));

Line 1671: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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);
1670: l_open_tag := '';
1671: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1672: END IF;
1673:
1674: END IF;
1675:

Line 1710: dbms_lob.writeAppend(g_tmp_clob,LENGTH(l_open_tag),l_open_tag);

1706: END LOOP;
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 := '';

Line 1715: 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);
1716: END IF;
1717:
1718: END IF;
1719:

Line 2113: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2109: l_gre_id := gre_record.orgid;
2110: /* Close and reopen tag for GRE */
2111: IF l_emp_count <>0 THEN
2112: l_open_tag := '';
2113: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2114:
2115: l_open_tag := '';
2116: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2117: build_gre_xml(l_gre_id);

Line 2116: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2112: l_open_tag := '';
2113: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2114:
2115: l_open_tag := '';
2116: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2117: build_gre_xml(l_gre_id);
2118: END IF;
2119:
2120: /* Fetch the Employees in the GRE and build the XML for each employee */

Line 2139: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2135: IF l_emp_count = 0 OR l_emp_count > g_chunk_size THEN
2136: IF l_emp_count <> 0 THEN
2137: /* Close all the open tags */
2138: l_open_tag := '';
2139: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2140: /* Close the temporary CLOB opened */
2141: dbms_lob.close(g_tmp_clob);
2142: /* Store the temporary CLOB in the Global CLOB array */
2143: g_clob_cnt := g_clob_cnt + 1;

Line 2141: dbms_lob.close(g_tmp_clob);

2137: /* Close all the open tags */
2138: l_open_tag := '';
2139: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2140: /* Close the temporary CLOB opened */
2141: dbms_lob.close(g_tmp_clob);
2142: /* Store the temporary CLOB in the Global CLOB array */
2143: g_clob_cnt := g_clob_cnt + 1;
2144: g_clob(g_clob_cnt) := g_tmp_clob;
2145: /* Reset the employees count to 1 */

Line 2149: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);

2145: /* Reset the employees count to 1 */
2146: l_emp_count := 1;
2147: END IF;
2148: /* Create a new temporary CLOB for writing XML Data */
2149: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2150: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2151: /* Open the parent Tags */
2152: l_open_tag := '';
2153: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

Line 2150: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);

2146: l_emp_count := 1;
2147: END IF;
2148: /* Create a new temporary CLOB for writing XML Data */
2149: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2150: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2151: /* Open the parent Tags */
2152: l_open_tag := '';
2153: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2154: /* Write the Common data in the New CLOB created */

Line 2153: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2149: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2150: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2151: /* Open the parent Tags */
2152: l_open_tag := '';
2153: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2154: /* Write the Common data in the New CLOB created */
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);

Line 2162: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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:
2164: build_gre_xml(l_gre_id);
2165: END IF;
2166: l_emp_count := l_emp_count + 1;

Line 2168: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2164: build_gre_xml(l_gre_id);
2165: END IF;
2166: l_emp_count := l_emp_count + 1;
2167: l_open_tag := '';
2168: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2169: /* The following calls builds the XML related to form16, form 16aa and 12ba
2170: required to generate the report
2171: */
2172:

Line 2184: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2180: pay_in_utils.set_location(g_debug,'Building XML for Form 12BA',90);
2181: init_form12ba_code;
2182: build_form12ba_xml(l_action_context_id,l_source_id);
2183: l_open_tag := '';
2184: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2185: END IF;
2186: END IF;
2187: END IF;
2188: CLOSE csr_emp_source_id;

Line 2195: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

2191:
2192: END LOOP;
2193: IF l_emp_count <> 0 THEN
2194: l_open_tag := '';
2195: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2196: /* Close the temporary CLOB opened which is not yet closed*/
2197: dbms_lob.close(g_tmp_clob);
2198: /* Copy the Temporary CLOB into the Global CLOB Array */
2199: g_clob_cnt := g_clob_cnt + 1;

Line 2197: dbms_lob.close(g_tmp_clob);

2193: IF l_emp_count <> 0 THEN
2194: l_open_tag := '';
2195: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2196: /* Close the temporary CLOB opened which is not yet closed*/
2197: dbms_lob.close(g_tmp_clob);
2198: /* Copy the Temporary CLOB into the Global CLOB Array */
2199: g_clob_cnt := g_clob_cnt + 1;
2200: g_clob(g_clob_cnt) := g_tmp_clob;
2201: p_clob_cnt := g_clob_cnt;