APPS.FUN_REPORT_PVT dependencies on DBMS_XMLGEN

Line 1312: l_ctx dbms_xmlgen.ctxHandle;

1308: ) IS
1309: l_api_name VARCHAR2(20);
1310: l_progress VARCHAR2(3);
1311:
1312: l_ctx dbms_xmlgen.ctxHandle;
1313: BEGIN
1314: l_api_name := 'get_xml';
1315: l_progress := '000';
1316:

Line 1323: l_ctx := DBMS_XMLGEN.newcontext(p_query);

1319: -- Initialize API return status to success
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321:
1322: l_progress := '010';
1323: l_ctx := DBMS_XMLGEN.newcontext(p_query);
1324: FUN_UTIL.log_conc_stmt(
1325: g_pkg_name, l_api_name, l_progress, 'l_ctx', l_ctx);
1326:
1327:

Line 1330: DBMS_XMLGEN.setRowSetTag(l_ctx, p_rowset_tag);

1326:
1327:
1328: -- change rowset tag
1329: IF p_rowset_tag IS NOT NULL THEN
1330: DBMS_XMLGEN.setRowSetTag(l_ctx, p_rowset_tag);
1331: END IF;
1332:
1333: -- change row tag
1334: IF p_row_tag IS NOT NULL THEN

Line 1335: DBMS_XMLGEN.setRowTag(l_ctx, p_row_tag);

1331: END IF;
1332:
1333: -- change row tag
1334: IF p_row_tag IS NOT NULL THEN
1335: DBMS_XMLGEN.setRowTag(l_ctx, p_row_tag);
1336: END IF;
1337:
1338:
1339: l_progress := '020';

Line 1340: x_xml := DBMS_XMLGEN.getXML(l_ctx);

1336: END IF;
1337:
1338:
1339: l_progress := '020';
1340: x_xml := DBMS_XMLGEN.getXML(l_ctx);
1341:
1342: DBMS_XMLGEN.closecontext(l_ctx);
1343:
1344: EXCEPTION

Line 1342: DBMS_XMLGEN.closecontext(l_ctx);

1338:
1339: l_progress := '020';
1340: x_xml := DBMS_XMLGEN.getXML(l_ctx);
1341:
1342: DBMS_XMLGEN.closecontext(l_ctx);
1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1347: DBMS_XMLGEN.closecontext(l_ctx);

1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347: DBMS_XMLGEN.closecontext(l_ctx);
1348: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
1349: RAISE;
1350: END get_xml;
1351: