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 478: dbms_lob.writeAppend(g_tmp_clob,length(l_tag),l_tag);

474: l_tag := pay_in_xml_utils.getTag( p_tag_name => p_tag_name
475: , p_tag_value => p_tag_value
476: );
477:
478: dbms_lob.writeAppend(g_tmp_clob,length(l_tag),l_tag);
479: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
480: END write_tag;
481:
482: --------------------------------------------------------------------------

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

1587: IF(i.Description_Value <> 'X')THEN
1588: l_80c_tag_seq := ltrim(lower(to_char(l_via_seq_80c_num,'RM')),' ' )||')';
1589:
1590: l_open_tag := '';
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)));

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

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 := '';
1600: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1601: END IF;
1602: END LOOP;
1603:
1604: l_tot_80c_qual := LEAST(l_tot_80c_qual,g_80cce_limit);

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

1625: '80CCF') THEN
1626: l_via_oth_flag := 1;
1627: l_80du_tag_seq := '('||fnd_global.local_chr(l_via_seq_80d_u_num)||')';
1628: l_open_tag := '';
1629: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
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);

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

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

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

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

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

1652:
1653: l_via_seq_80cce_num := l_via_seq_80cce_num + 1;
1654:
1655: l_open_tag := '';
1656: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1657: l_tot_80ccc_gross := l_tot_80ccc_gross + nvl(i.Gross_Value,0);
1658: l_tot_80ccc_qual := l_tot_80ccc_qual + l_qualifying_amt;
1659: ELSE
1660: NULL;

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

1707: IF l_flag_rep_gen = -1 THEN
1708: /* Do not generate any report for this employee */
1709: p_flag_for_16aa := -1;
1710: emp_pos := INSTR(g_tmp_clob,'',-1);
1711: dbms_lob.TRIM(g_tmp_clob,emp_pos-1);
1712: ELSE
1713: /* Generate either 16 /16AA for this employee */
1714: p_flag_for_16aa := 1;
1715:

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

1725:
1726: FOR i IN 1..5 LOOP
1727: IF(t_table_1(i) <>0) THEN
1728: l_open_tag := '';
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)));

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

1746: END IF;
1747:
1748:
1749: l_open_tag := '';
1750: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1751: END IF;
1752: END LOOP;
1753:
1754: IF p_flag_for_16aa = 1 THEN

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

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

Line 1762: 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;
1765:
1766: FOR rec_deduction_via_d_to_u IN csr_deduction_via_d_to_u

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

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

Line 1799: 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 ;
1802: END LOOP ;
1803:

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

1867: END IF;
1868: --
1869: IF( l_Non_Taxable_Amt > 0) THEN
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:

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

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:
1879: END IF;
1880: --
1881: END LOOP;

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

1941: END LOOP;
1942:
1943: IF l_entry_exists = 1 THEN
1944: l_open_tag := '';
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));

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

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);
1961: l_open_tag := '';
1962: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
1963: END IF;
1964: l_tds_total := l_tds_total + l_emp_tds + l_emp_cess;
1965: END IF;
1966:

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

2413: l_gre_id := gre_record.orgid;
2414: /* Close and reopen tag for GRE */
2415: IF l_emp_count <>0 THEN
2416: l_open_tag := '';
2417: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2418:
2419: l_open_tag := '';
2420: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2421: build_gre_xml(l_gre_id,p_designation);

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

2416: l_open_tag := '';
2417: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2418:
2419: l_open_tag := '';
2420: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2421: build_gre_xml(l_gre_id,p_designation);
2422: END IF;
2423:
2424: /* Fetch the Employees in the GRE and build the XML for each employee */

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

2440: IF l_emp_count = 0 OR l_emp_count > g_chunk_size THEN
2441: IF l_emp_count <> 0 THEN
2442: /* Close all the open tags */
2443: l_open_tag := '';
2444: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2445: /* Close the temporary CLOB opened */
2446: dbms_lob.close(g_tmp_clob);
2447: /* Store the temporary CLOB in the Global CLOB array */
2448: g_clob_cnt := g_clob_cnt + 1;

Line 2446: dbms_lob.close(g_tmp_clob);

2442: /* Close all the open tags */
2443: l_open_tag := '';
2444: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2445: /* Close the temporary CLOB opened */
2446: dbms_lob.close(g_tmp_clob);
2447: /* Store the temporary CLOB in the Global CLOB array */
2448: g_clob_cnt := g_clob_cnt + 1;
2449: g_clob(g_clob_cnt) := g_tmp_clob;
2450: /* Reset the employees count to 1 */

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

