APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_RULES_V

Line 964: FROM OKC_RULES_V

960: --Also added FND_DATE.canonical_to_date(rule_information2) to covert the rule_information2 to date format
961: CURSOR l_okl_stub_start_csr
962: IS
963: SELECT MAX(FND_DATE.canonical_to_date(RULE_INFORMATION2)+to_number(RULE_INFORMATION7)) start_date
964: FROM OKC_RULES_V
965: WHERE rgp_id = p_rgp_id
966: AND dnz_chr_id = p_dnz_chr_id
967: AND object2_id1 = p_slh_id
968: AND id <> p_rule_id

Line 1674: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,

1670: p_service_fee_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1671: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1672: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1673: x_pym_level OUT NOCOPY VARCHAR2,
1674: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1675: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1676: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS
1677:
1678: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1684: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

1680: l_api_version CONSTANT NUMBER := 1.0;
1681:
1682: l_pym_level VARCHAR2(30) := 'HEADER';
1683: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1684: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1685: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1686: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1687:
1688: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 1951: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

1947: lx_rgpv_rec OKL_RULE_PUB.rgpv_rec_type := NULL;
1948:
1949: l_pym_level VARCHAR2(30) := 'HEADER';
1950: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1951: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1952: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1953: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1954: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
1955:

Line 1954: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;

1950: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1951: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
1952: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
1953: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
1954: l_stream_id OKC_RULES_V.OBJECT1_ID1%TYPE := OKL_API.G_MISS_CHAR;
1955:
1956: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;
1957: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
1958: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 2564: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

2560: l_flag VARCHAR2(1) := 'N';
2561: l_term okl_k_headers.term_duration%TYPE;
2562:
2563: l_pym_level VARCHAR2(30) := 'HEADER';
2564: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2565: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2566: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2567:
2568: -- x_return_status varchar2(1);

Line 2806: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

2802: l_api_version CONSTANT NUMBER := 1.0;
2803:
2804: l_pym_level VARCHAR2(30) := 'HEADER';
2805: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2806: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2807: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2808: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2809: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
2810:

Line 3392: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;

3388:
3389: l_term okl_k_headers.term_duration%TYPE;
3390:
3391: l_pym_level VARCHAR2(30) := 'HEADER';
3392: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3393: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3394: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3395:
3396: x_primary_sty_id okl_strm_type_b.ID%TYPE;