APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_RULES_V

Line 447: okc_rules_v rule

443:
444: CURSOR okl_bill_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
445: SELECT rule.object1_id1
446: FROM okc_rule_groups_v rgp,
447: okc_rules_v rule
448: WHERE rgp.chr_id = p_chr_id
449: AND rgp.id = rule.rgp_id
450: AND rgp.rgd_code = 'LABILL'
451: AND rule.rule_information_category = 'BTO';

Line 469: l_okl_bill_to_id OKC_RULES_V.OBJECT1_ID1%TYPE;

465:
466: l_okl_customer_id OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE;
467: l_oks_customer_id OKL_LA_LINK_SERVICE_UV.CUSTOMER_ID%TYPE;
468:
469: l_okl_bill_to_id OKC_RULES_V.OBJECT1_ID1%TYPE;
470: l_oks_bill_to_id OKL_LA_LINK_SERVICE_UV.BILL_TO_ID%TYPE;
471:
472: l_oks_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
473: l_okl_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

Line 2970: FROM okc_rules_v rule,

2966: l_api_version CONSTANT NUMBER := 1;
2967:
2968: CURSOR arintf_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2969: SELECT rule.id
2970: FROM okc_rules_v rule,
2971: okc_rule_groups_v rg
2972: WHERE rule.rgp_id = rg.id
2973: AND rule.rule_information_category = 'SBG'
2974: AND rule.jtot_object1_code = 'OKS_TRXTYPE'

Line 2980: l_arintf_rule_id OKC_RULES_V.ID%TYPE;

2976:
2977: p_rulv_rec OKC_RULE_PUB.RULV_REC_TYPE;
2978: x_rulv_rec OKC_RULE_PUB.RULV_REC_TYPE;
2979:
2980: l_arintf_rule_id OKC_RULES_V.ID%TYPE;
2981:
2982: BEGIN
2983: IF (G_DEBUG_ENABLED = 'Y') THEN
2984: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);