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_CREATE_KLE_PVT dependencies on OKC_LINE_STYLES_V

Line 92: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';

88: G_FORMULA_OEC OKL_FORMULAE_V.NAME%TYPE := 'LINE_OEC';
89: G_FORMULA_CAP OKL_FORMULAE_V.NAME%TYPE := 'LINE_CAP_AMNT';
90: G_FORMULA_RES OKL_FORMULAE_V.NAME%TYPE := 'LINE_RESIDUAL_VALUE';
91: G_ID2 CONSTANT VARCHAR2(200) := '#';
92: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
93: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
94: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
95: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
96: G_QUOTE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'QUOTE';

Line 93: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';

89: G_FORMULA_CAP OKL_FORMULAE_V.NAME%TYPE := 'LINE_CAP_AMNT';
90: G_FORMULA_RES OKL_FORMULAE_V.NAME%TYPE := 'LINE_RESIDUAL_VALUE';
91: G_ID2 CONSTANT VARCHAR2(200) := '#';
92: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
93: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
94: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
95: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
96: G_QUOTE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'QUOTE';
97: ---------------------------------------------------------------------------------------------------------------

Line 1502: okc_line_styles_v lse

1498: /*FROM okc_k_items_v cim
1499: WHERE cim.dnz_chr_id = p_dnz_chr_id
1500: AND cim.cle_id in (SELECT cle.id
1501: FROM okc_k_lines_v cle,
1502: okc_line_styles_v lse
1503: WHERE cle.lse_id = lse.id
1504: AND lse.lty_code = 'ITEM'
1505: AND cle.dnz_chr_id = cim.dnz_chr_id
1506: AND cle.cle_id in (SELECT cle1.cle_id

Line 1796: FUNCTION get_lse_id(p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

1792: END IF;
1793: RETURN(x_return_status);
1794: END get_party_site_id;
1795: ---------------------------------------------------------------------------------------------
1796: FUNCTION get_lse_id(p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
1797: x_lse_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
1798: RETURN VARCHAR2 IS
1799: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1800:

Line 1797: x_lse_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)

1793: RETURN(x_return_status);
1794: END get_party_site_id;
1795: ---------------------------------------------------------------------------------------------
1796: FUNCTION get_lse_id(p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
1797: x_lse_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
1798: RETURN VARCHAR2 IS
1799: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1800:
1801: CURSOR c_get_lse_id1(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS

Line 1801: CURSOR c_get_lse_id1(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS

1797: x_lse_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
1798: RETURN VARCHAR2 IS
1799: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1800:
1801: CURSOR c_get_lse_id1(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1802: SELECT lse.id
1803: FROM okc_subclass_top_line stl,
1804: okc_line_styles_b lse
1805: WHERE lse.lty_code = G_FIN_LINE_LTY_CODE

Line 1811: CURSOR c_get_lse_id2(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS

1807: AND lse.lse_type = G_TLS_TYPE
1808: AND lse.id = stl.lse_id
1809: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
1810:
1811: CURSOR c_get_lse_id2(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1812: SELECT lse1.id
1813: FROM okc_subclass_top_line stl,
1814: okc_line_styles_b lse2,
1815: okc_line_styles_b lse1

Line 1822: CURSOR c_get_lse_id3(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE,

1818: AND lse1.lse_parent_id = lse2.id
1819: AND lse2.id = stl.lse_id
1820: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
1821:
1822: CURSOR c_get_lse_id3(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE,
1823: p_code2 OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1824: SELECT lse1.id
1825: FROM okc_subclass_top_line stl,
1826: okc_line_styles_b lse3,

Line 1823: p_code2 OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS

1819: AND lse2.id = stl.lse_id
1820: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
1821:
1822: CURSOR c_get_lse_id3(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE,
1823: p_code2 OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1824: SELECT lse1.id
1825: FROM okc_subclass_top_line stl,
1826: okc_line_styles_b lse3,
1827: okc_line_styles_b lse2,

Line 1842: p_token1_value => 'OKC_LINE_STYLES_V.LSE_TYPE');

1838: p_lty_code = OKL_API.G_MISS_CHAR) THEN
1839: OKL_API.set_message(p_app_name => G_APP_NAME,
1840: p_msg_name => G_REQUIRED_VALUE,
1841: p_token1 => G_COL_NAME_TOKEN,
1842: p_token1_value => 'OKC_LINE_STYLES_V.LSE_TYPE');
1843: x_return_status := OKL_API.G_RET_STS_ERROR;
1844: END IF;
1845: -- Top Line Line Style
1846: IF p_lty_code = G_FIN_LINE_LTY_CODE THEN

Line 1853: p_token1_value => 'OKC_LINE_STYLES_V.ID');

1849: IF c_get_lse_id1%NOTFOUND THEN
1850: OKL_API.set_message(p_app_name => G_APP_NAME,
1851: p_msg_name => G_NO_MATCHING_RECORD,
1852: p_token1 => G_COL_NAME_TOKEN,
1853: p_token1_value => 'OKC_LINE_STYLES_V.ID');
1854: x_return_status := OKL_API.G_RET_STS_ERROR;
1855: END IF;
1856: CLOSE c_get_lse_id1;
1857: -- Model Line, Fixed Asset line and Instance line

Line 1865: p_token1_value => 'OKC_LINE_STYLES_V.ID');

1861: IF c_get_lse_id2%NOTFOUND THEN
1862: OKL_API.set_message(p_app_name => G_APP_NAME,
1863: p_msg_name => G_NO_MATCHING_RECORD,
1864: p_token1 => G_COL_NAME_TOKEN,
1865: p_token1_value => 'OKC_LINE_STYLES_V.ID');
1866: x_return_status := OKL_API.G_RET_STS_ERROR;
1867: END IF;
1868: CLOSE c_get_lse_id2;
1869: -- Addon line and Install Base line

Line 1879: p_token1_value => 'OKC_LINE_STYLES_V.ID');

1875: IF c_get_lse_id3%NOTFOUND THEN
1876: OKL_API.set_message(p_app_name => G_APP_NAME,
1877: p_msg_name => G_NO_MATCHING_RECORD,
1878: p_token1 => G_COL_NAME_TOKEN,
1879: p_token1_value => 'OKC_LINE_STYLES_V.ID');
1880: x_return_status := OKL_API.G_RET_STS_ERROR;
1881: END IF;
1882: CLOSE c_get_lse_id3;
1883: ELSIF p_lty_code = G_ADDON_LINE_LTY_CODE THEN

Line 1891: p_token1_value => 'OKC_LINE_STYLES_V.ID');

1887: IF c_get_lse_id3%NOTFOUND THEN
1888: OKL_API.set_message(p_app_name => G_APP_NAME,
1889: p_msg_name => G_NO_MATCHING_RECORD,
1890: p_token1 => G_COL_NAME_TOKEN,
1891: p_token1_value => 'OKC_LINE_STYLES_V.ID');
1892: x_return_status := OKL_API.G_RET_STS_ERROR;
1893: END IF;
1894: CLOSE c_get_lse_id3;
1895: END IF;

Line 1925: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)

1921: RETURN(x_return_status);
1922: END get_lse_id;
1923: --------------------------------------------------------------------------------------------------
1924: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
1925: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
1926: RETURN VARCHAR2 IS
1927: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1928: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
1929: SELECT id

Line 3258: -- with OKC_LINE_STYLES_V

3254: -- Start of Commnets
3255: -- Badrinath Kuchibholta
3256: -- Procedure Name : validate_lse_id
3257: -- Description : validation and get the lty_code
3258: -- with OKC_LINE_STYLES_V
3259: -- Business Rules :
3260: -- Parameters :
3261: -- Version : 1.0
3262: -- End of Commnets

Line 3265: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,

3261: -- Version : 1.0
3262: -- End of Commnets
3263: PROCEDURE validate_lse_id(p_clev_rec IN clev_rec_type,
3264: x_return_status OUT NOCOPY VARCHAR2,
3265: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3266: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3267: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3268: SELECT lty_code,
3269: lse_type

Line 3266: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS

3262: -- End of Commnets
3263: PROCEDURE validate_lse_id(p_clev_rec IN clev_rec_type,
3264: x_return_status OUT NOCOPY VARCHAR2,
3265: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3266: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3267: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3268: SELECT lty_code,
3269: lse_type
3270: FROM OKC_LINE_STYLES_V

Line 3267: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS

3263: PROCEDURE validate_lse_id(p_clev_rec IN clev_rec_type,
3264: x_return_status OUT NOCOPY VARCHAR2,
3265: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3266: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3267: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3268: SELECT lty_code,
3269: lse_type
3270: FROM OKC_LINE_STYLES_V
3271: WHERE id = p_lse_id;

Line 3270: FROM OKC_LINE_STYLES_V

3266: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3267: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3268: SELECT lty_code,
3269: lse_type
3270: FROM OKC_LINE_STYLES_V
3271: WHERE id = p_lse_id;
3272: BEGIN
3273: -- initialize return status
3274: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3350: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

3346: -- Version : 1.0
3347: -- End of Commnets
3348:
3349: PROCEDURE validate_cle_lse_id(p_clev_rec IN clev_rec_type,
3350: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3351: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3352: x_return_status OUT NOCOPY VARCHAR2) IS
3353: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3354: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

Line 3351: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,

3347: -- End of Commnets
3348:
3349: PROCEDURE validate_cle_lse_id(p_clev_rec IN clev_rec_type,
3350: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3351: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3352: x_return_status OUT NOCOPY VARCHAR2) IS
3353: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3354: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3355: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

Line 3354: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

3350: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3351: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3352: x_return_status OUT NOCOPY VARCHAR2) IS
3353: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3354: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3355: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3356:
3357: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3358: SELECT lse.lty_code

Line 3355: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

3351: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3352: x_return_status OUT NOCOPY VARCHAR2) IS
3353: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3354: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3355: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3356:
3357: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3358: SELECT lse.lty_code
3359: FROM OKC_K_LINES_V cle,

Line 3360: OKC_LINE_STYLES_V lse

3356:
3357: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3358: SELECT lse.lty_code
3359: FROM OKC_K_LINES_V cle,
3360: OKC_LINE_STYLES_V lse
3361: WHERE cle.id = p_cle_id
3362: AND lse.id = cle.lse_id;
3363:
3364: BEGIN

Line 3867: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;

3863: PROCEDURE validate_sts_code(p_clev_rec IN clev_rec_type,
3864: x_return_status OUT NOCOPY VARCHAR2) IS
3865:
3866: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;
3867: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3868:
3869: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3870: SELECT lse.lty_code
3871: FROM OKC_LINE_STYLES_V lse

Line 3871: FROM OKC_LINE_STYLES_V lse

3867: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3868:
3869: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3870: SELECT lse.lty_code
3871: FROM OKC_LINE_STYLES_V lse
3872: WHERE lse.id = p_lse_id;
3873:
3874: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3875: p_cle_id OKC_K_LINES_V.ID%TYPE,

Line 3876: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS

3872: WHERE lse.id = p_lse_id;
3873:
3874: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3875: p_cle_id OKC_K_LINES_V.ID%TYPE,
3876: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3877: SELECT cle.sts_code
3878: FROM OKC_K_LINES_V cle
3879: WHERE cle.id in (SELECT cle.cle_id
3880: FROM OKC_K_LINES_V cle

Line 3882: FROM OKC_LINE_STYLES_V lse,

3878: FROM OKC_K_LINES_V cle
3879: WHERE cle.id in (SELECT cle.cle_id
3880: FROM OKC_K_LINES_V cle
3881: WHERE id in (SELECT cle.cle_id
3882: FROM OKC_LINE_STYLES_V lse,
3883: OKC_K_LINES_V cle
3884: WHERE dnz_chr_id = p_dnz_chr_id
3885: AND cle.lse_id = lse.id
3886: AND cle.id = p_cle_id

Line 3891: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS

3887: AND lse.lty_code = p_lty_code));
3888:
3889: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3890: p_cle_id OKC_K_LINES_V.ID%TYPE,
3891: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3892: SELECT cle.sts_code
3893: FROM OKC_K_LINES_V cle
3894: WHERE id in (SELECT cle.cle_id
3895: FROM OKC_LINE_STYLES_V lse,

Line 3895: FROM OKC_LINE_STYLES_V lse,

3891: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3892: SELECT cle.sts_code
3893: FROM OKC_K_LINES_V cle
3894: WHERE id in (SELECT cle.cle_id
3895: FROM OKC_LINE_STYLES_V lse,
3896: OKC_K_LINES_V cle
3897: WHERE dnz_chr_id = p_dnz_chr_id
3898: AND cle.lse_id = lse.id
3899: AND cle.id = p_cle_id

Line 5515: -- 4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

5511: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5512: x_return_status OUT NOCOPY VARCHAR2,
5513: x_msg_count OUT NOCOPY NUMBER,
5514: x_msg_data OUT NOCOPY VARCHAR2,
5515: -- 4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
5516: p_clev_rec IN clev_rec_type,
5517: p_klev_rec IN klev_rec_type,
5518: p_cimv_rec IN cimv_rec_type,
5519: x_clev_rec OUT NOCOPY clev_rec_type,

Line 5526: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

5522: l_clev_rec clev_rec_type;
5523: r_clev_rec clev_rec_type;
5524: l_talv_rec talv_rec_type;
5525: l_cimv_rec cimv_rec_type;
5526: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5527: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MODEL_ITEM';
5528:
5529: ------------------
5530: --Bug# 2994971

Line 5747: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

5743: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5744: x_return_status OUT NOCOPY VARCHAR2,
5745: x_msg_count OUT NOCOPY NUMBER,
5746: x_msg_data OUT NOCOPY VARCHAR2,
5747: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
5748: p_clev_rec IN clev_rec_type,
5749: p_klev_rec IN klev_rec_type,
5750: p_cimv_rec IN cimv_rec_type,
5751: x_clev_rec OUT NOCOPY clev_rec_type,

Line 5758: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

5754:
5755: l_clev_rec clev_rec_type;
5756: l_talv_rec talv_rec_type;
5757: l_cimv_rec cimv_rec_type;
5758: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5759: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MODEL_ITEM';
5760:
5761: ------------------
5762: --Bug# 2994971

Line 5912: -- p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

5908: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5909: x_return_status OUT NOCOPY VARCHAR2,
5910: x_msg_count OUT NOCOPY NUMBER,
5911: x_msg_data OUT NOCOPY VARCHAR2,
5912: -- p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
5913: -- 4414408
5914: p_clev_rec IN clev_rec_type,
5915: p_klev_rec IN klev_rec_type,
5916: p_cimv_rec IN cimv_rec_type,

Line 5931: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

5927: l_talv_rec talv_rec_type;
5928: l_trxv_rec trxv_rec_type;
5929: i NUMBER := 0;
5930:
5931: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5932: lv_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
5933: lv_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR;
5934: ln_dummy NUMBER := 0;
5935: lv_dummy VARCHAR2(3);

Line 6244: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

6240: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6241: x_return_status OUT NOCOPY VARCHAR2,
6242: x_msg_count OUT NOCOPY NUMBER,
6243: x_msg_data OUT NOCOPY VARCHAR2,
6244: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
6245: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6246: p_clev_rec IN clev_rec_type,
6247: p_klev_rec IN klev_rec_type,
6248: p_cimv_rec IN cimv_rec_type,

Line 6260: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6256: l_cimv_rec cimv_rec_type;
6257: l_talv_rec talv_rec_type;
6258: l_trxv_rec trxv_rec_type;
6259: i NUMBER := 0;
6260: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6261: ln_dummy NUMBER := 0;
6262: lv_dummy VARCHAR2(3);
6263: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
6264: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FA_LINE_ITEM';

Line 6420: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

6416: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6417: x_return_status OUT NOCOPY VARCHAR2,
6418: x_msg_count OUT NOCOPY NUMBER,
6419: x_msg_data OUT NOCOPY VARCHAR2,
6420: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
6421: p_clev_rec IN clev_rec_type,
6422: p_klev_rec IN klev_rec_type,
6423: p_cimv_rec IN cimv_rec_type,
6424: x_clev_rec OUT NOCOPY clev_rec_type,

Line 6430: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6426: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
6427: l_clev_rec clev_rec_type;
6428: r_clev_rec clev_rec_type;
6429: l_cimv_rec cimv_rec_type;
6430: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6431: i NUMBER := 0;
6432: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_ITEM';
6433: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6434: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;

Line 6629: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

6625: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6626: x_return_status OUT NOCOPY VARCHAR2,
6627: x_msg_count OUT NOCOPY NUMBER,
6628: x_msg_data OUT NOCOPY VARCHAR2,
6629: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
6630: p_clev_rec IN clev_rec_type,
6631: p_klev_rec IN klev_rec_type,
6632: p_cimv_rec IN cimv_rec_type,
6633: x_clev_rec OUT NOCOPY clev_rec_type,

Line 6639: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6635: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
6636: l_clev_rec clev_rec_type;
6637: l_klev_rec klev_rec_type;
6638: l_cimv_rec cimv_rec_type;
6639: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6640: i NUMBER;
6641: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_ITEM';
6642: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6643: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;

Line 6852: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6848: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
6849: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_REC';
6850: l_clev_rec clev_rec_type;
6851: -- Variables for validation of line style
6852: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6853: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6854: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6855:
6856: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

Line 6853: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

6849: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_REC';
6850: l_clev_rec clev_rec_type;
6851: -- Variables for validation of line style
6852: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6853: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6854: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6855:
6856: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 7050: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7046: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
7047: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_REC';
7048: l_clev_rec clev_rec_type;
7049: -- Variables for validation of line style
7050: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7051: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7052: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7053:
7054: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

Line 7051: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

7047: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_REC';
7048: l_clev_rec clev_rec_type;
7049: -- Variables for validation of line style
7050: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7051: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7052: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7053:
7054: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7055: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 7265: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7261: l_api_name CONSTANT VARCHAR2(30) := 'DEL_ADDON_REC';
7262: l_delete_clev_rec clev_rec_type;
7263: l_delete_klev_rec klev_rec_type;
7264: -- Variables for validation of line style
7265: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7266: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7267: BEGIN
7268: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7269: -- Call start_activity to create savepoint, check compatibility

Line 7266: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

7262: l_delete_clev_rec clev_rec_type;
7263: l_delete_klev_rec klev_rec_type;
7264: -- Variables for validation of line style
7265: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7266: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7267: BEGIN
7268: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7269: -- Call start_activity to create savepoint, check compatibility
7270: -- and initialize message list

Line 7422: -- #4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

7418: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7419: x_return_status OUT NOCOPY VARCHAR2,
7420: x_msg_count OUT NOCOPY NUMBER,
7421: x_msg_data OUT NOCOPY VARCHAR2,
7422: -- #4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
7423: p_clev_rec IN clev_rec_type,
7424: p_klev_rec IN klev_rec_type,
7425: x_clev_rec OUT NOCOPY clev_rec_type,
7426: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 7429: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7425: x_clev_rec OUT NOCOPY clev_rec_type,
7426: x_klev_rec OUT NOCOPY klev_rec_type) IS
7427: l_clev_rec clev_rec_type;
7428: r_clev_rec clev_rec_type;
7429: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7430:
7431: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTS_LINE';
7432: BEGIN
7433:

Line 7591: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

7587: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7588: x_return_status OUT NOCOPY VARCHAR2,
7589: x_msg_count OUT NOCOPY NUMBER,
7590: x_msg_data OUT NOCOPY VARCHAR2,
7591: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
7592: p_clev_rec IN clev_rec_type,
7593: p_klev_rec IN klev_rec_type,
7594: x_clev_rec OUT NOCOPY clev_rec_type,
7595: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 7598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7594: x_clev_rec OUT NOCOPY clev_rec_type,
7595: x_klev_rec OUT NOCOPY klev_rec_type) IS
7596:
7597: l_clev_rec clev_rec_type;
7598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7599:
7600: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INSTS_LINE';
7601: BEGIN
7602: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 7686: -- 4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

7682: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7683: x_return_status OUT NOCOPY VARCHAR2,
7684: x_msg_count OUT NOCOPY NUMBER,
7685: x_msg_data OUT NOCOPY VARCHAR2,
7686: -- 4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
7687: p_clev_rec IN clev_rec_type,
7688: p_klev_rec IN klev_rec_type,
7689: p_cimv_rec IN cimv_rec_type,
7690: p_itiv_rec IN itiv_rec_type,

Line 7701: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7697: r_clev_rec clev_rec_type;
7698: l_cimv_rec cimv_rec_type;
7699: r_cimv_rec cimv_rec_type;
7700: lv_dummy VARCHAR2(3) := OKL_API.G_MISS_CHAR ;
7701: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7702: l_itiv_rec itiv_rec_type;
7703: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_IB_LINE';
7704: BEGIN
7705: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 8036: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

8032: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8033: x_return_status OUT NOCOPY VARCHAR2,
8034: x_msg_count OUT NOCOPY NUMBER,
8035: x_msg_data OUT NOCOPY VARCHAR2,
8036: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
8037: p_clev_rec IN clev_rec_type,
8038: p_klev_rec IN klev_rec_type,
8039: p_cimv_rec IN cimv_rec_type,
8040: p_itiv_rec IN itiv_rec_type,

Line 8049: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

8045:
8046: l_clev_rec clev_rec_type;
8047: l_cimv_rec cimv_rec_type;
8048: l_itiv_rec itiv_rec_type;
8049: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8050: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
8051: lv_dummy VARCHAR2(3) := OKL_API.G_MISS_CHAR ;
8052: i NUMBER := 0;
8053: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_IB_LINE';

Line 8251: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

8247: x_klev_rec OUT NOCOPY klev_rec_type) IS
8248: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FIN_AST_LINES';
8249: l_clev_rec clev_rec_type;
8250: -- Variables for validation of line style
8251: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8252: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8253: BEGIN
8254: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8255: -- Call start_activity to create savepoint, check compatibility

Line 8252: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

8248: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FIN_AST_LINES';
8249: l_clev_rec clev_rec_type;
8250: -- Variables for validation of line style
8251: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8252: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8253: BEGIN
8254: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8255: -- Call start_activity to create savepoint, check compatibility
8256: -- and initialize message list

Line 8420: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

8416: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FIN_AST_LINES';
8417: l_clev_rec clev_rec_type := p_clev_rec;
8418: l_klev_rec klev_rec_type := p_klev_rec;
8419: -- Variables for validation of line style
8420: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8421: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8422: ln_fa_id OKC_K_LINES_V.ID%TYPE;
8423:
8424: -- Temp variables for capital reduction and tradein amount

Line 8421: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

8417: l_clev_rec clev_rec_type := p_clev_rec;
8418: l_klev_rec klev_rec_type := p_klev_rec;
8419: -- Variables for validation of line style
8420: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8421: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8422: ln_fa_id OKC_K_LINES_V.ID%TYPE;
8423:
8424: -- Temp variables for capital reduction and tradein amount
8425: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;

Line 9680: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

9676: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
9677: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MODEL_LINES';
9678: l_clev_rec clev_rec_type;
9679: -- Variables for validation of line style
9680: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9681: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9682: l_update_clev_rec clev_rec_type;
9683: l_update_klev_rec klev_rec_type;
9684: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;

Line 9681: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

9677: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MODEL_LINES';
9678: l_clev_rec clev_rec_type;
9679: -- Variables for validation of line style
9680: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9681: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9682: l_update_clev_rec clev_rec_type;
9683: l_update_klev_rec klev_rec_type;
9684: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
9685: l_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;

Line 9684: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;

9680: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9681: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9682: l_update_clev_rec clev_rec_type;
9683: l_update_klev_rec klev_rec_type;
9684: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
9685: l_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
9686:
9687: BEGIN
9688: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 9854: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

9850: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
9851: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MODEL_LINES';
9852: l_clev_rec clev_rec_type;
9853: -- Variables for validation of line style
9854: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9855: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9856: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9857:
9858: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

Line 9855: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

9851: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MODEL_LINES';
9852: l_clev_rec clev_rec_type;
9853: -- Variables for validation of line style
9854: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9855: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9856: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9857:
9858: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9859: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 10067: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

10063:
10064: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FXD_AST_LINES';
10065: l_clev_rec clev_rec_type;
10066: -- Variables for validation of line style
10067: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
10068: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
10069: BEGIN
10070: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10071: -- Call start_activity to create savepoint, check compatibility

Line 10068: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

10064: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FXD_AST_LINES';
10065: l_clev_rec clev_rec_type;
10066: -- Variables for validation of line style
10067: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
10068: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
10069: BEGIN
10070: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10071: -- Call start_activity to create savepoint, check compatibility
10072: -- and initialize message list

Line 10239: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

10235: x_talv_rec OUT NOCOPY talv_rec_type) IS
10236: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FXD_AST_LINES';
10237: l_clev_rec clev_rec_type;
10238: -- Variables for validation of line style
10239: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
10240: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
10241: BEGIN
10242: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10243: -- Call start_activity to create savepoint, check compatibility

Line 10240: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

10236: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FXD_AST_LINES';
10237: l_clev_rec clev_rec_type;
10238: -- Variables for validation of line style
10239: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
10240: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
10241: BEGIN
10242: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10243: -- Call start_activity to create savepoint, check compatibility
10244: -- and initialize message list

Line 11182: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;

11178: x_itiv_rec OUT NOCOPY itiv_rec_type) IS
11179:
11180: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_LINES';
11181: l_clev_rec clev_rec_type;
11182: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11183: -- Variables for validation of line style
11184: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11185: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11186: BEGIN

Line 11184: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11180: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_LINES';
11181: l_clev_rec clev_rec_type;
11182: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11183: -- Variables for validation of line style
11184: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11185: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11186: BEGIN
11187: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11188: -- Call start_activity to create savepoint, check compatibility

Line 11185: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11181: l_clev_rec clev_rec_type;
11182: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11183: -- Variables for validation of line style
11184: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11185: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11186: BEGIN
11187: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11188: -- Call start_activity to create savepoint, check compatibility
11189: -- and initialize message list

Line 11317: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11313:
11314: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INSTANCE_LINES';
11315: l_clev_rec clev_rec_type;
11316: -- Variables for validation of line style
11317: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11318: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11319: BEGIN
11320: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11321: -- Call start_activity to create savepoint, check compatibility

Line 11318: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11314: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INSTANCE_LINES';
11315: l_clev_rec clev_rec_type;
11316: -- Variables for validation of line style
11317: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11318: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11319: BEGIN
11320: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11321: -- Call start_activity to create savepoint, check compatibility
11322: -- and initialize message list

Line 11458: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;

11454:
11455: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_IB_LINES';
11456: l_clev_rec clev_rec_type;
11457: l_cimv_rec cimv_rec_type;
11458: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11459: -- Variables for validation of line style
11460: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11461: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11462: BEGIN

Line 11460: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11456: l_clev_rec clev_rec_type;
11457: l_cimv_rec cimv_rec_type;
11458: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11459: -- Variables for validation of line style
11460: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11461: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11462: BEGIN
11463: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11464: -- Call start_activity to create savepoint, check compatibility

Line 11461: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11457: l_cimv_rec cimv_rec_type;
11458: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11459: -- Variables for validation of line style
11460: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11461: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11462: BEGIN
11463: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11464: -- Call start_activity to create savepoint, check compatibility
11465: -- and initialize message list

Line 11604: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11600: lv_dummy VARCHAR2(3);
11601: lv_ib_id1 OKX_INSTALL_ITEMS_V.ID1%TYPE;
11602: lv_ib_id2 OKX_INSTALL_ITEMS_V.ID2%TYPE;
11603: -- Variables for validation of line style
11604: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11605: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11606: l_talv_rec talv_rec_type;
11607: l_trxv_rec trxv_rec_type;
11608: l_itiv_rec itiv_rec_type;

Line 11605: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11601: lv_ib_id1 OKX_INSTALL_ITEMS_V.ID1%TYPE;
11602: lv_ib_id2 OKX_INSTALL_ITEMS_V.ID2%TYPE;
11603: -- Variables for validation of line style
11604: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11605: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11606: l_talv_rec talv_rec_type;
11607: l_trxv_rec trxv_rec_type;
11608: l_itiv_rec itiv_rec_type;
11609: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;

Line 11749: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11745: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PTY_RLE_LINES';
11746: l_clev_rec clev_rec_type;
11747: l_cplv_rec cplv_rec_type;
11748: l_klev_rec klev_rec_type;
11749: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11750: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11751:
11752: --Bug# 4558486
11753: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;

Line 11750: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11746: l_clev_rec clev_rec_type;
11747: l_cplv_rec cplv_rec_type;
11748: l_klev_rec klev_rec_type;
11749: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11750: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11751:
11752: --Bug# 4558486
11753: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;
11754: x_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;

Line 11950: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11946: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PTY_RLE_LINES';
11947: l_clev_rec clev_rec_type;
11948: l_cplv_rec cplv_rec_type;
11949: l_klev_rec klev_rec_type;
11950: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11951: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11952:
11953: --Bug# 4558486
11954: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;

Line 11951: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11947: l_clev_rec clev_rec_type;
11948: l_cplv_rec cplv_rec_type;
11949: l_klev_rec klev_rec_type;
11950: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11951: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11952:
11953: --Bug# 4558486
11954: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;
11955: x_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;