APPS.HR_TRANSACTION_SWI dependencies on DBMS_LOB

Line 695: DBMS_LOB.createTemporary(g_tempClob, FALSE);

691: g_processing_EO_cdatavalue := xmldom.getNodeValue(l_CDATANode);
692:
693: -- Make a CLOB out of the root_node for binding purposes
694: hr_utility.set_location('Making the CLOB:' || l_proc,15);
695: DBMS_LOB.createTemporary(g_tempClob, FALSE);
696: -- DBMS_LOB.createTemporary(g_tempClob, FALSE);
697: xmldom.writeToClob(l_EORowNode,g_tempClob);
698:
699: hr_utility.set_location('Building the Dynamic Procedure call:' || l_proc,20);

Line 696: -- DBMS_LOB.createTemporary(g_tempClob, FALSE);

692:
693: -- Make a CLOB out of the root_node for binding purposes
694: hr_utility.set_location('Making the CLOB:' || l_proc,15);
695: DBMS_LOB.createTemporary(g_tempClob, FALSE);
696: -- DBMS_LOB.createTemporary(g_tempClob, FALSE);
697: xmldom.writeToClob(l_EORowNode,g_tempClob);
698:
699: hr_utility.set_location('Building the Dynamic Procedure call:' || l_proc,20);
700: -- if l_EO_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API' or l_EO_api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API' then

Line 719: DBMS_LOB.freetemporary(g_tempClob);

715: -- Free the CLOB
716: -- Make the call to set_status to set the current_return Status
717: x_current_status:=set_status(x_current_status,l_procapi_retstat_out);
718:
719: DBMS_LOB.freetemporary(g_tempClob);
720:
721: IF(l_procapi_retstat_out = 'E') THEN
722: hr_utility.set_location(' Error processing with api call '||l_EO_api_name || l_proc,50);
723: RAISE g_process_api_internal_error;

Line 783: DBMS_LOB.createTemporary(g_tempClob, FALSE);

779:
780: -- Make a CLOB out of the root_node for binding purposes
781: if(xmlDOM.isNull(l_EORowNode)=false) then
782: hr_utility.set_location('Making the CLOB:' || l_proc,15);
783: DBMS_LOB.createTemporary(g_tempClob, FALSE);
784: xmldom.writeToClob(l_EORowNode,g_tempClob);
785: end if;
786:
787:

Line 804: DBMS_LOB.freetemporary(g_tempClob);

800: ,p_return_status => :2
801: ,p_validate => :3
802: ,p_effective_date => :4); end;';
803: EXECUTE IMMEDIATE l_sqlbuf using in p_transaction_step_id, out l_procapi_retstat_out, in p_validate, in p_effective_date ;
804: DBMS_LOB.freetemporary(g_tempClob);
805: end if;
806:
807: -- Free the CLOB
808: -- Make the call to set_status to set the current_return Status

Line 2258: DBMS_LOB.createTemporary(error_log, FALSE);

2254: begin
2255: IF(NOT xmldom.isnull(p_error_doc)) THEN
2256: SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters
2257: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2258: DBMS_LOB.createTemporary(error_log, FALSE);
2259: xmldom.writeToClob(p_error_doc,error_log,charset);
2260: p_error_log:=error_log;
2261: DBMS_LOB.freetemporary(error_log);
2262: xmldom.freeDocument(p_error_doc);

Line 2261: DBMS_LOB.freetemporary(error_log);

2257: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2258: DBMS_LOB.createTemporary(error_log, FALSE);
2259: xmldom.writeToClob(p_error_doc,error_log,charset);
2260: p_error_log:=error_log;
2261: DBMS_LOB.freetemporary(error_log);
2262: xmldom.freeDocument(p_error_doc);
2263: END IF;
2264: end;
2265: