DBA Data[Home] [Help]

APPS.OKL_RESI_CAT_SETS_PVT dependencies on OKL_RESI_CAT_SETS_PVT

Line 1: PACKAGE BODY OKL_RESI_CAT_SETS_PVT as

1: PACKAGE BODY OKL_RESI_CAT_SETS_PVT as
2: /* $Header: OKLRRCSB.pls 120.4 2005/09/14 06:43:12 smadhava noship $ */
3:
4: -- Function checks if there are repetitions of items or categories in a residual category set
5: FUNCTION check_existence (p_source_code VARCHAR2, p_res_tbl IN okl_res_tbl) RETURN VARCHAR2 IS

Line 77: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.check_update_status';

73: */
74: FUNCTION check_update_status(
75: p_source_code IN VARCHAR2
76: , p_res_upd_tbl IN okl_res_tbl) RETURN VARCHAR2 IS
77: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.check_update_status';
78: l_debug_enabled VARCHAR2(10);
79: is_debug_procedure_on BOOLEAN;
80: is_debug_statement_on BOOLEAN;
81:

Line 173: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.create_rcs';

169: , p_res_tbl IN okl_res_tbl
170: , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
171: , x_res_tbl OUT NOCOPY okl_res_tbl
172: ) IS
173: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.create_rcs';
174: l_debug_enabled VARCHAR2(10);
175: is_debug_procedure_on BOOLEAN;
176: is_debug_statement_on BOOLEAN;
177:

Line 324: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.update_rcs';

320: , p_rcsv_rec IN okl_rcsv_rec
321: , p_res_tbl IN okl_res_tbl
322: , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
323: ) IS
324: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.update_rcs';
325: l_debug_enabled VARCHAR2(10);
326: is_debug_procedure_on BOOLEAN;
327: is_debug_statement_on BOOLEAN;
328:

Line 512: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.activate_rcs';

508: , p_rcsv_rec IN okl_rcsv_rec
509: , p_res_tbl IN okl_res_tbl
510: , x_rcsv_rec OUT NOCOPY okl_rcsv_rec
511: ) IS
512: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.activate_rcs';
513: l_debug_enabled VARCHAR2(10);
514: is_debug_procedure_on BOOLEAN;
515: is_debug_statement_on BOOLEAN;
516:

Line 636: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.Inactivate_rcs';

632: , x_msg_data OUT NOCOPY VARCHAR2
633: , p_rcs_id IN NUMBER
634: , p_obj_ver_number IN NUMBER
635: ) IS
636: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.Inactivate_rcs';
637: l_debug_enabled VARCHAR2(10);
638: is_debug_procedure_on BOOLEAN;
639: is_debug_statement_on BOOLEAN;
640:

Line 740: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.delete_objects';

736: , x_return_status OUT NOCOPY VARCHAR2
737: , x_msg_count OUT NOCOPY NUMBER
738: , x_msg_data OUT NOCOPY VARCHAR2
739: , p_res_tbl IN okl_res_tbl) IS
740: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_RESI_CAT_SETS_PVT.delete_objects';
741: l_debug_enabled VARCHAR2(10);
742: is_debug_procedure_on BOOLEAN;
743: is_debug_statement_on BOOLEAN;
744:

Line 828: END OKL_RESI_CAT_SETS_PVT;

824: '_PVT'
825: );
826: END delete_objects;
827:
828: END OKL_RESI_CAT_SETS_PVT;