APPS.OKL_CREATE_KLE_PVT dependencies on OKC_RULES_V

Line 2500: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';

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:
2504: CURSOR c_get_asset_number(p_kle_Id OKL_TXL_ASSETS_V.KLE_ID%TYPE)

Line 2559: FROM OKC_RULES_V

2555: AND cle.dnz_chr_id = chr.id;
2556:
2557: CURSOR c_check_release_asset(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) is
2558: SELECT RULE_INFORMATION1
2559: FROM OKC_RULES_V
2560: WHERE DNZ_CHR_ID = p_dnz_chr_id
2561: AND RULE_INFORMATION_CATEGORY = 'LARLES';
2562:
2563: BEGIN

Line 2578: -- Get the Release asset code from OKC_RULES_V

2574: -- halt validation as it is a required field
2575: RAISE G_EXCEPTION_STOP_VALIDATION;
2576: END IF;
2577:
2578: -- Get the Release asset code from OKC_RULES_V
2579: OPEN c_check_release_asset(p_dnz_chr_id);
2580: FETCH c_check_release_asset into lv_release_asset;
2581: IF c_check_release_asset%NOTFOUND THEN
2582: lv_release_asset := 'N';

Line 2587: p_token1_value => 'OKC_RULES_V.RULE_INFORMATION1');

2583: /* x_return_status := OKL_API.G_RET_STS_ERROR;
2584: OKL_API.set_message(p_app_name => G_APP_NAME,
2585: p_msg_name => G_NO_MATCHING_RECORD,
2586: p_token1 => G_COL_NAME_TOKEN,
2587: p_token1_value => 'OKC_RULES_V.RULE_INFORMATION1');
2588: RAISE G_EXCEPTION_HALT_VALIDATION;*/
2589: END IF;
2590: CLOSE c_check_release_asset;
2591:

Line 2853: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';

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';
2854:
2855: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2856: SELECT 1
2857: --FROM DUAL

Line 2900: FROM OKC_RULES_V

2896: AND TAS.TSU_CODE = 'ENTERED'; --);
2897:
2898: CURSOR c_check_release_asset(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) is
2899: SELECT RULE_INFORMATION1
2900: FROM OKC_RULES_V
2901: WHERE DNZ_CHR_ID = p_dnz_chr_id
2902: AND RULE_INFORMATION_CATEGORY = 'LARLES';
2903:
2904: BEGIN

Line 2928: -- Get the Release asset code from OKC_RULES_V

2924: -- halt validation as it is a required field
2925: RAISE G_EXCEPTION_STOP_VALIDATION;
2926: END IF;
2927:
2928: -- Get the Release asset code from OKC_RULES_V
2929: OPEN c_check_release_asset(p_dnz_chr_id);
2930: FETCH c_check_release_asset into lv_release_asset;
2931: IF c_check_release_asset%NOTFOUND THEN
2932: lv_release_asset := 'N';

Line 2937: p_token1_value => 'OKC_RULES_V.RULE_INFORMATION1');

2933: /* x_return_status := OKL_API.G_RET_STS_ERROR;
2934: OKL_API.set_message(p_app_name => G_APP_NAME,
2935: p_msg_name => G_NO_MATCHING_RECORD,
2936: p_token1 => G_COL_NAME_TOKEN,
2937: p_token1_value => 'OKC_RULES_V.RULE_INFORMATION1');
2938: RAISE G_EXCEPTION_HALT_VALIDATION;*/
2939: END IF;
2940: CLOSE c_check_release_asset;
2941: