APPS.OKL_SPLIT_ASSET_PVT dependencies on FND_LOOKUPS

Line 1712: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

1708: l_template_tbl OKL_ACCOUNT_DIST_PVT.AVLV_TBL_TYPE;
1709: l_amount_tbl OKL_ACCOUNT_DIST_PVT.AMOUNT_TBL_TYPE;
1710: lx_template_tbl OKL_ACCOUNT_DIST_PUB.avlv_tbl_type;
1711: l_trx_desc VARCHAR2(2000);
1712: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1713: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1714: l_try_name VARCHAR2(30);
1715: l_trans_code VARCHAR2(30);
1716: l_tcn_type VARCHAR2(3);

Line 1742: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS

1738: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1739: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1740: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1741:
1742: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
1743: select description,
1744: lookup_code
1745: from fnd_lookup_values
1746: where language = 'US'

Line 1750: l_fnd_rec fnd_lookups_csr%ROWTYPE;

1746: where language = 'US'
1747: and lookup_type = lkp_type
1748: and meaning = mng;
1749:
1750: l_fnd_rec fnd_lookups_csr%ROWTYPE;
1751:
1752: BEGIN
1753: -- Set API savepoint
1754: SAVEPOINT process_split_accounting_PVT;

Line 2087: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');

2083: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2084: RAISE Okl_Api.G_EXCEPTION_ERROR;
2085: END IF;
2086:
2087: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2088: FETCH fnd_lookups_csr INTO l_fnd_rec;
2089: IF fnd_lookups_csr%NOTFOUND THEN
2090: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2091: CLOSE fnd_lookups_csr;

Line 2088: FETCH fnd_lookups_csr INTO l_fnd_rec;

2084: RAISE Okl_Api.G_EXCEPTION_ERROR;
2085: END IF;
2086:
2087: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2088: FETCH fnd_lookups_csr INTO l_fnd_rec;
2089: IF fnd_lookups_csr%NOTFOUND THEN
2090: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2091: CLOSE fnd_lookups_csr;
2092: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2089: IF fnd_lookups_csr%NOTFOUND THEN

2085: END IF;
2086:
2087: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2088: FETCH fnd_lookups_csr INTO l_fnd_rec;
2089: IF fnd_lookups_csr%NOTFOUND THEN
2090: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2091: CLOSE fnd_lookups_csr;
2092: RAISE Okl_Api.G_EXCEPTION_ERROR;
2093: END IF;

Line 2091: CLOSE fnd_lookups_csr;

2087: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2088: FETCH fnd_lookups_csr INTO l_fnd_rec;
2089: IF fnd_lookups_csr%NOTFOUND THEN
2090: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2091: CLOSE fnd_lookups_csr;
2092: RAISE Okl_Api.G_EXCEPTION_ERROR;
2093: END IF;
2094: CLOSE fnd_lookups_csr;
2095:

Line 2094: CLOSE fnd_lookups_csr;

2090: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2091: CLOSE fnd_lookups_csr;
2092: RAISE Okl_Api.G_EXCEPTION_ERROR;
2093: END IF;
2094: CLOSE fnd_lookups_csr;
2095:
2096: --From the l_amount_out_tbl returned , the transaction line amount and header amount need to be updated back on the contract
2097: l_tclv_tbl := x_tclv_tbl;
2098: l_tcnv_rec := l_trxH_out_rec;