3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE crt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: chr_id NUMBER := OKC_API.G_MISS_NUM,
9: crs_code OKC_CHANGE_REQUESTS_B.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE crt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: chr_id NUMBER := OKC_API.G_MISS_NUM,
9: crs_code OKC_CHANGE_REQUESTS_B.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE crt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: chr_id NUMBER := OKC_API.G_MISS_NUM,
9: crs_code OKC_CHANGE_REQUESTS_B.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
6: TYPE crt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: chr_id NUMBER := OKC_API.G_MISS_NUM,
9: crs_code OKC_CHANGE_REQUESTS_B.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: chr_id NUMBER := OKC_API.G_MISS_NUM,
9: crs_code OKC_CHANGE_REQUESTS_B.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
8: chr_id NUMBER := OKC_API.G_MISS_NUM,
9: crs_code OKC_CHANGE_REQUESTS_B.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
9: crs_code OKC_CHANGE_REQUESTS_B.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
10: user_id NUMBER := OKC_API.G_MISS_NUM,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
11: datetime_request OKC_CHANGE_REQUESTS_B.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
12: crt_type OKC_CHANGE_REQUESTS_B.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
15: creation_date OKC_CHANGE_REQUESTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_date OKC_CHANGE_REQUESTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
18: datetime_effective OKC_CHANGE_REQUESTS_B.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
19: extended_yn OKC_CHANGE_REQUESTS_B.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
20: authority OKC_CHANGE_REQUESTS_B.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: signature_required_yn OKC_CHANGE_REQUESTS_B.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: datetime_approved OKC_CHANGE_REQUESTS_B.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: datetime_rejected OKC_CHANGE_REQUESTS_B.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: datetime_ineffective OKC_CHANGE_REQUESTS_B.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: version_contract OKC_CHANGE_REQUESTS_B.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: applied_contract_version OKC_CHANGE_REQUESTS_B.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: datetime_applied OKC_CHANGE_REQUESTS_B.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: last_update_login NUMBER := OKC_API.G_MISS_NUM,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute_category OKC_CHANGE_REQUESTS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute1 OKC_CHANGE_REQUESTS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute2 OKC_CHANGE_REQUESTS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute3 OKC_CHANGE_REQUESTS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute4 OKC_CHANGE_REQUESTS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute5 OKC_CHANGE_REQUESTS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42: attribute13 OKC_CHANGE_REQUESTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute6 OKC_CHANGE_REQUESTS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42: attribute13 OKC_CHANGE_REQUESTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
43: attribute14 OKC_CHANGE_REQUESTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute7 OKC_CHANGE_REQUESTS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42: attribute13 OKC_CHANGE_REQUESTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
43: attribute14 OKC_CHANGE_REQUESTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
44: attribute15 OKC_CHANGE_REQUESTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: attribute8 OKC_CHANGE_REQUESTS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42: attribute13 OKC_CHANGE_REQUESTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
43: attribute14 OKC_CHANGE_REQUESTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
44: attribute15 OKC_CHANGE_REQUESTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
45: g_miss_crt_rec crt_rec_type;
38: attribute9 OKC_CHANGE_REQUESTS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42: attribute13 OKC_CHANGE_REQUESTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
43: attribute14 OKC_CHANGE_REQUESTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
44: attribute15 OKC_CHANGE_REQUESTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
45: g_miss_crt_rec crt_rec_type;
46: TYPE crt_tbl_type IS TABLE OF crt_rec_type
39: attribute10 OKC_CHANGE_REQUESTS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42: attribute13 OKC_CHANGE_REQUESTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
43: attribute14 OKC_CHANGE_REQUESTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
44: attribute15 OKC_CHANGE_REQUESTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
45: g_miss_crt_rec crt_rec_type;
46: TYPE crt_tbl_type IS TABLE OF crt_rec_type
47: INDEX BY BINARY_INTEGER;
40: attribute11 OKC_CHANGE_REQUESTS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
41: attribute12 OKC_CHANGE_REQUESTS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
42: attribute13 OKC_CHANGE_REQUESTS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
43: attribute14 OKC_CHANGE_REQUESTS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
44: attribute15 OKC_CHANGE_REQUESTS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
45: g_miss_crt_rec crt_rec_type;
46: TYPE crt_tbl_type IS TABLE OF crt_rec_type
47: INDEX BY BINARY_INTEGER;
48: TYPE OkcChangeRequestsTlRecType IS RECORD (
45: g_miss_crt_rec crt_rec_type;
46: TYPE crt_tbl_type IS TABLE OF crt_rec_type
47: INDEX BY BINARY_INTEGER;
48: TYPE OkcChangeRequestsTlRecType IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM,
50: language OKC_CHANGE_REQUESTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
51: source_lang OKC_CHANGE_REQUESTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
46: TYPE crt_tbl_type IS TABLE OF crt_rec_type
47: INDEX BY BINARY_INTEGER;
48: TYPE OkcChangeRequestsTlRecType IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM,
50: language OKC_CHANGE_REQUESTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
51: source_lang OKC_CHANGE_REQUESTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
47: INDEX BY BINARY_INTEGER;
48: TYPE OkcChangeRequestsTlRecType IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM,
50: language OKC_CHANGE_REQUESTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
51: source_lang OKC_CHANGE_REQUESTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
48: TYPE OkcChangeRequestsTlRecType IS RECORD (
49: id NUMBER := OKC_API.G_MISS_NUM,
50: language OKC_CHANGE_REQUESTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
51: source_lang OKC_CHANGE_REQUESTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49: id NUMBER := OKC_API.G_MISS_NUM,
50: language OKC_CHANGE_REQUESTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
51: source_lang OKC_CHANGE_REQUESTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50: language OKC_CHANGE_REQUESTS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
51: source_lang OKC_CHANGE_REQUESTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_CHANGE_REQUESTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51: source_lang OKC_CHANGE_REQUESTS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_CHANGE_REQUESTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM);
52: sfwt_flag OKC_CHANGE_REQUESTS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_CHANGE_REQUESTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: GMissOkcChangeRequestsTlRec OkcChangeRequestsTlRecType;
53: name OKC_CHANGE_REQUESTS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_CHANGE_REQUESTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: GMissOkcChangeRequestsTlRec OkcChangeRequestsTlRecType;
61: TYPE OkcChangeRequestsTlTblType IS TABLE OF OkcChangeRequestsTlRecType
54: short_description OKC_CHANGE_REQUESTS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_CHANGE_REQUESTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: GMissOkcChangeRequestsTlRec OkcChangeRequestsTlRecType;
61: TYPE OkcChangeRequestsTlTblType IS TABLE OF OkcChangeRequestsTlRecType
62: INDEX BY BINARY_INTEGER;
55: created_by NUMBER := OKC_API.G_MISS_NUM,
56: creation_date OKC_CHANGE_REQUESTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
57: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
58: last_update_date OKC_CHANGE_REQUESTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
59: last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: GMissOkcChangeRequestsTlRec OkcChangeRequestsTlRecType;
61: TYPE OkcChangeRequestsTlTblType IS TABLE OF OkcChangeRequestsTlRecType
62: INDEX BY BINARY_INTEGER;
63: TYPE crtv_rec_type IS RECORD (
60: GMissOkcChangeRequestsTlRec OkcChangeRequestsTlRecType;
61: TYPE OkcChangeRequestsTlTblType IS TABLE OF OkcChangeRequestsTlRecType
62: INDEX BY BINARY_INTEGER;
63: TYPE crtv_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM,
65: object_version_number NUMBER := OKC_API.G_MISS_NUM,
66: sfwt_flag OKC_CHANGE_REQUESTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
61: TYPE OkcChangeRequestsTlTblType IS TABLE OF OkcChangeRequestsTlRecType
62: INDEX BY BINARY_INTEGER;
63: TYPE crtv_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM,
65: object_version_number NUMBER := OKC_API.G_MISS_NUM,
66: sfwt_flag OKC_CHANGE_REQUESTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
62: INDEX BY BINARY_INTEGER;
63: TYPE crtv_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM,
65: object_version_number NUMBER := OKC_API.G_MISS_NUM,
66: sfwt_flag OKC_CHANGE_REQUESTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
63: TYPE crtv_rec_type IS RECORD (
64: id NUMBER := OKC_API.G_MISS_NUM,
65: object_version_number NUMBER := OKC_API.G_MISS_NUM,
66: sfwt_flag OKC_CHANGE_REQUESTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
64: id NUMBER := OKC_API.G_MISS_NUM,
65: object_version_number NUMBER := OKC_API.G_MISS_NUM,
66: sfwt_flag OKC_CHANGE_REQUESTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
65: object_version_number NUMBER := OKC_API.G_MISS_NUM,
66: sfwt_flag OKC_CHANGE_REQUESTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
66: sfwt_flag OKC_CHANGE_REQUESTS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
67: chr_id NUMBER := OKC_API.G_MISS_NUM,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
68: crs_code OKC_CHANGE_REQUESTS_V.CRS_CODE%TYPE := OKC_API.G_MISS_CHAR,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
69: user_id NUMBER := OKC_API.G_MISS_NUM,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
70: name OKC_CHANGE_REQUESTS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
71: datetime_request OKC_CHANGE_REQUESTS_V.DATETIME_REQUEST%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
72: short_description OKC_CHANGE_REQUESTS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
73: extended_yn OKC_CHANGE_REQUESTS_V.EXTENDED_YN%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
74: authority OKC_CHANGE_REQUESTS_V.AUTHORITY%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
75: signature_required_yn OKC_CHANGE_REQUESTS_V.SIGNATURE_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
76: datetime_approved OKC_CHANGE_REQUESTS_V.DATETIME_APPROVED%TYPE := OKC_API.G_MISS_DATE,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
77: datetime_rejected OKC_CHANGE_REQUESTS_V.DATETIME_REJECTED%TYPE := OKC_API.G_MISS_DATE,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
78: datetime_effective OKC_CHANGE_REQUESTS_V.DATETIME_EFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
79: datetime_ineffective OKC_CHANGE_REQUESTS_V.DATETIME_INEFFECTIVE%TYPE := OKC_API.G_MISS_DATE,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
80: datetime_applied OKC_CHANGE_REQUESTS_V.DATETIME_APPLIED%TYPE := OKC_API.G_MISS_DATE,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
81: version_contract OKC_CHANGE_REQUESTS_V.VERSION_CONTRACT%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
82: applied_contract_version OKC_CHANGE_REQUESTS_V.APPLIED_CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
83: attribute_category OKC_CHANGE_REQUESTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
84: attribute1 OKC_CHANGE_REQUESTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
85: attribute2 OKC_CHANGE_REQUESTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
86: attribute3 OKC_CHANGE_REQUESTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
87: attribute4 OKC_CHANGE_REQUESTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
88: attribute5 OKC_CHANGE_REQUESTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
89: attribute6 OKC_CHANGE_REQUESTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
90: attribute7 OKC_CHANGE_REQUESTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
91: attribute8 OKC_CHANGE_REQUESTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: attribute9 OKC_CHANGE_REQUESTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
93: attribute10 OKC_CHANGE_REQUESTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94: attribute11 OKC_CHANGE_REQUESTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95: attribute12 OKC_CHANGE_REQUESTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
103: last_update_date OKC_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96: attribute13 OKC_CHANGE_REQUESTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
103: last_update_date OKC_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
104: last_update_login NUMBER := OKC_API.G_MISS_NUM);
97: attribute14 OKC_CHANGE_REQUESTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
103: last_update_date OKC_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
104: last_update_login NUMBER := OKC_API.G_MISS_NUM);
105: g_miss_crtv_rec crtv_rec_type;
98: attribute15 OKC_CHANGE_REQUESTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
103: last_update_date OKC_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
104: last_update_login NUMBER := OKC_API.G_MISS_NUM);
105: g_miss_crtv_rec crtv_rec_type;
106: TYPE crtv_tbl_type IS TABLE OF crtv_rec_type
99: crt_type OKC_CHANGE_REQUESTS_V.CRT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
103: last_update_date OKC_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
104: last_update_login NUMBER := OKC_API.G_MISS_NUM);
105: g_miss_crtv_rec crtv_rec_type;
106: TYPE crtv_tbl_type IS TABLE OF crtv_rec_type
107: INDEX BY BINARY_INTEGER;
100: created_by NUMBER := OKC_API.G_MISS_NUM,
101: creation_date OKC_CHANGE_REQUESTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
102: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
103: last_update_date OKC_CHANGE_REQUESTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
104: last_update_login NUMBER := OKC_API.G_MISS_NUM);
105: g_miss_crtv_rec crtv_rec_type;
106: TYPE crtv_tbl_type IS TABLE OF crtv_rec_type
107: INDEX BY BINARY_INTEGER;
108: ---------------------------------------------------------------------------
107: INDEX BY BINARY_INTEGER;
108: ---------------------------------------------------------------------------
109: -- GLOBAL MESSAGE CONSTANTS
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
108: ---------------------------------------------------------------------------
109: -- GLOBAL MESSAGE CONSTANTS
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
109: -- GLOBAL MESSAGE CONSTANTS
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
110: ---------------------------------------------------------------------------
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
111: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
112: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
113: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: ---------------------------------------------------------------------------
114: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: ---------------------------------------------------------------------------
122: -- GLOBAL VARIABLES
115: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: ---------------------------------------------------------------------------
122: -- GLOBAL VARIABLES
123: ---------------------------------------------------------------------------
116: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
117: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
118: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
119: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121: ---------------------------------------------------------------------------
122: -- GLOBAL VARIABLES
123: ---------------------------------------------------------------------------
124: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CRT_PVT';
121: ---------------------------------------------------------------------------
122: -- GLOBAL VARIABLES
123: ---------------------------------------------------------------------------
124: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CRT_PVT';
125: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
126: ---------------------------------------------------------------------------
127: -- Procedures and Functions
128: ---------------------------------------------------------------------------
129:
132: PROCEDURE api_copy;
133: PROCEDURE add_language;
134: PROCEDURE insert_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_crtv_rec IN crtv_rec_type,
141: x_crtv_rec OUT NOCOPY crtv_rec_type);
142:
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_crtv_tbl IN crtv_tbl_type,
150: x_crtv_tbl OUT NOCOPY crtv_tbl_type);
151:
152: PROCEDURE lock_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_crtv_rec IN crtv_rec_type);
158: p_crtv_rec IN crtv_rec_type);
159:
160: PROCEDURE lock_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_crtv_tbl IN crtv_tbl_type);
166: p_crtv_tbl IN crtv_tbl_type);
167:
168: PROCEDURE update_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_crtv_rec IN crtv_rec_type,
175: x_crtv_rec OUT NOCOPY crtv_rec_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_crtv_tbl IN crtv_tbl_type,
184: x_crtv_tbl OUT NOCOPY crtv_tbl_type);
185:
186: PROCEDURE delete_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_crtv_rec IN crtv_rec_type);
192: p_crtv_rec IN crtv_rec_type);
193:
194: PROCEDURE delete_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_crtv_tbl IN crtv_tbl_type);
200: p_crtv_tbl IN crtv_tbl_type);
201:
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_crtv_rec IN crtv_rec_type);
208: p_crtv_rec IN crtv_rec_type);
209:
210: PROCEDURE validate_row(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_crtv_tbl IN crtv_tbl_type);