DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKL_TRX_CONTRACTS

Line 5514: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5510: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
5511: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5512: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5513:
5514: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5515: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5516:
5517: i NUMBER;
5518: l_tcnCode VARCHAR2(256);

Line 5515: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5511: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5512: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5513:
5514: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5515: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5516:
5517: i NUMBER;
5518: l_tcnCode VARCHAR2(256);
5519: l_transaction_type VARCHAR2(256) := 'Miscellaneous';--'Generate Yields';

Line 5745: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5741: pl_khrv_rec okl_contract_pvt.khrv_rec_type;
5742: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5743: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5744:
5745: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5746: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5747: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
5748: l_strm_rec strm_csr%ROWTYPE;
5749: l_strms_rec strms_csr%ROWTYPE;

Line 5746: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

5742: xl_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
5743: xl_khrv_rec okl_contract_pub.khrv_rec_type;
5744:
5745: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5746: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
5747: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
5748: l_strm_rec strm_csr%ROWTYPE;
5749: l_strms_rec strms_csr%ROWTYPE;
5750:

Line 6522: okl_trx_contracts ktrx,

6518: --Cursor to check whether it is a partial termination mass rebook transaction
6519: CURSOR l_chk_mass_rbk_csr IS
6520: SELECT '!'
6521: FROM okc_k_headers_b CHR,
6522: okl_trx_contracts ktrx,
6523: okl_trx_contracts trx
6524: WHERE CHR.ID = p_chr_id
6525: AND ktrx.KHR_ID = chr.id
6526: AND ktrx.tsu_code = 'ENTERED'

Line 6523: okl_trx_contracts trx

6519: CURSOR l_chk_mass_rbk_csr IS
6520: SELECT '!'
6521: FROM okc_k_headers_b CHR,
6522: okl_trx_contracts ktrx,
6523: okl_trx_contracts trx
6524: WHERE CHR.ID = p_chr_id
6525: AND ktrx.KHR_ID = chr.id
6526: AND ktrx.tsu_code = 'ENTERED'
6527: AND ktrx.rbr_code IS NOT NULL

Line 6666: okl_trx_contracts ktrx,

6662:
6663: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
6664: SELECT 'Y'
6665: FROM okc_k_headers_b CHR,
6666: okl_trx_contracts ktrx,
6667: okl_trx_contracts trx,
6668: okl_txl_quote_lines_b txl
6669: WHERE CHR.ID = p_chr_id
6670: AND ktrx.KHR_ID = chr.id

Line 6667: okl_trx_contracts trx,

6663: CURSOR chk_curr_terminated_line(p_kle_id IN OKC_K_LINES_B.ID%TYPE) IS
6664: SELECT 'Y'
6665: FROM okc_k_headers_b CHR,
6666: okl_trx_contracts ktrx,
6667: okl_trx_contracts trx,
6668: okl_txl_quote_lines_b txl
6669: WHERE CHR.ID = p_chr_id
6670: AND ktrx.KHR_ID = chr.id
6671: AND ktrx.tsu_code = 'ENTERED'

Line 7100: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

7096: xl_khrv_rec okl_contract_pub.khrv_rec_type;
7097:
7098: l_chr_yields yields_rec_type;
7099:
7100: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7101: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7102: -- Code for bulk update -02/18/2004 - HKPATEL
7103: l_id_tbl okl_streams_util.NumberTabTyp;
7104: -- Code for bulk update ends here -02/18/2004 - HKPATEL

Line 7101: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

7097:
7098: l_chr_yields yields_rec_type;
7099:
7100: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7101: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
7102: -- Code for bulk update -02/18/2004 - HKPATEL
7103: l_id_tbl okl_streams_util.NumberTabTyp;
7104: -- Code for bulk update ends here -02/18/2004 - HKPATEL
7105:

Line 19372: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

19368: l_isStrmGenAllowed BOOLEAN := TRUE;
19369: l_passStatus VARCHAR2(256);
19370: l_failStatus VARCHAR2(256);
19371:
19372: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19373: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19374:
19375: l_lines_rec l_line_rec_csr%ROWTYPE;
19376: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';

Line 19373: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

19369: l_passStatus VARCHAR2(256);
19370: l_failStatus VARCHAR2(256);
19371:
19372: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19373: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19374:
19375: l_lines_rec l_line_rec_csr%ROWTYPE;
19376: l_transaction_type VARCHAR2(256):= 'Miscellaneous';--'Generate Yields';
19377: l_request_id NUMBER;

Line 19616: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

19612: l_isStrmGenAllowed BOOLEAN := TRUE;
19613: l_passStatus VARCHAR2(256);
19614: l_failStatus VARCHAR2(256);
19615:
19616: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19617: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19618:
19619: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
19620: x_stmv_tbl okl_streams_pub.stmv_tbl_type;

Line 19617: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;

19613: l_passStatus VARCHAR2(256);
19614: l_failStatus VARCHAR2(256);
19615:
19616: l_trxH_in_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19617: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
19618:
19619: l_stmv_tbl okl_streams_pub.stmv_tbl_type;
19620: x_stmv_tbl okl_streams_pub.stmv_tbl_type;
19621: