DBA Data[Home] [Help]

APPS.OKS_CTZ_PVT dependencies on OKS_COVERAGE_TIMEZONES

Line 6: -- OKS_COVERAGE_TIMEZONES_V Record Spec

2: /* $Header: OKSCOVZS.pls 120.1 2005/07/15 09:22:24 parkumar noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_COVERAGE_TIMEZONES_V Record Spec
7: TYPE OksCoverageTimezonesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR

6: -- OKS_COVERAGE_TIMEZONES_V Record Spec
7: TYPE OksCoverageTimezonesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,default_yn OKS_COVERAGE_TIMEZONES_V.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
11: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

12: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
13: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
14: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

15: ,program_id NUMBER := OKC_API.G_MISS_NUM
16: ,program_update_date OKS_COVERAGE_TIMEZONES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

17: ,request_id NUMBER := OKC_API.G_MISS_NUM
18: ,created_by NUMBER := OKC_API.G_MISS_NUM
19: ,creation_date OKS_COVERAGE_TIMEZONES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
20: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
21: ,last_update_date OKS_COVERAGE_TIMEZONES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
27: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
28: -- R12 Data Model Changes 4485150 End
29: );
30: GMissOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;

Line 27: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

23: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
24: -- R12 Data Model Changes 4485150 Start
25: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
26: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
27: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
28: -- R12 Data Model Changes 4485150 End
29: );
30: GMissOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
31: TYPE OksCoverageTimezonesVTblType IS TABLE OF OksCoverageTimezonesVRecType

Line 33: -- OKS_COVERAGE_TIMEZONES Record Spec

29: );
30: GMissOksCoverageTimezonesVRec OksCoverageTimezonesVRecType;
31: TYPE OksCoverageTimezonesVTblType IS TABLE OF OksCoverageTimezonesVRecType
32: INDEX BY BINARY_INTEGER;
33: -- OKS_COVERAGE_TIMEZONES Record Spec
34: TYPE OksCoverageTimezonesRecType IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR

Line 37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR

33: -- OKS_COVERAGE_TIMEZONES Record Spec
34: TYPE OksCoverageTimezonesRecType IS RECORD (
35: id NUMBER := OKC_API.G_MISS_NUM
36: ,cle_id NUMBER := OKC_API.G_MISS_NUM
37: ,default_yn OKS_COVERAGE_TIMEZONES.DEFAULT_YN%TYPE := OKC_API.G_MISS_CHAR
38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

38: ,timezone_id NUMBER := OKC_API.G_MISS_NUM
39: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

41: ,program_id NUMBER := OKC_API.G_MISS_NUM
42: ,program_update_date OKS_COVERAGE_TIMEZONES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

43: ,request_id NUMBER := OKC_API.G_MISS_NUM
44: ,created_by NUMBER := OKC_API.G_MISS_NUM
45: ,creation_date OKS_COVERAGE_TIMEZONES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
46: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
47: ,last_update_date OKS_COVERAGE_TIMEZONES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM

Line 52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR

48: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
53: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: -- R12 Data Model Changes 4485150 End
55: );
56: GMissOksCoverageTimezonesRec OksCoverageTimezonesRecType;

Line 53: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR

49: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
50: -- R12 Data Model Changes 4485150 Start
51: ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
52: ,orig_system_reference1 OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
53: ,orig_system_source_code OKS_COVERAGE_TIMEZONES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
54: -- R12 Data Model Changes 4485150 End
55: );
56: GMissOksCoverageTimezonesRec OksCoverageTimezonesRecType;
57: TYPE OksCoverageTimezonesTblType IS TABLE OF OksCoverageTimezonesRecType

Line 99: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,

95: p_init_msg_list IN VARCHAR2,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
100: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType);
101: PROCEDURE insert_row(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2,

Line 100: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType);

96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
100: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType);
101: PROCEDURE insert_row(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2,
104: x_return_status OUT NOCOPY VARCHAR2,

Line 107: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,

103: p_init_msg_list IN VARCHAR2,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
108: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
109: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
110: PROCEDURE insert_row(
111: p_api_version IN NUMBER,

Line 108: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,

104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
108: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
109: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
110: PROCEDURE insert_row(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2,

Line 116: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,

112: p_init_msg_list IN VARCHAR2,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
117: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType);
118: PROCEDURE lock_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2,

Line 117: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType);

113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
117: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType);
118: PROCEDURE lock_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2,
121: x_return_status OUT NOCOPY VARCHAR2,

Line 124: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType);

120: p_init_msg_list IN VARCHAR2,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType);
125: PROCEDURE lock_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2,
128: x_return_status OUT NOCOPY VARCHAR2,

Line 131: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,

127: p_init_msg_list IN VARCHAR2,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
132: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
133: PROCEDURE lock_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2,

Line 139: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType);

135: p_init_msg_list IN VARCHAR2,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType);
140: PROCEDURE update_row(
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2,
143: x_return_status OUT NOCOPY VARCHAR2,

Line 146: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,

142: p_init_msg_list IN VARCHAR2,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
147: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType);
148: PROCEDURE update_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2,

Line 147: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType);

143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType,
147: x_oks_coverage_timezones_v_rec OUT NOCOPY OksCoverageTimezonesVRecType);
148: PROCEDURE update_row(
149: p_api_version IN NUMBER,
150: p_init_msg_list IN VARCHAR2,
151: x_return_status OUT NOCOPY VARCHAR2,

Line 154: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,

150: p_init_msg_list IN VARCHAR2,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
155: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
156: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
157: PROCEDURE update_row(
158: p_api_version IN NUMBER,

Line 155: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,

151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
155: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType,
156: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
157: PROCEDURE update_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2,

Line 163: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,

159: p_init_msg_list IN VARCHAR2,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
164: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType);
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2,

Line 164: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType);

160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
164: x_oks_coverage_timezones_v_tbl OUT NOCOPY OksCoverageTimezonesVTblType);
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2,
168: x_return_status OUT NOCOPY VARCHAR2,

Line 171: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType);

167: p_init_msg_list IN VARCHAR2,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType);
172: PROCEDURE delete_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2,
175: x_return_status OUT NOCOPY VARCHAR2,

Line 178: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,

174: p_init_msg_list IN VARCHAR2,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
179: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
180: PROCEDURE delete_row(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2,

Line 186: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType);

182: p_init_msg_list IN VARCHAR2,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType);
187: PROCEDURE validate_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2,
190: x_return_status OUT NOCOPY VARCHAR2,

Line 193: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType);

189: p_init_msg_list IN VARCHAR2,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_oks_coverage_timezones_v_rec IN OksCoverageTimezonesVRecType);
194: PROCEDURE validate_row(
195: p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2,
197: x_return_status OUT NOCOPY VARCHAR2,

Line 200: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,

196: p_init_msg_list IN VARCHAR2,
197: x_return_status OUT NOCOPY VARCHAR2,
198: x_msg_count OUT NOCOPY NUMBER,
199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType,
201: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
202: PROCEDURE validate_row(
203: p_api_version IN NUMBER,
204: p_init_msg_list IN VARCHAR2,

Line 208: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType);

204: p_init_msg_list IN VARCHAR2,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_oks_coverage_timezones_v_tbl IN OksCoverageTimezonesVTblType);
209:
210:
211: FUNCTION Create_Version(
212: p_id IN NUMBER,