3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cpl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cpl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE cpl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
6: TYPE cpl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
10: cle_id NUMBER := OKC_API.G_MISS_NUM,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
11: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
12: rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
13: object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
14: object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
15: jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: object_version_number NUMBER := OKC_API.G_MISS_NUM,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
17: created_by NUMBER := OKC_API.G_MISS_NUM,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
18: creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
19: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
20: last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
21: code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
22: facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_login NUMBER := OKC_API.G_MISS_NUM,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
38: attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46: -- R12 Data Model Changes 4485150 Start
39: attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46: -- R12 Data Model Changes 4485150 Start
47: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
40: attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46: -- R12 Data Model Changes 4485150 Start
47: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
48: orig_system_reference1 OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
41: attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42: attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46: -- R12 Data Model Changes 4485150 Start
47: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
48: orig_system_reference1 OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
49: orig_system_source_code OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
43: attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46: -- R12 Data Model Changes 4485150 Start
47: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
48: orig_system_reference1 OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
49: orig_system_source_code OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
50: -- R12 Data Model Changes 4485150 End
51: );
44: attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46: -- R12 Data Model Changes 4485150 Start
47: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
48: orig_system_reference1 OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
49: orig_system_source_code OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
50: -- R12 Data Model Changes 4485150 End
51: );
52: g_miss_cpl_rec cpl_rec_type;
45: attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46: -- R12 Data Model Changes 4485150 Start
47: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
48: orig_system_reference1 OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
49: orig_system_source_code OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
50: -- R12 Data Model Changes 4485150 End
51: );
52: g_miss_cpl_rec cpl_rec_type;
53: TYPE cpl_tbl_type IS TABLE OF cpl_rec_type
52: g_miss_cpl_rec cpl_rec_type;
53: TYPE cpl_tbl_type IS TABLE OF cpl_rec_type
54: INDEX BY BINARY_INTEGER;
55: TYPE okc_k_party_roles_tl_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM,
57: language OKC_K_PARTY_ROLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
58: source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
53: TYPE cpl_tbl_type IS TABLE OF cpl_rec_type
54: INDEX BY BINARY_INTEGER;
55: TYPE okc_k_party_roles_tl_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM,
57: language OKC_K_PARTY_ROLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
58: source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
54: INDEX BY BINARY_INTEGER;
55: TYPE okc_k_party_roles_tl_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM,
57: language OKC_K_PARTY_ROLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
58: source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
55: TYPE okc_k_party_roles_tl_rec_type IS RECORD (
56: id NUMBER := OKC_API.G_MISS_NUM,
57: language OKC_K_PARTY_ROLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
58: source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
56: id NUMBER := OKC_API.G_MISS_NUM,
57: language OKC_K_PARTY_ROLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
58: source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
57: language OKC_K_PARTY_ROLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
58: source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
65: alias OKC_K_PARTY_ROLES_TL.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
58: source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
65: alias OKC_K_PARTY_ROLES_TL.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
59: sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
65: alias OKC_K_PARTY_ROLES_TL.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: GMissOkcKPartyRolesTlRec okc_k_party_roles_tl_rec_type;
60: created_by NUMBER := OKC_API.G_MISS_NUM,
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
65: alias OKC_K_PARTY_ROLES_TL.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: GMissOkcKPartyRolesTlRec okc_k_party_roles_tl_rec_type;
68: TYPE okc_k_party_roles_tl_tbl_type IS TABLE OF okc_k_party_roles_tl_rec_type
61: creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
65: alias OKC_K_PARTY_ROLES_TL.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: GMissOkcKPartyRolesTlRec okc_k_party_roles_tl_rec_type;
68: TYPE okc_k_party_roles_tl_tbl_type IS TABLE OF okc_k_party_roles_tl_rec_type
69: INDEX BY BINARY_INTEGER;
62: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
65: alias OKC_K_PARTY_ROLES_TL.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
66: last_update_login NUMBER := OKC_API.G_MISS_NUM);
67: GMissOkcKPartyRolesTlRec okc_k_party_roles_tl_rec_type;
68: TYPE okc_k_party_roles_tl_tbl_type IS TABLE OF okc_k_party_roles_tl_rec_type
69: INDEX BY BINARY_INTEGER;
70: TYPE cplv_rec_type IS RECORD (
67: GMissOkcKPartyRolesTlRec okc_k_party_roles_tl_rec_type;
68: TYPE okc_k_party_roles_tl_tbl_type IS TABLE OF okc_k_party_roles_tl_rec_type
69: INDEX BY BINARY_INTEGER;
70: TYPE cplv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: TYPE okc_k_party_roles_tl_tbl_type IS TABLE OF okc_k_party_roles_tl_rec_type
69: INDEX BY BINARY_INTEGER;
70: TYPE cplv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
69: INDEX BY BINARY_INTEGER;
70: TYPE cplv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70: TYPE cplv_rec_type IS RECORD (
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
71: id NUMBER := OKC_API.G_MISS_NUM,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
72: object_version_number NUMBER := OKC_API.G_MISS_NUM,
73: sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
73: sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
74: cpl_id NUMBER := OKC_API.G_MISS_NUM,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
75: chr_id NUMBER := OKC_API.G_MISS_NUM,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
76: cle_id NUMBER := OKC_API.G_MISS_NUM,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
77: rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
78: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
79: object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
80: object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
81: jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
82: cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
83: code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
84: facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
85: minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
87: women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
88: alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
89: primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
91: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
92: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
93: attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
94: attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
95: attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
96: attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
97: attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
98: attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
99: attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
100: attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
101: attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
102: attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
103: attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
104: attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112: last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
105: attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112: last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_update_login NUMBER := OKC_API.G_MISS_NUM);
106: attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112: last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_update_login NUMBER := OKC_API.G_MISS_NUM);
114: g_miss_cplv_rec cplv_rec_type;
107: attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112: last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_update_login NUMBER := OKC_API.G_MISS_NUM);
114: g_miss_cplv_rec cplv_rec_type;
115: TYPE cplv_tbl_type IS TABLE OF cplv_rec_type
108: attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112: last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_update_login NUMBER := OKC_API.G_MISS_NUM);
114: g_miss_cplv_rec cplv_rec_type;
115: TYPE cplv_tbl_type IS TABLE OF cplv_rec_type
116: INDEX BY BINARY_INTEGER;
109: created_by NUMBER := OKC_API.G_MISS_NUM,
110: creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112: last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
113: last_update_login NUMBER := OKC_API.G_MISS_NUM);
114: g_miss_cplv_rec cplv_rec_type;
115: TYPE cplv_tbl_type IS TABLE OF cplv_rec_type
116: INDEX BY BINARY_INTEGER;
117: ---------------------------------------------------------------------------
116: INDEX BY BINARY_INTEGER;
117: ---------------------------------------------------------------------------
118: -- GLOBAL MESSAGE CONSTANTS
119: ---------------------------------------------------------------------------
120: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
121: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
122: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
117: ---------------------------------------------------------------------------
118: -- GLOBAL MESSAGE CONSTANTS
119: ---------------------------------------------------------------------------
120: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
121: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
122: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
118: -- GLOBAL MESSAGE CONSTANTS
119: ---------------------------------------------------------------------------
120: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
121: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
122: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
119: ---------------------------------------------------------------------------
120: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
121: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
122: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
120: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
121: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
122: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
121: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
122: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
122: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
130: ---------------------------------------------------------------------------
123: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
130: ---------------------------------------------------------------------------
131: -- GLOBAL VARIABLES
124: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
130: ---------------------------------------------------------------------------
131: -- GLOBAL VARIABLES
132: ---------------------------------------------------------------------------
125: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
128: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
129: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
130: ---------------------------------------------------------------------------
131: -- GLOBAL VARIABLES
132: ---------------------------------------------------------------------------
133: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CPL_PVT';
130: ---------------------------------------------------------------------------
131: -- GLOBAL VARIABLES
132: ---------------------------------------------------------------------------
133: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CPL_PVT';
134: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
135: ---------------------------------------------------------------------------
136: -- Procedures and Functions
137: ---------------------------------------------------------------------------
138:
141: PROCEDURE api_copy;
142: PROCEDURE add_language;
143: PROCEDURE insert_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_cplv_rec IN cplv_rec_type,
150: x_cplv_rec OUT NOCOPY cplv_rec_type);
151:
152: PROCEDURE insert_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_cplv_tbl IN cplv_tbl_type,
159: x_cplv_tbl OUT NOCOPY cplv_tbl_type);
160:
161: PROCEDURE lock_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_cplv_rec IN cplv_rec_type);
167: p_cplv_rec IN cplv_rec_type);
168:
169: PROCEDURE lock_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_cplv_tbl IN cplv_tbl_type);
175: p_cplv_tbl IN cplv_tbl_type);
176:
177: PROCEDURE update_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_cplv_rec IN cplv_rec_type,
184: x_cplv_rec OUT NOCOPY cplv_rec_type);
185:
186: PROCEDURE update_row(
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189: x_return_status OUT NOCOPY VARCHAR2,
190: x_msg_count OUT NOCOPY NUMBER,
191: x_msg_data OUT NOCOPY VARCHAR2,
192: p_cplv_tbl IN cplv_tbl_type,
193: x_cplv_tbl OUT NOCOPY cplv_tbl_type);
194:
195: PROCEDURE delete_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_cplv_rec IN cplv_rec_type);
201: p_cplv_rec IN cplv_rec_type);
202:
203: PROCEDURE delete_row(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_cplv_tbl IN cplv_tbl_type);
209: p_cplv_tbl IN cplv_tbl_type);
210:
211: PROCEDURE validate_row(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_cplv_rec IN cplv_rec_type);
217: p_cplv_rec IN cplv_rec_type);
218:
219: PROCEDURE validate_row(
220: p_api_version IN NUMBER,
221: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_cplv_tbl IN cplv_tbl_type);