DBA Data[Home] [Help]

APPS.PAY_IE_P35_XML_PKG dependencies on DBMS_LOB

Line 37: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);

33: BEGIN
34: -- bug 5852148
35: --l_str := ' ';
36: l_str := ' ';
37: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);
38: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);
39: hr_utility.set_location('TableCnt' || to_char(vXMLTable.count),13);
40: IF vXMLTable.count > 0 THEN
41: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 38: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);

34: -- bug 5852148
35: --l_str := ' ';
36: l_str := ' ';
37: dbms_lob.createtemporary(p_xfdf_string,FALSE,DBMS_LOB.CALL);
38: dbms_lob.open(p_xfdf_string,dbms_lob.lob_readwrite);
39: hr_utility.set_location('TableCnt' || to_char(vXMLTable.count),13);
40: IF vXMLTable.count > 0 THEN
41: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
42: -- Bug 4705094

Line 44: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1);

40: IF vXMLTable.count > 0 THEN
41: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
42: -- Bug 4705094
43: l_str1 := vXMLTable(ctr_table).xmlString;
44: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1);
45: hr_utility.set_location(to_char(ctr_table),15);
46: END LOOP;
47: ELSE
48: l_str1 := l_str;

Line 49: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1 );

45: hr_utility.set_location(to_char(ctr_table),15);
46: END LOOP;
47: ELSE
48: l_str1 := l_str;
49: dbms_lob.writeAppend( p_xfdf_string, length(l_str1), l_str1 );
50: END IF;
51: END WritetoCLOB;
52: --------------------------------------------------------------------------------
53: -- POPULATE_P35_REPORT