DBA Data[Home] [Help]

APPS.PO_FED_FIELD_FUNCTIONS dependencies on DBMS_XMLGEN

Line 2960: queryCtx DBMS_XMLGEN.ctxType;

2956: END supplier_details_XRD;
2957:
2958: FUNCTION create_address_xml(p_sql_stmt VARCHAR2) RETURN CLOB
2959: IS
2960: queryCtx DBMS_XMLGEN.ctxType;
2961: result CLOB;
2962: BEGIN
2963: queryCtx := DBMS_XMLGEN.newContext(p_sql_stmt);
2964:

Line 2963: queryCtx := DBMS_XMLGEN.newContext(p_sql_stmt);

2959: IS
2960: queryCtx DBMS_XMLGEN.ctxType;
2961: result CLOB;
2962: BEGIN
2963: queryCtx := DBMS_XMLGEN.newContext(p_sql_stmt);
2964:
2965: DBMS_XMLGEN.setRowTag(
2966: queryCtx
2967: , NULL

Line 2965: DBMS_XMLGEN.setRowTag(

2961: result CLOB;
2962: BEGIN
2963: queryCtx := DBMS_XMLGEN.newContext(p_sql_stmt);
2964:
2965: DBMS_XMLGEN.setRowTag(
2966: queryCtx
2967: , NULL
2968: );
2969: DBMS_XMLGEN.setRowSetTag(

Line 2969: DBMS_XMLGEN.setRowSetTag(

2965: DBMS_XMLGEN.setRowTag(
2966: queryCtx
2967: , NULL
2968: );
2969: DBMS_XMLGEN.setRowSetTag(
2970: queryCtx
2971: , 'ADDRESS'
2972: );
2973:

Line 2974: --DBMS_XMLGEN.useNullAttributeIndicator(queryCtx,TRUE);

2970: queryCtx
2971: , 'ADDRESS'
2972: );
2973:
2974: --DBMS_XMLGEN.useNullAttributeIndicator(queryCtx,TRUE);
2975:
2976: result := DBMS_XMLGEN.getXml(queryCtx);
2977:
2978: DBMS_XMLGEN.closeContext(queryCtx);

Line 2976: result := DBMS_XMLGEN.getXml(queryCtx);

2972: );
2973:
2974: --DBMS_XMLGEN.useNullAttributeIndicator(queryCtx,TRUE);
2975:
2976: result := DBMS_XMLGEN.getXml(queryCtx);
2977:
2978: DBMS_XMLGEN.closeContext(queryCtx);
2979: RETURN result;
2980:

Line 2978: DBMS_XMLGEN.closeContext(queryCtx);

2974: --DBMS_XMLGEN.useNullAttributeIndicator(queryCtx,TRUE);
2975:
2976: result := DBMS_XMLGEN.getXml(queryCtx);
2977:
2978: DBMS_XMLGEN.closeContext(queryCtx);
2979: RETURN result;
2980:
2981: EXCEPTION
2982: WHEN OTHERS THEN