APPS.OKL_LA_TRADEIN_PVT dependencies on OKC_K_HEADERS_B

Line 173: FROM okc_k_headers_b

169: WHERE id = p_cle_id;
170:
171: SELECT currency_code
172: INTO l_currency_code
173: FROM okc_k_headers_b
174: WHERE id = p_chr_id;
175:
176: l_link_asset_tbl := p_link_asset_tbl;
177:

Line 593: l_chr_id okc_k_headers_b.id%type := p_chr_id;

589:
590: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
591: lx_khrv_rec okl_khr_pvt.khrv_rec_type;
592:
593: l_chr_id okc_k_headers_b.id%type := p_chr_id;
594: l_tradein_date okl_k_headers.date_tradein%TYPE := p_tradein_date;
595: l_tradein_amount okl_k_headers.tradein_amount%TYPE := p_tradein_amount;
596: l_tradein_desc okl_k_headers.tradein_description%TYPE := p_tradein_desc;
597:

Line 877: l_chr_id okc_k_headers_b.id%type := p_chr_id;

873:
874: lx_klev_rec okl_kle_pvt.klev_rec_type;
875: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
876:
877: l_chr_id okc_k_headers_b.id%type := p_chr_id;
878:
879: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
880: l_api_version CONSTANT NUMBER := 1.0;
881: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 1056: l_chr_id okc_k_headers_b.id%type := p_chr_id;

1052:
1053: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1054: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1055:
1056: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1057:
1058: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
1059: l_api_version CONSTANT NUMBER := 1.0;
1060: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 1197: l_chr_id okc_k_headers_b.id%type := p_chr_id;

1193:
1194: lx_klev_rec okl_kle_pvt.klev_rec_type;
1195: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
1196:
1197: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1198:
1199: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
1200: l_api_version CONSTANT NUMBER := 1.0;
1201: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 1320: l_chr_id okc_k_headers_b.id%type := p_chr_id;

1316:
1317: lx_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;
1318: lx_klev_tbl OKL_KLE_PVT.klev_tbl_type;
1319:
1320: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1321:
1322: l_api_name CONSTANT VARCHAR2(30) := 'create_tradein';
1323: l_api_version CONSTANT NUMBER := 1.0;
1324: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 1423: l_chr_id okc_k_headers_b.id%type := null;

1419: x_msg_count OUT NOCOPY NUMBER,
1420: x_msg_data OUT NOCOPY VARCHAR2) IS
1421:
1422:
1423: l_chr_id okc_k_headers_b.id%type := null;
1424: l_cl_id okc_k_headers_b.id%type := null;
1425:
1426: l_api_name CONSTANT VARCHAR2(30) := 'allocate_amount';
1427: l_api_version CONSTANT NUMBER := 1.0;

Line 1424: l_cl_id okc_k_headers_b.id%type := null;

1420: x_msg_data OUT NOCOPY VARCHAR2) IS
1421:
1422:
1423: l_chr_id okc_k_headers_b.id%type := null;
1424: l_cl_id okc_k_headers_b.id%type := null;
1425:
1426: l_api_name CONSTANT VARCHAR2(30) := 'allocate_amount';
1427: l_api_version CONSTANT NUMBER := 1.0;
1428:

Line 1543: l_chr_id okc_k_headers_b.id%type := null;

1539:
1540: k BINARY_INTEGER := 1; -- create table index
1541: m BINARY_INTEGER := 1; -- update table index
1542: i number := 0;
1543: l_chr_id okc_k_headers_b.id%type := null;
1544: l_tradein_amount NUMBER := 0;
1545: l_asset_oec NUMBER;
1546: l_oec_total NUMBER := 0;
1547: l_assoc_amount NUMBER;

Line 1598: FROM okc_k_headers_b

1594: WHERE id = p_chr_id;
1595:
1596: SELECT currency_code
1597: INTO l_currency_code
1598: FROM okc_k_headers_b
1599: WHERE id = p_chr_id;
1600:
1601: IF (l_asset_tbl.COUNT > 0) THEN
1602:

Line 1823: l_chr_id okc_k_headers_b.id%type := p_chr_id;

1819:
1820: lx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1821: lx_khrv_rec okl_khr_pvt.khrv_rec_type;
1822:
1823: l_chr_id okc_k_headers_b.id%type := p_chr_id;
1824:
1825: l_api_name CONSTANT VARCHAR2(30) := 'delete_contract';
1826: l_api_version CONSTANT NUMBER := 1.0;
1827: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;