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_DK_EMP_TRAINEE_REIMBURSE dependencies on DBMS_LOB

Line 56: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);

52: --
53: -- l_str1 := ' ';
54: l_str1 := ' ';
55:
56: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
57: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
58: --
59: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
60: --

Line 57: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);

53: -- l_str1 := ' ';
54: l_str1 := ' ';
55:
56: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
57: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
58: --
59: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
60: --
61: IF g_xml_element_table.COUNT > 0 THEN

Line 59: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);

55:
56: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
57: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
58: --
59: dbms_lob.writeappend(l_clob, LENGTH(l_str1), l_str1);
60: --
61: IF g_xml_element_table.COUNT > 0 THEN
62: FOR table_counter IN g_xml_element_table.FIRST .. g_xml_element_table.LAST LOOP
63: IF g_xml_element_table(table_counter).tagvalue = '_START_' THEN

Line 73: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);

69: REPLACE (l_xml_element_template1, 'TAG', g_xml_element_table(table_counter).tagname)
70: ,'VALUE', g_xml_element_table(table_counter).tagvalue);
71: END IF;
72: --
73: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
74: END LOOP;
75: END IF;
76: --
77: dbms_lob.writeappend(l_clob, LENGTH(l_str2), l_str2);

Line 77: dbms_lob.writeappend(l_clob, LENGTH(l_str2), l_str2);

73: dbms_lob.writeappend(l_clob, LENGTH(l_xml_element), l_xml_element);
74: END LOOP;
75: END IF;
76: --
77: dbms_lob.writeappend(l_clob, LENGTH(l_str2), l_str2);
78: --
79: p_clob := l_clob;
80: --
81: EXCEPTION

Line 269: -- DBMS_LOB.CREATETEMPORARY (XMLRESULT, TRUE, DBMS_LOB.SESSION);

265: P_EFFECTIVE_DATE := SYSDATE;
266: END;*/
267: --lv_offset := 23;
268: -- Create a temporary LOB to store the generated XML.
269: -- DBMS_LOB.CREATETEMPORARY (XMLRESULT, TRUE, DBMS_LOB.SESSION);
270: -- DBMS_LOB.CREATETEMPORARY (lv_clob, TRUE, DBMS_LOB.SESSION);
271: /*Converting the P_EFFECTIVE_DATE1 parameter to date and assigning it to P_EFFECTIVE_DATE*/
272: P_EFFECTIVE_DATE :=FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DATE1);
273: -- Control structure to identify which Quarter the report to be executed

Line 270: -- DBMS_LOB.CREATETEMPORARY (lv_clob, TRUE, DBMS_LOB.SESSION);

266: END;*/
267: --lv_offset := 23;
268: -- Create a temporary LOB to store the generated XML.
269: -- DBMS_LOB.CREATETEMPORARY (XMLRESULT, TRUE, DBMS_LOB.SESSION);
270: -- DBMS_LOB.CREATETEMPORARY (lv_clob, TRUE, DBMS_LOB.SESSION);
271: /*Converting the P_EFFECTIVE_DATE1 parameter to date and assigning it to P_EFFECTIVE_DATE*/
272: P_EFFECTIVE_DATE :=FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DATE1);
273: -- Control structure to identify which Quarter the report to be executed
274: IF P_QUARTER = 1 THEN

Line 400: DBMS_LOB.ERASE(XMLRESULT, LV_OFFSET, 1 );

396: DBMS_XMLQUERY.SETROWSETTAG (XMLIDENT, 'AERReport');
397: DBMS_XMLQUERY.SETROWTAG (XMLIDENT, 'Employee');
398: DBMS_XMLQUERY.GETXML(XMLIDENT, XMLRESULT);
399: DBMS_XMLQUERY.CLOSECONTEXT(XMLIDENT);
400: DBMS_LOB.ERASE(XMLRESULT, LV_OFFSET, 1 );
401: l_iana_charset := PAY_DK_GENERAL.get_IANA_charset();
402: LV_CLOB := ' ' ;
403: DBMS_LOB.APPEND (LV_CLOB, XMLRESULT );
404: -- Assign the resulted XML into output variable

Line 403: DBMS_LOB.APPEND (LV_CLOB, XMLRESULT );

399: DBMS_XMLQUERY.CLOSECONTEXT(XMLIDENT);
400: DBMS_LOB.ERASE(XMLRESULT, LV_OFFSET, 1 );
401: l_iana_charset := PAY_DK_GENERAL.get_IANA_charset();
402: LV_CLOB := ' ' ;
403: DBMS_LOB.APPEND (LV_CLOB, XMLRESULT );
404: -- Assign the resulted XML into output variable
405: */
406: g_xml_element_table(l_xml_element_count).tagname := 'AERReport';
407: g_xml_element_table(l_xml_element_count).tagvalue := '_START_';

Line 444: -- DBMS_LOB.FREETEMPORARY(XMLRESULT);

440: l_xml_element_count := l_xml_element_count + 1;
441: --
442: write_to_clob(P_XML);
443: --
444: -- DBMS_LOB.FREETEMPORARY(XMLRESULT);
445: -- DBMS_LOB.FREETEMPORARY(LV_CLOB);
446: --
447: END POPULATE_DETAILS;
448: --

Line 445: -- DBMS_LOB.FREETEMPORARY(LV_CLOB);

441: --
442: write_to_clob(P_XML);
443: --
444: -- DBMS_LOB.FREETEMPORARY(XMLRESULT);
445: -- DBMS_LOB.FREETEMPORARY(LV_CLOB);
446: --
447: END POPULATE_DETAILS;
448: --
449: END PAY_DK_EMP_TRAINEE_REIMBURSE;