APPS.LNS_APPROVAL_ACTION_PUB dependencies on DBMS_LOB

Line 586: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);

582:
583:
584: -- START OF BODY OF API
585: /* init all_statements clob */
586: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
587: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
588:
589: -- init;
590:

Line 587: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);

583:
584: -- START OF BODY OF API
585: /* init all_statements clob */
586: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
587: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
588:
589: -- init;
590:
591: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to do_create_approval_action proc');

Line 671: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,

667: IF (l_statement_xml IS NULL) THEN
668: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'There is no xml for Bill Statement');
669: ELSE
670: /* remove xml header */
671: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,
672: pattern => '>',
673: offset => 1,
674: nth => 1);
675: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Have removed header from the statement');

Line 676: dbms_lob.Append(g_last_all_statements, l_statement_xml);

672: pattern => '>',
673: offset => 1,
674: nth => 1);
675: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Have removed header from the statement');
676: dbms_lob.Append(g_last_all_statements, l_statement_xml);
677: END IF;
678:
679: END IF;
680: