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 3217: -- with OKC_LINE_STYLES_V

3213: -- Start of Commnets
3214: -- Badrinath Kuchibholta
3215: -- Procedure Name : validate_lse_id
3216: -- Description : validation and get the lty_code
3217: -- with OKC_LINE_STYLES_V
3218: -- Business Rules :
3219: -- Parameters :
3220: -- Version : 1.0
3221: -- End of Commnets

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

3220: -- Version : 1.0
3221: -- End of Commnets
3222: PROCEDURE validate_lse_id(p_clev_rec IN clev_rec_type,
3223: x_return_status OUT NOCOPY VARCHAR2,
3224: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3225: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3226: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3227: SELECT lty_code,
3228: lse_type

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

3221: -- End of Commnets
3222: PROCEDURE validate_lse_id(p_clev_rec IN clev_rec_type,
3223: x_return_status OUT NOCOPY VARCHAR2,
3224: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3225: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3226: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3227: SELECT lty_code,
3228: lse_type
3229: FROM OKC_LINE_STYLES_V

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

3222: PROCEDURE validate_lse_id(p_clev_rec IN clev_rec_type,
3223: x_return_status OUT NOCOPY VARCHAR2,
3224: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3225: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3226: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3227: SELECT lty_code,
3228: lse_type
3229: FROM OKC_LINE_STYLES_V
3230: WHERE id = p_lse_id;

Line 3229: FROM OKC_LINE_STYLES_V

3225: x_lse_type OUT NOCOPY OKC_LINE_STYLES_V.LSE_TYPE%TYPE) IS
3226: CURSOR c_lse_id_validate(p_lse_id OKC_LINE_STYLES_V.ID%TYPE) IS
3227: SELECT lty_code,
3228: lse_type
3229: FROM OKC_LINE_STYLES_V
3230: WHERE id = p_lse_id;
3231: BEGIN
3232: -- initialize return status
3233: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3309: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

3305: -- Version : 1.0
3306: -- End of Commnets
3307:
3308: PROCEDURE validate_cle_lse_id(p_clev_rec IN clev_rec_type,
3309: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3310: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3311: x_return_status OUT NOCOPY VARCHAR2) IS
3312: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3313: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

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

3306: -- End of Commnets
3307:
3308: PROCEDURE validate_cle_lse_id(p_clev_rec IN clev_rec_type,
3309: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3310: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3311: x_return_status OUT NOCOPY VARCHAR2) IS
3312: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3313: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3314: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

Line 3313: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

3309: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3310: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3311: x_return_status OUT NOCOPY VARCHAR2) IS
3312: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3313: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3314: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3315:
3316: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3317: SELECT lse.lty_code

Line 3314: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

3310: x_lty_code OUT NOCOPY OKC_LINE_STYLES_V.LTY_CODE%TYPE,
3311: x_return_status OUT NOCOPY VARCHAR2) IS
3312: ln_cle_id OKC_K_LINES_V.ID%TYPE := 0;
3313: lv_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
3314: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
3315:
3316: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3317: SELECT lse.lty_code
3318: FROM OKC_K_LINES_V cle,

Line 3319: OKC_LINE_STYLES_V lse

3315:
3316: CURSOR c_cle_id_validate(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE) IS
3317: SELECT lse.lty_code
3318: FROM OKC_K_LINES_V cle,
3319: OKC_LINE_STYLES_V lse
3320: WHERE cle.id = p_cle_id
3321: AND lse.id = cle.lse_id;
3322:
3323: BEGIN

Line 3826: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;

3822: PROCEDURE validate_sts_code(p_clev_rec IN clev_rec_type,
3823: x_return_status OUT NOCOPY VARCHAR2) IS
3824:
3825: lv_sts_code OKC_K_LINES_V.STS_CODE%TYPE;
3826: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3827:
3828: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3829: SELECT lse.lty_code
3830: FROM OKC_LINE_STYLES_V lse

Line 3830: FROM OKC_LINE_STYLES_V lse

