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 2664: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2660: -- Enforce validation
2661: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_B
2662: OPEN c_txl_asset_number(p_asset_number,
2663: p_kle_id);
2664: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2665: IF c_txl_asset_number%NOTFOUND THEN
2666: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2667: END IF;
2668: CLOSE c_txl_asset_number;

Line 2700: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2696: -- Enforce validation
2697: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_B
2698: OPEN c_txl_asset_number(p_asset_number,
2699: p_kle_id);
2700: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2701: IF c_txl_asset_number%NOTFOUND THEN
2702: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2703: END IF;
2704: CLOSE c_txl_asset_number;

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

2730:
2731: -- Since we have add this check only the cases if the asset number
2732: -- cannot be duplicate when created new fo re_book scenario
2733: ELSIF lv_source_code = 'OKL_REBOOK' THEN
2734: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_V
2735: OPEN c_txl_asset_number(p_asset_number,
2736: p_kle_Id);
2737: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2738: IF c_txl_asset_number%NOTFOUND THEN

Line 2737: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2733: ELSIF lv_source_code = 'OKL_REBOOK' THEN
2734: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_V
2735: OPEN c_txl_asset_number(p_asset_number,
2736: p_kle_Id);
2737: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2738: IF c_txl_asset_number%NOTFOUND THEN
2739: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2740: END IF;
2741: CLOSE c_txl_asset_number;

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

2765: END IF;
2766: CLOSE c_txd_assets_v;
2767: END IF;
2768:
2769: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
2770: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
2771: -- store SQL error message on message stack
2772: OKL_API.set_message(p_app_name => G_APP_NAME,
2773: p_msg_name => G_ASSET_NUMBER);

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

2771: -- store SQL error message on message stack
2772: OKL_API.set_message(p_app_name => G_APP_NAME,
2773: p_msg_name => G_ASSET_NUMBER);
2774: RAISE G_EXCEPTION_HALT_VALIDATION;
2775: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
2776: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
2777: -- store SQL error message on message stack
2778: OKL_API.set_message(p_app_name => G_APP_NAME,
2779: p_msg_name => G_ASSET_NUMBER);

Line 2867: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

2863: -- Parameters : OUT Return Status, IN Rec Info
2864: -- Version : 1.0
2865: -- End of Commnets
2866: PROCEDURE validate_new_asset_number(x_return_status OUT NOCOPY VARCHAR2,
2867: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2868: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2869: ln_okl_txl_assets_v NUMBER := 0;
2870: ln_okx_assets_v NUMBER := 0;
2871: ln_okx_asset_lines_v NUMBER := 0;

Line 2869: ln_okl_txl_assets_v NUMBER := 0;

2865: -- End of Commnets
2866: PROCEDURE validate_new_asset_number(x_return_status OUT NOCOPY VARCHAR2,
2867: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2868: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2869: ln_okl_txl_assets_v NUMBER := 0;
2870: ln_okx_assets_v NUMBER := 0;
2871: ln_okx_asset_lines_v NUMBER := 0;
2872: ln_okl_txd_assets_v NUMBER := 0;
2873: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';

Line 2910: OKL_TXL_ASSETS_V TXL,

2906: SELECT 1
2907: --FROM DUAL
2908: --WHERE EXISTS (SELECT '1'
2909: FROM OKL_TRX_ASSETS TAS,
2910: OKL_TXL_ASSETS_V TXL,
2911: OKL_TXD_ASSETS_V TXD
2912: WHERE TXD.asset_number = p_asset_number
2913: AND TXD.TAL_ID = TXL.ID
2914: AND TXL.TAL_TYPE = 'ALI'

Line 2988: FETCH c_txl_asset_number into ln_okl_txl_assets_v;

2984: IF (upper(lv_release_asset) = 'N') THEN -- Start of release asset check
2985: -- Enforce validation
2986: -- Validate if the Asset Number exists in OKL_TXL_ASSETS_B
2987: OPEN c_txl_asset_number(p_asset_number);
2988: FETCH c_txl_asset_number into ln_okl_txl_assets_v;
2989: IF c_txl_asset_number%NOTFOUND THEN
2990: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2991: END IF;
2992: CLOSE c_txl_asset_number;

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

3015: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3016: END IF;
3017: CLOSE c_txd_assets_v;
3018:
3019: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
3020: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
3021: -- store SQL error message on message stack
3022: OKL_API.set_message(p_app_name => G_APP_NAME,
3023: p_msg_name => G_ASSET_NUMBER);

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

3021: -- store SQL error message on message stack
3022: OKL_API.set_message(p_app_name => G_APP_NAME,
3023: p_msg_name => G_ASSET_NUMBER);
3024: RAISE G_EXCEPTION_HALT_VALIDATION;
3025: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
3026: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
3027: -- store SQL error message on message stack
3028: OKL_API.set_message(p_app_name => G_APP_NAME,
3029: p_msg_name => G_ASSET_NUMBER);

Line 3723: -- Description : validation with OKL_TXL_ASSETS_V

3719: --------------------------------------------------------------------------------------------
3720: -- Start of Commnets
3721: -- Badrinath Kuchibholta
3722: -- Procedure Name : validate_kle_id
3723: -- Description : validation with OKL_TXL_ASSETS_V
3724: -- Business Rules :
3725: -- Parameters :
3726: -- Version : 1.0
3727: -- End of Commnets

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

3729: PROCEDURE validate_kle_id(p_klev_rec IN klev_rec_type,
3730: x_record_exists OUT NOCOPY VARCHAR2,
3731: x_return_status OUT NOCOPY VARCHAR2) IS
3732: ln_dummy NUMBER := 0;
3733: CURSOR c_kle_id_validate(p_kle_id OKL_TXL_ASSETS_V.KLE_ID%TYPE) IS
3734: SELECT 1
3735: --FROM dual
3736: --WHERE EXISTS (SELECT '1'
3737: FROM OKL_TXL_ASSETS_V

Line 3737: FROM OKL_TXL_ASSETS_V

3733: CURSOR c_kle_id_validate(p_kle_id OKL_TXL_ASSETS_V.KLE_ID%TYPE) IS
3734: SELECT 1
3735: --FROM dual
3736: --WHERE EXISTS (SELECT '1'
3737: FROM OKL_TXL_ASSETS_V
3738: WHERE kle_id = p_kle_id; --);
3739: BEGIN
3740: -- initialize return status
3741: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

3745: -- store SQL error message on message stack
3746: OKL_API.set_message(p_app_name => G_APP_NAME,
3747: p_msg_name => G_REQUIRED_VALUE,
3748: p_token1 => G_COL_NAME_TOKEN,
3749: p_token1_value => 'OKL_TXL_ASSETS_V.KLE_ID');
3750: -- halt validation as it is a required field
3751: RAISE G_EXCEPTION_STOP_VALIDATION;
3752: END IF;
3753: -- Enforce Foreign Key

Line 5937: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;

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);
5936: ln_tas_id OKL_TRX_ASSETS.ID%TYPE;
5937: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;
5938: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FA_LINE_ITEM';
5939: CURSOR c_asset_exist_chr(p_id1 OKX_ASSETS_V.ID1%TYPE,
5940: p_id2 OKX_ASSETS_V.ID2%TYPE,
5941: p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)

Line 6245: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

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

Line 6841: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

6837: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
6838: x_return_status OUT NOCOPY VARCHAR2,
6839: x_msg_count OUT NOCOPY NUMBER,
6840: x_msg_data OUT NOCOPY VARCHAR2,
6841: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6842: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
6843: p_clev_rec IN clev_rec_type,
6844: p_klev_rec IN klev_rec_type,
6845: p_cimv_rec IN cimv_rec_type,

Line 6842: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

6838: x_return_status OUT NOCOPY VARCHAR2,
6839: x_msg_count OUT NOCOPY NUMBER,
6840: x_msg_data OUT NOCOPY VARCHAR2,
6841: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
6842: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
6843: p_clev_rec IN clev_rec_type,
6844: p_klev_rec IN klev_rec_type,
6845: p_cimv_rec IN cimv_rec_type,
6846: x_clev_rec OUT NOCOPY clev_rec_type,

Line 6912: -- in OKL_TXL_ASSETS_V

6908: RAISE OKL_API.G_EXCEPTION_ERROR;
6909: END IF;
6910: -- Validate to see if the asset_number given is not null
6911: -- and also Validate asset_number does not exists
6912: -- in OKL_TXL_ASSETS_V
6913: OPEN get_fa_id(p_top_line => p_clev_rec.cle_id,
6914: p_dnz_chr_id => p_clev_rec.dnz_chr_id);
6915: IF get_fa_id%NOTFOUND THEN
6916: OKL_API.set_message(p_app_name => G_APP_NAME,

Line 7039: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

7035: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
7036: x_return_status OUT NOCOPY VARCHAR2,
7037: x_msg_count OUT NOCOPY NUMBER,
7038: x_msg_data OUT NOCOPY VARCHAR2,
7039: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
7040: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
7041: p_clev_rec IN clev_rec_type,
7042: p_klev_rec IN klev_rec_type,
7043: p_cimv_rec IN cimv_rec_type,

Line 7040: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

7036: x_return_status OUT NOCOPY VARCHAR2,
7037: x_msg_count OUT NOCOPY NUMBER,
7038: x_msg_data OUT NOCOPY VARCHAR2,
7039: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
7040: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
7041: p_clev_rec IN clev_rec_type,
7042: p_klev_rec IN klev_rec_type,
7043: p_cimv_rec IN cimv_rec_type,
7044: x_clev_rec OUT NOCOPY clev_rec_type,

Line 7135: -- in OKL_TXL_ASSETS_V

7131: RAISE OKL_API.G_EXCEPTION_ERROR;
7132: END IF;
7133: -- Validate to see if the asset_number given is not null
7134: -- and also Validate asset_number does not exists
7135: -- in OKL_TXL_ASSETS_V
7136: IF UPPER(p_new_yn) = 'Y' THEN
7137: validate_new_ast_num_update(x_return_status => x_return_status,
7138: p_asset_number => p_asset_number,
7139: p_kle_id => ln_fa_id,

Line 8242: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8238: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8239: x_return_status OUT NOCOPY VARCHAR2,
8240: x_msg_count OUT NOCOPY NUMBER,
8241: x_msg_data OUT NOCOPY VARCHAR2,
8242: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8243: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8244: p_clev_rec IN clev_rec_type,
8245: p_klev_rec IN klev_rec_type,
8246: x_clev_rec OUT NOCOPY clev_rec_type,

Line 8243: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8239: x_return_status OUT NOCOPY VARCHAR2,
8240: x_msg_count OUT NOCOPY NUMBER,
8241: x_msg_data OUT NOCOPY VARCHAR2,
8242: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8243: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8244: p_clev_rec IN clev_rec_type,
8245: p_klev_rec IN klev_rec_type,
8246: x_clev_rec OUT NOCOPY clev_rec_type,
8247: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 8284: -- in OKL_TXL_ASSETS_V

8280: RAISE OKL_API.G_EXCEPTION_ERROR;
8281: END IF;
8282: -- Validate to see if the asset_number given is not null
8283: -- and also Validate asset_number does not exists
8284: -- in OKL_TXL_ASSETS_V
8285: IF UPPER(p_new_yn) = 'Y' THEN
8286: validate_new_asset_number(x_return_status => x_return_status,
8287: p_asset_number => p_asset_number,
8288: p_dnz_chr_id => p_clev_rec.dnz_chr_id);

Line 8409: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8405: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8406: x_return_status OUT NOCOPY VARCHAR2,
8407: x_msg_count OUT NOCOPY NUMBER,
8408: x_msg_data OUT NOCOPY VARCHAR2,
8409: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8410: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8411: p_clev_rec IN clev_rec_type,
8412: p_klev_rec IN klev_rec_type,
8413: x_clev_rec OUT NOCOPY clev_rec_type,

Line 8410: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8406: x_return_status OUT NOCOPY VARCHAR2,
8407: x_msg_count OUT NOCOPY NUMBER,
8408: x_msg_data OUT NOCOPY VARCHAR2,
8409: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8410: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8411: p_clev_rec IN clev_rec_type,
8412: p_klev_rec IN klev_rec_type,
8413: x_clev_rec OUT NOCOPY clev_rec_type,
8414: x_klev_rec OUT NOCOPY klev_rec_type,

Line 8493: -- in OKL_TXL_ASSETS_V

8489: RAISE OKL_API.G_EXCEPTION_ERROR;
8490: END IF;
8491: -- Validate to see if the asset_number given is not null
8492: -- and also Validate asset_number does not exists
8493: -- in OKL_TXL_ASSETS_V
8494: IF UPPER(p_new_yn) = 'Y' THEN
8495: validate_new_ast_num_update(x_return_status => x_return_status,
8496: p_asset_number => p_asset_number,
8497: p_kle_id => ln_fa_id,

Line 8664: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8660: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8661: x_return_status OUT NOCOPY VARCHAR2,
8662: x_msg_count OUT NOCOPY NUMBER,
8663: x_msg_data OUT NOCOPY VARCHAR2,
8664: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8665: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8666: p_clev_rec IN clev_rec_type,
8667: p_klev_rec IN klev_rec_type,
8668: x_clev_rec OUT NOCOPY clev_rec_type,

Line 8665: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8661: x_return_status OUT NOCOPY VARCHAR2,
8662: x_msg_count OUT NOCOPY NUMBER,
8663: x_msg_data OUT NOCOPY VARCHAR2,
8664: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8665: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8666: p_clev_rec IN clev_rec_type,
8667: p_klev_rec IN klev_rec_type,
8668: x_clev_rec OUT NOCOPY clev_rec_type,
8669: x_klev_rec OUT NOCOPY klev_rec_type) IS

Line 8924: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

8920: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8921: x_return_status OUT NOCOPY VARCHAR2,
8922: x_msg_count OUT NOCOPY NUMBER,
8923: x_msg_data OUT NOCOPY VARCHAR2,
8924: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8925: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8926: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8927: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8928: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 8925: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

8921: x_return_status OUT NOCOPY VARCHAR2,
8922: x_msg_count OUT NOCOPY NUMBER,
8923: x_msg_data OUT NOCOPY VARCHAR2,
8924: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
8925: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
8926: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
8927: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
8928: x_fin_clev_rec OUT NOCOPY clev_rec_type,
8929: x_fin_klev_rec OUT NOCOPY klev_rec_type,

Line 9131: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9127: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9128: x_return_status OUT NOCOPY VARCHAR2,
9129: x_msg_count OUT NOCOPY NUMBER,
9130: x_msg_data OUT NOCOPY VARCHAR2,
9131: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9132: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9133: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9134: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9135: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 9132: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9128: x_return_status OUT NOCOPY VARCHAR2,
9129: x_msg_count OUT NOCOPY NUMBER,
9130: x_msg_data OUT NOCOPY VARCHAR2,
9131: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9132: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9133: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9134: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9135: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9136: x_fin_klev_rec OUT NOCOPY klev_rec_type,

Line 9336: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9332: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9333: x_return_status OUT NOCOPY VARCHAR2,
9334: x_msg_count OUT NOCOPY NUMBER,
9335: x_msg_data OUT NOCOPY VARCHAR2,
9336: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9337: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9338: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9339: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9340: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 9337: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9333: x_return_status OUT NOCOPY VARCHAR2,
9334: x_msg_count OUT NOCOPY NUMBER,
9335: x_msg_data OUT NOCOPY VARCHAR2,
9336: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9337: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9338: p_top_line_id IN OKC_K_LINES_V.ID%TYPE, -- 4414408
9339: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
9340: x_fin_clev_rec OUT NOCOPY clev_rec_type,
9341: x_fin_klev_rec OUT NOCOPY klev_rec_type,

Line 9543: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9539: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9540: x_return_status OUT NOCOPY VARCHAR2,
9541: x_msg_count OUT NOCOPY NUMBER,
9542: x_msg_data OUT NOCOPY VARCHAR2,
9543: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9544: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9545: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9546: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9547: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,

Line 9544: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9540: x_return_status OUT NOCOPY VARCHAR2,
9541: x_msg_count OUT NOCOPY NUMBER,
9542: x_msg_data OUT NOCOPY VARCHAR2,
9543: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9544: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9545: p_res_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
9546: p_oec IN OKL_K_LINES_V.OEC%TYPE,
9547: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
9548: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,

Line 9669: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9665: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9666: x_return_status OUT NOCOPY VARCHAR2,
9667: x_msg_count OUT NOCOPY NUMBER,
9668: x_msg_data OUT NOCOPY VARCHAR2,
9669: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9670: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9671: p_clev_rec IN clev_rec_type,
9672: p_klev_rec IN klev_rec_type,
9673: p_cimv_rec IN cimv_rec_type,

Line 9670: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9666: x_return_status OUT NOCOPY VARCHAR2,
9667: x_msg_count OUT NOCOPY NUMBER,
9668: x_msg_data OUT NOCOPY VARCHAR2,
9669: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9670: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9671: p_clev_rec IN clev_rec_type,
9672: p_klev_rec IN klev_rec_type,
9673: p_cimv_rec IN cimv_rec_type,
9674: x_clev_rec OUT NOCOPY clev_rec_type,

Line 9717: -- in OKL_TXL_ASSETS_V

9713: RAISE OKL_API.G_EXCEPTION_ERROR;
9714: END IF;
9715: -- Validate to see if the asset_number given is not null
9716: -- and also Validate asset_number does not exists
9717: -- in OKL_TXL_ASSETS_V
9718: IF UPPER(p_new_yn) = 'Y' THEN
9719: validate_new_asset_number(x_return_status => x_return_status,
9720: p_asset_number => p_asset_number,
9721: p_dnz_chr_id => p_clev_rec.dnz_chr_id);

Line 9843: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

9839: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
9840: x_return_status OUT NOCOPY VARCHAR2,
9841: x_msg_count OUT NOCOPY NUMBER,
9842: x_msg_data OUT NOCOPY VARCHAR2,
9843: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9844: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9845: p_clev_rec IN clev_rec_type,
9846: p_klev_rec IN klev_rec_type,
9847: p_cimv_rec IN cimv_rec_type,

Line 9844: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

9840: x_return_status OUT NOCOPY VARCHAR2,
9841: x_msg_count OUT NOCOPY NUMBER,
9842: x_msg_data OUT NOCOPY VARCHAR2,
9843: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
9844: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
9845: p_clev_rec IN clev_rec_type,
9846: p_klev_rec IN klev_rec_type,
9847: p_cimv_rec IN cimv_rec_type,
9848: x_clev_rec OUT NOCOPY clev_rec_type,

Line 9922: -- in OKL_TXL_ASSETS_V

9918: RAISE OKL_API.G_EXCEPTION_ERROR;
9919: END IF;
9920: -- Validate to see if the asset_number given is not null
9921: -- and also Validate asset_number does not exists
9922: -- in OKL_TXL_ASSETS_V
9923: IF UPPER(p_new_yn) = 'Y' THEN
9924: validate_new_ast_num_update(x_return_status => x_return_status,
9925: p_asset_number => p_asset_number,
9926: p_kle_id => ln_fa_id,

Line 10052: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10048: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
10049: x_return_status OUT NOCOPY VARCHAR2,
10050: x_msg_count OUT NOCOPY NUMBER,
10051: x_msg_data OUT NOCOPY VARCHAR2,
10052: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10053: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10054: p_clev_rec IN clev_rec_type,
10055: p_klev_rec IN klev_rec_type,
10056: p_cimv_rec IN cimv_rec_type,

Line 10053: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10049: x_return_status OUT NOCOPY VARCHAR2,
10050: x_msg_count OUT NOCOPY NUMBER,
10051: x_msg_data OUT NOCOPY VARCHAR2,
10052: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10053: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10054: p_clev_rec IN clev_rec_type,
10055: p_klev_rec IN klev_rec_type,
10056: p_cimv_rec IN cimv_rec_type,
10057: p_talv_rec IN talv_rec_type,

Line 10099: -- in OKL_TXL_ASSETS_V

10095: RAISE OKL_API.G_EXCEPTION_ERROR;
10096: END IF;
10097: -- Validate to see if the asset_number given is not null
10098: -- and also Validate asset_number does not exists
10099: -- in OKL_TXL_ASSETS_V
10100: IF UPPER(p_new_yn) = 'Y' THEN
10101: validate_new_asset_number(x_return_status => x_return_status,
10102: p_asset_number => p_asset_number,
10103: p_dnz_chr_id => p_clev_rec.dnz_chr_id);

Line 10226: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10222: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
10223: x_return_status OUT NOCOPY VARCHAR2,
10224: x_msg_count OUT NOCOPY NUMBER,
10225: x_msg_data OUT NOCOPY VARCHAR2,
10226: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10227: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10228: p_clev_rec IN clev_rec_type,
10229: p_klev_rec IN klev_rec_type,
10230: p_cimv_rec IN cimv_rec_type,

Line 10227: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10223: x_return_status OUT NOCOPY VARCHAR2,
10224: x_msg_count OUT NOCOPY NUMBER,
10225: x_msg_data OUT NOCOPY VARCHAR2,
10226: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10227: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10228: p_clev_rec IN clev_rec_type,
10229: p_klev_rec IN klev_rec_type,
10230: p_cimv_rec IN cimv_rec_type,
10231: p_talv_rec IN talv_rec_type,

Line 10276: -- in OKL_TXL_ASSETS_V

10272: RAISE OKL_API.G_EXCEPTION_ERROR;
10273: END IF;
10274: -- Validate to see if the asset_number given is not null
10275: -- and also Validate asset_number does not exists
10276: -- in OKL_TXL_ASSETS_V
10277: IF UPPER(p_new_yn) = 'Y' THEN
10278: validate_new_ast_num_update(x_return_status => x_return_status,
10279: p_asset_number => p_asset_number,
10280: p_kle_id => p_talv_rec.kle_id,

Line 10399: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10395: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10396: x_return_status OUT NOCOPY VARCHAR2,
10397: x_msg_count OUT NOCOPY NUMBER,
10398: x_msg_data OUT NOCOPY VARCHAR2,
10399: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10400: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10401: p_clev_tbl IN clev_tbl_type,
10402: p_klev_tbl IN klev_tbl_type,
10403: p_cimv_tbl IN cimv_tbl_type,

Line 10400: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10396: x_return_status OUT NOCOPY VARCHAR2,
10397: x_msg_count OUT NOCOPY NUMBER,
10398: x_msg_data OUT NOCOPY VARCHAR2,
10399: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10400: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10401: p_clev_tbl IN clev_tbl_type,
10402: p_klev_tbl IN klev_tbl_type,
10403: p_cimv_tbl IN cimv_tbl_type,
10404: x_clev_tbl OUT NOCOPY clev_tbl_type,

Line 10684: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10680: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10681: x_return_status OUT NOCOPY VARCHAR2,
10682: x_msg_count OUT NOCOPY NUMBER,
10683: x_msg_data OUT NOCOPY VARCHAR2,
10684: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10685: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10686: p_clev_tbl IN clev_tbl_type,
10687: p_klev_tbl IN klev_tbl_type,
10688: p_cimv_tbl IN cimv_tbl_type,

Line 10685: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10681: x_return_status OUT NOCOPY VARCHAR2,
10682: x_msg_count OUT NOCOPY NUMBER,
10683: x_msg_data OUT NOCOPY VARCHAR2,
10684: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10685: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10686: p_clev_tbl IN clev_tbl_type,
10687: p_klev_tbl IN klev_tbl_type,
10688: p_cimv_tbl IN cimv_tbl_type,
10689: x_clev_tbl OUT NOCOPY clev_tbl_type,

Line 10938: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

10934: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10935: x_return_status OUT NOCOPY VARCHAR2,
10936: x_msg_count OUT NOCOPY NUMBER,
10937: x_msg_data OUT NOCOPY VARCHAR2,
10938: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10939: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10940: p_clev_tbl IN clev_tbl_type,
10941: p_klev_tbl IN klev_tbl_type,
10942: x_fin_clev_rec OUT NOCOPY clev_rec_type,

Line 10939: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

10935: x_return_status OUT NOCOPY VARCHAR2,
10936: x_msg_count OUT NOCOPY NUMBER,
10937: x_msg_data OUT NOCOPY VARCHAR2,
10938: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
10939: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
10940: p_clev_tbl IN clev_tbl_type,
10941: p_klev_tbl IN klev_tbl_type,
10942: x_fin_clev_rec OUT NOCOPY clev_rec_type,
10943: x_fin_klev_rec OUT NOCOPY klev_rec_type) IS

Line 11610: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%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;
11610: ln_line_number OKL_TXL_ASSETS_V.LINE_NUMBER%TYPE;
11611: BEGIN
11612: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11613: -- Call start_activity to create savepoint, check compatibility
11614: -- and initialize message list

Line 15145: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

15141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15142: x_return_status OUT NOCOPY VARCHAR2,
15143: x_msg_count OUT NOCOPY NUMBER,
15144: x_msg_data OUT NOCOPY VARCHAR2,
15145: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
15146: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
15147: p_clev_fin_rec IN clev_rec_type,
15148: p_klev_fin_rec IN klev_rec_type,
15149: p_cimv_model_rec IN cimv_rec_type,

Line 15146: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

15142: x_return_status OUT NOCOPY VARCHAR2,
15143: x_msg_count OUT NOCOPY NUMBER,
15144: x_msg_data OUT NOCOPY VARCHAR2,
15145: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
15146: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
15147: p_clev_fin_rec IN clev_rec_type,
15148: p_klev_fin_rec IN klev_rec_type,
15149: p_cimv_model_rec IN cimv_rec_type,
15150: p_clev_fa_rec IN clev_rec_type,

Line 15159: l_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;

15155: x_clev_model_rec OUT NOCOPY clev_rec_type,
15156: x_clev_fa_rec OUT NOCOPY clev_rec_type,
15157: x_clev_ib_rec OUT NOCOPY clev_rec_type) IS
15158: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ALL_LINES';
15159: l_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;
15160: m_clev_fin_rec clev_rec_type;
15161: m_klev_fin_rec klev_rec_type;
15162: l_clev_fin_rec clev_rec_type;
15163: l_klev_fin_rec klev_rec_type;

Line 15591: -- in OKL_TXL_ASSETS_V

15587: END IF;
15588: -- 4414408 Validate the Asset Number
15589: -- Validate to see if the asset_number given is not null
15590: -- and also Validate asset_number does not exists
15591: -- in OKL_TXL_ASSETS_V
15592: IF UPPER(p_new_yn) = 'Y' THEN
15593: validate_new_asset_number(x_return_status => x_return_status,
15594: p_asset_number => l_asset_number,
15595: p_dnz_chr_id => l_clev_fin_rec.dnz_chr_id);

Line 16256: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

16252: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
16253: x_return_status OUT NOCOPY VARCHAR2,
16254: x_msg_count OUT NOCOPY NUMBER,
16255: x_msg_data OUT NOCOPY VARCHAR2,
16256: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
16257: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
16258: p_clev_fin_rec IN clev_rec_type,
16259: p_klev_fin_rec IN klev_rec_type,
16260: p_clev_model_rec IN clev_rec_type,

Line 16257: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

16253: x_return_status OUT NOCOPY VARCHAR2,
16254: x_msg_count OUT NOCOPY NUMBER,
16255: x_msg_data OUT NOCOPY VARCHAR2,
16256: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
16257: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
16258: p_clev_fin_rec IN clev_rec_type,
16259: p_klev_fin_rec IN klev_rec_type,
16260: p_clev_model_rec IN clev_rec_type,
16261: p_cimv_model_rec IN cimv_rec_type,

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

16870: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
16871: OKL_API.set_message(p_app_name => G_APP_NAME,
16872: p_msg_name => G_FETCHING_INFO,
16873: p_token1 => G_REC_NAME_TOKEN,
16874: p_token1_value => 'OKL_TXL_ASSETS_V Record');
16875: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
16876: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16877: OKL_API.set_message(p_app_name => G_APP_NAME,
16878: p_msg_name => G_FETCHING_INFO,

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

16876: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
16877: OKL_API.set_message(p_app_name => G_APP_NAME,
16878: p_msg_name => G_FETCHING_INFO,
16879: p_token1 => G_REC_NAME_TOKEN,
16880: p_token1_value => 'OKL_TXL_ASSETS_V Record');
16881: RAISE OKL_API.G_EXCEPTION_ERROR;
16882: END IF;
16883: IF (l_talv_fa_rec.asset_number IS NUll OR
16884: l_talv_fa_rec.asset_number = OKL_API.G_MISS_CHAR) THEN

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

16890: l_talv_fa_rec.original_cost = OKL_API.G_MISS_NUM) THEN
16891: OKL_API.set_message(p_app_name => G_APP_NAME,
16892: p_msg_name => G_REQUIRED_VALUE,
16893: p_token1 => G_REC_NAME_TOKEN,
16894: p_token1_value => 'OKL_TXL_ASSETS_V.ORIGINAL_COST');
16895: RAISE OKL_API.G_EXCEPTION_ERROR;
16896: END IF;
16897: IF (l_talv_fa_rec.current_units IS NUll OR
16898: l_talv_fa_rec.current_units = OKL_API.G_MISS_NUM) THEN

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

16898: l_talv_fa_rec.current_units = OKL_API.G_MISS_NUM) THEN
16899: OKL_API.set_message(p_app_name => G_APP_NAME,
16900: p_msg_name => G_REQUIRED_VALUE,
16901: p_token1 => G_COL_NAME_TOKEN,
16902: p_token1_value => 'OKL_TXL_ASSETS_V.CURRENT_UNITS');
16903: RAISE OKL_API.G_EXCEPTION_ERROR;
16904: END IF;
16905: l_clev_model_rec.price_unit := l_talv_fa_rec.original_cost;
16906: l_clev_fa_rec.price_unit := l_talv_fa_rec.original_cost;

Line 18024: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

18020: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
18021: x_return_status OUT NOCOPY VARCHAR2,
18022: x_msg_count OUT NOCOPY NUMBER,
18023: x_msg_data OUT NOCOPY VARCHAR2,
18024: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
18025: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
18026: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,
18027: p_clev_ib_rec IN clev_rec_type,
18028: p_itiv_ib_tbl IN itiv_tbl_type,

Line 18025: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

18021: x_return_status OUT NOCOPY VARCHAR2,
18022: x_msg_count OUT NOCOPY NUMBER,
18023: x_msg_data OUT NOCOPY VARCHAR2,
18024: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
18025: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
18026: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,
18027: p_clev_ib_rec IN clev_rec_type,
18028: p_itiv_ib_tbl IN itiv_tbl_type,
18029: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,

Line 18026: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,

18022: x_msg_count OUT NOCOPY NUMBER,
18023: x_msg_data OUT NOCOPY VARCHAR2,
18024: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
18025: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
18026: p_current_units IN OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,
18027: p_clev_ib_rec IN clev_rec_type,
18028: p_itiv_ib_tbl IN itiv_tbl_type,
18029: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,
18030: x_itiv_ib_tbl OUT NOCOPY itiv_tbl_type,

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

18941: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
18942: OKL_API.set_message(p_app_name => G_APP_NAME,
18943: p_msg_name => G_FETCHING_INFO,
18944: p_token1 => G_REC_NAME_TOKEN,
18945: p_token1_value => 'OKL_TXL_ASSETS_V Record');
18946: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
18947: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18948: OKL_API.set_message(p_app_name => G_APP_NAME,
18949: p_msg_name => G_FETCHING_INFO,

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

18947: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
18948: OKL_API.set_message(p_app_name => G_APP_NAME,
18949: p_msg_name => G_FETCHING_INFO,
18950: p_token1 => G_REC_NAME_TOKEN,
18951: p_token1_value => 'OKL_TXL_ASSETS_V Record');
18952: RAISE OKL_API.G_EXCEPTION_ERROR;
18953: END IF;
18954:
18955: --Build talv fa item rec

Line 19083: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

19079: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
19080: x_return_status OUT NOCOPY VARCHAR2,
19081: x_msg_count OUT NOCOPY NUMBER,
19082: x_msg_data OUT NOCOPY VARCHAR2,
19083: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
19084: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
19085: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
19086: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
19087: p_itiv_ib_tbl IN itiv_tbl_type,

Line 19084: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

19080: x_return_status OUT NOCOPY VARCHAR2,
19081: x_msg_count OUT NOCOPY NUMBER,
19082: x_msg_data OUT NOCOPY VARCHAR2,
19083: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
19084: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
19085: p_top_line_id IN OKC_K_LINES_V.ID%TYPE,
19086: p_dnz_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
19087: p_itiv_ib_tbl IN itiv_tbl_type,
19088: x_clev_ib_tbl OUT NOCOPY clev_tbl_type,

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

19847: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
19848: OKL_API.set_message(p_app_name => G_APP_NAME,
19849: p_msg_name => G_FETCHING_INFO,
19850: p_token1 => G_REC_NAME_TOKEN,
19851: p_token1_value => 'OKL_TXL_ASSETS_V Record');
19852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
19853: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19854: OKL_API.set_message(p_app_name => G_APP_NAME,
19855: p_msg_name => G_FETCHING_INFO,

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

19853: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
19854: OKL_API.set_message(p_app_name => G_APP_NAME,
19855: p_msg_name => G_FETCHING_INFO,
19856: p_token1 => G_REC_NAME_TOKEN,
19857: p_token1_value => 'OKL_TXL_ASSETS_V Record');
19858: RAISE OKL_API.G_EXCEPTION_ERROR;
19859: END IF;
19860: --Build talv fa item rec
19861: r_talv_fa_rec.current_units := ln_remain_inst;

Line 20021: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

20017: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
20018: x_return_status OUT NOCOPY VARCHAR2,
20019: x_msg_count OUT NOCOPY NUMBER,
20020: x_msg_data OUT NOCOPY VARCHAR2,
20021: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
20022: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
20023: p_clev_ib_tbl IN clev_tbl_type,
20024: x_clev_fin_rec OUT NOCOPY clev_rec_type,
20025: x_klev_fin_rec OUT NOCOPY klev_rec_type,

Line 20022: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,

20018: x_return_status OUT NOCOPY VARCHAR2,
20019: x_msg_count OUT NOCOPY NUMBER,
20020: x_msg_data OUT NOCOPY VARCHAR2,
20021: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
20022: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
20023: p_clev_ib_tbl IN clev_tbl_type,
20024: x_clev_fin_rec OUT NOCOPY clev_rec_type,
20025: x_klev_fin_rec OUT NOCOPY klev_rec_type,
20026: x_cimv_model_rec OUT NOCOPY cimv_rec_type,

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

20684: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20685: OKL_API.set_message(p_app_name => G_APP_NAME,
20686: p_msg_name => G_FETCHING_INFO,
20687: p_token1 => G_REC_NAME_TOKEN,
20688: p_token1_value => 'OKL_TXL_ASSETS_V Record');
20689: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20690: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20691: OKL_API.set_message(p_app_name => G_APP_NAME,
20692: p_msg_name => G_FETCHING_INFO,

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

20690: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20691: OKL_API.set_message(p_app_name => G_APP_NAME,
20692: p_msg_name => G_FETCHING_INFO,
20693: p_token1 => G_REC_NAME_TOKEN,
20694: p_token1_value => 'OKL_TXL_ASSETS_V Record');
20695: RAISE OKL_API.G_EXCEPTION_ERROR;
20696: END IF;
20697: --Build talv fa item rec
20698: r_talv_fa_rec.current_units := ln_remain_inst;