APPS.OKL_AM_REPURCHASE_ASSET_PVT dependencies on OKL_TRX_QUOTES_B

Line 653: FROM okl_trx_quotes_b

649:
650: -- see if any quotes already exist for this asset return id
651: CURSOR l_qtev_csr (p_art_id NUMBER) IS
652: SELECT quote_number
653: FROM okl_trx_quotes_b
654: WHERE art_id = p_art_id;
655:
656: -- select the asset return id to see if valid
657:

Line 680: FROM okl_trx_quotes_b

676:
677: -- Select the accepted_yn flag
678: CURSOR l_acpt_csr (p_qte_id IN NUMBER) IS
679: SELECT accepted_yn
680: FROM okl_trx_quotes_b
681: WHERE ID = p_qte_id;
682:
683: -- SECHAWLA 22-JAN-03 Bug # 2762419 : Added this cursor to check the status of the asset line
684: CURSOR l_okclines_csr (p_kle_id IN NUMBER) IS

Line 2419: p_source_table => 'OKL_TRX_QUOTES_B'

2415: x_msg_data => x_msg_data,
2416: p_source_trx_id => lp_qtev_rec.ID,
2417: -- TRX_ID is QUOTE_ID
2418: p_source_trx_name => 'Estimated Billing',
2419: p_source_table => 'OKL_TRX_QUOTES_B'
2420: ); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
2421:
2422: IF (is_debug_statement_on) THEN
2423: okl_debug_pub.log_debug

Line 2420: ); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B

2416: p_source_trx_id => lp_qtev_rec.ID,
2417: -- TRX_ID is QUOTE_ID
2418: p_source_trx_name => 'Estimated Billing',
2419: p_source_table => 'OKL_TRX_QUOTES_B'
2420: ); -- SOURCE_TABLE IS OKL_TRX_QUOTES_B
2421:
2422: IF (is_debug_statement_on) THEN
2423: okl_debug_pub.log_debug
2424: (g_level_statement,