APPS.HR_TRANSACTION_SWI dependencies on DBMS_LOB

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

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

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

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

Line 723: DBMS_LOB.freetemporary(g_tempClob);

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

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

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

Line 808: DBMS_LOB.freetemporary(g_tempClob);

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

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

2665: begin
2666: IF(NOT xmldom.isnull(p_error_doc)) THEN
2667: SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters
2668: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2669: DBMS_LOB.createTemporary(error_log, FALSE);
2670: xmldom.writeToClob(p_error_doc,error_log,charset);
2671: p_error_log:=error_log;
2672: DBMS_LOB.freetemporary(error_log);
2673: xmldom.freeDocument(p_error_doc);

Line 2672: DBMS_LOB.freetemporary(error_log);

2668: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2669: DBMS_LOB.createTemporary(error_log, FALSE);
2670: xmldom.writeToClob(p_error_doc,error_log,charset);
2671: p_error_log:=error_log;
2672: DBMS_LOB.freetemporary(error_log);
2673: xmldom.freeDocument(p_error_doc);
2674: END IF;
2675: end;
2676: