eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_QUOTES_WF dependencies on OKL_TRX_QUOTES_PUB

Line 2034: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

2030:
2031: l_id NUMBER;
2032: l_rule_khr_id NUMBER;
2033: l_qtp_code VARCHAR2(30);
2034: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
2035: l_rgd_code VARCHAR2(30);
2036:
2037: -- Get the quote khr_id
2038: CURSOR c_qte_csr(c_id NUMBER) IS

Line 3923: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;

3919: l_api_version NUMBER := 1;
3920: lx_msg_count NUMBER;
3921: lx_msg_data VARCHAR2(2000);
3922: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3923: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
3924: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
3925: l_quote_status VARCHAR2(200) := 'COMPLETE';--'OKL_QUOTE_STATUS'
3926: -- Start : PRASJAIN : Bug 6324373
3927: l_quote_status_err VARCHAR2(200) := 'ACCEPTED';--'OKL_QUOTE_STATUS'

Line 3924: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;

3920: lx_msg_count NUMBER;
3921: lx_msg_data VARCHAR2(2000);
3922: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3923: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
3924: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
3925: l_quote_status VARCHAR2(200) := 'COMPLETE';--'OKL_QUOTE_STATUS'
3926: -- Start : PRASJAIN : Bug 6324373
3927: l_quote_status_err VARCHAR2(200) := 'ACCEPTED';--'OKL_QUOTE_STATUS'
3928: l_tmt_status_code VARCHAR2(200);

Line 3973: OKL_TRX_QUOTES_PUB.update_trx_quotes (

3969: END IF;
3970: -- End : PRASJAIN : Bug 6324373
3971:
3972: -- Call the update of the quote header api
3973: OKL_TRX_QUOTES_PUB.update_trx_quotes (
3974: p_api_version => l_api_version,
3975: p_init_msg_list => OKL_API.G_FALSE,
3976: x_return_status => l_return_status,
3977: x_msg_count => lx_msg_count,

Line 3984: 'after call to OKL_TRX_QUOTES_PUB.update_trx_quotes :'||l_return_status);

3980: x_qtev_rec => lx_qtev_rec);
3981:
3982: IF (is_debug_statement_on) THEN
3983: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3984: 'after call to OKL_TRX_QUOTES_PUB.update_trx_quotes :'||l_return_status);
3985: END IF;
3986:
3987: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
3988: resultout := 'COMPLETE:N';

Line 5321: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

5317: l_partial_yn VARCHAR2(1);
5318: l_khr_id NUMBER;
5319: l_rule_khr_id NUMBER;
5320: l_qtp_code VARCHAR2(30);
5321: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
5322: l_rgd_code VARCHAR2(30);
5323:
5324: CURSOR c_qte_csr(c_id NUMBER) IS
5325: SELECT partial_yn, khr_id, qtp_code

Line 5577: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

5573: l_partial_yn VARCHAR2(1);
5574: l_khr_id NUMBER;
5575: l_rule_khr_id NUMBER;
5576: l_qtp_code VARCHAR2(30);
5577: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
5578: l_rgd_code VARCHAR2(30);
5579:
5580: --Rkuttiya 18-SEP-2003 added "last_updated by" column to the following cursor for bug 2794685
5581: CURSOR c_qte_csr(c_id NUMBER) IS

Line 6697: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;

6693: l_partial_yn VARCHAR2(1);
6694: l_khr_id NUMBER;
6695: l_rule_khr_id NUMBER;
6696: l_qtp_code VARCHAR2(30);
6697: l_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
6698: l_rgd_code VARCHAR2(30);
6699:
6700: l_quote_total NUMBER := 0;
6701: l_quote_net NUMBER := 0;

Line 8097: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;

8093: l_api_version NUMBER := 1;
8094: lx_msg_count NUMBER;
8095: lx_msg_data VARCHAR2(2000);
8096: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8097: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
8098: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
8099: l_quote_status VARCHAR2(200) := 'DRAFTED';--'OKL_QUOTE_STATUS'
8100: -- for debug logging
8101: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'update_quote_drafted';

Line 8098: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;

8094: lx_msg_count NUMBER;
8095: lx_msg_data VARCHAR2(2000);
8096: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8097: lp_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
8098: lx_qtev_rec OKL_TRX_QUOTES_PUB.qtev_rec_type;
8099: l_quote_status VARCHAR2(200) := 'DRAFTED';--'OKL_QUOTE_STATUS'
8100: -- for debug logging
8101: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'update_quote_drafted';
8102: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 8126: OKL_TRX_QUOTES_PUB.update_trx_quotes (

8122: lp_qtev_rec.id := TO_NUMBER(l_transaction_id);
8123: lp_qtev_rec.qst_code := l_quote_status;
8124:
8125: -- Call the update of the quote header api
8126: OKL_TRX_QUOTES_PUB.update_trx_quotes (
8127: p_api_version => l_api_version,
8128: p_init_msg_list => OKL_API.G_FALSE,
8129: x_return_status => l_return_status,
8130: x_msg_count => lx_msg_count,

Line 8137: 'after call to OKL_TRX_QUOTES_PUB.update_trx_quotes :'||l_return_status);

8133: x_qtev_rec => lx_qtev_rec);
8134:
8135: IF (is_debug_statement_on) THEN
8136: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
8137: 'after call to OKL_TRX_QUOTES_PUB.update_trx_quotes :'||l_return_status);
8138: END IF;
8139:
8140: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
8141: RAISE G_EXCEPTION;