APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_RULE_GROUPS_V

Line 553: OKC_RULE_GROUPS_V RG, OKL_K_LINES_V LN, OKC_LINE_STYLES_V LS

549: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE := null;
550: cursor LINE_STYLE_CSR(P_RGP_ID IN NUMBER) is
551: SELECT LS.LTY_CODE
552: FROM
553: OKC_RULE_GROUPS_V RG, OKL_K_LINES_V LN, OKC_LINE_STYLES_V LS
554: WHERE
555: RG.ID = P_RGP_ID AND
556: RG.CLE_ID = LN.ID AND
557: LN.ID = LS.ID;

Line 1675: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,

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;
1679: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';

Line 1685: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

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;
1689:

Line 1706: FROM OKC_RULE_GROUPS_V WHERE

1702:
1703: cursor RGP_HDR_CSR(P_CHR_ID IN NUMBER) is
1704: SELECT
1705: ID
1706: FROM OKC_RULE_GROUPS_V WHERE
1707: DNZ_CHR_ID = P_CHR_ID AND CHR_ID = P_CHR_ID
1708: AND RGD_CODE = 'LALEVL'
1709: AND CLE_ID IS NULL;
1710:

Line 1714: FROM OKC_RULE_GROUPS_V RG WHERE

1710:
1711: cursor RGP_CLE_CSR(P_CHR_ID IN NUMBER, P_CLE_ID IN NUMBER) is
1712: SELECT
1713: ID
1714: FROM OKC_RULE_GROUPS_V RG WHERE
1715: RG.DNZ_CHR_ID = P_CHR_ID AND RG.CHR_ID IS NULL
1716: AND RGD_CODE = 'LALEVL'
1717: AND RG.CLE_ID = P_CLE_ID;
1718:

Line 1952: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

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:
1956: l_fee_line_type OKL_K_FEE_LINES_UV.FEE_TYPE%TYPE := null;

Line 2565: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

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);
2569: x_primary_sty_id okl_strm_type_b.ID%TYPE;

Line 2807: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

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:
2811: lx_rulv_tbl rulv_tbl_type;

Line 3393: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;

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;
3397: