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_SPLIT_CONTRACT_PVT dependencies on OKL_TRX_CONTRACTS

Line 904: x_transaction_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,

900: x_return_status OUT NOCOPY VARCHAR2,
901: x_msg_count OUT NOCOPY NUMBER,
902: x_msg_data OUT NOCOPY VARCHAR2,
903: x_process_action OUT NOCOPY VARCHAR2,
904: x_transaction_id OUT NOCOPY OKL_TRX_CONTRACTS.ID%TYPE,
905: x_child_chrid1 OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE,
906: x_child_chrid2 OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE,
907: p_contract_id IN OKC_K_HEADERS_V.ID%TYPE) IS
908:

Line 912: ln_transaction_id OKL_TRX_CONTRACTS.ID%TYPE;

908:
909: l_api_name CONSTANT VARCHAR2(30) := 'check_split_process';
910: ln_split_contract1 OKC_K_HEADERS_B.ID%TYPE := NULL;
911: ln_split_contract2 OKC_K_HEADERS_B.ID%TYPE := NULL;
912: ln_transaction_id OKL_TRX_CONTRACTS.ID%TYPE;
913: ln_contract_id NUMBER := 0;
914: lb_value BOOLEAN := FALSE;
915:
916:

Line 928: FROM okl_trx_contracts

924:
925: -- To get the transaction created for the contract.
926: CURSOR c_get_transaction_id(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
927: SELECT id
928: FROM okl_trx_contracts
929: WHERE khr_id = p_chr_id
930: AND tcn_type = 'SPLC'
931: --rkuttiya added for 12.1.1 Multi GAAP
932: AND representation_type = 'PRIMARY'

Line 1010: p_token1_value => 'OKL_TRX_CONTRACTS.ID');

1006: ELSIF c_get_transaction_id%NOTFOUND THEN
1007: OKL_API.set_message(p_app_name => G_APP_NAME,
1008: p_msg_name => G_REQUIRED_VALUE,
1009: p_token1 => G_COL_NAME_TOKEN,
1010: p_token1_value => 'OKL_TRX_CONTRACTS.ID');
1011: -- halt validation as it is a required field
1012: RAISE G_EXCEPTION_STOP_VALIDATION;
1013: END IF;
1014: CLOSE c_get_transaction_id;

Line 1558: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

1554:
1555: l_api_name CONSTANT VARCHAR2(30) := 'LOCAL_DEL_CONTRACT_LINE';
1556: l_chrv_rec chrv_rec_type;
1557: l_khrv_rec khrv_rec_type;
1558: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1559: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1560: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
1561: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1562: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

Line 1559: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

1555: l_api_name CONSTANT VARCHAR2(30) := 'LOCAL_DEL_CONTRACT_LINE';
1556: l_chrv_rec chrv_rec_type;
1557: l_khrv_rec khrv_rec_type;
1558: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1559: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1560: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
1561: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1562: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1563:

Line 1562: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

1558: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1559: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1560: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
1561: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1562: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1563:
1564: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1565: SELECT id stm_id
1566: FROM OKL_STREAMS

Line 1571: FROM OKL_TRX_CONTRACTS

1567: WHERE khr_id = p_khr_id;
1568:
1569: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1570: SELECT id trx_id
1571: FROM OKL_TRX_CONTRACTS
1572: WHERE khr_id = p_khr_id
1573: --rkuttiya added for 12.1.1 Multi GAAP
1574: AND representation_type = 'PRIMARY';
1575:

Line 1601: FROM okl_trx_contracts trx,

1597:
1598: -- To get status of splited transaction Chr id
1599: CURSOR get_trx_id(p_org_sys_id OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE) IS
1600: SELECT trx.id trx_id
1601: FROM okl_trx_contracts trx,
1602: okl_trx_types_tl try,
1603: okc_k_headers_b CHR
1604: WHERE try.name = 'Split Contract'
1605: AND try.LANGUAGE = 'US'

Line 1645: -- Process the okl_trx_contracts

