APPS.PAY_IN_EOY_REPORTS dependencies on HR_MX_UTILITY

Line 2457: l_open_tag := '';

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 */
2460:
2461: -- Bug # 12700621 : Adding paramter for report date

Line 2705: l_open_tag := '';

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