2450: /* Reset the employees count to 1 */
2451: l_emp_count := 1;
2452: END IF;
2453: /* Create a new temporary CLOB for writing XML Data */
2454: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2455: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2456: /* Open the parent Tags */
2457: l_open_tag := '';
2458: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2451: l_emp_count := 1;
2452: END IF;
2453: /* Create a new temporary CLOB for writing XML Data */
2454: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2455: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2456: /* Open the parent Tags */
2457: l_open_tag := '';
2458: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2459: /* Write the Common data in the New CLOB created */

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

2454: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2455: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2456: /* Open the parent Tags */
2457: l_open_tag := '';
2458: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2459: /* Write the Common data in the New CLOB created */
2460:
2461: -- Bug # 12700621 : Adding paramter for report date
2462: /* write_tag('REPORT_DATE',TO_CHAR(TRUNC(SYSDATE),'DD-MM-YYYY')); */

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

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:
2485: build_gre_xml(l_gre_id,p_designation);
2486: END IF;
2487: l_emp_count := l_emp_count + 1;

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

2486: END IF;
2487: l_emp_count := l_emp_count + 1;
2488:
2489: l_open_tag := '';
2490: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2491: /* The following calls builds the XML related to form16, form 16aa and 12ba
2492: required to generate the report
2493: */
2494:

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

2503: init_form12ba_code;
2504: build_form12ba_xml(l_action_context_id,l_source_id);
2505: get_image_details(l_gre_id);
2506: l_open_tag := '0';
2507: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2508: l_open_tag := '0';
2509: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2510: l_open_tag := '0';
2511: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2505: get_image_details(l_gre_id);
2506: l_open_tag := '0';
2507: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2508: l_open_tag := '0';
2509: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2510: l_open_tag := '0';
2511: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2512: l_open_tag := '';
2513: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2507: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2508: l_open_tag := '0';
2509: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2510: l_open_tag := '0';
2511: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2512: l_open_tag := '';
2513: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2514: END IF;
2515: END IF;

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

2509: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2510: l_open_tag := '0';
2511: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2512: l_open_tag := '';
2513: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2514: END IF;
2515: END IF;
2516: END IF;
2517: CLOSE csr_emp_source_id;

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

2520:
2521: END LOOP;
2522: IF l_emp_count <> 0 THEN
2523: l_open_tag := '';
2524: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2525: /* Close the temporary CLOB opened which is not yet closed*/
2526: dbms_lob.close(g_tmp_clob);
2527: /* Copy the Temporary CLOB into the Global CLOB Array */
2528: g_clob_cnt := g_clob_cnt + 1;

Line 2526: dbms_lob.close(g_tmp_clob);

2522: IF l_emp_count <> 0 THEN
2523: l_open_tag := '';
2524: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2525: /* Close the temporary CLOB opened which is not yet closed*/
2526: dbms_lob.close(g_tmp_clob);
2527: /* Copy the Temporary CLOB into the Global CLOB Array */
2528: g_clob_cnt := g_clob_cnt + 1;
2529: g_clob(g_clob_cnt) := g_tmp_clob;
2530: p_clob_cnt := g_clob_cnt;

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

2672: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,40);
2673: pay_in_utils.set_location(g_debug,'l_gre_id: '||l_gre_id,45);
2674: IF l_emp_count <>0 THEN
2675: l_open_tag := '';
2676: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2677: l_open_tag := '';
2678: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2679: build_gre_xml(l_gre_id,p_designation);
2680: END IF;

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

2674: IF l_emp_count <>0 THEN
2675: l_open_tag := '';
2676: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2677: l_open_tag := '';
2678: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2679: build_gre_xml(l_gre_id,p_designation);
2680: END IF;
2681: FOR emp_record IN csr_fetch_employees(l_gre_id)
2682: LOOP

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

2698: l_emp_count := 1;
2699: END IF;
2700: IF l_emp_count = 0 THEN
2701:
2702: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2703: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2704:
2705: l_open_tag := '';
2706: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2699: END IF;
2700: IF l_emp_count = 0 THEN
2701:
2702: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2703: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2704:
2705: l_open_tag := '';
2706: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2707:

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

2702: dbms_lob.createtemporary(g_tmp_clob,FALSE,DBMS_LOB.CALL);
2703: dbms_lob.open(g_tmp_clob,dbms_lob.lob_readwrite);
2704:
2705: l_open_tag := '';
2706: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2707:
2708: IF p_report_date IS NOT NULL THEN
2709: write_tag('REPORT_DATE',TO_CHAR(TO_DATE(p_report_date,'YYYY-MM-DD HH24:MI:SS'),'DD-MM-YYYY'));
2710: ELSE

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

2717: ELSE
2718: write_tag('REPORT_DATE_TIME',TO_CHAR(TO_DATE(sysdate,'DD-MM-RRRR HH24:MI:SS'),'DD-Mon-YYYY HH24:MI:SS'));
2719: END IF;
2720: l_open_tag := '';
2721: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2722:
2723: build_gre_xml(l_gre_id,p_designation);
2724: END IF;
2725: END IF;

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

2724: END IF;
2725: END IF;
2726: l_emp_count := l_emp_count + 1;
2727: l_open_tag := '';
2728: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2729: pay_in_utils.set_location(g_debug,'INDIA F16: Building XML for Employee',70);
2730: build_employee_xml(l_action_context_id,l_source_id,p_designation,p_rem_pay_period,p_flag);
2731: pay_in_utils.set_location(g_debug,'Building XML for Form 16/16AA',80);
2732: build_form16_xml(l_action_context_id,l_source_id,p_rem_pay_period,p_flag,l_flag_for_16aa);

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

2738: build_form12ba_xml(l_action_context_id,l_source_id);
2739: get_image_details(l_gre_id);
2740: IF (p_report_type = 'XML') THEN ---------- Mail Form16
2741: l_open_tag := '0';
2742: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2743: l_open_tag := '1';
2744: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2745: l_open_tag := '0';
2746: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2740: IF (p_report_type = 'XML') THEN ---------- Mail Form16
2741: l_open_tag := '0';
2742: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2743: l_open_tag := '1';
2744: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2745: l_open_tag := '0';
2746: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2747: l_open_tag := 'Form 16';
2748: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2742: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2743: l_open_tag := '1';
2744: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2745: l_open_tag := '0';
2746: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2747: l_open_tag := 'Form 16';
2748: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2749:
2750: ELSIF (p_report_type = 'XML2') THEN -------- Mail Form12B

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

2744: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2745: l_open_tag := '0';
2746: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2747: l_open_tag := 'Form 16';
2748: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2749:
2750: ELSIF (p_report_type = 'XML2') THEN -------- Mail Form12B
2751: l_open_tag := '1';
2752: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2748: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2749:
2750: ELSIF (p_report_type = 'XML2') THEN -------- Mail Form12B
2751: l_open_tag := '1';
2752: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2753: l_open_tag := '0';
2754: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2755: l_open_tag := '0';
2756: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2750: ELSIF (p_report_type = 'XML2') THEN -------- Mail Form12B
2751: l_open_tag := '1';
2752: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2753: l_open_tag := '0';
2754: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2755: l_open_tag := '0';
2756: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2757: l_open_tag := 'Form 12BA';
2758: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2752: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2753: l_open_tag := '0';
2754: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2755: l_open_tag := '0';
2756: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2757: l_open_tag := 'Form 12BA';
2758: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2759:
2760: ELSE -------- Mail Annexure B

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

2754: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2755: l_open_tag := '0';
2756: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2757: l_open_tag := 'Form 12BA';
2758: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2759:
2760: ELSE -------- Mail Annexure B
2761: l_open_tag := '0';
2762: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2758: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2759:
2760: ELSE -------- Mail Annexure B
2761: l_open_tag := '0';
2762: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2763: l_open_tag := '0';
2764: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2765: l_open_tag := '1';
2766: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2760: ELSE -------- Mail Annexure B
2761: l_open_tag := '0';
2762: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2763: l_open_tag := '0';
2764: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2765: l_open_tag := '1';
2766: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2767: l_open_tag := 'Annexure-B';
2768: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);

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

2762: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2763: l_open_tag := '0';
2764: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2765: l_open_tag := '1';
2766: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2767: l_open_tag := 'Annexure-B';
2768: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2769:
2770:

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

2764: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2765: l_open_tag := '1';
2766: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2767: l_open_tag := 'Annexure-B';
2768: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2769:
2770:
2771: END IF;
2772: l_open_tag := '';

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

2769:
2770:
2771: END IF;
2772: l_open_tag := '';
2773: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2774: END IF;
2775: END IF;
2776: END IF;
2777: CLOSE csr_emp_source_id;

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

2780: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,60);
2781: IF l_emp_count <> 0 THEN
2782: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,70);
2783: l_open_tag := '';
2784: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2785: dbms_lob.close(g_tmp_clob);
2786: p_xml :=g_tmp_clob;
2787: ELSE
2788: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,80);

Line 2785: dbms_lob.close(g_tmp_clob);

2781: IF l_emp_count <> 0 THEN
2782: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,70);
2783: l_open_tag := '';
2784: dbms_lob.writeAppend(g_tmp_clob,length(l_open_tag),l_open_tag);
2785: dbms_lob.close(g_tmp_clob);
2786: p_xml :=g_tmp_clob;
2787: ELSE
2788: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,80);
2789: p_xml :=g_tmp_clob;

Line 2791: fnd_file.put_line(fnd_file.log,dbms_lob.substr(g_tmp_clob));

2787: ELSE
2788: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,80);
2789: p_xml :=g_tmp_clob;
2790: END IF;
2791: fnd_file.put_line(fnd_file.log,dbms_lob.substr(g_tmp_clob));
2792: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,100);
2793: END load_xml_burst;
2794:
2795: