4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_ACTION_TIME_TYPES_V Record Spec
7: TYPE OksActionTimeTypesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
5: ---------------------------------------------------------------------------
6: -- OKS_ACTION_TIME_TYPES_V Record Spec
7: TYPE OksActionTimeTypesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
6: -- OKS_ACTION_TIME_TYPES_V Record Spec
7: TYPE OksActionTimeTypesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE OksActionTimeTypesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
10: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
11: ,action_type_code OKS_ACTION_TIME_TYPES_V.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
12: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
13: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
14: ,program_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
15: ,program_update_date OKS_ACTION_TIME_TYPES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: -- R12 Data Model Changes 4485150 Start
16: ,request_id NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: -- R12 Data Model Changes 4485150 Start
24: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: -- R12 Data Model Changes 4485150 Start
24: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
25: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
18: ,creation_date OKS_ACTION_TIME_TYPES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: -- R12 Data Model Changes 4485150 Start
24: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
25: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
26: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
20: ,last_update_date OKS_ACTION_TIME_TYPES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: -- R12 Data Model Changes 4485150 Start
24: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
25: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
26: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: -- R12 Data Model Changes 4485150 End
28: );
21: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: -- R12 Data Model Changes 4485150 Start
24: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
25: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
26: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: -- R12 Data Model Changes 4485150 End
28: );
29: GMissOksActionTimeTypesVRec OksActionTimeTypesVRecType;
22: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
23: -- R12 Data Model Changes 4485150 Start
24: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
25: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
26: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: -- R12 Data Model Changes 4485150 End
28: );
29: GMissOksActionTimeTypesVRec OksActionTimeTypesVRecType;
30: TYPE OksActionTimeTypesVTblType IS TABLE OF OksActionTimeTypesVRecType
30: TYPE OksActionTimeTypesVTblType IS TABLE OF OksActionTimeTypesVRecType
31: INDEX BY BINARY_INTEGER;
32: -- OKS_ACTION_TIME_TYPES Record Spec
33: TYPE oks_action_time_types_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,cle_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
31: INDEX BY BINARY_INTEGER;
32: -- OKS_ACTION_TIME_TYPES Record Spec
33: TYPE oks_action_time_types_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,cle_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
32: -- OKS_ACTION_TIME_TYPES Record Spec
33: TYPE oks_action_time_types_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,cle_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
33: TYPE oks_action_time_types_rec_type IS RECORD (
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,cle_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
34: id NUMBER := OKC_API.G_MISS_NUM
35: ,cle_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
35: ,cle_id NUMBER := OKC_API.G_MISS_NUM
36: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
36: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
37: ,action_type_code OKS_ACTION_TIME_TYPES.ACTION_TYPE_CODE%TYPE := OKC_API.G_MISS_CHAR
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
38: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
39: ,program_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
40: ,program_update_date OKS_ACTION_TIME_TYPES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: -- R12 Data Model Changes 4485150 Start
41: ,request_id NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: -- R12 Data Model Changes 4485150 Start
49: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
42: ,created_by NUMBER := OKC_API.G_MISS_NUM
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: -- R12 Data Model Changes 4485150 Start
49: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
50: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
43: ,creation_date OKS_ACTION_TIME_TYPES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
44: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: -- R12 Data Model Changes 4485150 Start
49: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
50: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
51: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
45: ,last_update_date OKS_ACTION_TIME_TYPES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: -- R12 Data Model Changes 4485150 Start
49: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
50: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
51: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
52: -- R12 Data Model Changes 4485150 End
53: );
46: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: -- R12 Data Model Changes 4485150 Start
49: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
50: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
51: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
52: -- R12 Data Model Changes 4485150 End
53: );
54: GMissOksActionTimeTypesRec oks_action_time_types_rec_type;
47: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48: -- R12 Data Model Changes 4485150 Start
49: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
50: ,orig_system_reference1 OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
51: ,orig_system_source_code OKS_ACTION_TIME_TYPES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
52: -- R12 Data Model Changes 4485150 End
53: );
54: GMissOksActionTimeTypesRec oks_action_time_types_rec_type;
55: TYPE oks_action_time_types_tbl_type IS TABLE OF oks_action_time_types_rec_type
56: INDEX BY BINARY_INTEGER;
57: ---------------------------------------------------------------------------
58: -- GLOBAL MESSAGE CONSTANTS
59: ---------------------------------------------------------------------------
60: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
61: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
62: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
57: ---------------------------------------------------------------------------
58: -- GLOBAL MESSAGE CONSTANTS
59: ---------------------------------------------------------------------------
60: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
61: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
62: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
58: -- GLOBAL MESSAGE CONSTANTS
59: ---------------------------------------------------------------------------
60: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
61: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
62: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
59: ---------------------------------------------------------------------------
60: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
61: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
62: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
60: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
61: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
62: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
68: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
61: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
62: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
68: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
69: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
62: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
68: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
69: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
70: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
63: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
68: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
69: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
70: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
71: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
64: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
68: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
69: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
70: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
71: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
72: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
65: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
66: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
68: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
69: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
70: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
71: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
72: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
73:
79: ---------------------------------------------------------------------------
80: -- GLOBAL VARIABLES
81: ---------------------------------------------------------------------------
82: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_ACT_PVT';
83: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
84: ---------------------------------------------------------------------------
85: -- Procedures and Functions
86: ---------------------------------------------------------------------------
87:
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
106: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType,
107: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
108: PROCEDURE insert_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2,
111: x_return_status OUT NOCOPY VARCHAR2,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
130: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2,
134: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
153: x_oks_action_time_types_v_tbl OUT NOCOPY OksActionTimeTypesVTblType,
154: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
155: PROCEDURE update_row(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2,
158: x_return_status OUT NOCOPY VARCHAR2,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
177: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2,
181: x_return_status OUT NOCOPY VARCHAR2,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_oks_action_time_types_v_tbl IN OksActionTimeTypesVTblType,
199: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
200: PROCEDURE validate_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2,
203: x_return_status OUT NOCOPY VARCHAR2,