[Home] [Help]
1076: --Bug# 6438785
1077: p_validate_date_yn IN VARCHAR2 DEFAULT 'Y',
1078: p_update_type IN VARCHAR2 DEFAULT NULL) IS
1079: i NUMBER := 0;
1080: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1081: l_start_date date := null;
1082: l_prev_start_date date := null;
1083: l_end_date date := null;
1084: l_k_start_date date := null;
1413: l_api_version CONSTANT NUMBER := 1.0;
1414:
1415: i NUMBER := 0;
1416: l_rulv_rec rulv_rec_type := p_rulv_rec;
1417: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1418: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
1419:
1420: l_days boolean := false;
1421: l_days_amt boolean := false;
1891: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1892: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1893: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1894:
1895: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
1896:
1897: ------------- temp
1898: Cursor get_dir is
1899: SELECT nvl(substrb(translate(ltrim(value),',',' '),
2161: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
2162:
2163: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;
2164: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
2165: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
2166:
2167: --Bug# 13973475
2168: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
2169: l_stream_type_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
2810: p_chr_id IN NUMBER,
2811: x_rulv_tbl OUT NOCOPY rulv_tbl_type
2812: ) IS
2813: i NUMBER := 0;
2814: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
2815:
2816: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2817: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
2818: -- x_rulv_tbl OKL_RULE_PUB.RULV_TBL_TYPE;