APPS.CST_UNINVOICEDRECEIPTS_PVT dependencies on DBMS_XMLGEN

Line 552: l_ctx DBMS_XMLGEN.CTXHANDLE;

548: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
549: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
550:
551: l_stmt_num NUMBER;
552: l_ctx DBMS_XMLGEN.CTXHANDLE;
553:
554: BEGIN
555:
556: l_stmt_num := 0;

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

581: l_return_status := FND_API.G_RET_STS_SUCCESS;
582:
583: -- create a new context with the SQL query
584: l_stmt_num := 10;
585: l_ctx := DBMS_XMLGEN.newContext (p_ref_cur);
586:
587: -- Add tag names for rows and row sets
588: l_stmt_num := 20;
589: DBMS_XMLGEN.setRowSetTag(l_ctx, p_row_tag);

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

585: l_ctx := DBMS_XMLGEN.newContext (p_ref_cur);
586:
587: -- Add tag names for rows and row sets
588: l_stmt_num := 20;
589: DBMS_XMLGEN.setRowSetTag(l_ctx, p_row_tag);
590: DBMS_XMLGEN.setRowTag(l_ctx, p_row_set_tag);
591:
592: -- generate XML data
593: l_stmt_num := 30;

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

586:
587: -- Add tag names for rows and row sets
588: l_stmt_num := 20;
589: DBMS_XMLGEN.setRowSetTag(l_ctx, p_row_tag);
590: DBMS_XMLGEN.setRowTag(l_ctx, p_row_set_tag);
591:
592: -- generate XML data
593: l_stmt_num := 30;
594: x_xml_data := DBMS_XMLGEN.getXML (l_ctx);

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

590: DBMS_XMLGEN.setRowTag(l_ctx, p_row_set_tag);
591:
592: -- generate XML data
593: l_stmt_num := 30;
594: x_xml_data := DBMS_XMLGEN.getXML (l_ctx);
595:
596: -- close the context
597: l_stmt_num := 40;
598: DBMS_XMLGEN.CLOSECONTEXT(l_ctx);

Line 598: DBMS_XMLGEN.CLOSECONTEXT(l_ctx);

594: x_xml_data := DBMS_XMLGEN.getXML (l_ctx);
595:
596: -- close the context
597: l_stmt_num := 40;
598: DBMS_XMLGEN.CLOSECONTEXT(l_ctx);
599:
600: -- Procedure level log message for exit point
601: IF (l_pLog) THEN
602: FND_LOG.STRING(

Line 688: l_ctx DBMS_XMLGEN.CTXHANDLE;

684: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
685: l_pLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
686: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
687:
688: l_ctx DBMS_XMLGEN.CTXHANDLE;
689: l_offset NUMBER;
690: l_stmt_num NUMBER;
691: l_length_src1 NUMBER;
692: l_length_src2 NUMBER;