4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKC_K_HISTORY_V Record Spec
7: TYPE hstv_rec_type IS RECORD (
8: 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: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKC_K_HISTORY_V Record Spec
7: TYPE hstv_rec_type IS RECORD (
8: 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: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
6: -- OKC_K_HISTORY_V Record Spec
7: TYPE hstv_rec_type IS RECORD (
8: 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: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
7: TYPE hstv_rec_type IS RECORD (
8: 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: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
8: 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: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
9: ,chr_id NUMBER := OKC_API.G_MISS_NUM
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
10: ,cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,contract_version OKC_K_HISTORY_V.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
12: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
13: ,opn_code OKC_K_HISTORY_V.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,sts_code_from OKC_K_HISTORY_V.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
15: ,sts_code_to OKC_K_HISTORY_V.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,reason_code OKC_K_HISTORY_V.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
17: ,trn_code OKC_K_HISTORY_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
18: ,manual_yn OKC_K_HISTORY_V.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
26: ,program_id NUMBER := OKC_API.G_MISS_NUM
19: ,comments OKC_K_HISTORY_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
26: ,program_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_update_date OKC_K_HISTORY_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,created_by NUMBER := OKC_API.G_MISS_NUM
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
26: ,program_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_update_date OKC_K_HISTORY_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
28: ,request_id NUMBER := OKC_API.G_MISS_NUM);
21: ,creation_date OKC_K_HISTORY_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
26: ,program_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_update_date OKC_K_HISTORY_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
28: ,request_id NUMBER := OKC_API.G_MISS_NUM);
29: G_MISS_hstv_rec hstv_rec_type;
22: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
26: ,program_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_update_date OKC_K_HISTORY_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
28: ,request_id NUMBER := OKC_API.G_MISS_NUM);
29: G_MISS_hstv_rec hstv_rec_type;
30: TYPE hstv_tbl_type IS TABLE OF hstv_rec_type
23: ,last_update_date OKC_K_HISTORY_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
26: ,program_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_update_date OKC_K_HISTORY_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
28: ,request_id NUMBER := OKC_API.G_MISS_NUM);
29: G_MISS_hstv_rec hstv_rec_type;
30: TYPE hstv_tbl_type IS TABLE OF hstv_rec_type
31: INDEX BY BINARY_INTEGER;
24: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
25: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
26: ,program_id NUMBER := OKC_API.G_MISS_NUM
27: ,program_update_date OKC_K_HISTORY_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
28: ,request_id NUMBER := OKC_API.G_MISS_NUM);
29: G_MISS_hstv_rec hstv_rec_type;
30: TYPE hstv_tbl_type IS TABLE OF hstv_rec_type
31: INDEX BY BINARY_INTEGER;
32: -- OKC_K_HISTORY_B Record Spec
30: TYPE hstv_tbl_type IS TABLE OF hstv_rec_type
31: INDEX BY BINARY_INTEGER;
32: -- OKC_K_HISTORY_B Record Spec
33: TYPE hst_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
31: INDEX BY BINARY_INTEGER;
32: -- OKC_K_HISTORY_B Record Spec
33: TYPE hst_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
32: -- OKC_K_HISTORY_B Record Spec
33: TYPE hst_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
33: TYPE hst_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
35: ,chr_id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
37: ,contract_version OKC_K_HISTORY_B.CONTRACT_VERSION%TYPE := OKC_API.G_MISS_CHAR
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,sts_code_from OKC_K_HISTORY_B.STS_CODE_FROM%TYPE := OKC_API.G_MISS_CHAR
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
39: ,opn_code OKC_K_HISTORY_B.OPN_CODE%TYPE := OKC_API.G_MISS_CHAR
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
40: ,sts_code_to OKC_K_HISTORY_B.STS_CODE_TO%TYPE := OKC_API.G_MISS_CHAR
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,reason_code OKC_K_HISTORY_B.REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
42: ,trn_code OKC_K_HISTORY_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
43: ,manual_yn OKC_K_HISTORY_B.MANUAL_YN%TYPE := OKC_API.G_MISS_CHAR
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_update_date OKC_K_HISTORY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,creation_date OKC_K_HISTORY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_update_date OKC_K_HISTORY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,request_id NUMBER := OKC_API.G_MISS_NUM);
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_update_date OKC_K_HISTORY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,request_id NUMBER := OKC_API.G_MISS_NUM);
54: G_MISS_hst_rec hst_rec_type;
47: ,last_update_date OKC_K_HISTORY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_update_date OKC_K_HISTORY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,request_id NUMBER := OKC_API.G_MISS_NUM);
54: G_MISS_hst_rec hst_rec_type;
55: TYPE hst_tbl_type IS TABLE OF hst_rec_type
48: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_update_date OKC_K_HISTORY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,request_id NUMBER := OKC_API.G_MISS_NUM);
54: G_MISS_hst_rec hst_rec_type;
55: TYPE hst_tbl_type IS TABLE OF hst_rec_type
56: INDEX BY BINARY_INTEGER;
49: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
50: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
51: ,program_id NUMBER := OKC_API.G_MISS_NUM
52: ,program_update_date OKC_K_HISTORY_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,request_id NUMBER := OKC_API.G_MISS_NUM);
54: G_MISS_hst_rec hst_rec_type;
55: TYPE hst_tbl_type IS TABLE OF hst_rec_type
56: INDEX BY BINARY_INTEGER;
57: -- OKC_K_HISTORY_TL Record Spec
55: TYPE hst_tbl_type IS TABLE OF hst_rec_type
56: INDEX BY BINARY_INTEGER;
57: -- OKC_K_HISTORY_TL Record Spec
58: TYPE okc_k_history_tl_rec_type IS RECORD (
59: id NUMBER := OKC_API.G_MISS_NUM
60: ,language OKC_K_HISTORY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
61: ,source_lang OKC_K_HISTORY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
56: INDEX BY BINARY_INTEGER;
57: -- OKC_K_HISTORY_TL Record Spec
58: TYPE okc_k_history_tl_rec_type IS RECORD (
59: id NUMBER := OKC_API.G_MISS_NUM
60: ,language OKC_K_HISTORY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
61: ,source_lang OKC_K_HISTORY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
57: -- OKC_K_HISTORY_TL Record Spec
58: TYPE okc_k_history_tl_rec_type IS RECORD (
59: id NUMBER := OKC_API.G_MISS_NUM
60: ,language OKC_K_HISTORY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
61: ,source_lang OKC_K_HISTORY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
58: TYPE okc_k_history_tl_rec_type IS RECORD (
59: id NUMBER := OKC_API.G_MISS_NUM
60: ,language OKC_K_HISTORY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
61: ,source_lang OKC_K_HISTORY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
66: ,last_update_date OKC_K_HISTORY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59: id NUMBER := OKC_API.G_MISS_NUM
60: ,language OKC_K_HISTORY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
61: ,source_lang OKC_K_HISTORY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
66: ,last_update_date OKC_K_HISTORY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
60: ,language OKC_K_HISTORY_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
61: ,source_lang OKC_K_HISTORY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
66: ,last_update_date OKC_K_HISTORY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_okc_k_history_tl_rec okc_k_history_tl_rec_type;
61: ,source_lang OKC_K_HISTORY_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
66: ,last_update_date OKC_K_HISTORY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_okc_k_history_tl_rec okc_k_history_tl_rec_type;
69: TYPE okc_k_history_tl_tbl_type IS TABLE OF okc_k_history_tl_rec_type
62: ,comments OKC_K_HISTORY_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
66: ,last_update_date OKC_K_HISTORY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_okc_k_history_tl_rec okc_k_history_tl_rec_type;
69: TYPE okc_k_history_tl_tbl_type IS TABLE OF okc_k_history_tl_rec_type
70: INDEX BY BINARY_INTEGER;
63: ,created_by NUMBER := OKC_API.G_MISS_NUM
64: ,creation_date OKC_K_HISTORY_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
66: ,last_update_date OKC_K_HISTORY_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
67: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_okc_k_history_tl_rec okc_k_history_tl_rec_type;
69: TYPE okc_k_history_tl_tbl_type IS TABLE OF okc_k_history_tl_rec_type
70: INDEX BY BINARY_INTEGER;
71: ---------------------------------------------------------------------------
70: INDEX BY BINARY_INTEGER;
71: ---------------------------------------------------------------------------
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
71: ---------------------------------------------------------------------------
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
85: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
85: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
86: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
85: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
86: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
87:
93: ---------------------------------------------------------------------------
94: -- GLOBAL VARIABLES
95: ---------------------------------------------------------------------------
96: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_HST_PVT';
97: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
98: ---------------------------------------------------------------------------
99: -- Procedures and Functions
100: ---------------------------------------------------------------------------
101:
104: PROCEDURE api_copy;
105: PROCEDURE add_language;
106: PROCEDURE insert_row(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_hstv_rec IN hstv_rec_type,
112: p_hstv_rec IN hstv_rec_type,
113: x_hstv_rec OUT NOCOPY hstv_rec_type);
114: PROCEDURE insert_row(
115: p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_hstv_tbl IN hstv_tbl_type,
118: x_msg_count OUT NOCOPY NUMBER,
119: x_msg_data OUT NOCOPY VARCHAR2,
120: p_hstv_tbl IN hstv_tbl_type,
121: x_hstv_tbl OUT NOCOPY hstv_tbl_type,
122: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
123: PROCEDURE insert_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
121: x_hstv_tbl OUT NOCOPY hstv_tbl_type,
122: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
123: PROCEDURE insert_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_hstv_tbl IN hstv_tbl_type,
129: p_hstv_tbl IN hstv_tbl_type,
130: x_hstv_tbl OUT NOCOPY hstv_tbl_type);
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_hstv_rec IN hstv_rec_type);
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_hstv_rec IN hstv_rec_type);
138: PROCEDURE lock_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_hstv_tbl IN hstv_tbl_type,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_hstv_tbl IN hstv_tbl_type,
145: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
146: PROCEDURE lock_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
144: p_hstv_tbl IN hstv_tbl_type,
145: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
146: PROCEDURE lock_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_hstv_tbl IN hstv_tbl_type);
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_hstv_tbl IN hstv_tbl_type);
153: PROCEDURE update_row(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_hstv_rec IN hstv_rec_type,
159: p_hstv_rec IN hstv_rec_type,
160: x_hstv_rec OUT NOCOPY hstv_rec_type);
161: PROCEDURE update_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_hstv_tbl IN hstv_tbl_type,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_hstv_tbl IN hstv_tbl_type,
168: x_hstv_tbl OUT NOCOPY hstv_tbl_type,
169: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
170: PROCEDURE update_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
168: x_hstv_tbl OUT NOCOPY hstv_tbl_type,
169: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
170: PROCEDURE update_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_hstv_tbl IN hstv_tbl_type,
176: p_hstv_tbl IN hstv_tbl_type,
177: x_hstv_tbl OUT NOCOPY hstv_tbl_type);
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_hstv_rec IN hstv_rec_type);
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_hstv_rec IN hstv_rec_type);
185: PROCEDURE delete_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_hstv_tbl IN hstv_tbl_type,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_hstv_tbl IN hstv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
193: PROCEDURE delete_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
191: p_hstv_tbl IN hstv_tbl_type,
192: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
193: PROCEDURE delete_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_hstv_tbl IN hstv_tbl_type);
199: p_hstv_tbl IN hstv_tbl_type);
200:
201: PROCEDURE delete_all_rows(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_chr_id IN NUMBER);
207: p_chr_id IN NUMBER);
208:
209: PROCEDURE validate_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_hstv_rec IN hstv_rec_type);
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_hstv_rec IN hstv_rec_type);
216: PROCEDURE validate_row(
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_hstv_tbl IN hstv_tbl_type,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2,
222: p_hstv_tbl IN hstv_tbl_type,
223: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
224: PROCEDURE validate_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
222: p_hstv_tbl IN hstv_tbl_type,
223: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
224: PROCEDURE validate_row(
225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227: x_return_status OUT NOCOPY VARCHAR2,
228: x_msg_count OUT NOCOPY NUMBER,
229: x_msg_data OUT NOCOPY VARCHAR2,
230: p_hstv_tbl IN hstv_tbl_type);