DBA Data[Home] [Help]

APPS.OKL_ITM_CAT_RV_PRCS_PUB dependencies on OKL_ITM_CAT_RV_PRCS_PUB

Line 1: PACKAGE BODY OKL_ITM_CAT_RV_PRCS_PUB AS

1: PACKAGE BODY OKL_ITM_CAT_RV_PRCS_PUB AS
2: /* $Header: OKLPICPB.pls 120.4 2005/10/30 03:31:59 appldev noship $ */
3:
4: PROCEDURE insert_itm_cat_rv_prcs(
5: p_api_version IN NUMBER

Line 14: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.insert_itm_cat_rv_prcs (REC)';

10: ,p_icpv_rec IN icpv_rec_type
11: ,x_icpv_rec OUT NOCOPY icpv_rec_type) IS
12:
13: l_program_name CONSTANT VARCHAR2(35) := 'insert_itm_cat_rv_prcs';
14: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.insert_itm_cat_rv_prcs (REC)';
15: p_transaction_control VARCHAR2(1) := G_TRUE;
16: lx_return_status VARCHAR2(1);
17:
18: BEGIN

Line 95: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.insert_itm_cat_rv_prcs (TBL)';

91: ,p_icpv_tbl IN icpv_tbl_type
92: ,x_icpv_tbl OUT NOCOPY icpv_tbl_type) IS
93:
94: l_program_name CONSTANT VARCHAR2(35) := 'insert_itm_cat_rv_prcs';
95: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.insert_itm_cat_rv_prcs (TBL)';
96: p_transaction_control VARCHAR2(1) := G_TRUE;
97: lx_return_status VARCHAR2(1);
98:
99: BEGIN

Line 175: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.lock_itm_cat_rv_prcs (REC)';

171: ,x_msg_data OUT NOCOPY VARCHAR2
172: ,p_icpv_rec IN icpv_rec_type) IS
173:
174: l_program_name CONSTANT VARCHAR2(35) := 'lock_itm_cat_rv_prcs';
175: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.lock_itm_cat_rv_prcs (REC)';
176: p_transaction_control VARCHAR2(1) := G_TRUE;
177: lx_return_status VARCHAR2(1);
178:
179: BEGIN

Line 254: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.lock_itm_cat_rv_prcs (TBL)';

250: ,x_msg_data OUT NOCOPY VARCHAR2
251: ,p_icpv_tbl IN icpv_tbl_type) IS
252:
253: l_program_name CONSTANT VARCHAR2(35) := 'lock_itm_cat_rv_prcs';
254: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.lock_itm_cat_rv_prcs (TBL)';
255: p_transaction_control VARCHAR2(1) := G_TRUE;
256: lx_return_status VARCHAR2(1);
257:
258: BEGIN

Line 334: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.update_itm_cat_rv_prcs (REC)';

330: ,p_icpv_rec IN icpv_rec_type
331: ,x_icpv_rec OUT NOCOPY icpv_rec_type) IS
332:
333: l_program_name CONSTANT VARCHAR2(35) := 'update_itm_cat_rv_prcs';
334: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.update_itm_cat_rv_prcs (REC)';
335: p_transaction_control VARCHAR2(1) := G_TRUE;
336: lx_return_status VARCHAR2(1);
337:
338: BEGIN

Line 415: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.update_itm_cat_rv_prcs (TBL)';

411: ,p_icpv_tbl IN icpv_tbl_type
412: ,x_icpv_tbl OUT NOCOPY icpv_tbl_type) IS
413:
414: l_program_name CONSTANT VARCHAR2(35) := 'update_itm_cat_rv_prcs';
415: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.update_itm_cat_rv_prcs (TBL)';
416: p_transaction_control VARCHAR2(1) := G_TRUE;
417: lx_return_status VARCHAR2(1);
418:
419: BEGIN

Line 495: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.delete_itm_cat_rv_prcs (REC)';

491: ,x_msg_data OUT NOCOPY VARCHAR2
492: ,p_icpv_rec IN icpv_rec_type) IS
493:
494: l_program_name CONSTANT VARCHAR2(35) := 'delete_itm_cat_rv_prcs';
495: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.delete_itm_cat_rv_prcs (REC)';
496: p_transaction_control VARCHAR2(1) := G_TRUE;
497: lx_return_status VARCHAR2(1);
498:
499: BEGIN

Line 574: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.delete_itm_cat_rv_prcs (TBL)';

570: ,x_msg_data OUT NOCOPY VARCHAR2
571: ,p_icpv_tbl IN icpv_tbl_type) IS
572:
573: l_program_name CONSTANT VARCHAR2(35) := 'delete_itm_cat_rv_prcs';
574: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.delete_itm_cat_rv_prcs (TBL)';
575: p_transaction_control VARCHAR2(1) := G_TRUE;
576: lx_return_status VARCHAR2(1);
577:
578: BEGIN

Line 653: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.validate_itm_cat_rv_prcs (REC)';

649: ,x_msg_data OUT NOCOPY VARCHAR2
650: ,p_icpv_rec IN icpv_rec_type) IS
651:
652: l_program_name CONSTANT VARCHAR2(35) := 'validate_itm_cat_rv_prcs';
653: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.validate_itm_cat_rv_prcs (REC)';
654: p_transaction_control VARCHAR2(1) := G_TRUE;
655: lx_return_status VARCHAR2(1);
656:
657: BEGIN

Line 732: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.validate_itm_cat_rv_prcs (TBL)';

728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_icpv_tbl IN icpv_tbl_type) IS
730:
731: l_program_name CONSTANT VARCHAR2(35) := 'validate_itm_cat_rv_prcs';
732: l_api_name CONSTANT VARCHAR2(65) := 'okl_itm_cat_rv_prcs_pub.validate_itm_cat_rv_prcs (TBL)';
733: p_transaction_control VARCHAR2(1) := G_TRUE;
734: lx_return_status VARCHAR2(1);
735:
736: BEGIN

Line 801: END okl_itm_cat_rv_prcs_pub;

797: x_return_status := G_RET_STS_UNEXP_ERROR;
798:
799: END validate_itm_cat_rv_prcs;
800:
801: END okl_itm_cat_rv_prcs_pub;