APPS.OKL_RGRP_RULES_PROCESS_PVT dependencies on OKC_RG_PARTY_ROLES

Line 971: RETURN OKC_RG_PARTY_ROLES.ID%TYPE IS

967: p_line_id IN NUMBER,
968: p_rgp_id IN NUMBER,
969: p_cpl_id IN NUMBER,
970: p_rrd_id IN NUMBER)
971: RETURN OKC_RG_PARTY_ROLES.ID%TYPE IS
972: -- rule_group_id NUMBER := null;
973: rmp_id NUMBER := null;
974: -- l_rgr_rec rgr_rec_type := p_rgr_rec;
975: cursor RMP_CSR( P_CHR_ID IN NUMBER,P_RGP_ID IN NUMBER, P_CPL_ID IN NUMBER, P_RRD_ID IN NUMBER) is

Line 976: SELECT ID FROM OKC_RG_PARTY_ROLES

972: -- rule_group_id NUMBER := null;
973: rmp_id NUMBER := null;
974: -- l_rgr_rec rgr_rec_type := p_rgr_rec;
975: cursor RMP_CSR( P_CHR_ID IN NUMBER,P_RGP_ID IN NUMBER, P_CPL_ID IN NUMBER, P_RRD_ID IN NUMBER) is
976: SELECT ID FROM OKC_RG_PARTY_ROLES
977: WHERE DNZ_CHR_ID = P_CHR_ID AND
978: RGP_ID = P_RGP_ID AND
979: CPL_ID = P_CPL_ID AND
980: RRD_ID = P_RRD_ID;

Line 1009: SELECT RGP_ID FROM OKC_RG_PARTY_ROLES

1005: -- rule_group_id NUMBER := null;
1006: rgp_id NUMBER := null;
1007: -- l_rgr_rec rgr_rec_type := p_rgr_rec;
1008: cursor RMP_CSR( P_CHR_ID IN NUMBER, P_CPL_ID IN NUMBER, P_RRD_ID IN NUMBER) is
1009: SELECT RGP_ID FROM OKC_RG_PARTY_ROLES
1010: WHERE DNZ_CHR_ID = P_CHR_ID AND
1011: CPL_ID = P_CPL_ID AND
1012: RRD_ID = P_RRD_ID;
1013: BEGIN

Line 1040: rmp_id OKC_RG_PARTY_ROLES.ID%TYPE := null;

1036: p_rgr_rec IN rgr_rec_type) IS
1037: lx_rgr_rec rgr_rec_type := p_rgr_rec;
1038: l_rmpv_rec rmpv_rec_type;
1039: lx_rmpv_rec rmpv_rec_type;
1040: rmp_id OKC_RG_PARTY_ROLES.ID%TYPE := null;
1041: rule_group_id NUMBER := null;
1042: BEGIN
1043: rule_group_id := get_rg_party_roles_rgp_id(
1044: p_api_version => p_api_version,