1641: -- get Trx id
1642: OPEN get_trx_id(p_org_sys_id => ln_orig_system_id1);
1643: FETCH get_trx_id INTO l_tcnv_rec.id;
1644: IF get_trx_id%FOUND THEN
1645: -- Process the okl_trx_contracts
1646: l_tcnv_rec.tsu_code := 'CANCELED';
1647: Okl_Trx_Contracts_Pub.update_trx_contracts(
1648: p_api_version => p_api_version,
1649: p_init_msg_list => p_init_msg_list,

Line 1647: Okl_Trx_Contracts_Pub.update_trx_contracts(

1643: FETCH get_trx_id INTO l_tcnv_rec.id;
1644: IF get_trx_id%FOUND THEN
1645: -- Process the okl_trx_contracts
1646: l_tcnv_rec.tsu_code := 'CANCELED';
1647: Okl_Trx_Contracts_Pub.update_trx_contracts(
1648: p_api_version => p_api_version,
1649: p_init_msg_list => p_init_msg_list,
1650: x_return_status => x_return_status,
1651: x_msg_count => x_msg_count,

Line 1714: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(

1710: END IF;
1711: -- Deleting the transctions of the journal Entries
1712: FOR r_get_je_trans IN c_get_je_trans(p_khr_id => p_contract_id) LOOP
1713: r_tcnv_rec.id := r_get_je_trans.trx_id;
1714: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
1715: p_api_version => p_api_version,
1716: p_init_msg_list => p_init_msg_list,
1717: x_return_status => x_return_status,
1718: x_msg_count => x_msg_count,

Line 1892: ln_transaction_id OKL_TRX_CONTRACTS.ID%TYPE;

1888:
1889: l_api_name CONSTANT VARCHAR2(30) := 'cancel_split_process';
1890: ln_split_contract1 OKC_K_HEADERS_B.ID%TYPE := NULL;
1891: ln_split_contract2 OKC_K_HEADERS_B.ID%TYPE := NULL;
1892: ln_transaction_id OKL_TRX_CONTRACTS.ID%TYPE;
1893: ln_contract_id NUMBER := 0;
1894: lb_value BOOLEAN := FALSE;
1895: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1896: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

Line 1895: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

1891: ln_split_contract2 OKC_K_HEADERS_B.ID%TYPE := NULL;
1892: ln_transaction_id OKL_TRX_CONTRACTS.ID%TYPE;
1893: ln_contract_id NUMBER := 0;
1894: lb_value BOOLEAN := FALSE;
1895: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1896: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1897:
1898: -- To check the existence of the contract.
1899: CURSOR c_get_contract(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

Line 1896: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

1892: ln_transaction_id OKL_TRX_CONTRACTS.ID%TYPE;
1893: ln_contract_id NUMBER := 0;
1894: lb_value BOOLEAN := FALSE;
1895: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1896: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1897:
1898: -- To check the existence of the contract.
1899: CURSOR c_get_contract(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
1900: SELECT 1

Line 1909: FROM okl_trx_contracts trx,

1905:
1906: -- To get the transaction created for the contract.
1907: CURSOR c_get_trx_id(p_chr_id OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE) IS
1908: SELECT trx.id trx_id
1909: FROM okl_trx_contracts trx,
1910: okl_trx_types_tl try
1911: WHERE try.name = 'Split Contract'
1912: AND try.LANGUAGE = 'US'
1913: AND trx.try_id = try.id

Line 1985: Okl_Trx_Contracts_Pub.update_trx_contracts(

1981: FETCH c_get_trx_id INTO l_tcnv_rec.id;
1982: IF c_get_trx_id%FOUND THEN
1983: -- Cancel the transaction for Split Conntract.
1984: l_tcnv_rec.tsu_code := 'CANCELED';
1985: Okl_Trx_Contracts_Pub.update_trx_contracts(
1986: p_api_version => p_api_version,
1987: p_init_msg_list => p_init_msg_list,
1988: x_return_status => x_return_status,
1989: x_msg_count => x_msg_count,

Line 3294: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

3290: l_cimv_rec cimv_rec_type;
3291: lx_cimv_rec cimv_rec_type;
3292: l_trxv_rec trxv_rec_type;
3293: lx_trxv_rec trxv_rec_type;
3294: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
3295: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
3296:
3297: -- rravikir added for Bug 2927173, 2901442
3298: lprv_rec OKL_REV_LOSS_PROV_PVT.lprv_rec_type;

Line 3295: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;

3291: lx_cimv_rec cimv_rec_type;
3292: l_trxv_rec trxv_rec_type;
3293: lx_trxv_rec trxv_rec_type;
3294: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
3295: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
3296:
3297: -- rravikir added for Bug 2927173, 2901442
3298: lprv_rec OKL_REV_LOSS_PROV_PVT.lprv_rec_type;
3299: ln_orig_contract_id OKC_K_HEADERS_B.ID%TYPE;

Line 3302: ld_split_date OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE;

3298: lprv_rec OKL_REV_LOSS_PROV_PVT.lprv_rec_type;
3299: ln_orig_contract_id OKC_K_HEADERS_B.ID%TYPE;
3300: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
3301: ld_contract_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
3302: ld_split_date OKL_TRX_CONTRACTS.DATE_TRANSACTION_OCCURRED%TYPE;
3303: -- end for Bug 2927173, 2901442
3304:
3305: -- rravikir added for Bug 3487162
3306: l_gl_date DATE;

Line 3335: FROM okl_trx_contracts trx,

3331: CURSOR check_split_k_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
3332: SELECT 1
3333: FROM dual
3334: WHERE EXISTS (SELECT 1
3335: FROM okl_trx_contracts trx,
3336: okl_trx_types_tl try,
3337: okl_k_headers khr
3338: WHERE try.name = 'Split Contract'
3339: AND try.LANGUAGE = 'US'

Line 3360: FROM okl_trx_contracts trx,

3356: CURSOR check_ctrct_status(p_chr_id OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE) IS
3357: SELECT CHR.id chr_id,
3358: sts_code sts_code,
3359: trx.id trx_id
3360: FROM okl_trx_contracts trx,
3361: okl_trx_types_tl try,
3362: okc_k_headers_b CHR
3363: WHERE try.name = 'Split Contract'
3364: AND try.LANGUAGE = 'US'

Line 3414: OKL_TRX_CONTRACTS TRX

3410: -- rravikir added - Bug 2927173, 2901442
3411: CURSOR get_split_info(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
3412: SELECT KHR.ID, KHR.CONTRACT_NUMBER, KHR.START_DATE, TRX.DATE_TRANSACTION_OCCURRED
3413: FROM OKC_K_HEADERS_B KHR,
3414: OKL_TRX_CONTRACTS TRX
3415: WHERE TRX.KHR_ID = KHR.ID
3416: AND TRX.TSU_CODE = 'PROCESSED'
3417: AND TRX.TCN_TYPE = 'SPLC'
3418: --rkuttiya added for 12.1.1 Multi GAAP

Line 3764: p_token1_value => 'OKL_TRX_CONTRACTS.ID');

3760: IF check_ctrct_status%NOTFOUND THEN
3761: OKL_API.set_message(p_app_name => G_APP_NAME,
3762: p_msg_name => G_NO_MATCHING_RECORD,
3763: p_token1 => G_COL_NAME_TOKEN,
3764: p_token1_value => 'OKL_TRX_CONTRACTS.ID');
3765: x_return_status := OKL_API.G_RET_STS_ERROR;
3766: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
3767: END IF;
3768: i := i + 1;

Line 3792: Okl_Trx_Contracts_Pub.update_trx_contracts(

3788: IF lv_ok_to_terminate_orig_K = 'Y' THEN
3789: -- Now since both the contract booked we can safely update the
3790: -- Transaction to PROCESSED
3791: l_tcnv_rec.tsu_code := 'PROCESSED';
3792: Okl_Trx_Contracts_Pub.update_trx_contracts(
3793: p_api_version => p_api_version,
3794: p_init_msg_list => p_init_msg_list,
3795: x_return_status => x_return_status,
3796: x_msg_count => x_msg_count,

Line 4558: ,okl_trx_contracts trxb

4554: CURSOR l_old_chr_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE) IS
4555: SELECT chrb.orig_system_id1 old_chr_id
4556: ,trxb.date_transaction_occurred date_transaction_occurred
4557: FROM okc_k_headers_b chrb
4558: ,okl_trx_contracts trxb
4559: ,okl_trx_types_b tryv
4560: WHERE chrb.id = p_khr_id
4561: -- AND trxb.khr_id_old = chrb.orig_system_id1
4562: AND trxb.khr_id = chrb.id

Line 4571: ,okl_trx_contracts trxb1

4567: CURSOR l_old_chr_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE) IS
4568: SELECT chrb.orig_system_id1 old_chr_id
4569: ,trxb2.date_transaction_occurred date_transaction_occurred
4570: FROM okc_k_headers_b chrb
4571: ,okl_trx_contracts trxb1
4572: ,okl_trx_types_b tryv
4573: ,okl_trx_contracts trxb2
4574: WHERE chrb.id = p_khr_id
4575: AND trxb1.khr_id = chrb.id

Line 4573: ,okl_trx_contracts trxb2

4569: ,trxb2.date_transaction_occurred date_transaction_occurred
4570: FROM okc_k_headers_b chrb
4571: ,okl_trx_contracts trxb1
4572: ,okl_trx_types_b tryv
4573: ,okl_trx_contracts trxb2
4574: WHERE chrb.id = p_khr_id
4575: AND trxb1.khr_id = chrb.id
4576: AND trxb1.tsu_code = 'PROCESSED'
4577: --rkuttiya added for 12.1.1 MUlti GAAP