APPS.POR_AMENDMENT_PKG dependencies on DBMS_XMLGEN

Line 1057: queryCtx dbms_xmlgen.ctxType;

1053:
1054:
1055: FUNCTION create_xml(p_sql_stmt VARCHAR2) RETURN CLOB
1056: IS
1057: queryCtx dbms_xmlgen.ctxType;
1058: result CLOB;
1059: BEGIN
1060: -- set up the query context
1061: queryCtx := dbms_xmlgen.newContext(p_sql_stmt);

Line 1061: queryCtx := dbms_xmlgen.newContext(p_sql_stmt);

1057: queryCtx dbms_xmlgen.ctxType;
1058: result CLOB;
1059: BEGIN
1060: -- set up the query context
1061: queryCtx := dbms_xmlgen.newContext(p_sql_stmt);
1062:
1063: dbms_xmlgen.setRowTag(
1064: queryCtx
1065: , 'ROW'

Line 1063: dbms_xmlgen.setRowTag(

1059: BEGIN
1060: -- set up the query context
1061: queryCtx := dbms_xmlgen.newContext(p_sql_stmt);
1062:
1063: dbms_xmlgen.setRowTag(
1064: queryCtx
1065: , 'ROW'
1066: );
1067: dbms_xmlgen.setRowSetTag(

Line 1067: dbms_xmlgen.setRowSetTag(

1063: dbms_xmlgen.setRowTag(
1064: queryCtx
1065: , 'ROW'
1066: );
1067: dbms_xmlgen.setRowSetTag(
1068: queryCtx
1069: , 'ROWSET'
1070: );
1071:

Line 1072: dbms_xmlgen.setConvertSpecialChars(queryCtx,TRUE);

1068: queryCtx
1069: , 'ROWSET'
1070: );
1071:
1072: dbms_xmlgen.setConvertSpecialChars(queryCtx,TRUE);
1073: dbms_xmlgen.setNULLHandling(queryCtx,2);
1074:
1075: result := dbms_xmlgen.getXml(queryCtx);
1076: dbms_xmlgen.closeContext(queryCtx);

Line 1073: dbms_xmlgen.setNULLHandling(queryCtx,2);

1069: , 'ROWSET'
1070: );
1071:
1072: dbms_xmlgen.setConvertSpecialChars(queryCtx,TRUE);
1073: dbms_xmlgen.setNULLHandling(queryCtx,2);
1074:
1075: result := dbms_xmlgen.getXml(queryCtx);
1076: dbms_xmlgen.closeContext(queryCtx);
1077: RETURN result;

Line 1075: result := dbms_xmlgen.getXml(queryCtx);

1071:
1072: dbms_xmlgen.setConvertSpecialChars(queryCtx,TRUE);
1073: dbms_xmlgen.setNULLHandling(queryCtx,2);
1074:
1075: result := dbms_xmlgen.getXml(queryCtx);
1076: dbms_xmlgen.closeContext(queryCtx);
1077: RETURN result;
1078:
1079: EXCEPTION

Line 1076: dbms_xmlgen.closeContext(queryCtx);

1072: dbms_xmlgen.setConvertSpecialChars(queryCtx,TRUE);
1073: dbms_xmlgen.setNULLHandling(queryCtx,2);
1074:
1075: result := dbms_xmlgen.getXml(queryCtx);
1076: dbms_xmlgen.closeContext(queryCtx);
1077: RETURN result;
1078:
1079: EXCEPTION
1080: WHEN OTHERS THEN