DBA Data[Home] [Help]

APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKL_OPT_RULES

Line 259: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,

255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_khr_id IN NUMBER,
258: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
259: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
260: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
261: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
262:
263: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 260: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,

256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_khr_id IN NUMBER,
258: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
259: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
260: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
261: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
262:
263: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
264: l_api_name CONSTANT VARCHAR2(30) := 'CHK_AND_CPY_RUL_HDR';

Line 445: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,

441: x_msg_count OUT NOCOPY NUMBER,
442: x_msg_data OUT NOCOPY VARCHAR2,
443: p_khr_id IN NUMBER,
444: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
445: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
446: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
447: p_lse_id IN OKL_OPT_RULES.lrg_lse_id%TYPE,
448: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
449:

Line 446: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,

442: x_msg_data OUT NOCOPY VARCHAR2,
443: p_khr_id IN NUMBER,
444: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
445: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
446: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
447: p_lse_id IN OKL_OPT_RULES.lrg_lse_id%TYPE,
448: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
449:
450: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 447: p_lse_id IN OKL_OPT_RULES.lrg_lse_id%TYPE,

443: p_khr_id IN NUMBER,
444: p_rulv_rec IN OKC_RULE_PUB.rulv_rec_type,
445: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
446: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
447: p_lse_id IN OKL_OPT_RULES.lrg_lse_id%TYPE,
448: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
449:
450: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
451: l_api_name CONSTANT VARCHAR2(30) := 'CHK_AND_CPY_RUL_LINE';

Line 751: FROM OKL_OPT_RULES orl,

747: orl.LRG_SRD_ID,
748: orl.LRG_LSE_ID,
749: orl.RGR_RGD_CODE,
750: orl.RGR_RDF_CODE
751: FROM OKL_OPT_RULES orl,
752: OKC_SUBCLASS_RG_DEFS srd
753: WHERE srd.id = orl.SRD_ID_FOR
754: AND srd.rgd_code = orl.rgr_rgd_code
755: AND srd.scs_code = p_scs_code

Line 775: FROM OKL_OPT_RULES orl,

771: orl.LRG_SRD_ID,
772: orl.LRG_LSE_ID,
773: orl.RGR_RGD_CODE,
774: orl.RGR_RDF_CODE
775: FROM OKL_OPT_RULES orl,
776: OKC_SUBCLASS_RG_DEFS srd,
777: OKC_LSE_RULE_GROUPS lrg
778: WHERE srd.id = lrg.SRD_ID
779: AND srd.rgd_code = orl.rgr_rgd_code