APPS.OKL_SPLIT_ASSET_PVT dependencies on FND_LOOKUPS

Line 1684: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

1680: l_template_tbl OKL_ACCOUNT_DIST_PVT.AVLV_TBL_TYPE;
1681: l_amount_tbl OKL_ACCOUNT_DIST_PVT.AMOUNT_TBL_TYPE;
1682: lx_template_tbl OKL_ACCOUNT_DIST_PUB.avlv_tbl_type;
1683: l_trx_desc VARCHAR2(2000);
1684: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1685: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1686: l_try_name VARCHAR2(30);
1687: l_trans_code VARCHAR2(30);
1688: l_tcn_type VARCHAR2(3);

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

1710: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1711: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1712: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1713:
1714: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
1715: select description,
1716: lookup_code
1717: from fnd_lookup_values
1718: where language = 'US'

Line 1722: l_fnd_rec fnd_lookups_csr%ROWTYPE;

1718: where language = 'US'
1719: and lookup_type = lkp_type
1720: and meaning = mng;
1721:
1722: l_fnd_rec fnd_lookups_csr%ROWTYPE;
1723:
1724: BEGIN
1725: -- Set API savepoint
1726: SAVEPOINT process_split_accounting_PVT;

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

2055: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2056: RAISE Okl_Api.G_EXCEPTION_ERROR;
2057: END IF;
2058:
2059: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2060: FETCH fnd_lookups_csr INTO l_fnd_rec;
2061: IF fnd_lookups_csr%NOTFOUND THEN
2062: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2063: CLOSE fnd_lookups_csr;

Line 2060: FETCH fnd_lookups_csr INTO l_fnd_rec;

2056: RAISE Okl_Api.G_EXCEPTION_ERROR;
2057: END IF;
2058:
2059: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2060: FETCH fnd_lookups_csr INTO l_fnd_rec;
2061: IF fnd_lookups_csr%NOTFOUND THEN
2062: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2063: CLOSE fnd_lookups_csr;
2064: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 2061: IF fnd_lookups_csr%NOTFOUND THEN

2057: END IF;
2058:
2059: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2060: FETCH fnd_lookups_csr INTO l_fnd_rec;
2061: IF fnd_lookups_csr%NOTFOUND THEN
2062: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2063: CLOSE fnd_lookups_csr;
2064: RAISE Okl_Api.G_EXCEPTION_ERROR;
2065: END IF;

Line 2063: CLOSE fnd_lookups_csr;

2059: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
2060: FETCH fnd_lookups_csr INTO l_fnd_rec;
2061: IF fnd_lookups_csr%NOTFOUND THEN
2062: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2063: CLOSE fnd_lookups_csr;
2064: RAISE Okl_Api.G_EXCEPTION_ERROR;
2065: END IF;
2066: CLOSE fnd_lookups_csr;
2067:

Line 2066: CLOSE fnd_lookups_csr;

2062: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE,OKL_API.G_COL_NAME_TOKEN,l_try_name);
2063: CLOSE fnd_lookups_csr;
2064: RAISE Okl_Api.G_EXCEPTION_ERROR;
2065: END IF;
2066: CLOSE fnd_lookups_csr;
2067:
2068: --From the l_amount_out_tbl returned , the transaction line amount and header amount need to be updated back on the contract
2069: l_tclv_tbl := x_tclv_tbl;
2070: l_tcnv_rec := l_trxH_out_rec;