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.OKL_CHECKLIST_PVT dependencies on OKL_API

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

3: ----------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CHECKLIST_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

Line 9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CHECKLIST_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;

Line 10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CHECKLIST_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:

Line 11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';

Line 22: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;

18:
19: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
21: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
22: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
23: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
24:
25: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
26: G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';

Line 23: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;

19: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
20: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
21: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
22: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
23: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
24:
25: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
26: G_API_TYPE CONSTANT VARCHAR(4) := '_PVT';
27:

Line 60: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

56: -- End of comments
57: ----------------------------------------------------------------------------------
58: PROCEDURE create_checklist_hdr(
59: p_api_version IN NUMBER
60: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
61: ,x_return_status OUT NOCOPY VARCHAR2
62: ,x_msg_count OUT NOCOPY NUMBER
63: ,x_msg_data OUT NOCOPY VARCHAR2
64: ,p_clhv_rec IN clhv_rec_type

Line 80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

76: -- End of comments
77: ----------------------------------------------------------------------------------
78: PROCEDURE update_checklist_hdr(
79: p_api_version IN NUMBER
80: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
81: ,x_return_status OUT NOCOPY VARCHAR2
82: ,x_msg_count OUT NOCOPY NUMBER
83: ,x_msg_data OUT NOCOPY VARCHAR2
84: ,p_clhv_rec IN clhv_rec_type

Line 100: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

96: -- End of comments
97: ----------------------------------------------------------------------------------
98: PROCEDURE delete_checklist_hdr(
99: p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
101: ,x_return_status OUT NOCOPY VARCHAR2
102: ,x_msg_count OUT NOCOPY NUMBER
103: ,x_msg_data OUT NOCOPY VARCHAR2
104: ,p_clhv_rec IN clhv_rec_type

Line 119: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

115: -- End of comments
116: ----------------------------------------------------------------------------------
117: PROCEDURE create_checklist_dtl(
118: p_api_version IN NUMBER
119: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
120: ,x_return_status OUT NOCOPY VARCHAR2
121: ,x_msg_count OUT NOCOPY NUMBER
122: ,x_msg_data OUT NOCOPY VARCHAR2
123: ,p_cldv_tbl IN cldv_tbl_type

Line 139: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

135: -- End of comments
136: ----------------------------------------------------------------------------------
137: PROCEDURE update_checklist_dtl(
138: p_api_version IN NUMBER
139: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER
142: ,x_msg_data OUT NOCOPY VARCHAR2
143: ,p_cldv_tbl IN cldv_tbl_type

Line 159: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

155: -- End of comments
156: ----------------------------------------------------------------------------------
157: PROCEDURE delete_checklist_dtl(
158: p_api_version IN NUMBER
159: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
160: ,x_return_status OUT NOCOPY VARCHAR2
161: ,x_msg_count OUT NOCOPY NUMBER
162: ,x_msg_data OUT NOCOPY VARCHAR2
163: ,p_cldv_tbl IN cldv_tbl_type

Line 180: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

176: -- End of comments
177: ----------------------------------------------------------------------------------
178: PROCEDURE submit_for_approval(
179: p_api_version IN NUMBER
180: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_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: ,x_status_code OUT NOCOPY VARCHAR2

Line 208: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

204: -- End of comments
205: ----------------------------------------------------------------------------------
206: PROCEDURE create_checklist_inst_hdr(
207: p_api_version IN NUMBER
208: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
209: ,x_return_status OUT NOCOPY VARCHAR2
210: ,x_msg_count OUT NOCOPY NUMBER
211: ,x_msg_data OUT NOCOPY VARCHAR2
212: ,p_clhv_rec IN clhv_rec_type

Line 232: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

228: -- End of comments
229: ----------------------------------------------------------------------------------
230: PROCEDURE update_checklist_inst_hdr(
231: p_api_version IN NUMBER
232: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
233: ,x_return_status OUT NOCOPY VARCHAR2
234: ,x_msg_count OUT NOCOPY NUMBER
235: ,x_msg_data OUT NOCOPY VARCHAR2
236: ,p_clhv_rec IN clhv_rec_type

Line 252: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

248: -- End of comments
249: ----------------------------------------------------------------------------------
250: PROCEDURE delete_checklist_inst_hdr(
251: p_api_version IN NUMBER
252: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
253: ,x_return_status OUT NOCOPY VARCHAR2
254: ,x_msg_count OUT NOCOPY NUMBER
255: ,x_msg_data OUT NOCOPY VARCHAR2
256: ,p_clhv_rec IN clhv_rec_type

Line 287: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

283: -- End of comments
284: ----------------------------------------------------------------------------------
285: PROCEDURE create_checklist_inst_dtl(
286: p_api_version IN NUMBER
287: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
288: ,x_return_status OUT NOCOPY VARCHAR2
289: ,x_msg_count OUT NOCOPY NUMBER
290: ,x_msg_data OUT NOCOPY VARCHAR2
291: ,p_cldv_tbl IN cldv_tbl_type

Line 312: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

308: -- End of comments
309: ----------------------------------------------------------------------------------
310: PROCEDURE update_checklist_inst_dtl(
311: p_api_version IN NUMBER
312: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
313: ,x_return_status OUT NOCOPY VARCHAR2
314: ,x_msg_count OUT NOCOPY NUMBER
315: ,x_msg_data OUT NOCOPY VARCHAR2
316: ,p_cldv_tbl IN cldv_tbl_type

Line 332: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

328: -- End of comments
329: ----------------------------------------------------------------------------------
330: PROCEDURE delete_checklist_inst_dtl(
331: p_api_version IN NUMBER
332: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
333: ,x_return_status OUT NOCOPY VARCHAR2
334: ,x_msg_count OUT NOCOPY NUMBER
335: ,x_msg_data OUT NOCOPY VARCHAR2
336: ,p_cldv_tbl IN cldv_tbl_type

Line 358: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

354: -- End of comments
355: ----------------------------------------------------------------------------------
356: PROCEDURE chk_eligible_for_approval(
357: p_api_version IN NUMBER
358: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
359: ,x_return_status OUT NOCOPY VARCHAR2
360: ,x_msg_count OUT NOCOPY NUMBER
361: ,x_msg_data OUT NOCOPY VARCHAR2
362: ,p_clh_id IN NUMBER

Line 378: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

374: -- End of comments
375: ----------------------------------------------------------------------------------
376: PROCEDURE update_checklist_function(
377: p_api_version IN NUMBER
378: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
379: ,x_return_status OUT NOCOPY VARCHAR2
380: ,x_msg_count OUT NOCOPY NUMBER
381: ,x_msg_data OUT NOCOPY VARCHAR2
382: ,p_checklist_obj_id IN NUMBER

Line 404: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

400: -- End of comments
401: ----------------------------------------------------------------------------------
402: PROCEDURE create_contract_checklist(
403: p_api_version IN NUMBER
404: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
405: ,x_return_status OUT NOCOPY VARCHAR2
406: ,x_msg_count OUT NOCOPY NUMBER
407: ,x_msg_data OUT NOCOPY VARCHAR2
408: ,p_chr_id IN NUMBER