APPS.FND_ODF_GEN dependencies on DBMS_UTILITY

Line 593: l_seqList DBMS_UTILITY.UNCL_ARRAY;

589: p_retVal OUT NOCOPY CLOB)
590: IS
591: l_objXMLOpenHandle NUMBER;
592: l_tablen BINARY_INTEGER;
593: l_seqList DBMS_UTILITY.UNCL_ARRAY;
594: finalInSt VARCHAR2(1000);
595: l_finalXML CLOB;
596: l_tmpXML CLOB;
597: l_eobjXMLs sys.XMLType;

Line 608: DBMS_UTILITY.COMMA_TO_TABLE(p_seqNameList,l_tabLen,l_seqList);

604: /* Use it to form the in statement for set_filter method */
605: /* get in a pl/sql table */
606: p_seqCount := 0;
607: finalInSt := 'IN (';
608: DBMS_UTILITY.COMMA_TO_TABLE(p_seqNameList,l_tabLen,l_seqList);
609: for i in 1..l_tabLen loop
610: finalInSt := finalInSt || '''' || l_seqList(i) || '''';
611: if ( i <> l_tabLen ) then
612: finalInSt := finalInSt || ',';

Line 665: l_policyList DBMS_UTILITY.UNCL_ARRAY;

661: p_retVal OUT NOCOPY CLOB)
662: IS
663: l_objXMLOpenHandle NUMBER;
664: l_tablen BINARY_INTEGER;
665: l_policyList DBMS_UTILITY.UNCL_ARRAY;
666: finalInSt VARCHAR2(1000);
667: l_finalXML CLOB;
668: l_tmpXML CLOB;
669: l_eobjXMLs sys.XMLType;