eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_SRVAVL_PVT dependencies on OKC_API

Line 6: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2: /* $Header: OKSRSVAB.pls 120.0 2005/05/25 18:33:59 appldev noship $ */
3:
4: PROCEDURE insert_serv_avail(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2,
10: p_savv_rec IN savv_rec_type,

Line 16: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

12:
13: Is
14:
15: l_api_name CONSTANT VARCHAR2(30) := 'insert_serv_avail';
16: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17:
18: Begin
19:
20: oks_avl_pvt.insert_row

Line 33: When OKC_API.G_EXCEPTION_ERROR THEN

29: );
30:
31:
32: Exception
33: When OKC_API.G_EXCEPTION_ERROR THEN
34: x_return_status := OKC_API.HANDLE_EXCEPTIONS
35: (
36: l_api_name,
37: G_PKG_NAME,

Line 34: x_return_status := OKC_API.HANDLE_EXCEPTIONS

30:
31:
32: Exception
33: When OKC_API.G_EXCEPTION_ERROR THEN
34: x_return_status := OKC_API.HANDLE_EXCEPTIONS
35: (
36: l_api_name,
37: G_PKG_NAME,
38: 'OKC_API.G_RET_STS_ERROR',

Line 38: 'OKC_API.G_RET_STS_ERROR',

34: x_return_status := OKC_API.HANDLE_EXCEPTIONS
35: (
36: l_api_name,
37: G_PKG_NAME,
38: 'OKC_API.G_RET_STS_ERROR',
39: x_msg_count,
40: x_msg_data,
41: '_PVT'
42: );

Line 44: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

40: x_msg_data,
41: '_PVT'
42: );
43:
44: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
45: x_return_status := OKC_API.HANDLE_EXCEPTIONS
46: (
47: l_api_name,
48: G_PKG_NAME,

Line 45: x_return_status := OKC_API.HANDLE_EXCEPTIONS

41: '_PVT'
42: );
43:
44: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
45: x_return_status := OKC_API.HANDLE_EXCEPTIONS
46: (
47: l_api_name,
48: G_PKG_NAME,
49: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 49: 'OKC_API.G_RET_STS_UNEXP_ERROR',

45: x_return_status := OKC_API.HANDLE_EXCEPTIONS
46: (
47: l_api_name,
48: G_PKG_NAME,
49: 'OKC_API.G_RET_STS_UNEXP_ERROR',
50: x_msg_count,
51: x_msg_data,
52: '_PVT'
53: );

Line 56: x_return_status := OKC_API.HANDLE_EXCEPTIONS

52: '_PVT'
53: );
54:
55: When OTHERS THEN
56: x_return_status := OKC_API.HANDLE_EXCEPTIONS
57: (
58: l_api_name,
59: G_PKG_NAME,
60: 'OTHERS',

Line 72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

68:
69:
70: PROCEDURE lock_serv_avail(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_savv_rec IN savv_rec_type)

Line 79: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_savv_rec IN savv_rec_type)
77: Is
78: l_api_name CONSTANT VARCHAR2(30) := 'lock_serv_avail';
79: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
80:
81: Begin
82:
83: oks_avl_pvt.lock_row

Line 94: When OKC_API.G_EXCEPTION_ERROR THEN

90: p_savv_rec
91: );
92:
93: Exception
94: When OKC_API.G_EXCEPTION_ERROR THEN
95: x_return_status := OKC_API.HANDLE_EXCEPTIONS
96: (
97: l_api_name,
98: G_PKG_NAME,

Line 95: x_return_status := OKC_API.HANDLE_EXCEPTIONS

91: );
92:
93: Exception
94: When OKC_API.G_EXCEPTION_ERROR THEN
95: x_return_status := OKC_API.HANDLE_EXCEPTIONS
96: (
97: l_api_name,
98: G_PKG_NAME,
99: 'OKC_API.G_RET_STS_ERROR',

Line 99: 'OKC_API.G_RET_STS_ERROR',

95: x_return_status := OKC_API.HANDLE_EXCEPTIONS
96: (
97: l_api_name,
98: G_PKG_NAME,
99: 'OKC_API.G_RET_STS_ERROR',
100: x_msg_count,
101: x_msg_data,
102: '_PVT'
103: );

Line 105: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

101: x_msg_data,
102: '_PVT'
103: );
104:
105: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
106: x_return_status := OKC_API.HANDLE_EXCEPTIONS
107: (
108: l_api_name,
109: G_PKG_NAME,

Line 106: x_return_status := OKC_API.HANDLE_EXCEPTIONS

102: '_PVT'
103: );
104:
105: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
106: x_return_status := OKC_API.HANDLE_EXCEPTIONS
107: (
108: l_api_name,
109: G_PKG_NAME,
110: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 110: 'OKC_API.G_RET_STS_UNEXP_ERROR',

106: x_return_status := OKC_API.HANDLE_EXCEPTIONS
107: (
108: l_api_name,
109: G_PKG_NAME,
110: 'OKC_API.G_RET_STS_UNEXP_ERROR',
111: x_msg_count,
112: x_msg_data,
113: '_PVT'
114: );

Line 117: x_return_status := OKC_API.HANDLE_EXCEPTIONS

113: '_PVT'
114: );
115:
116: When OTHERS THEN
117: x_return_status := OKC_API.HANDLE_EXCEPTIONS
118: (
119: l_api_name,
120: G_PKG_NAME,
121: 'OTHERS',

Line 133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

129:
130:
131: PROCEDURE update_serv_avail(
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_savv_rec IN savv_rec_type,

Line 141: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

137: p_savv_rec IN savv_rec_type,
138: x_savv_rec OUT NOCOPY savv_rec_type)
139: Is
140: l_api_name CONSTANT VARCHAR2(30) := 'update_serv_avail';
141: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
142:
143: Begin
144:
145: oks_avl_pvt.update_row

Line 157: When OKC_API.G_EXCEPTION_ERROR THEN

153: x_savv_rec
154: );
155:
156: Exception
157: When OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (
160: l_api_name,
161: G_PKG_NAME,

Line 158: x_return_status := OKC_API.HANDLE_EXCEPTIONS

154: );
155:
156: Exception
157: When OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (
160: l_api_name,
161: G_PKG_NAME,
162: 'OKC_API.G_RET_STS_ERROR',

Line 162: 'OKC_API.G_RET_STS_ERROR',

158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (
160: l_api_name,
161: G_PKG_NAME,
162: 'OKC_API.G_RET_STS_ERROR',
163: x_msg_count,
164: x_msg_data,
165: '_PVT'
166: );

Line 168: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

164: x_msg_data,
165: '_PVT'
166: );
167:
168: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status := OKC_API.HANDLE_EXCEPTIONS
170: (
171: l_api_name,
172: G_PKG_NAME,

Line 169: x_return_status := OKC_API.HANDLE_EXCEPTIONS

165: '_PVT'
166: );
167:
168: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status := OKC_API.HANDLE_EXCEPTIONS
170: (
171: l_api_name,
172: G_PKG_NAME,
173: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 173: 'OKC_API.G_RET_STS_UNEXP_ERROR',

169: x_return_status := OKC_API.HANDLE_EXCEPTIONS
170: (
171: l_api_name,
172: G_PKG_NAME,
173: 'OKC_API.G_RET_STS_UNEXP_ERROR',
174: x_msg_count,
175: x_msg_data,
176: '_PVT'
177: );

Line 180: x_return_status := OKC_API.HANDLE_EXCEPTIONS

176: '_PVT'
177: );
178:
179: When OTHERS THEN
180: x_return_status := OKC_API.HANDLE_EXCEPTIONS
181: (
182: l_api_name,
183: G_PKG_NAME,
184: 'OTHERS',

Line 196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

192:
193:
194: PROCEDURE delete_serv_avail(
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_savv_rec IN savv_rec_type)

Line 203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

199: x_msg_data OUT NOCOPY VARCHAR2,
200: p_savv_rec IN savv_rec_type)
201: Is
202: l_api_name CONSTANT VARCHAR2(30) := 'delete_serv_avail';
203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
204:
205: Begin
206:
207: oks_avl_pvt.delete_row

Line 218: When OKC_API.G_EXCEPTION_ERROR THEN

214: p_savv_rec
215: );
216:
217: Exception
218: When OKC_API.G_EXCEPTION_ERROR THEN
219: x_return_status := OKC_API.HANDLE_EXCEPTIONS
220: (
221: l_api_name,
222: G_PKG_NAME,

Line 219: x_return_status := OKC_API.HANDLE_EXCEPTIONS

215: );
216:
217: Exception
218: When OKC_API.G_EXCEPTION_ERROR THEN
219: x_return_status := OKC_API.HANDLE_EXCEPTIONS
220: (
221: l_api_name,
222: G_PKG_NAME,
223: 'OKC_API.G_RET_STS_ERROR',

Line 223: 'OKC_API.G_RET_STS_ERROR',

219: x_return_status := OKC_API.HANDLE_EXCEPTIONS
220: (
221: l_api_name,
222: G_PKG_NAME,
223: 'OKC_API.G_RET_STS_ERROR',
224: x_msg_count,
225: x_msg_data,
226: '_PVT'
227: );

Line 229: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

225: x_msg_data,
226: '_PVT'
227: );
228:
229: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
230: x_return_status := OKC_API.HANDLE_EXCEPTIONS
231: (
232: l_api_name,
233: G_PKG_NAME,

Line 230: x_return_status := OKC_API.HANDLE_EXCEPTIONS

226: '_PVT'
227: );
228:
229: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
230: x_return_status := OKC_API.HANDLE_EXCEPTIONS
231: (
232: l_api_name,
233: G_PKG_NAME,
234: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 234: 'OKC_API.G_RET_STS_UNEXP_ERROR',

230: x_return_status := OKC_API.HANDLE_EXCEPTIONS
231: (
232: l_api_name,
233: G_PKG_NAME,
234: 'OKC_API.G_RET_STS_UNEXP_ERROR',
235: x_msg_count,
236: x_msg_data,
237: '_PVT'
238: );

Line 241: x_return_status := OKC_API.HANDLE_EXCEPTIONS

237: '_PVT'
238: );
239:
240: When OTHERS THEN
241: x_return_status := OKC_API.HANDLE_EXCEPTIONS
242: (
243: l_api_name,
244: G_PKG_NAME,
245: 'OTHERS',

Line 257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

253:
254:
255: PROCEDURE validate_serv_avail(
256: p_api_version IN NUMBER,
257: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258: x_return_status OUT NOCOPY VARCHAR2,
259: x_msg_count OUT NOCOPY NUMBER,
260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_savv_rec IN savv_rec_type)

Line 264: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

260: x_msg_data OUT NOCOPY VARCHAR2,
261: p_savv_rec IN savv_rec_type)
262: Is
263: l_api_name CONSTANT VARCHAR2(30) := 'validate_serv_avail';
264: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
265:
266: Begin
267:
268: oks_avl_pvt.validate_row

Line 280: When OKC_API.G_EXCEPTION_ERROR THEN

276: );
277:
278:
279: Exception
280: When OKC_API.G_EXCEPTION_ERROR THEN
281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,

Line 281: x_return_status := OKC_API.HANDLE_EXCEPTIONS

277:
278:
279: Exception
280: When OKC_API.G_EXCEPTION_ERROR THEN
281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,
285: 'OKC_API.G_RET_STS_ERROR',

Line 285: 'OKC_API.G_RET_STS_ERROR',

281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
282: (
283: l_api_name,
284: G_PKG_NAME,
285: 'OKC_API.G_RET_STS_ERROR',
286: x_msg_count,
287: x_msg_data,
288: '_PVT'
289: );

Line 291: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

287: x_msg_data,
288: '_PVT'
289: );
290:
291: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (
294: l_api_name,
295: G_PKG_NAME,

Line 292: x_return_status := OKC_API.HANDLE_EXCEPTIONS

288: '_PVT'
289: );
290:
291: When OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (
294: l_api_name,
295: G_PKG_NAME,
296: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 296: 'OKC_API.G_RET_STS_UNEXP_ERROR',

292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
293: (
294: l_api_name,
295: G_PKG_NAME,
296: 'OKC_API.G_RET_STS_UNEXP_ERROR',
297: x_msg_count,
298: x_msg_data,
299: '_PVT'
300: );

Line 303: x_return_status := OKC_API.HANDLE_EXCEPTIONS

299: '_PVT'
300: );
301:
302: When OTHERS THEN
303: x_return_status := OKC_API.HANDLE_EXCEPTIONS
304: (
305: l_api_name,
306: G_PKG_NAME,
307: 'OTHERS',