APPS.CST_UNINVOICEDRECEIPTS_PVT dependencies on DBMS_XMLGEN

Line 659: l_ctx DBMS_XMLGEN.CTXHANDLE;

655: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
656: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
657:
658: l_stmt_num NUMBER;
659: l_ctx DBMS_XMLGEN.CTXHANDLE;
660:
661: BEGIN
662:
663: l_stmt_num := 0;

Line 692: l_ctx := DBMS_XMLGEN.newContext (p_ref_cur);

688: l_return_status := FND_API.G_RET_STS_SUCCESS;
689:
690: -- create a new context with the SQL query
691: l_stmt_num := 10;
692: l_ctx := DBMS_XMLGEN.newContext (p_ref_cur);
693:
694: -- Add tag names for rows and row sets
695: l_stmt_num := 20;
696: DBMS_XMLGEN.setRowSetTag(l_ctx, p_row_tag);

Line 696: DBMS_XMLGEN.setRowSetTag(l_ctx, p_row_tag);

692: l_ctx := DBMS_XMLGEN.newContext (p_ref_cur);
693:
694: -- Add tag names for rows and row sets
695: l_stmt_num := 20;
696: DBMS_XMLGEN.setRowSetTag(l_ctx, p_row_tag);
697: DBMS_XMLGEN.setRowTag(l_ctx, p_row_set_tag);
698:
699: -- generate XML data
700: l_stmt_num := 30;

Line 697: DBMS_XMLGEN.setRowTag(l_ctx, p_row_set_tag);

693:
694: -- Add tag names for rows and row sets
695: l_stmt_num := 20;
696: DBMS_XMLGEN.setRowSetTag(l_ctx, p_row_tag);
697: DBMS_XMLGEN.setRowTag(l_ctx, p_row_set_tag);
698:
699: -- generate XML data
700: l_stmt_num := 30;
701: x_xml_data := DBMS_XMLGEN.getXML (l_ctx);

Line 701: x_xml_data := DBMS_XMLGEN.getXML (l_ctx);

697: DBMS_XMLGEN.setRowTag(l_ctx, p_row_set_tag);
698:
699: -- generate XML data
700: l_stmt_num := 30;
701: x_xml_data := DBMS_XMLGEN.getXML (l_ctx);
702:
703: -- close the context
704: l_stmt_num := 40;
705: DBMS_XMLGEN.CLOSECONTEXT(l_ctx);

Line 705: DBMS_XMLGEN.CLOSECONTEXT(l_ctx);

701: x_xml_data := DBMS_XMLGEN.getXML (l_ctx);
702:
703: -- close the context
704: l_stmt_num := 40;
705: DBMS_XMLGEN.CLOSECONTEXT(l_ctx);
706:
707: -- Procedure level log message for exit point
708: IF (l_pLog) THEN
709: FND_LOG.STRING(

Line 795: l_ctx DBMS_XMLGEN.CTXHANDLE;

791: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
792: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
793: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
794:
795: l_ctx DBMS_XMLGEN.CTXHANDLE;
796: l_offset NUMBER;
797: l_stmt_num NUMBER;
798: l_length_src1 NUMBER;
799: l_length_src2 NUMBER;