1: PACKAGE BODY okl_trx_quotes_pub AS
2: /* $Header: OKLPQTEB.pls 120.3 2007/12/17 11:23:59 ansethur ship $ */
3:
4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_trx_quotes_pub.';
9:
2: /* $Header: OKLPQTEB.pls 120.3 2007/12/17 11:23:59 ansethur ship $ */
3:
4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_trx_quotes_pub.';
9:
10: PROCEDURE insert_trx_quotes(
3:
4: -- GLOBAL VARIABLES
5: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
6: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_MODULE_NAME CONSTANT VARCHAR2(500) := 'okl.am.plsql.okl_trx_quotes_pub.';
9:
10: PROCEDURE insert_trx_quotes(
11: p_api_version IN NUMBER