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 2562: FROM OKC_RULES_V

2558: -- but needs to be validated at contract line
2559: -- Cursor modified to include validation at asset line level
2560: /*CURSOR c_check_release_asset(p_dnz_chr_id OKC_K_HEADERS_B.ID%TYPE) is
2561: SELECT RULE_INFORMATION1
2562: FROM OKC_RULES_V
2563: WHERE DNZ_CHR_ID = p_dnz_chr_id
2564: AND RULE_INFORMATION_CATEGORY = 'LARLES';*/
2565:
2566: CURSOR c_check_release_asset(p_asset_number IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

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

2590: -- halt validation as it is a required field
2591: RAISE G_EXCEPTION_STOP_VALIDATION;
2592: END IF;
2593:
2594: -- Get the Release asset code from OKC_RULES_V
2595: --Bug# 15992711 : Change in number of parameters passed to new cursor
2596: --OPEN c_check_release_asset(p_dnz_chr_id);
2597: OPEN c_check_release_asset(p_asset_number);
2598: -- Bug# 15992711 : End of Modifications

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

2603: /* x_return_status := OKL_API.G_RET_STS_ERROR;
2604: OKL_API.set_message(p_app_name => G_APP_NAME,
2605: p_msg_name => G_NO_MATCHING_RECORD,
2606: p_token1 => G_COL_NAME_TOKEN,
2607: p_token1_value => 'OKC_RULES_V.RULE_INFORMATION1');
2608: RAISE G_EXCEPTION_HALT_VALIDATION;*/
2609: END IF;
2610: CLOSE c_check_release_asset;
2611:

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

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';
2874:
2875: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2876: SELECT 1
2877: --FROM DUAL

Line 2923: FROM OKC_RULES_V

2919: -- but needs to be validated at contract line
2920: -- Cursor modified to include validation at asset line level
2921: /*CURSOR c_check_release_asset(p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) is
2922: SELECT RULE_INFORMATION1
2923: FROM OKC_RULES_V
2924: WHERE DNZ_CHR_ID = p_dnz_chr_id
2925: AND RULE_INFORMATION_CATEGORY = 'LARLES';*/
2926:
2927: CURSOR c_check_release_asset(p_asset_number IN OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

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

2961: -- halt validation as it is a required field
2962: RAISE G_EXCEPTION_STOP_VALIDATION;
2963: END IF;
2964:
2965: -- Get the Release asset code from OKC_RULES_V
2966: -- Bug# 15992711 : Change in number of parameters passed to new cursor
2967: -- OPEN c_check_release_asset(p_dnz_chr_id);
2968: OPEN c_check_release_asset(p_asset_number);
2969: -- Bug# 15992711 : End of Modifications

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

2974: /* x_return_status := OKL_API.G_RET_STS_ERROR;
2975: OKL_API.set_message(p_app_name => G_APP_NAME,
2976: p_msg_name => G_NO_MATCHING_RECORD,
2977: p_token1 => G_COL_NAME_TOKEN,
2978: p_token1_value => 'OKC_RULES_V.RULE_INFORMATION1');
2979: RAISE G_EXCEPTION_HALT_VALIDATION;*/
2980: END IF;
2981: CLOSE c_check_release_asset;
2982: