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 1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,

1878: p_asset_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM,
1879: p_payment_id OKL_STRMTYP_SOURCE_V.ID1%TYPE,
1880: x_pym_level OUT NOCOPY VARCHAR2,
1881: x_slh_id OUT NOCOPY OKC_RULES_V.ID%TYPE,
1882: x_rgp_id OUT NOCOPY OKC_RULE_GROUPS_V.ID%TYPE,
1883: x_cle_id OUT NOCOPY OKC_K_LINES_B.ID%TYPE) IS
1884:
1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1886: l_api_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT';

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

1888:
1889: l_pym_level VARCHAR2(30) := 'HEADER';
1890: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
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:

Line 1913: FROM OKC_RULE_GROUPS_V WHERE

1909:
1910: cursor RGP_HDR_CSR(P_CHR_ID IN NUMBER) is
1911: SELECT
1912: ID
1913: FROM OKC_RULE_GROUPS_V WHERE
1914: DNZ_CHR_ID = P_CHR_ID AND CHR_ID = P_CHR_ID
1915: AND RGD_CODE = 'LALEVL'
1916: AND CLE_ID IS NULL;
1917:

Line 1921: FROM OKC_RULE_GROUPS_V RG WHERE

1917:
1918: cursor RGP_CLE_CSR(P_CHR_ID IN NUMBER, P_CLE_ID IN NUMBER) is
1919: SELECT
1920: ID
1921: FROM OKC_RULE_GROUPS_V RG WHERE
1922: RG.DNZ_CHR_ID = P_CHR_ID AND RG.CHR_ID IS NULL
1923: AND RGD_CODE = 'LALEVL'
1924: AND RG.CLE_ID = P_CLE_ID;
1925:

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

2155:
2156: l_pym_level VARCHAR2(30) := 'HEADER';
2157: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2158: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
2159: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2160: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
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;

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

2829: l_term okl_k_headers.term_duration%TYPE;
2830:
2831: l_pym_level VARCHAR2(30) := 'HEADER';
2832: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
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;

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

3071:
3072: l_pym_level VARCHAR2(30) := 'HEADER';
3073: l_subline_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3074: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3075: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3076: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3077: l_stream_id OKL_STRMTYP_SOURCE_V.ID1%TYPE := OKL_API.G_MISS_NUM;
3078:
3079: lx_rulv_tbl rulv_tbl_type;

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

3687: l_term okl_k_headers.term_duration%TYPE;
3688:
3689: l_pym_level VARCHAR2(30) := 'HEADER';
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: