[Home] [Help]
217: CURSOR c_principal_pymts_yn(p_chr_id IN NUMBER) IS
218: SELECT 'Y'
219: FROM okc_rule_groups_b rgp,
220: okc_rules_b rul,
221: okl_strm_type_b sty,
222: okc_k_lines_b cle
223: WHERE rgp.rgd_code = 'LALEVL'
224: AND rgp.dnz_chr_id = p_chr_id
225: AND rul.dnz_chr_id = rgp.dnz_chr_id
650: cursor PAYMENT_TYPE_CSR(P_SLH_ID IN VARCHAR2) is
651: -- SELECT STRM.CODE
652: SELECT STRM.STREAM_TYPE_PURPOSE
653: FROM OKC_RULES_B RUL,
654: OKL_STRM_TYPE_B STRM
655: WHERE RUL.ID = TO_NUMBER(P_SLH_ID)
656: AND STRM.ID = TO_NUMBER(RUL.OBJECT1_ID1);
657:
658: BEGIN
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;
2170:
2171: ------------- temp
2172: Cursor get_dir is
2173: SELECT nvl(substrb(translate(ltrim(value),',',' '),
2833: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2834: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2835:
2836: -- x_return_status varchar2(1);
2837: x_primary_sty_id okl_strm_type_b.ID%TYPE;
2838:
2839: /*
2840: *CURSOR VIR_PAYMENT (P_CHR_ID IN NUMBER) IS
2841: *SELECT 'Y', K.TERM_DURATION
3462: l_chr_id OKC_K_HEADERS_B.id%TYPE;
3463:
3464: --Bug# 13973475
3465: l_pdt_parameter_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
3466: l_stream_type_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
3467:
3468: begin
3469:
3470: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3690: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3691: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3692: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3693:
3694: x_primary_sty_id okl_strm_type_b.ID%TYPE;
3695:
3696: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
3697: l_interest_calculation_basis VARCHAR2(30);
3698: l_revenue_recognition_method VARCHAR2(30);