3826: lv_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE;
3827:
3828: CURSOR c_lty_code_validate(p_lse_id OKC_LINE_STYLES_B.ID%TYPE) IS
3829: SELECT lse.lty_code
3830: FROM OKC_LINE_STYLES_V lse
3831: WHERE lse.id = p_lse_id;
3832:
3833: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3834: p_cle_id OKC_K_LINES_V.ID%TYPE,

Line 3835: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS

3831: WHERE lse.id = p_lse_id;
3832:
3833: CURSOR c_sub_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3834: p_cle_id OKC_K_LINES_V.ID%TYPE,
3835: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3836: SELECT cle.sts_code
3837: FROM OKC_K_LINES_V cle
3838: WHERE cle.id in (SELECT cle.cle_id
3839: FROM OKC_K_LINES_V cle

Line 3841: FROM OKC_LINE_STYLES_V lse,

3837: FROM OKC_K_LINES_V cle
3838: WHERE cle.id in (SELECT cle.cle_id
3839: FROM OKC_K_LINES_V cle
3840: WHERE id in (SELECT cle.cle_id
3841: FROM OKC_LINE_STYLES_V lse,
3842: OKC_K_LINES_V cle
3843: WHERE dnz_chr_id = p_dnz_chr_id
3844: AND cle.lse_id = lse.id
3845: AND cle.id = p_cle_id

Line 3850: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS

3846: AND lse.lty_code = p_lty_code));
3847:
3848: CURSOR c_sub_line_sts_code(p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
3849: p_cle_id OKC_K_LINES_V.ID%TYPE,
3850: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3851: SELECT cle.sts_code
3852: FROM OKC_K_LINES_V cle
3853: WHERE id in (SELECT cle.cle_id
3854: FROM OKC_LINE_STYLES_V lse,

Line 3854: FROM OKC_LINE_STYLES_V lse,

3850: p_lty_code OKC_LINE_STYLES_V.lty_CODE%TYPE) IS
3851: SELECT cle.sts_code
3852: FROM OKC_K_LINES_V cle
3853: WHERE id in (SELECT cle.cle_id
3854: FROM OKC_LINE_STYLES_V lse,
3855: OKC_K_LINES_V cle
3856: WHERE dnz_chr_id = p_dnz_chr_id
3857: AND cle.lse_id = lse.id
3858: AND cle.id = p_cle_id

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

5470: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5471: x_return_status OUT NOCOPY VARCHAR2,
5472: x_msg_count OUT NOCOPY NUMBER,
5473: x_msg_data OUT NOCOPY VARCHAR2,
5474: -- 4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
5475: p_clev_rec IN clev_rec_type,
5476: p_klev_rec IN klev_rec_type,
5477: p_cimv_rec IN cimv_rec_type,
5478: x_clev_rec OUT NOCOPY clev_rec_type,

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

5481: l_clev_rec clev_rec_type;
5482: r_clev_rec clev_rec_type;
5483: l_talv_rec talv_rec_type;
5484: l_cimv_rec cimv_rec_type;
5485: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5486: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MODEL_ITEM';
5487:
5488: ------------------
5489: --Bug# 2994971

Line 5706: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

5702: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5703: x_return_status OUT NOCOPY VARCHAR2,
5704: x_msg_count OUT NOCOPY NUMBER,
5705: x_msg_data OUT NOCOPY VARCHAR2,
5706: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
5707: p_clev_rec IN clev_rec_type,
5708: p_klev_rec IN klev_rec_type,
5709: p_cimv_rec IN cimv_rec_type,
5710: x_clev_rec OUT NOCOPY clev_rec_type,

Line 5717: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

5713:
5714: l_clev_rec clev_rec_type;
5715: l_talv_rec talv_rec_type;
5716: l_cimv_rec cimv_rec_type;
5717: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5718: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MODEL_ITEM';
5719:
5720: ------------------
5721: --Bug# 2994971

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

5867: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
5868: x_return_status OUT NOCOPY VARCHAR2,
5869: x_msg_count OUT NOCOPY NUMBER,
5870: x_msg_data OUT NOCOPY VARCHAR2,
5871: -- p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
5872: -- 4414408
5873: p_clev_rec IN clev_rec_type,
5874: p_klev_rec IN klev_rec_type,
5875: p_cimv_rec IN cimv_rec_type,

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

5886: l_talv_rec talv_rec_type;
5887: l_trxv_rec trxv_rec_type;
5888: i NUMBER := 0;
5889:
5890: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
5891: lv_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
5892: lv_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE := OKL_API.G_MISS_CHAR;
5893: ln_dummy NUMBER := 0;
5894: lv_dummy VARCHAR2(3);

Line 6203: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

6199: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6200: x_return_status OUT NOCOPY VARCHAR2,
6201: x_msg_count OUT NOCOPY NUMBER,
6202: x_msg_data OUT NOCOPY VARCHAR2,
6203: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
6204: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6205: p_clev_rec IN clev_rec_type,
6206: p_klev_rec IN klev_rec_type,
6207: p_cimv_rec IN cimv_rec_type,

Line 6219: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6215: l_cimv_rec cimv_rec_type;
6216: l_talv_rec talv_rec_type;
6217: l_trxv_rec trxv_rec_type;
6218: i NUMBER := 0;
6219: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6220: ln_dummy NUMBER := 0;
6221: lv_dummy VARCHAR2(3);
6222: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
6223: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FA_LINE_ITEM';

Line 6379: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

6375: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6376: x_return_status OUT NOCOPY VARCHAR2,
6377: x_msg_count OUT NOCOPY NUMBER,
6378: x_msg_data OUT NOCOPY VARCHAR2,
6379: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
6380: p_clev_rec IN clev_rec_type,
6381: p_klev_rec IN klev_rec_type,
6382: p_cimv_rec IN cimv_rec_type,
6383: x_clev_rec OUT NOCOPY clev_rec_type,

Line 6389: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6385: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
6386: l_clev_rec clev_rec_type;
6387: r_clev_rec clev_rec_type;
6388: l_cimv_rec cimv_rec_type;
6389: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6390: i NUMBER := 0;
6391: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_ITEM';
6392: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE := 0;
6393: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE := 0;

Line 6588: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

6584: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6585: x_return_status OUT NOCOPY VARCHAR2,
6586: x_msg_count OUT NOCOPY NUMBER,
6587: x_msg_data OUT NOCOPY VARCHAR2,
6588: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
6589: p_clev_rec IN clev_rec_type,
6590: p_klev_rec IN klev_rec_type,
6591: p_cimv_rec IN cimv_rec_type,
6592: x_clev_rec OUT NOCOPY clev_rec_type,

Line 6598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6594: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
6595: l_clev_rec clev_rec_type;
6596: l_klev_rec klev_rec_type;
6597: l_cimv_rec cimv_rec_type;
6598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6599: i NUMBER;
6600: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_ITEM';
6601: ln_display_sequence OKC_K_LINES_V.DISPLAY_SEQUENCE%TYPE;
6602: ln_num_of_items OKC_K_ITEMS.NUMBER_OF_ITEMS%TYPE;

Line 6811: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

6807: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
6808: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_REC';
6809: l_clev_rec clev_rec_type;
6810: -- Variables for validation of line style
6811: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6812: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6813: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6814:
6815: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

Line 6812: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

6808: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_AO_LNE_REC';
6809: l_clev_rec clev_rec_type;
6810: -- Variables for validation of line style
6811: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
6812: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
6813: ln_fa_id OKC_K_LINES_V.ID%TYPE;
6814:
6815: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6816: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 7009: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7005: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
7006: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_REC';
7007: l_clev_rec clev_rec_type;
7008: -- Variables for validation of line style
7009: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7010: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7011: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7012:
7013: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

Line 7010: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

7006: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_AO_LNE_REC';
7007: l_clev_rec clev_rec_type;
7008: -- Variables for validation of line style
7009: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7010: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7011: ln_fa_id OKC_K_LINES_V.ID%TYPE;
7012:
7013: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7014: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 7224: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7220: l_api_name CONSTANT VARCHAR2(30) := 'DEL_ADDON_REC';
7221: l_delete_clev_rec clev_rec_type;
7222: l_delete_klev_rec klev_rec_type;
7223: -- Variables for validation of line style
7224: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7225: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7226: BEGIN
7227: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7228: -- Call start_activity to create savepoint, check compatibility

Line 7225: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

7221: l_delete_clev_rec clev_rec_type;
7222: l_delete_klev_rec klev_rec_type;
7223: -- Variables for validation of line style
7224: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7225: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
7226: BEGIN
7227: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7228: -- Call start_activity to create savepoint, check compatibility
7229: -- and initialize message list

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

7377: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7378: x_return_status OUT NOCOPY VARCHAR2,
7379: x_msg_count OUT NOCOPY NUMBER,
7380: x_msg_data OUT NOCOPY VARCHAR2,
7381: -- #4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
7382: p_clev_rec IN clev_rec_type,
7383: p_klev_rec IN klev_rec_type,
7384: x_clev_rec OUT NOCOPY clev_rec_type,
7385: x_klev_rec OUT NOCOPY klev_rec_type) IS

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

7384: x_clev_rec OUT NOCOPY clev_rec_type,
7385: x_klev_rec OUT NOCOPY klev_rec_type) IS
7386: l_clev_rec clev_rec_type;
7387: r_clev_rec clev_rec_type;
7388: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7389:
7390: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTS_LINE';
7391: BEGIN
7392:

Line 7550: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

7546: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7547: x_return_status OUT NOCOPY VARCHAR2,
7548: x_msg_count OUT NOCOPY NUMBER,
7549: x_msg_data OUT NOCOPY VARCHAR2,
7550: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
7551: p_clev_rec IN clev_rec_type,
7552: p_klev_rec IN klev_rec_type,
7553: x_clev_rec OUT NOCOPY clev_rec_type,
7554: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 7557: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

7553: x_clev_rec OUT NOCOPY clev_rec_type,
7554: x_klev_rec OUT NOCOPY klev_rec_type) IS
7555:
7556: l_clev_rec clev_rec_type;
7557: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7558:
7559: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INSTS_LINE';
7560: BEGIN
7561: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

