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 OKL_TXL_ASSETS_V

Line 196: FUNCTION generate_asset_number(x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)

192: p_token2_value => sqlerrm);
193: RETURN x_return_status;
194: END generate_instance_number_ib;
195: ---------------------------------------------------------------------------------------------------------------
196: FUNCTION generate_asset_number(x_asset_number OUT NOCOPY OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE)
197: RETURN VARCHAR2 IS
198: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
199: ln_dummy1 NUMBER := 0;
200: ln_dummy2 NUMBER := 0;

Line 911: FUNCTION get_rec_txlv(p_txlv_id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,

907: END IF;
908: RETURN(x_return_status);
909: END default_contract_line_values;
910: -------------------------------------------------------------------------------------------------
911: FUNCTION get_rec_txlv(p_txlv_id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,
912: x_txlv_rec OUT NOCOPY talv_rec_type)
913: RETURN VARCHAR2 IS
914: CURSOR okl_talv_pk_csr (p_kle_id IN NUMBER) IS
915: SELECT ID,

Line 993: FROM Okl_Txl_Assets_V

989: CURRENCY_CODE,
990: CURRENCY_CONVERSION_TYPE,
991: CURRENCY_CONVERSION_RATE,
992: CURRENCY_CONVERSION_DATE
993: FROM Okl_Txl_Assets_V
994: WHERE okl_txl_assets_v.kle_id = p_kle_id;
995: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
996: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
997: BEGIN

Line 994: WHERE okl_txl_assets_v.kle_id = p_kle_id;

990: CURRENCY_CONVERSION_TYPE,
991: CURRENCY_CONVERSION_RATE,
992: CURRENCY_CONVERSION_DATE
993: FROM Okl_Txl_Assets_V
994: WHERE okl_txl_assets_v.kle_id = p_kle_id;
995: l_okl_talv_pk okl_talv_pk_csr%ROWTYPE;
996: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
997: BEGIN
998: OPEN okl_talv_pk_csr (p_txlv_id);

Line 2490: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

2486: -- Parameters : OUT Return Status, IN Rec Info
2487: -- Version : 1.0
2488: -- End of Commnets
2489: PROCEDURE validate_new_ast_num_update(x_return_status OUT NOCOPY VARCHAR2,
2490: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2491: p_kle_Id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,
2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;

Line 2491: p_kle_Id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,

2487: -- Version : 1.0
2488: -- End of Commnets
2489: PROCEDURE validate_new_ast_num_update(x_return_status OUT NOCOPY VARCHAR2,
2490: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2491: p_kle_Id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,
2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;
2495: ln_okx_asset_lines_v NUMBER := 0;

Line 2493: ln_okl_txl_assets_v NUMBER := 0;

2489: PROCEDURE validate_new_ast_num_update(x_return_status OUT NOCOPY VARCHAR2,
2490: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2491: p_kle_Id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,
2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;
2495: ln_okx_asset_lines_v NUMBER := 0;
2496: ln_okl_txd_assets_v NUMBER := 0;
2497: lv_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;

Line 2499: lv_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;

2495: ln_okx_asset_lines_v NUMBER := 0;
2496: ln_okl_txd_assets_v NUMBER := 0;
2497: lv_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2498: lv_asset_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2499: lv_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
2500: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';
2501: x_msg_count NUMBER;
2502: x_msg_data VARCHAR2(100);
2503:

Line 2504: CURSOR c_get_asset_number(p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE)

2500: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';
2501: x_msg_count NUMBER;
2502: x_msg_data VARCHAR2(100);
2503:
2504: CURSOR c_get_asset_number(p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE)
2505: IS
2506: SELECT NAME
2507: FROM OKC_K_LINES_TL
2508: WHERE ID = (SELECT CLE_ID

Line 2514: p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE)

2510: WHERE ID = p_kle_Id)
2511: AND language = USERENV('lang');
2512:
2513: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE,
2514: p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE)
2515: IS
2516: SELECT 1
2517: --FROM DUAL
2518: --WHERE EXISTS (SELECT '1'

Line 2542: OKL_TXL_ASSETS_V TXL,

2538: SELECT 1
2539: --FROM DUAL
2540: --WHERE EXISTS (SELECT '1'
2541: FROM OKL_TRX_ASSETS TAS,
2542: OKL_TXL_ASSETS_V TXL,
2543: OKL_TXD_ASSETS_V TXD
2544: WHERE TXD.asset_number = p_asset_number
2545: AND TXD.TAL_ID = TXL.ID
2546: AND TXL.TAL_TYPE = 'ALI'

Line 2550: CURSOR c_source_code(p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE) is

2546: AND TXL.TAL_TYPE = 'ALI'
2547: AND TXL.TAS_ID = TAS.ID
2548: AND TAS.TSU_CODE = 'ENTERED'; --);
2549:
2550: CURSOR c_source_code(p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE) is
2551: SELECT nvl(chr.orig_system_source_code,'x')
2552: FROM okc_k_headers_b chr,
2553: okc_k_lines_b cle
2554: WHERE cle.id = p_kle_Id

Line 2644: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2640: -- Enforce validation
2641: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_B
2642: OPEN c_txl_asset_number(p_asset_number,
2643: p_kle_id);
2644: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2645: IF c_txl_asset_number%NOTFOUND THEN
2646: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2647: END IF;
2648: CLOSE c_txl_asset_number;

Line 2680: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2676: -- Enforce validation
2677: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_B
2678: OPEN c_txl_asset_number(p_asset_number,
2679: p_kle_id);
2680: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2681: IF c_txl_asset_number%NOTFOUND THEN
2682: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2683: END IF;
2684: CLOSE c_txl_asset_number;

Line 2714: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_V

2710:
2711: -- Since we have add this check only the cases if the asset number
2712: -- cannot be duplicate when created new fo re_book scenario
2713: ELSIF lv_source_code = 'OKL_REBOOK' THEN
2714: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_V
2715: OPEN c_txl_asset_number(p_asset_number,
2716: p_kle_Id);
2717: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2718: IF c_txl_asset_number%NOTFOUND THEN

Line 2717: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2713: ELSIF lv_source_code = 'OKL_REBOOK' THEN
2714: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_V
2715: OPEN c_txl_asset_number(p_asset_number,
2716: p_kle_Id);
2717: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2718: IF c_txl_asset_number%NOTFOUND THEN
2719: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2720: END IF;
2721: CLOSE c_txl_asset_number;

Line 2749: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR

2745: END IF;
2746: CLOSE c_txd_assets_v;
2747: END IF;
2748:
2749: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
2750: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
2751: -- store SQL error message on message stack
2752: OKL_API.set_message(p_app_name => G_APP_NAME,
2753: p_msg_name => G_ASSET_NUMBER);

Line 2755: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND

2751: -- store SQL error message on message stack
2752: OKL_API.set_message(p_app_name => G_APP_NAME,
2753: p_msg_name => G_ASSET_NUMBER);
2754: RAISE G_EXCEPTION_HALT_VALIDATION;
2755: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
2756: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
2757: -- store SQL error message on message stack
2758: OKL_API.set_message(p_app_name => G_APP_NAME,
2759: p_msg_name => G_ASSET_NUMBER);

Line 2847: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

2843: -- Parameters : OUT Return Status, IN Rec Info
2844: -- Version : 1.0
2845: -- End of Commnets
2846: PROCEDURE validate_new_asset_number(x_return_status OUT NOCOPY VARCHAR2,
2847: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2848: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2849: ln_okl_txl_assets_v NUMBER := 0;
2850: ln_okx_assets_v NUMBER := 0;
2851: ln_okx_asset_lines_v NUMBER := 0;

Line 2849: ln_okl_txl_assets_v NUMBER := 0;

2845: -- End of Commnets
2846: PROCEDURE validate_new_asset_number(x_return_status OUT NOCOPY VARCHAR2,
2847: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2848: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2849: ln_okl_txl_assets_v NUMBER := 0;
2850: ln_okx_assets_v NUMBER := 0;
2851: ln_okx_asset_lines_v NUMBER := 0;
2852: ln_okl_txd_assets_v NUMBER := 0;
2853: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';

Line 2890: OKL_TXL_ASSETS_V TXL,

2886: SELECT 1
2887: --FROM DUAL
2888: --WHERE EXISTS (SELECT '1'
2889: FROM OKL_TRX_ASSETS TAS,
2890: OKL_TXL_ASSETS_V TXL,
2891: OKL_TXD_ASSETS_V TXD
2892: WHERE TXD.asset_number = p_asset_number
2893: AND TXD.TAL_ID = TXL.ID
2894: AND TXL.TAL_TYPE = 'ALI'

Line 2947: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2943: IF (upper(lv_release_asset) = 'N') THEN -- Start of release asset check
2944: -- Enforce validation
2945: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_B
2946: OPEN c_txl_asset_number(p_asset_number);
2947: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2948: IF c_txl_asset_number%NOTFOUND THEN
2949: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2950: END IF;
2951: CLOSE c_txl_asset_number;

Line 2978: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR

2974: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2975: END IF;
2976: CLOSE c_txd_assets_v;
2977:
2978: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
2979: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
2980: -- store SQL error message on message stack
2981: OKL_API.set_message(p_app_name => G_APP_NAME,
2982: p_msg_name => G_ASSET_NUMBER);

Line 2984: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND

2980: -- store SQL error message on message stack
2981: OKL_API.set_message(p_app_name => G_APP_NAME,
2982: p_msg_name => G_ASSET_NUMBER);
2983: RAISE G_EXCEPTION_HALT_VALIDATION;
2984: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
2985: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
2986: -- store SQL error message on message stack
2987: OKL_API.set_message(p_app_name => G_APP_NAME,
2988: p_msg_name => G_ASSET_NUMBER);

Line 3682: -- Description : validation with OKL_TXL_ASSETS_V

3678: --------------------------------------------------------------------------------------------
3679: -- Start of Commnets
3680: -- Badrinath Kuchibholta
3681: -- Procedure Name : validate_kle_id
3682: -- Description : validation with OKL_TXL_ASSETS_V
3683: -- Business Rules :
3684: -- Parameters :
3685: -- Version : 1.0
3686: -- End of Commnets

Line 3692: CURSOR c_kle_id_validate(p_kle_id OKL_TXL_ASSETS_V.KLE_ID%TYPE) IS

3688: PROCEDURE validate_kle_id(p_klev_rec IN klev_rec_type,
3689: x_record_exists OUT NOCOPY VARCHAR2,
3690: x_return_status OUT NOCOPY VARCHAR2) IS
3691: ln_dummy NUMBER := 0;
3692: CURSOR c_kle_id_validate(p_kle_id OKL_TXL_ASSETS_V.KLE_ID%TYPE) IS
3693: SELECT 1
3694: --FROM dual
3695: --WHERE EXISTS (SELECT '1'
3696: FROM OKL_TXL_ASSETS_V

Line 3696: FROM OKL_TXL_ASSETS_V

3692: CURSOR c_kle_id_validate(p_kle_id OKL_TXL_ASSETS_V.KLE_ID%TYPE) IS
3693: SELECT 1
3694: --FROM dual
3695: --WHERE EXISTS (SELECT '1'
3696: FROM OKL_TXL_ASSETS_V
3697: WHERE kle_id = p_kle_id; --);
3698: BEGIN
3699: -- initialize return status
3700: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3708: p_token1_value => 'OKL_TXL_ASSETS_V.KLE_ID');

3704: -- store SQL error message on message stack
3705: OKL_API.set_message(p_app_name => G_APP_NAME,
3706: p_msg_name => G_REQUIRED_VALUE,
3707: p_token1 => G_COL_NAME_TOKEN,
3708: p_token1_value => 'OKL_TXL_ASSETS_V.KLE_ID');
3709: -- halt validation as it is a required field
3710: RAISE G_EXCEPTION_STOP_VALIDATION;
3711: END IF;
3712: -- Enforce Foreign Key

Line 5896: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;

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);
5895: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
5896: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;
5897: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FA_LINE_ITEM';
5898: CURSOR c_asset_exist_chr(p_id1 OKX_ASSETS_V.ID1%TYPE,
5899: p_id2 OKX_ASSETS_V.ID2%TYPE,
5900: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)

Line 6204: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

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,
6208: p_talv_rec IN talv_rec_type,

Line 6800: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

6796: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6797: x_return_status OUT NOCOPY VARCHAR2,
6798: x_msg_count OUT NOCOPY NUMBER,
6799: x_msg_data OUT NOCOPY VARCHAR2,
6800: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6801: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
6802: p_clev_rec IN clev_rec_type,
6803: p_klev_rec IN klev_rec_type,
6804: p_cimv_rec IN cimv_rec_type,

Line 6801: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

6797: x_return_status OUT NOCOPY VARCHAR2,
6798: x_msg_count OUT NOCOPY NUMBER,
6799: x_msg_data OUT NOCOPY VARCHAR2,
6800: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6801: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
6802: p_clev_rec IN clev_rec_type,
6803: p_klev_rec IN klev_rec_type,
6804: p_cimv_rec IN cimv_rec_type,
6805: x_clev_rec OUT NOCOPY clev_rec_type,

Line 6871: -- in OKL_TXL_ASSETS_V

6867: RAISE OKL_API.G_EXCEPTION_ERROR;
6868: END IF;
6869: -- Validate to see if the asset_number given is not null
6870: -- and also Validate asset_number does not exists
6871: -- in OKL_TXL_ASSETS_V
6872: OPEN get_fa_id(p_top_line => p_clev_rec.cle_id,
6873: p_dnz_chr_id => p_clev_rec.dnz_chr_id);
6874: IF get_fa_id%NOTFOUND THEN
6875: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 6998: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

6994: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6995: x_return_status OUT NOCOPY VARCHAR2,
6996: x_msg_count OUT NOCOPY NUMBER,
6997: x_msg_data OUT NOCOPY VARCHAR2,
6998: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6999: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
7000: p_clev_rec IN clev_rec_type,
7001: p_klev_rec IN klev_rec_type,
7002: p_cimv_rec IN cimv_rec_type,

Line 6999: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

6995: x_return_status OUT NOCOPY VARCHAR2,
6996: x_msg_count OUT NOCOPY NUMBER,
6997: x_msg_data OUT NOCOPY VARCHAR2,
6998: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6999: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
7000: p_clev_rec IN clev_rec_type,
7001: p_klev_rec IN klev_rec_type,
7002: p_cimv_rec IN cimv_rec_type,
7003: x_clev_rec OUT NOCOPY clev_rec_type,

Line 7094: -- in OKL_TXL_ASSETS_V

7090: RAISE OKL_API.G_EXCEPTION_ERROR;
7091: END IF;
7092: -- Validate to see if the asset_number given is not null
7093: -- and also Validate asset_number does not exists
7094: -- in OKL_TXL_ASSETS_V
7095: IF UPPER(p_new_yn) = 'Y' THEN
7096: validate_new_ast_num_update(x_return_status => x_return_status,
7097: p_asset_number => p_asset_number,
7098: p_kle_id => ln_fa_id,

Line 8201: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8197: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8198: x_return_status OUT NOCOPY VARCHAR2,
8199: x_msg_count OUT NOCOPY NUMBER,
8200: x_msg_data OUT NOCOPY VARCHAR2,
8201: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8202: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8203: p_clev_rec IN clev_rec_type,
8204: p_klev_rec IN klev_rec_type,
8205: x_clev_rec OUT NOCOPY clev_rec_type,

Line 8202: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8198: x_return_status OUT NOCOPY VARCHAR2,
8199: x_msg_count OUT NOCOPY NUMBER,
8200: x_msg_data OUT NOCOPY VARCHAR2,
8201: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8202: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8203: p_clev_rec IN clev_rec_type,
8204: p_klev_rec IN klev_rec_type,
8205: x_clev_rec OUT NOCOPY clev_rec_type,
8206: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 8243: -- in OKL_TXL_ASSETS_V

8239: RAISE OKL_API.G_EXCEPTION_ERROR;
8240: END IF;
8241: -- Validate to see if the asset_number given is not null
8242: -- and also Validate asset_number does not exists
8243: -- in OKL_TXL_ASSETS_V
8244: IF UPPER(p_new_yn) = 'Y' THEN
8245: validate_new_asset_number(x_return_status => x_return_status,
8246: p_asset_number => p_asset_number,
8247: p_dnz_chr_id => p_clev_rec.dnz_chr_id);

Line 8368: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8364: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8365: x_return_status OUT NOCOPY VARCHAR2,
8366: x_msg_count OUT NOCOPY NUMBER,
8367: x_msg_data OUT NOCOPY VARCHAR2,
8368: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8369: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8370: p_clev_rec IN clev_rec_type,
8371: p_klev_rec IN klev_rec_type,
8372: x_clev_rec OUT NOCOPY clev_rec_type,

Line 8369: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8365: x_return_status OUT NOCOPY VARCHAR2,
8366: x_msg_count OUT NOCOPY NUMBER,
8367: x_msg_data OUT NOCOPY VARCHAR2,
8368: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8369: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8370: p_clev_rec IN clev_rec_type,
8371: p_klev_rec IN klev_rec_type,
8372: x_clev_rec OUT NOCOPY clev_rec_type,
8373: x_klev_rec OUT NOCOPY klev_rec_type,

Line 8452: -- in OKL_TXL_ASSETS_V

8448: RAISE OKL_API.G_EXCEPTION_ERROR;
8449: END IF;
8450: -- Validate to see if the asset_number given is not null
8451: -- and also Validate asset_number does not exists
8452: -- in OKL_TXL_ASSETS_V
8453: IF UPPER(p_new_yn) = 'Y' THEN
8454: validate_new_ast_num_update(x_return_status => x_return_status,
8455: p_asset_number => p_asset_number,
8456: p_kle_id => ln_fa_id,

Line 8623: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8619: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8620: x_return_status OUT NOCOPY VARCHAR2,
8621: x_msg_count OUT NOCOPY NUMBER,
8622: x_msg_data OUT NOCOPY VARCHAR2,
8623: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8624: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8625: p_clev_rec IN clev_rec_type,
8626: p_klev_rec IN klev_rec_type,
8627: x_clev_rec OUT NOCOPY clev_rec_type,

Line 8624: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8620: x_return_status OUT NOCOPY VARCHAR2,
8621: x_msg_count OUT NOCOPY NUMBER,
8622: x_msg_data OUT NOCOPY VARCHAR2,
8623: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8624: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8625: p_clev_rec IN clev_rec_type,
8626: p_klev_rec IN klev_rec_type,
8627: x_clev_rec OUT NOCOPY clev_rec_type,
8628: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 8839: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8835: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8836: x_return_status OUT NOCOPY VARCHAR2,
8837: x_msg_count OUT NOCOPY NUMBER,
8838: x_msg_data OUT NOCOPY VARCHAR2,
8839: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8840: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8841: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8842: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8843: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 8840: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8836: x_return_status OUT NOCOPY VARCHAR2,
8837: x_msg_count OUT NOCOPY NUMBER,
8838: x_msg_data OUT NOCOPY VARCHAR2,
8839: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8840: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8841: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8842: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8843: x_fin_clev_rec OUT NOCOPY clev_rec_type,
8844: x_fin_klev_rec OUT NOCOPY klev_rec_type,

Line 9046: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9042: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9043: x_return_status OUT NOCOPY VARCHAR2,
9044: x_msg_count OUT NOCOPY NUMBER,
9045: x_msg_data OUT NOCOPY VARCHAR2,
9046: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9047: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9048: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9049: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9050: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 9047: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9043: x_return_status OUT NOCOPY VARCHAR2,
9044: x_msg_count OUT NOCOPY NUMBER,
9045: x_msg_data OUT NOCOPY VARCHAR2,
9046: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9047: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9048: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9049: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9050: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9051: x_fin_klev_rec OUT NOCOPY klev_rec_type,

Line 9251: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9247: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9248: x_return_status OUT NOCOPY VARCHAR2,
9249: x_msg_count OUT NOCOPY NUMBER,
9250: x_msg_data OUT NOCOPY VARCHAR2,
9251: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9252: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9253: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9254: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9255: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 9252: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9248: x_return_status OUT NOCOPY VARCHAR2,
9249: x_msg_count OUT NOCOPY NUMBER,
9250: x_msg_data OUT NOCOPY VARCHAR2,
9251: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9252: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9253: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9254: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9255: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9256: x_fin_klev_rec OUT NOCOPY klev_rec_type,

Line 9458: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9454: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9455: x_return_status OUT NOCOPY VARCHAR2,
9456: x_msg_count OUT NOCOPY NUMBER,
9457: x_msg_data OUT NOCOPY VARCHAR2,
9458: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9459: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9460: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9461: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9462: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

Line 9459: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9455: x_return_status OUT NOCOPY VARCHAR2,
9456: x_msg_count OUT NOCOPY NUMBER,
9457: x_msg_data OUT NOCOPY VARCHAR2,
9458: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9459: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9460: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9461: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9462: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
9463: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

Line 9584: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9580: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9581: x_return_status OUT NOCOPY VARCHAR2,
9582: x_msg_count OUT NOCOPY NUMBER,
9583: x_msg_data OUT NOCOPY VARCHAR2,
9584: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9585: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9586: p_clev_rec IN clev_rec_type,
9587: p_klev_rec IN klev_rec_type,
9588: p_cimv_rec IN cimv_rec_type,

Line 9585: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9581: x_return_status OUT NOCOPY VARCHAR2,
9582: x_msg_count OUT NOCOPY NUMBER,
9583: x_msg_data OUT NOCOPY VARCHAR2,
9584: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9585: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9586: p_clev_rec IN clev_rec_type,
9587: p_klev_rec IN klev_rec_type,
9588: p_cimv_rec IN cimv_rec_type,
9589: x_clev_rec OUT NOCOPY clev_rec_type,

Line 9632: -- in OKL_TXL_ASSETS_V

9628: RAISE OKL_API.G_EXCEPTION_ERROR;
9629: END IF;
9630: -- Validate to see if the asset_number given is not null
9631: -- and also Validate asset_number does not exists
9632: -- in OKL_TXL_ASSETS_V
9633: IF UPPER(p_new_yn) = 'Y' THEN
9634: validate_new_asset_number(x_return_status => x_return_status,
9635: p_asset_number => p_asset_number,
9636: p_dnz_chr_id => p_clev_rec.dnz_chr_id);

Line 9758: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9754: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9755: x_return_status OUT NOCOPY VARCHAR2,
9756: x_msg_count OUT NOCOPY NUMBER,
9757: x_msg_data OUT NOCOPY VARCHAR2,
9758: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9759: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9760: p_clev_rec IN clev_rec_type,
9761: p_klev_rec IN klev_rec_type,
9762: p_cimv_rec IN cimv_rec_type,

Line 9759: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9755: x_return_status OUT NOCOPY VARCHAR2,
9756: x_msg_count OUT NOCOPY NUMBER,
9757: x_msg_data OUT NOCOPY VARCHAR2,
9758: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9759: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9760: p_clev_rec IN clev_rec_type,
9761: p_klev_rec IN klev_rec_type,
9762: p_cimv_rec IN cimv_rec_type,
9763: x_clev_rec OUT NOCOPY clev_rec_type,

Line 9837: -- in OKL_TXL_ASSETS_V

9833: RAISE OKL_API.G_EXCEPTION_ERROR;
9834: END IF;
9835: -- Validate to see if the asset_number given is not null
9836: -- and also Validate asset_number does not exists
9837: -- in OKL_TXL_ASSETS_V
9838: IF UPPER(p_new_yn) = 'Y' THEN
9839: validate_new_ast_num_update(x_return_status => x_return_status,
9840: p_asset_number => p_asset_number,
9841: p_kle_id => ln_fa_id,

Line 9967: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9963: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9964: x_return_status OUT NOCOPY VARCHAR2,
9965: x_msg_count OUT NOCOPY NUMBER,
9966: x_msg_data OUT NOCOPY VARCHAR2,
9967: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9968: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9969: p_clev_rec IN clev_rec_type,
9970: p_klev_rec IN klev_rec_type,
9971: p_cimv_rec IN cimv_rec_type,

Line 9968: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9964: x_return_status OUT NOCOPY VARCHAR2,
9965: x_msg_count OUT NOCOPY NUMBER,
9966: x_msg_data OUT NOCOPY VARCHAR2,
9967: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9968: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9969: p_clev_rec IN clev_rec_type,
9970: p_klev_rec IN klev_rec_type,
9971: p_cimv_rec IN cimv_rec_type,
9972: p_talv_rec IN talv_rec_type,

Line 10014: -- in OKL_TXL_ASSETS_V

10010: RAISE OKL_API.G_EXCEPTION_ERROR;
10011: END IF;
10012: -- Validate to see if the asset_number given is not null
10013: -- and also Validate asset_number does not exists
10014: -- in OKL_TXL_ASSETS_V
10015: IF UPPER(p_new_yn) = 'Y' THEN
10016: validate_new_asset_number(x_return_status => x_return_status,
10017: p_asset_number => p_asset_number,
10018: p_dnz_chr_id => p_clev_rec.dnz_chr_id);

Line 10141: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10137: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
10138: x_return_status OUT NOCOPY VARCHAR2,
10139: x_msg_count OUT NOCOPY NUMBER,
10140: x_msg_data OUT NOCOPY VARCHAR2,
10141: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10142: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10143: p_clev_rec IN clev_rec_type,
10144: p_klev_rec IN klev_rec_type,
10145: p_cimv_rec IN cimv_rec_type,

Line 10142: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10138: x_return_status OUT NOCOPY VARCHAR2,
10139: x_msg_count OUT NOCOPY NUMBER,
10140: x_msg_data OUT NOCOPY VARCHAR2,
10141: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10142: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10143: p_clev_rec IN clev_rec_type,
10144: p_klev_rec IN klev_rec_type,
10145: p_cimv_rec IN cimv_rec_type,
10146: p_talv_rec IN talv_rec_type,

Line 10191: -- in OKL_TXL_ASSETS_V

10187: RAISE OKL_API.G_EXCEPTION_ERROR;
10188: END IF;
10189: -- Validate to see if the asset_number given is not null
10190: -- and also Validate asset_number does not exists
10191: -- in OKL_TXL_ASSETS_V
10192: IF UPPER(p_new_yn) = 'Y' THEN
10193: validate_new_ast_num_update(x_return_status => x_return_status,
10194: p_asset_number => p_asset_number,
10195: p_kle_id => p_talv_rec.kle_id,

Line 10314: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10311: x_return_status OUT NOCOPY VARCHAR2,
10312: x_msg_count OUT NOCOPY NUMBER,
10313: x_msg_data OUT NOCOPY VARCHAR2,
10314: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10315: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10316: p_clev_tbl IN clev_tbl_type,
10317: p_klev_tbl IN klev_tbl_type,
10318: p_cimv_tbl IN cimv_tbl_type,

Line 10315: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10311: x_return_status OUT NOCOPY VARCHAR2,
10312: x_msg_count OUT NOCOPY NUMBER,
10313: x_msg_data OUT NOCOPY VARCHAR2,
10314: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10315: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10316: p_clev_tbl IN clev_tbl_type,
10317: p_klev_tbl IN klev_tbl_type,
10318: p_cimv_tbl IN cimv_tbl_type,
10319: x_clev_tbl OUT NOCOPY clev_tbl_type,

Line 10599: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10595: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10596: x_return_status OUT NOCOPY VARCHAR2,
10597: x_msg_count OUT NOCOPY NUMBER,
10598: x_msg_data OUT NOCOPY VARCHAR2,
10599: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10600: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10601: p_clev_tbl IN clev_tbl_type,
10602: p_klev_tbl IN klev_tbl_type,
10603: p_cimv_tbl IN cimv_tbl_type,

Line 10600: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10596: x_return_status OUT NOCOPY VARCHAR2,
10597: x_msg_count OUT NOCOPY NUMBER,
10598: x_msg_data OUT NOCOPY VARCHAR2,
10599: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10600: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10601: p_clev_tbl IN clev_tbl_type,
10602: p_klev_tbl IN klev_tbl_type,
10603: p_cimv_tbl IN cimv_tbl_type,
10604: x_clev_tbl OUT NOCOPY clev_tbl_type,

Line 10853: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10849: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10850: x_return_status OUT NOCOPY VARCHAR2,
10851: x_msg_count OUT NOCOPY NUMBER,
10852: x_msg_data OUT NOCOPY VARCHAR2,
10853: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10854: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10855: p_clev_tbl IN clev_tbl_type,
10856: p_klev_tbl IN klev_tbl_type,
10857: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 10854: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10850: x_return_status OUT NOCOPY VARCHAR2,
10851: x_msg_count OUT NOCOPY NUMBER,
10852: x_msg_data OUT NOCOPY VARCHAR2,
10853: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10854: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10855: p_clev_tbl IN clev_tbl_type,
10856: p_klev_tbl IN klev_tbl_type,
10857: x_fin_clev_rec OUT NOCOPY clev_rec_type,
10858: x_fin_klev_rec OUT NOCOPY klev_rec_type) IS

Line 11525: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%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;
11525: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;
11526: BEGIN
11527: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11528: -- Call start_activity to create savepoint, check compatibility
11529: -- and initialize message list

Line 15036: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

15032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15033: x_return_status OUT NOCOPY VARCHAR2,
15034: x_msg_count OUT NOCOPY NUMBER,
15035: x_msg_data OUT NOCOPY VARCHAR2,
15036: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
15037: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
15038: p_clev_fin_rec IN clev_rec_type,
15039: p_klev_fin_rec IN klev_rec_type,
15040: p_cimv_model_rec IN cimv_rec_type,

Line 15037: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

15033: x_return_status OUT NOCOPY VARCHAR2,
15034: x_msg_count OUT NOCOPY NUMBER,
15035: x_msg_data OUT NOCOPY VARCHAR2,
15036: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
15037: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
15038: p_clev_fin_rec IN clev_rec_type,
15039: p_klev_fin_rec IN klev_rec_type,
15040: p_cimv_model_rec IN cimv_rec_type,
15041: p_clev_fa_rec IN clev_rec_type,

Line 15050: l_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;

15046: x_clev_model_rec OUT NOCOPY clev_rec_type,
15047: x_clev_fa_rec OUT NOCOPY clev_rec_type,
15048: x_clev_ib_rec OUT NOCOPY clev_rec_type) IS
15049: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ALL_LINES';
15050: l_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
15051: m_clev_fin_rec clev_rec_type;
15052: m_klev_fin_rec klev_rec_type;
15053: l_clev_fin_rec clev_rec_type;
15054: l_klev_fin_rec klev_rec_type;

Line 15453: -- in OKL_TXL_ASSETS_V

15449: END IF;
15450: -- 4414408 Validate the Asset Number
15451: -- Validate to see if the asset_number given is not null
15452: -- and also Validate asset_number does not exists
15453: -- in OKL_TXL_ASSETS_V
15454: IF UPPER(p_new_yn) = 'Y' THEN
15455: validate_new_asset_number(x_return_status => x_return_status,
15456: p_asset_number => l_asset_number,
15457: p_dnz_chr_id => l_clev_fin_rec.dnz_chr_id);

Line 16118: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

16114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
16115: x_return_status OUT NOCOPY VARCHAR2,
16116: x_msg_count OUT NOCOPY NUMBER,
16117: x_msg_data OUT NOCOPY VARCHAR2,
16118: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
16119: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
16120: p_clev_fin_rec IN clev_rec_type,
16121: p_klev_fin_rec IN klev_rec_type,
16122: p_clev_model_rec IN clev_rec_type,

Line 16119: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

16115: x_return_status OUT NOCOPY VARCHAR2,
16116: x_msg_count OUT NOCOPY NUMBER,
16117: x_msg_data OUT NOCOPY VARCHAR2,
16118: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
16119: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
16120: p_clev_fin_rec IN clev_rec_type,
16121: p_klev_fin_rec IN klev_rec_type,
16122: p_clev_model_rec IN clev_rec_type,
16123: p_cimv_model_rec IN cimv_rec_type,

Line 16679: p_token1_value => 'OKL_TXL_ASSETS_V Record');

16675: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16676: OKL_API.set_message(p_app_name => G_APP_NAME,
16677: p_msg_name => G_FETCHING_INFO,
16678: p_token1 => G_REC_NAME_TOKEN,
16679: p_token1_value => 'OKL_TXL_ASSETS_V Record');
16680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
16681: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16682: OKL_API.set_message(p_app_name => G_APP_NAME,
16683: p_msg_name => G_FETCHING_INFO,

Line 16685: p_token1_value => 'OKL_TXL_ASSETS_V Record');

16681: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16682: OKL_API.set_message(p_app_name => G_APP_NAME,
16683: p_msg_name => G_FETCHING_INFO,
16684: p_token1 => G_REC_NAME_TOKEN,
16685: p_token1_value => 'OKL_TXL_ASSETS_V Record');
16686: RAISE OKL_API.G_EXCEPTION_ERROR;
16687: END IF;
16688: IF (l_talv_fa_rec.asset_number IS NUll OR
16689: l_talv_fa_rec.asset_number = OKL_API.G_MISS_CHAR) THEN

Line 16699: p_token1_value => 'OKL_TXL_ASSETS_V.ORIGINAL_COST');

16695: l_talv_fa_rec.original_cost = OKL_API.G_MISS_NUM) THEN
16696: OKL_API.set_message(p_app_name => G_APP_NAME,
16697: p_msg_name => G_REQUIRED_VALUE,
16698: p_token1 => G_REC_NAME_TOKEN,
16699: p_token1_value => 'OKL_TXL_ASSETS_V.ORIGINAL_COST');
16700: RAISE OKL_API.G_EXCEPTION_ERROR;
16701: END IF;
16702: IF (l_talv_fa_rec.current_units IS NUll OR
16703: l_talv_fa_rec.current_units = OKL_API.G_MISS_NUM) THEN

Line 16707: p_token1_value => 'OKL_TXL_ASSETS_V.CURRENT_UNITS');

16703: l_talv_fa_rec.current_units = OKL_API.G_MISS_NUM) THEN
16704: OKL_API.set_message(p_app_name => G_APP_NAME,
16705: p_msg_name => G_REQUIRED_VALUE,
16706: p_token1 => G_COL_NAME_TOKEN,
16707: p_token1_value => 'OKL_TXL_ASSETS_V.CURRENT_UNITS');
16708: RAISE OKL_API.G_EXCEPTION_ERROR;
16709: END IF;
16710: l_clev_model_rec.price_unit := l_talv_fa_rec.original_cost;
16711: l_clev_fa_rec.price_unit := l_talv_fa_rec.original_cost;

Line 17817: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

17813: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
17814: x_return_status OUT NOCOPY VARCHAR2,
17815: x_msg_count OUT NOCOPY NUMBER,
17816: x_msg_data OUT NOCOPY VARCHAR2,
17817: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
17818: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
17819: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,
17820: p_clev_ib_rec IN clev_rec_type,
17821: p_itiv_ib_tbl IN itiv_tbl_type,

Line 17818: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

17814: x_return_status OUT NOCOPY VARCHAR2,
17815: x_msg_count OUT NOCOPY NUMBER,
17816: x_msg_data OUT NOCOPY VARCHAR2,
17817: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
17818: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
17819: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,
17820: p_clev_ib_rec IN clev_rec_type,
17821: p_itiv_ib_tbl IN itiv_tbl_type,
17822: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,

Line 17819: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,

17815: x_msg_count OUT NOCOPY NUMBER,
17816: x_msg_data OUT NOCOPY VARCHAR2,
17817: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
17818: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
17819: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,
17820: p_clev_ib_rec IN clev_rec_type,
17821: p_itiv_ib_tbl IN itiv_tbl_type,
17822: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,
17823: x_itiv_ib_tbl OUT NOCOPY itiv_tbl_type,

Line 18714: p_token1_value => 'OKL_TXL_ASSETS_V Record');

18710: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18711: OKL_API.set_message(p_app_name => G_APP_NAME,
18712: p_msg_name => G_FETCHING_INFO,
18713: p_token1 => G_REC_NAME_TOKEN,
18714: p_token1_value => 'OKL_TXL_ASSETS_V Record');
18715: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18716: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18717: OKL_API.set_message(p_app_name => G_APP_NAME,
18718: p_msg_name => G_FETCHING_INFO,

Line 18720: p_token1_value => 'OKL_TXL_ASSETS_V Record');

18716: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18717: OKL_API.set_message(p_app_name => G_APP_NAME,
18718: p_msg_name => G_FETCHING_INFO,
18719: p_token1 => G_REC_NAME_TOKEN,
18720: p_token1_value => 'OKL_TXL_ASSETS_V Record');
18721: RAISE OKL_API.G_EXCEPTION_ERROR;
18722: END IF;
18723:
18724: --Build talv fa item rec

Line 18852: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

18848: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
18849: x_return_status OUT NOCOPY VARCHAR2,
18850: x_msg_count OUT NOCOPY NUMBER,
18851: x_msg_data OUT NOCOPY VARCHAR2,
18852: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
18853: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
18854: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
18855: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
18856: p_itiv_ib_tbl IN itiv_tbl_type,

Line 18853: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

18849: x_return_status OUT NOCOPY VARCHAR2,
18850: x_msg_count OUT NOCOPY NUMBER,
18851: x_msg_data OUT NOCOPY VARCHAR2,
18852: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
18853: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
18854: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
18855: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
18856: p_itiv_ib_tbl IN itiv_tbl_type,
18857: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,

Line 19596: p_token1_value => 'OKL_TXL_ASSETS_V Record');

