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_SYSTEM_PARAMS_ALL_PUB dependencies on OKL_SYSTEM_PARAMS_ALL

Line 1: PACKAGE BODY OKL_SYSTEM_PARAMS_ALL_PUB AS

1: PACKAGE BODY OKL_SYSTEM_PARAMS_ALL_PUB AS
2: /* $Header: OKLPSYPB.pls 120.2 2006/07/31 06:20:00 akrangan noship $ */
3: -- Start of comments
4: --
5: -- Procedure Name : insert_system_parameters

Line 6: -- Description : procedure to insert into OKL_SYSTEM_PARAMS_ALL_V - REC

2: /* $Header: OKLPSYPB.pls 120.2 2006/07/31 06:20:00 akrangan noship $ */
3: -- Start of comments
4: --
5: -- Procedure Name : insert_system_parameters
6: -- Description : procedure to insert into OKL_SYSTEM_PARAMS_ALL_V - REC
7: -- Business Rules :
8: -- Parameters :
9: -- Version : 1.0
10: -- History : RMUNJULU Created

Line 55: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');

51: ,p_data => x_msg_data);
52: WHEN OTHERS THEN
53: ROLLBACK TO insert_row_trx;
54: x_return_status := G_RET_STS_UNEXP_ERROR;
55: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
56: FND_MSG_PUB.count_and_get(
57: p_count => x_msg_count
58: ,p_data => x_msg_data);
59: END insert_system_parameters;

Line 63: -- Description : procedure to insert into OKL_SYSTEM_PARAMS_ALL_V - TBL

59: END insert_system_parameters;
60: -- Start of comments
61: --
62: -- Procedure Name : insert_system_parameters
63: -- Description : procedure to insert into OKL_SYSTEM_PARAMS_ALL_V - TBL
64: -- Business Rules :
65: -- Parameters :
66: -- Version : 1.0
67: -- History : RMUNJULU Created

Line 112: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');

108: ,p_data => x_msg_data);
109: WHEN OTHERS THEN
110: ROLLBACK TO insert_row_trx;
111: x_return_status := G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
113: FND_MSG_PUB.count_and_get(
114: p_count => x_msg_count
115: ,p_data => x_msg_data);
116: END insert_system_parameters;

Line 120: -- Description : procedure to lock OKL_SYSTEM_PARAMS_ALL_V - REC

116: END insert_system_parameters;
117: -- Start of comments
118: --
119: -- Procedure Name : lock_system_parameters
120: -- Description : procedure to lock OKL_SYSTEM_PARAMS_ALL_V - REC
121: -- Business Rules :
122: -- Parameters :
123: -- Version : 1.0
124: -- History : RMUNJULU Created

Line 167: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');

163: ,p_data => x_msg_data);
164: WHEN OTHERS THEN
165: ROLLBACK TO lock_row_trx;
166: x_return_status := G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
168: FND_MSG_PUB.count_and_get(
169: p_count => x_msg_count
170: ,p_data => x_msg_data);
171: END lock_system_parameters;

Line 175: -- Description : procedure to lock OKL_SYSTEM_PARAMS_ALL_V - TBL

171: END lock_system_parameters;
172: -- Start of comments
173: --
174: -- Procedure Name : lock_system_parameters
175: -- Description : procedure to lock OKL_SYSTEM_PARAMS_ALL_V - TBL
176: -- Business Rules :
177: -- Parameters :
178: -- Version : 1.0
179: -- History : RMUNJULU Created

Line 222: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');

218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: ROLLBACK TO lock_row_trx;
221: x_return_status := G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
223: FND_MSG_PUB.count_and_get(
224: p_count => x_msg_count
225: ,p_data => x_msg_data);
226: END lock_system_parameters;

Line 230: -- Description : procedure to update OKL_SYSTEM_PARAMS_ALL_V - REC

226: END lock_system_parameters;
227: -- Start of comments
228: --
229: -- Procedure Name : update_system_parameters
230: -- Description : procedure to update OKL_SYSTEM_PARAMS_ALL_V - REC
231: -- Business Rules :
232: -- Parameters :
233: -- Version : 1.0
234: -- History : RMUNJULU Created

Line 279: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');

275: ,p_data => x_msg_data);
276: WHEN OTHERS THEN
277: ROLLBACK TO update_row_trx;
278: x_return_status := G_RET_STS_UNEXP_ERROR;
279: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
280: FND_MSG_PUB.count_and_get(
281: p_count => x_msg_count
282: ,p_data => x_msg_data);
283: END update_system_parameters;

Line 287: -- Description : procedure to update OKL_SYSTEM_PARAMS_ALL_V - TBL