7641: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7642: x_return_status OUT NOCOPY VARCHAR2,
7643: x_msg_count OUT NOCOPY NUMBER,
7644: x_msg_data OUT NOCOPY VARCHAR2,
7645: -- 4414408 p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
7646: p_clev_rec IN clev_rec_type,
7647: p_klev_rec IN klev_rec_type,
7648: p_cimv_rec IN cimv_rec_type,
7649: p_itiv_rec IN itiv_rec_type,

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

7656: r_clev_rec clev_rec_type;
7657: l_cimv_rec cimv_rec_type;
7658: r_cimv_rec cimv_rec_type;
7659: lv_dummy VARCHAR2(3) := OKL_API.G_MISS_CHAR ;
7660: -- l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
7661: l_itiv_rec itiv_rec_type;
7662: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_IB_LINE';
7663: BEGIN
7664: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 7995: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,

7991: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7992: x_return_status OUT NOCOPY VARCHAR2,
7993: x_msg_count OUT NOCOPY NUMBER,
7994: x_msg_data OUT NOCOPY VARCHAR2,
7995: p_lty_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE,
7996: p_clev_rec IN clev_rec_type,
7997: p_klev_rec IN klev_rec_type,
7998: p_cimv_rec IN cimv_rec_type,
7999: p_itiv_rec IN itiv_rec_type,

Line 8008: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

8004:
8005: l_clev_rec clev_rec_type;
8006: l_cimv_rec cimv_rec_type;
8007: l_itiv_rec itiv_rec_type;
8008: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8009: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
8010: lv_dummy VARCHAR2(3) := OKL_API.G_MISS_CHAR ;
8011: i NUMBER := 0;
8012: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_IB_LINE';

Line 8210: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

8206: x_klev_rec OUT NOCOPY klev_rec_type) IS
8207: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FIN_AST_LINES';
8208: l_clev_rec clev_rec_type;
8209: -- Variables for validation of line style
8210: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8211: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8212: BEGIN
8213: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8214: -- Call start_activity to create savepoint, check compatibility

Line 8211: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

8207: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FIN_AST_LINES';
8208: l_clev_rec clev_rec_type;
8209: -- Variables for validation of line style
8210: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8211: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8212: BEGIN
8213: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8214: -- Call start_activity to create savepoint, check compatibility
8215: -- and initialize message list

Line 8379: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

8375: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FIN_AST_LINES';
8376: l_clev_rec clev_rec_type := p_clev_rec;
8377: l_klev_rec klev_rec_type := p_klev_rec;
8378: -- Variables for validation of line style
8379: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8380: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8381: ln_fa_id OKC_K_LINES_V.ID%TYPE;
8382:
8383: -- Temp variables for capital reduction and tradein amount

Line 8380: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

8376: l_clev_rec clev_rec_type := p_clev_rec;
8377: l_klev_rec klev_rec_type := p_klev_rec;
8378: -- Variables for validation of line style
8379: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
8380: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
8381: ln_fa_id OKC_K_LINES_V.ID%TYPE;
8382:
8383: -- Temp variables for capital reduction and tradein amount
8384: tradein_amount OKL_K_LINES.TRADEIN_AMOUNT%TYPE;

Line 9595: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

9591: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
9592: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MODEL_LINES';
9593: l_clev_rec clev_rec_type;
9594: -- Variables for validation of line style
9595: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9596: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9597: l_update_clev_rec clev_rec_type;
9598: l_update_klev_rec klev_rec_type;
9599: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;

Line 9596: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

9592: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_MODEL_LINES';
9593: l_clev_rec clev_rec_type;
9594: -- Variables for validation of line style
9595: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9596: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9597: l_update_clev_rec clev_rec_type;
9598: l_update_klev_rec klev_rec_type;
9599: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
9600: l_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;

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

9595: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9596: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9597: l_update_clev_rec clev_rec_type;
9598: l_update_klev_rec klev_rec_type;
9599: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
9600: l_qty OKC_K_ITEMS_V.NUMBER_OF_ITEMS%TYPE := 0;
9601:
9602: BEGIN
9603: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 9769: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

9765: x_cimv_rec OUT NOCOPY cimv_rec_type) IS
9766: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MODEL_LINES';
9767: l_clev_rec clev_rec_type;
9768: -- Variables for validation of line style
9769: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9770: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9771: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9772:
9773: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,

Line 9770: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

9766: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_MODEL_LINES';
9767: l_clev_rec clev_rec_type;
9768: -- Variables for validation of line style
9769: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9770: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9771: ln_fa_id OKC_K_LINES_V.ID%TYPE;
9772:
9773: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9774: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)

Line 9982: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

9978:
9979: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FXD_AST_LINES';
9980: l_clev_rec clev_rec_type;
9981: -- Variables for validation of line style
9982: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9983: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9984: BEGIN
9985: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9986: -- Call start_activity to create savepoint, check compatibility

Line 9983: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

9979: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FXD_AST_LINES';
9980: l_clev_rec clev_rec_type;
9981: -- Variables for validation of line style
9982: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
9983: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
9984: BEGIN
9985: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9986: -- Call start_activity to create savepoint, check compatibility
9987: -- and initialize message list

Line 10154: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

10150: x_talv_rec OUT NOCOPY talv_rec_type) IS
10151: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FXD_AST_LINES';
10152: l_clev_rec clev_rec_type;
10153: -- Variables for validation of line style
10154: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
10155: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
10156: BEGIN
10157: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10158: -- Call start_activity to create savepoint, check compatibility

Line 10155: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

10151: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FXD_AST_LINES';
10152: l_clev_rec clev_rec_type;
10153: -- Variables for validation of line style
10154: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
10155: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
10156: BEGIN
10157: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10158: -- Call start_activity to create savepoint, check compatibility
10159: -- and initialize message list

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

11093: x_itiv_rec OUT NOCOPY itiv_rec_type) IS
11094:
11095: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_LINES';
11096: l_clev_rec clev_rec_type;
11097: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11098: -- Variables for validation of line style
11099: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11100: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11101: BEGIN

