APPS.HR_H2PI_UPLOAD dependencies on DBMS_XMLSAVE

Line 14: l_saveCtx DBMS_XMLSave.CtxType;

10: --
11: procedure insert_xml_into_table (p_table_name in varchar2,
12: p_locator in clob) is
13:
14: l_saveCtx DBMS_XMLSave.CtxType;
15: l_rows number(15);
16: l_length number(15);
17: l_proc varchar2(73) := g_package || 'insert_xml_into_table';
18:

Line 22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);

18:
19: BEGIN
20: hr_utility.set_location('Entering:'|| l_proc, 10);
21: if dbms_lob.getlength(p_locator) > length('') + length(' 22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;

Line 23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);

19: BEGIN
20: hr_utility.set_location('Entering:'|| l_proc, 10);
21: if dbms_lob.getlength(p_locator) > length('') + length(' 22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;
27: --

Line 24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);

20: hr_utility.set_location('Entering:'|| l_proc, 10);
21: if dbms_lob.getlength(p_locator) > length('') + length(' 22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;
27: --
28: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 25: DBMS_XMLSave.closeContext(l_saveCtx);

21: if dbms_lob.getlength(p_locator) > length('') + length(' 22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);
26: end if;
27: --
28: hr_utility.set_location('Leaving:'|| l_proc, 20);
29: END insert_xml_into_table;