DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_RULE_GROUPS_V

Line 1285: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,

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

Line 1294: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,

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

Line 1358: FROM okc_rule_groups_v rg,

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

Line 5433: FROM okc_rule_groups_v rgp

5429:
5430: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,
5431: p_cle_id okc_k_lines_v.id%TYPE) IS
5432: SELECT rgp.id
5433: FROM okc_rule_groups_v rgp
5434: WHERE rgp.dnz_chr_id = p_chr_id
5435: AND rgp.cle_id = p_cle_id
5436: AND rgp.rgd_code = 'LAASTX'
5437: AND rgp.rgp_type = 'KRG';

Line 5456: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

5452: WHERE rule.dnz_chr_id = p_chr_id
5453: AND rule.rgp_id = p_rgp_id
5454: AND rule.rule_information_category = 'LAPRTX';
5455:
5456: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
5457: ln_rule_id OKC_RULES_V.ID%TYPE;
5458: -- 5179119
5459: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
5460: l_sales_tax_rule_found BOOLEAN;

Line 6018: FROM okc_rule_groups_v rgp

6014: -- 5179119
6015: CURSOR get_sales_tax_rgp_info(p_chr_id okc_k_headers_b.id%TYPE,
6016: p_cle_id okc_k_lines_v.id%TYPE) IS
6017: SELECT rgp.id
6018: FROM okc_rule_groups_v rgp
6019: WHERE rgp.dnz_chr_id = p_chr_id
6020: AND rgp.cle_id = p_cle_id
6021: AND rgp.rgd_code = 'LAASTX'
6022: AND rgp.rgp_type = 'KRG';

Line 6032: l_sales_tax_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

6028: WHERE rule.dnz_chr_id = p_chr_id
6029: AND rule.rgp_id = p_rgp_id
6030: AND rule.rule_information_category = 'LAASTX';
6031:
6032: l_sales_tax_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
6033: l_sales_tax_rule_id OKC_RULES_V.ID%TYPE;
6034: l_sales_tax_rgp_found BOOLEAN;
6035: l_sales_tax_rule_found BOOLEAN;
6036: l_create_rule_group BOOLEAN;

Line 7754: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;

7750: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7751: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7752: x_index_id okl_indices.id%TYPE;
7753:
7754: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7755: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7756:
7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;

Line 7755: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;

7751: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7752: x_index_id okl_indices.id%TYPE;
7753:
7754: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7755: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7756:
7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;

Line 7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;

7753:
7754: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7755: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7756:
7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;

Line 7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;

7754: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7755: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7756:
7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;

Line 7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;

7755: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7756:
7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;

Line 7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

7756:
7757: l_chr_id OKC_RULE_GROUPS_V.CHR_ID%TYPE;
7758: l_dnz_chr_id OKC_RULE_GROUPS_V.DNZ_CHR_ID%TYPE;
7759: l_cle_id OKC_RULE_GROUPS_V.CLE_ID%TYPE;
7760: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
7761: l_jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE;
7762: l_object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE;
7763: l_rule_info1 OKC_RULES_V.RULE_INFORMATION1%TYPE;
7764: l_rule_info2 OKC_RULES_V.RULE_INFORMATION2%TYPE;

Line 22260: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

22256: WHERE rgp.dnz_chr_id = p_chr_id
22257: AND rgp.cle_id = p_cle_id
22258: AND rgp.rgd_code = 'LALEVL'
22259: AND rgp.rgp_type = 'KRG';
22260: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22261:
22262: rule_group_failed EXCEPTION;
22263: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22264:

Line 22263: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;

22259: AND rgp.rgp_type = 'KRG';
22260: ln_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22261:
22262: rule_group_failed EXCEPTION;
22263: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE;
22264:
22265: --Bug# 6112766: End
22266:
22267: BEGIN