Line 11099: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11095: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_LINES';
11096: l_clev_rec clev_rec_type;
11097: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11098: -- Variables for validation of line style
11099: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11100: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11101: BEGIN
11102: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11103: -- Call start_activity to create savepoint, check compatibility

Line 11100: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11096: l_clev_rec clev_rec_type;
11097: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11098: -- Variables for validation of line style
11099: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11100: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11101: BEGIN
11102: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11103: -- Call start_activity to create savepoint, check compatibility
11104: -- and initialize message list

Line 11232: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11228:
11229: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INSTANCE_LINES';
11230: l_clev_rec clev_rec_type;
11231: -- Variables for validation of line style
11232: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11233: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11234: BEGIN
11235: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11236: -- Call start_activity to create savepoint, check compatibility

Line 11233: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11229: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INSTANCE_LINES';
11230: l_clev_rec clev_rec_type;
11231: -- Variables for validation of line style
11232: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11233: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11234: BEGIN
11235: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11236: -- Call start_activity to create savepoint, check compatibility
11237: -- and initialize message list

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

11369:
11370: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_INSTANCE_IB_LINES';
11371: l_clev_rec clev_rec_type;
11372: l_cimv_rec cimv_rec_type;
11373: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11374: -- Variables for validation of line style
11375: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11376: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11377: BEGIN

Line 11375: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11371: l_clev_rec clev_rec_type;
11372: l_cimv_rec cimv_rec_type;
11373: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11374: -- Variables for validation of line style
11375: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11376: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11377: BEGIN
11378: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11379: -- Call start_activity to create savepoint, check compatibility

Line 11376: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11372: l_cimv_rec cimv_rec_type;
11373: ln_lse_id OKC_LINE_STYLES_V.ID%TYPE := OKL_API.G_MISS_NUM;
11374: -- Variables for validation of line style
11375: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11376: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11377: BEGIN
11378: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11379: -- Call start_activity to create savepoint, check compatibility
11380: -- and initialize message list

Line 11519: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11515: lv_dummy VARCHAR2(3);
11516: lv_ib_id1 OKX_INSTALL_ITEMS_V.ID1%TYPE;
11517: lv_ib_id2 OKX_INSTALL_ITEMS_V.ID2%TYPE;
11518: -- Variables for validation of line style
11519: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11520: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11521: l_talv_rec talv_rec_type;
11522: l_trxv_rec trxv_rec_type;
11523: l_itiv_rec itiv_rec_type;

Line 11520: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11516: lv_ib_id1 OKX_INSTALL_ITEMS_V.ID1%TYPE;
11517: lv_ib_id2 OKX_INSTALL_ITEMS_V.ID2%TYPE;
11518: -- Variables for validation of line style
11519: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11520: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11521: l_talv_rec talv_rec_type;
11522: l_trxv_rec trxv_rec_type;
11523: l_itiv_rec itiv_rec_type;
11524: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;

Line 11664: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11660: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PTY_RLE_LINES';
11661: l_clev_rec clev_rec_type;
11662: l_cplv_rec cplv_rec_type;
11663: l_klev_rec klev_rec_type;
11664: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11665: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11666:
11667: --Bug# 4558486
11668: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;

Line 11665: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11661: l_clev_rec clev_rec_type;
11662: l_cplv_rec cplv_rec_type;
11663: l_klev_rec klev_rec_type;
11664: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11665: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11666:
11667: --Bug# 4558486
11668: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;
11669: x_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;

Line 11865: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

11861: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PTY_RLE_LINES';
11862: l_clev_rec clev_rec_type;
11863: l_cplv_rec cplv_rec_type;
11864: l_klev_rec klev_rec_type;
11865: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11866: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11867:
11868: --Bug# 4558486
11869: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;

Line 11866: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;

11862: l_clev_rec clev_rec_type;
11863: l_cplv_rec cplv_rec_type;
11864: l_klev_rec klev_rec_type;
11865: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
11866: l_lse_type OKC_LINE_STYLES_V.LSE_TYPE%TYPE;
11867:
11868: --Bug# 4558486
11869: l_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;
11870: x_kplv_rec OKL_K_PARTY_ROLES_PVT.kplv_rec_type;