3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE rgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE rgp_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
8: rgd_code OKC_RULE_GROUPS_B.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
9: sat_code OKC_RULE_GROUPS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
10: rgp_type OKC_RULE_GROUPS_B.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
11: chr_id NUMBER := OKC_API.G_MISS_NUM,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
12: cle_id NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
13: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: creation_date OKC_RULE_GROUPS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_date OKC_RULE_GROUPS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute_category OKC_RULE_GROUPS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_RULE_GROUPS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_RULE_GROUPS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_RULE_GROUPS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_RULE_GROUPS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_RULE_GROUPS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_RULE_GROUPS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_RULE_GROUPS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
29: attribute8 OKC_RULE_GROUPS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_rgp_rec rgp_rec_type;
30: attribute9 OKC_RULE_GROUPS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_rgp_rec rgp_rec_type;
38: TYPE rgp_tbl_type IS TABLE OF rgp_rec_type
31: attribute10 OKC_RULE_GROUPS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_rgp_rec rgp_rec_type;
38: TYPE rgp_tbl_type IS TABLE OF rgp_rec_type
39: INDEX BY BINARY_INTEGER;
32: attribute11 OKC_RULE_GROUPS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_RULE_GROUPS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_RULE_GROUPS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_RULE_GROUPS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_RULE_GROUPS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_rgp_rec rgp_rec_type;
38: TYPE rgp_tbl_type IS TABLE OF rgp_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE okc_rule_groups_tl_rec_type IS RECORD (
37: g_miss_rgp_rec rgp_rec_type;
38: TYPE rgp_tbl_type IS TABLE OF rgp_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE okc_rule_groups_tl_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKC_RULE_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKC_RULE_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
38: TYPE rgp_tbl_type IS TABLE OF rgp_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE okc_rule_groups_tl_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKC_RULE_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKC_RULE_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
39: INDEX BY BINARY_INTEGER;
40: TYPE okc_rule_groups_tl_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKC_RULE_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKC_RULE_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40: TYPE okc_rule_groups_tl_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKC_RULE_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKC_RULE_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: id NUMBER := OKC_API.G_MISS_NUM,
42: language OKC_RULE_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKC_RULE_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKC_RULE_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
42: language OKC_RULE_GROUPS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
43: source_lang OKC_RULE_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKC_RULE_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
43: source_lang OKC_RULE_GROUPS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKC_RULE_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
44: sfwt_flag OKC_RULE_GROUPS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKC_RULE_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
52: TYPE okc_rule_groups_tl_tbl_type IS TABLE OF okc_rule_groups_tl_rec_type
45: comments OKC_RULE_GROUPS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKC_RULE_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
52: TYPE okc_rule_groups_tl_tbl_type IS TABLE OF okc_rule_groups_tl_rec_type
53: INDEX BY BINARY_INTEGER;
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKC_RULE_GROUPS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKC_RULE_GROUPS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
52: TYPE okc_rule_groups_tl_tbl_type IS TABLE OF okc_rule_groups_tl_rec_type
53: INDEX BY BINARY_INTEGER;
54: TYPE rgpv_rec_type IS RECORD (
51: g_miss_okc_rule_groups_tl_rec okc_rule_groups_tl_rec_type;
52: TYPE okc_rule_groups_tl_tbl_type IS TABLE OF okc_rule_groups_tl_rec_type
53: INDEX BY BINARY_INTEGER;
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: TYPE okc_rule_groups_tl_tbl_type IS TABLE OF okc_rule_groups_tl_rec_type
53: INDEX BY BINARY_INTEGER;
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
53: INDEX BY BINARY_INTEGER;
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
54: TYPE rgpv_rec_type IS RECORD (
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
55: id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
56: object_version_number NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
57: sfwt_flag OKC_RULE_GROUPS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
58: rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
59: sat_code OKC_RULE_GROUPS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
60: rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
61: cle_id NUMBER := OKC_API.G_MISS_NUM,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
62: chr_id NUMBER := OKC_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
63: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
64: parent_rgp_id NUMBER := OKC_API.G_MISS_NUM,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
65: comments OKC_RULE_GROUPS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
66: attribute_category OKC_RULE_GROUPS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
67: attribute1 OKC_RULE_GROUPS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
68: attribute2 OKC_RULE_GROUPS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
69: attribute3 OKC_RULE_GROUPS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
70: attribute4 OKC_RULE_GROUPS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
71: attribute5 OKC_RULE_GROUPS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
72: attribute6 OKC_RULE_GROUPS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
73: attribute7 OKC_RULE_GROUPS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
74: attribute8 OKC_RULE_GROUPS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
75: attribute9 OKC_RULE_GROUPS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
76: attribute10 OKC_RULE_GROUPS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
77: attribute11 OKC_RULE_GROUPS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
78: attribute12 OKC_RULE_GROUPS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
79: attribute13 OKC_RULE_GROUPS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_rgpv_rec rgpv_rec_type;
80: attribute14 OKC_RULE_GROUPS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_rgpv_rec rgpv_rec_type;
88: TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
81: attribute15 OKC_RULE_GROUPS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_rgpv_rec rgpv_rec_type;
88: TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
89: INDEX BY BINARY_INTEGER;
82: created_by NUMBER := OKC_API.G_MISS_NUM,
83: creation_date OKC_RULE_GROUPS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: last_update_date OKC_RULE_GROUPS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: g_miss_rgpv_rec rgpv_rec_type;
88: TYPE rgpv_tbl_type IS TABLE OF rgpv_rec_type
89: INDEX BY BINARY_INTEGER;
90: ---------------------------------------------------------------------------
89: INDEX BY BINARY_INTEGER;
90: ---------------------------------------------------------------------------
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
90: ---------------------------------------------------------------------------
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91: -- GLOBAL MESSAGE CONSTANTS
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
92: ---------------------------------------------------------------------------
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
93: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
94: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
95: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: ---------------------------------------------------------------------------
96: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: ---------------------------------------------------------------------------
104: -- GLOBAL VARIABLES
97: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: ---------------------------------------------------------------------------
104: -- GLOBAL VARIABLES
105: ---------------------------------------------------------------------------
98: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: ---------------------------------------------------------------------------
104: -- GLOBAL VARIABLES
105: ---------------------------------------------------------------------------
106: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RGP_PVT';
103: ---------------------------------------------------------------------------
104: -- GLOBAL VARIABLES
105: ---------------------------------------------------------------------------
106: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RGP_PVT';
107: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
108: ---------------------------------------------------------------------------
109: -- Procedures and Functions
110: ---------------------------------------------------------------------------
111:
114: PROCEDURE api_copy;
115: PROCEDURE add_language;
116: PROCEDURE insert_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_rgpv_rec IN rgpv_rec_type,
123: x_rgpv_rec OUT NOCOPY rgpv_rec_type);
124:
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_rgpv_tbl IN rgpv_tbl_type,
132: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
133:
134: PROCEDURE lock_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_rgpv_rec IN rgpv_rec_type);
140: p_rgpv_rec IN rgpv_rec_type);
141:
142: PROCEDURE lock_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_rgpv_tbl IN rgpv_tbl_type);
148: p_rgpv_tbl IN rgpv_tbl_type);
149:
150: PROCEDURE update_row(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_rgpv_rec IN rgpv_rec_type,
157: x_rgpv_rec OUT NOCOPY rgpv_rec_type);
158:
159: PROCEDURE update_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_rgpv_tbl IN rgpv_tbl_type,
166: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
167:
168: PROCEDURE delete_row(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_rgpv_rec IN rgpv_rec_type);
174: p_rgpv_rec IN rgpv_rec_type);
175:
176: PROCEDURE delete_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_rgpv_tbl IN rgpv_tbl_type);
182: p_rgpv_tbl IN rgpv_tbl_type);
183:
184: PROCEDURE validate_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_rgpv_rec IN rgpv_rec_type);
190: p_rgpv_rec IN rgpv_rec_type);
191:
192: PROCEDURE validate_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_rgpv_tbl IN rgpv_tbl_type);