283: END update_system_parameters;
284: -- Start of comments
285: --
286: -- Procedure Name : update_system_parameters
287: -- Description : procedure to update OKL_SYSTEM_PARAMS_ALL_V - TBL
288: -- Business Rules :
289: -- Parameters :
290: -- Version : 1.0
291: -- History : RMUNJULU Created

Line 336: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');

332: ,p_data => x_msg_data);
333: WHEN OTHERS THEN
334: ROLLBACK TO update_row_trx;
335: x_return_status := G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
337: FND_MSG_PUB.count_and_get(
338: p_count => x_msg_count
339: ,p_data => x_msg_data);
340: END update_system_parameters;

Line 344: -- Description : procedure to delete from OKL_SYSTEM_PARAMS_ALL_V - REC

340: END update_system_parameters;
341: -- Start of comments
342: --
343: -- Procedure Name : delete_system_parameters
344: -- Description : procedure to delete from OKL_SYSTEM_PARAMS_ALL_V - REC
345: -- Business Rules :
346: -- Parameters :
347: -- Version : 1.0
348: -- History : RMUNJULU Created

Line 391: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');

387: ,p_data => x_msg_data);
388: WHEN OTHERS THEN
389: ROLLBACK TO delete_row_trx;
390: x_return_status := G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
392: FND_MSG_PUB.count_and_get(
393: p_count => x_msg_count
394: ,p_data => x_msg_data);
395: END delete_system_parameters;

Line 399: -- Description : procedure to delete from OKL_SYSTEM_PARAMS_ALL_V - TBL

395: END delete_system_parameters;
396: -- Start of comments
397: --
398: -- Procedure Name : delete_system_parameters
399: -- Description : procedure to delete from OKL_SYSTEM_PARAMS_ALL_V - TBL
400: -- Business Rules :
401: -- Parameters :
402: -- Version : 1.0
403: -- History : RMUNJULU Created

Line 446: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');

442: ,p_data => x_msg_data);
443: WHEN OTHERS THEN
444: ROLLBACK TO delete_row_trx;
445: x_return_status := G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
447: FND_MSG_PUB.count_and_get(
448: p_count => x_msg_count
449: ,p_data => x_msg_data);
450: END delete_system_parameters;

Line 454: -- Description : procedure to validate OKL_SYSTEM_PARAMS_ALL_V - REC

450: END delete_system_parameters;
451: -- Start of comments
452: --
453: -- Procedure Name : validate_system_parameters
454: -- Description : procedure to validate OKL_SYSTEM_PARAMS_ALL_V - REC
455: -- Business Rules :
456: -- Parameters :
457: -- Version : 1.0
458: -- History : RMUNJULU Created

Line 501: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');

497: ,p_data => x_msg_data);
498: WHEN OTHERS THEN
499: ROLLBACK TO validate_row_trx;
500: x_return_status := G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
502: FND_MSG_PUB.count_and_get(
503: p_count => x_msg_count
504: ,p_data => x_msg_data);
505: END validate_system_parameters;

Line 509: -- Description : procedure to validate OKL_SYSTEM_PARAMS_ALL_V - TBL

505: END validate_system_parameters;
506: -- Start of comments
507: --
508: -- Procedure Name : validate_system_parameters
509: -- Description : procedure to validate OKL_SYSTEM_PARAMS_ALL_V - TBL
510: -- Business Rules :
511: -- Parameters :
512: -- Version : 1.0
513: -- History : RMUNJULU Created

Line 556: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');

552: ,p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO validate_row_trx;
555: x_return_status := G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
557: FND_MSG_PUB.count_and_get(
558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: END validate_system_parameters;

Line 564: -- Description : function to get OKL_SYSTEM_PARAMS_ALL - TBL

560: END validate_system_parameters;
561: -- Start of comments
562: --
563: -- Procedure Name : get_system_param_value
564: -- Description : function to get OKL_SYSTEM_PARAMS_ALL - TBL
565: -- Business Rules :
566: -- Parameters :
567: -- Version : 1.0
568: -- History : AKRANGAN Created

Line 583: FROM okl_system_params_all

579: CURSOR C IS SELECT item_inv_org_id ,
580: rpt_prod_book_type_code ,
581: asst_add_book_type_code ,
582: ccard_remittance_id
583: FROM okl_system_params_all
584: WHERE org_id = l_org_id ;
585: BEGIN
586: FOR I IN C
587: LOOP

Line 601: END OKL_SYSTEM_PARAMS_ALL_PUB;

597: END LOOP;
598: --returns the reqd the system value here
599: RETURN x_ret_value;
600: END get_system_param_value;
601: END OKL_SYSTEM_PARAMS_ALL_PUB;