19592: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19593: OKL_API.set_message(p_app_name => G_APP_NAME,
19594: p_msg_name => G_FETCHING_INFO,
19595: p_token1 => G_REC_NAME_TOKEN,
19596: p_token1_value => 'OKL_TXL_ASSETS_V Record');
19597: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19598: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19599: OKL_API.set_message(p_app_name => G_APP_NAME,
19600: p_msg_name => G_FETCHING_INFO,

Line 19602: p_token1_value => 'OKL_TXL_ASSETS_V Record');

19598: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19599: OKL_API.set_message(p_app_name => G_APP_NAME,
19600: p_msg_name => G_FETCHING_INFO,
19601: p_token1 => G_REC_NAME_TOKEN,
19602: p_token1_value => 'OKL_TXL_ASSETS_V Record');
19603: RAISE OKL_API.G_EXCEPTION_ERROR;
19604: END IF;
19605: --Build talv fa item rec
19606: r_talv_fa_rec.current_units := ln_remain_inst;

Line 19765: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

19761: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
19762: x_return_status OUT NOCOPY VARCHAR2,
19763: x_msg_count OUT NOCOPY NUMBER,
19764: x_msg_data OUT NOCOPY VARCHAR2,
19765: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
19766: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
19767: p_clev_ib_tbl IN clev_tbl_type,
19768: x_clev_fin_rec OUT NOCOPY clev_rec_type,
19769: x_klev_fin_rec OUT NOCOPY klev_rec_type,

Line 19766: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

19762: x_return_status OUT NOCOPY VARCHAR2,
19763: x_msg_count OUT NOCOPY NUMBER,
19764: x_msg_data OUT NOCOPY VARCHAR2,
19765: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
19766: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
19767: p_clev_ib_tbl IN clev_tbl_type,
19768: x_clev_fin_rec OUT NOCOPY clev_rec_type,
19769: x_klev_fin_rec OUT NOCOPY klev_rec_type,
19770: x_cimv_model_rec OUT NOCOPY cimv_rec_type,

Line 20407: p_token1_value => 'OKL_TXL_ASSETS_V Record');

20403: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20404: OKL_API.set_message(p_app_name => G_APP_NAME,
20405: p_msg_name => G_FETCHING_INFO,
20406: p_token1 => G_REC_NAME_TOKEN,
20407: p_token1_value => 'OKL_TXL_ASSETS_V Record');
20408: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20409: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20410: OKL_API.set_message(p_app_name => G_APP_NAME,
20411: p_msg_name => G_FETCHING_INFO,

Line 20413: p_token1_value => 'OKL_TXL_ASSETS_V Record');

20409: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20410: OKL_API.set_message(p_app_name => G_APP_NAME,
20411: p_msg_name => G_FETCHING_INFO,
20412: p_token1 => G_REC_NAME_TOKEN,
20413: p_token1_value => 'OKL_TXL_ASSETS_V Record');
20414: RAISE OKL_API.G_EXCEPTION_ERROR;
20415: END IF;
20416: --Build talv fa item rec
20417: r_talv_fa_rec.current_units := ln_remain_inst;