[Home] [Help]
1962:
1963:
1964: --Insert into temp table. This is done because a handle to a CLOB created through JDBC
1965: --can be obtained only if it stored in a table and the table queried.
1966: insert into EDR_FINAL_XML_GT(event_name,event_key,event_xml)
1967: values(l_event_name,l_event_key,l_event_data);
1968:
1969: select event_xml
1970: into l_event_data
1967: values(l_event_name,l_event_key,l_event_data);
1968:
1969: select event_xml
1970: into l_event_data
1971: from EDR_FINAL_XML_GT;
1972:
1973: if dbms_lob.getlength(l_event_data)>0 then
1974: --Diagnostics Start
1975: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2071: --Bug 3893101: End
2072:
2073: --update the global temp table with the final xml obtained from ECX
2074: --this would be the xml payload of the e-record
2075: update EDR_FINAL_XML_GT
2076: set event_xml = l_erecord_data
2077: where event_name = l_event_name
2078: and event_key = l_event_key;
2079:
2076: set event_xml = l_erecord_data
2077: where event_name = l_event_name
2078: and event_key = l_event_key;
2079:
2080: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','updated edr_final_xml_gt with the final xml');
2081: else
2082: --Diagnostics Start
2083: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2084: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
2116:
2117: -- Bug 4126932 : END
2118:
2119: --clean up temp table
2120: delete from EDR_FINAL_XML_GT where event_name = l_event_name and event_key=l_event_key;
2121:
2122: wf_log_pkg.string(3, 'EDR_PSIG_RULE.psig_rule','AME API Called. Total Approver '||approverlist.count);
2123:
2124: -- get the Application Name