DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_RULE_GROUPS_V

Line 1288: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,

1284: x_msg_count OUT NOCOPY NUMBER,
1285: x_msg_data OUT NOCOPY VARCHAR2,
1286: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1287: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
1288: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1289: p_rule_code IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
1290: x_rulv_tbl OUT NOCOPY rulv_tbl_type,
1291: x_rule_count OUT NOCOPY NUMBER
1292: ) IS

Line 1297: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,

1293: l_proc_name VARCHAR2(35) := 'GET_CONTRACT_RULES';
1294:
1295: CURSOR rulv_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1296: p_cle_id OKC_K_LINES_V.ID%TYPE,
1297: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1298: p_rule_code OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE) IS
1299: SELECT
1300: rule.ID,
1301: rule.OBJECT_VERSION_NUMBER,

Line 1361: FROM okc_rule_groups_v rg,

1357: rule.ans_set_jtot_object_code,
1358: rule.ans_set_jtot_object_id1,
1359: rule.ans_set_jtot_object_id2,
1360: rule.DISPLAY_SEQUENCE
1361: FROM okc_rule_groups_v rg,
1362: okc_rules_v rule
1363: WHERE rg.id = rule.rgp_id
1364: AND rg.dnz_chr_id = p_chr_id
1365: AND ( ( p_cle_id IS NULL

Line 5601: FROM okc_rule_groups_v rgp

5597:
5598: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,
5599: p_cle_id okc_k_lines_v.id%TYPE) IS
5600: SELECT rgp.id
5601: FROM okc_rule_groups_v rgp
5602: WHERE rgp.dnz_chr_id = p_chr_id
5603: AND rgp.cle_id = p_cle_id
5604: AND rgp.rgd_code = 'LAASTX'
5605: AND rgp.rgp_type = 'KRG';

Line 5624: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

5620: WHERE rule.dnz_chr_id = p_chr_id
5621: AND rule.rgp_id = p_rgp_id
5622: AND rule.rule_information_category = 'LAPRTX';
5623:
5624: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
5625: ln_rule_id OKC_RULES_V.ID%TYPE;
5626: -- 5179119
5627: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
5628: l_sales_tax_rule_found BOOLEAN;

Line 6186: FROM okc_rule_groups_v rgp

6182: -- 5179119
6183: CURSOR get_sales_tax_rgp_info(p_chr_id okc_k_headers_b.id%TYPE,
6184: p_cle_id okc_k_lines_v.id%TYPE) IS
6185: SELECT rgp.id
6186: FROM okc_rule_groups_v rgp
6187: WHERE rgp.dnz_chr_id = p_chr_id
6188: AND rgp.cle_id = p_cle_id
6189: AND rgp.rgd_code = 'LAASTX'
6190: AND rgp.rgp_type = 'KRG';

Line 6200: l_sales_tax_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

6196: WHERE rule.dnz_chr_id = p_chr_id
6197: AND rule.rgp_id = p_rgp_id
6198: AND rule.rule_information_category = 'LAASTX';
6199:
6200: l_sales_tax_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
6201: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
6202: l_sales_tax_rgp_found BOOLEAN;
6203: l_sales_tax_rule_found BOOLEAN;
6204: l_create_rule_group BOOLEAN;

Line 7922: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;

7918: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7919: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7920: x_index_id okl_indices.id%TYPE;
7921:
7922: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7924:
7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;

Line 7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;

7919: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7920: x_index_id okl_indices.id%TYPE;
7921:
7922: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7924:
7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;

Line 7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;

7921:
7922: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7924:
7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;

Line 7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;

7922: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7924:
7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;

Line 7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;

7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7924:
7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;

Line 7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

7924:
7925: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7926: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7927: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7928: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7929: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7930: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7931: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7932: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;

Line 22447: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

22443: WHERE rgp.dnz_chr_id = p_chr_id
22444: AND rgp.cle_id = p_cle_id
22445: AND rgp.rgd_code = 'LALEVL'
22446: AND rgp.rgp_type = 'KRG';
22447: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22448:
22449: rule_group_failed EXCEPTION;
22450: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22451:

Line 22450: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

22446: AND rgp.rgp_type = 'KRG';
22447: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22448:
22449: rule_group_failed EXCEPTION;
22450: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22451:
22452: --Bug# 6112766: End
22453:
22454: BEGIN