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.

[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_TRX_CONTRACTS

Line 3178: okl_trx_contracts_all trx

3174: ,rbk_chr.start_date rbk_chr_start_date
3175: ,orig_chr.start_date orig_chr_start_date
3176: FROM okc_k_headers_all_b rbk_chr,
3177: okc_k_headers_all_b orig_chr,
3178: okl_trx_contracts_all trx
3179: WHERE rbk_chr.id = p_khr_id
3180: AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
3181: AND trx.khr_id_new = rbk_chr.id
3182: AND trx.tsu_code = 'ENTERED'

Line 3194: okl_trx_contracts_all trx

3190: 'MASS_REBOOK' rebook_type
3191: ,orig_chr.start_date rbk_chr_start_date
3192: ,orig_chr.start_date orig_chr_start_date
3193: FROM okc_k_headers_all_b orig_chr,
3194: okl_trx_contracts_all trx
3195: WHERE orig_chr.id = p_khr_id
3196: AND trx.khr_id = orig_chr.id
3197: AND trx.tsu_code = 'ENTERED'
3198: AND trx.tcn_type = 'TRBK'

Line 6624: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

6620: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
6621: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6622: xl_khrv_rec okl_contract_pub.khrv_rec_type;
6623:
6624: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
6625: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
6626:
6627: i NUMBER;
6628: l_tcnCode VARCHAR2(256);

Line 6625: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

6621: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
6622: xl_khrv_rec okl_contract_pub.khrv_rec_type;
6623:
6624: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
6625: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
6626:
6627: i NUMBER;
6628: l_tcnCode VARCHAR2(256);
6629: l_transaction_type VARCHAR2(256) := 'Miscellaneous';--'Generate Yields';

Line 7049: okl_trx_contracts ktrx,

7045: --Cursor to check whether it is a partial termination mass rebook transaction
7046: CURSOR l_chk_mass_rbk_csr IS
7047: SELECT '!'
7048: FROM okc_k_headers_b CHR,
7049: okl_trx_contracts ktrx,
7050: okl_trx_contracts trx
7051: WHERE CHR.ID = p_chr_id
7052: AND ktrx.KHR_ID = chr.id
7053: AND ktrx.tsu_code = 'ENTERED'

Line 7050: okl_trx_contracts trx

7046: CURSOR l_chk_mass_rbk_csr IS
7047: SELECT '!'
7048: FROM okc_k_headers_b CHR,
7049: okl_trx_contracts ktrx,
7050: okl_trx_contracts trx
7051: WHERE CHR.ID = p_chr_id
7052: AND ktrx.KHR_ID = chr.id
7053: AND ktrx.tsu_code = 'ENTERED'
7054: AND ktrx.rbr_code IS NOT NULL

Line 7161: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

7157: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
7158: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7159: xl_khrv_rec okl_contract_pub.khrv_rec_type;
7160:
7161: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7162: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7163: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
7164: l_strm_rec strm_csr%ROWTYPE;
7165: l_strms_rec strms_csr%ROWTYPE;

Line 7162: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

7158: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
7159: xl_khrv_rec okl_contract_pub.khrv_rec_type;
7160:
7161: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7162: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7163: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
7164: l_strm_rec strm_csr%ROWTYPE;
7165: l_strms_rec strms_csr%ROWTYPE;
7166:

Line 7960: okl_trx_contracts ktrx,

7956: --Cursor to check whether it is a partial termination mass rebook transaction
7957: CURSOR l_chk_mass_rbk_csr IS
7958: SELECT '!'
7959: FROM okc_k_headers_b CHR,
7960: okl_trx_contracts ktrx,
7961: okl_trx_contracts trx
7962: WHERE CHR.ID = p_chr_id
7963: AND ktrx.KHR_ID = chr.id
7964: AND ktrx.tsu_code = 'ENTERED'

Line 7961: okl_trx_contracts trx

7957: CURSOR l_chk_mass_rbk_csr IS
7958: SELECT '!'
7959: FROM okc_k_headers_b CHR,
7960: okl_trx_contracts ktrx,
7961: okl_trx_contracts trx
7962: WHERE CHR.ID = p_chr_id
7963: AND ktrx.KHR_ID = chr.id
7964: AND ktrx.tsu_code = 'ENTERED'
7965: AND ktrx.rbr_code IS NOT NULL

Line 8105: okl_trx_contracts ktrx,

8101:
8102: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
8103: SELECT 'Y'
8104: FROM okc_k_headers_b CHR,
8105: okl_trx_contracts ktrx,
8106: okl_trx_contracts trx,
8107: okl_txl_quote_lines_b txl
8108: WHERE CHR.ID = p_chr_id
8109: AND ktrx.KHR_ID = chr.id

Line 8106: okl_trx_contracts trx,

8102: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
8103: SELECT 'Y'
8104: FROM okc_k_headers_b CHR,
8105: okl_trx_contracts ktrx,
8106: okl_trx_contracts trx,
8107: okl_txl_quote_lines_b txl
8108: WHERE CHR.ID = p_chr_id
8109: AND ktrx.KHR_ID = chr.id
8110: AND ktrx.tsu_code = 'ENTERED'

Line 8130: okl_trx_contracts ktrx,

8126: AND TXL.QTE_ID = TRX.QTE_ID
8127: UNION -- 24-Mar-2008 sechawla FP fix 7445633 for base bug 7421107 : Added union part
8128: SELECT 'Y'
8129: FROM okc_k_headers_b CHR,
8130: okl_trx_contracts ktrx,
8131: okl_trx_contracts trx,
8132: okl_txl_quote_lines_b txl
8133: , OKC_K_ITEMS LNK_ITM
8134: WHERE CHR.ID = p_chr_id

Line 8131: okl_trx_contracts trx,

8127: UNION -- 24-Mar-2008 sechawla FP fix 7445633 for base bug 7421107 : Added union part
8128: SELECT 'Y'
8129: FROM okc_k_headers_b CHR,
8130: okl_trx_contracts ktrx,
8131: okl_trx_contracts trx,
8132: okl_txl_quote_lines_b txl
8133: , OKC_K_ITEMS LNK_ITM
8134: WHERE CHR.ID = p_chr_id
8135: AND ktrx.KHR_ID = chr.id

Line 8594: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

8590: xl_khrv_rec okl_contract_pub.khrv_rec_type;
8591:
8592: l_chr_yields yields_rec_type;
8593:
8594: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
8595: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
8596: -- Code for bulk update -02/18/2004 - HKPATEL
8597: l_id_tbl okl_streams_util.NumberTabTyp;
8598: -- Code for bulk update ends here -02/18/2004 - HKPATEL

Line 8595: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

8591:
8592: l_chr_yields yields_rec_type;
8593:
8594: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
8595: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
8596: -- Code for bulk update -02/18/2004 - HKPATEL
8597: l_id_tbl okl_streams_util.NumberTabTyp;
8598: -- Code for bulk update ends here -02/18/2004 - HKPATEL
8599:

Line 22163: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

22159: l_isStrmGenAllowed BOOLEAN := TRUE;
22160: l_passStatus VARCHAR2(256);
22161: l_failStatus VARCHAR2(256);
22162:
22163: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22164: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22165:
22166: l_lines_rec l_line_rec_csr%ROWTYPE;
22167: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';

Line 22164: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

22160: l_passStatus VARCHAR2(256);
22161: l_failStatus VARCHAR2(256);
22162:
22163: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22164: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22165:
22166: l_lines_rec l_line_rec_csr%ROWTYPE;
22167: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
22168: l_request_id NUMBER;

Line 22409: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

22405: l_isStrmGenAllowed BOOLEAN := TRUE;
22406: l_passStatus VARCHAR2(256);
22407: l_failStatus VARCHAR2(256);
22408:
22409: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22410: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22411:
22412: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
22413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 22410: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

22406: l_passStatus VARCHAR2(256);
22407: l_failStatus VARCHAR2(256);
22408:
22409: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22410: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
22411:
22412: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
22413: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
22414: