27:
28: ---------------------------
29: -- DECLARE Local Variables
30: ---------------------------
31: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec';
32: L_DEBUG_ENABLED VARCHAR2(10);
33: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
34: IS_DEBUG_PROCEDURE_ON BOOLEAN;
35: l_xmp_rec xmp_rec_type ;
29: -- DECLARE Local Variables
30: ---------------------------
31: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec';
32: L_DEBUG_ENABLED VARCHAR2(10);
33: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
34: IS_DEBUG_PROCEDURE_ON BOOLEAN;
35: l_xmp_rec xmp_rec_type ;
36: l_api_version NUMBER ;
37: l_init_msg_list VARCHAR2(1) ;
165:
166: ---------------------------
167: -- DECLARE Local Variables
168: ---------------------------
169: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_tbl';
170: L_DEBUG_ENABLED VARCHAR2(10);
171: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
172: IS_DEBUG_PROCEDURE_ON BOOLEAN;
173: l_xmp_tbl xmp_tbl_type ;
167: -- DECLARE Local Variables
168: ---------------------------
169: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_tbl';
170: L_DEBUG_ENABLED VARCHAR2(10);
171: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
172: IS_DEBUG_PROCEDURE_ON BOOLEAN;
173: l_xmp_tbl xmp_tbl_type ;
174: l_api_version NUMBER ;
175: l_init_msg_list VARCHAR2(1) ;
301: ) IS
302: ---------------------------
303: -- DECLARE Local Variables
304: ---------------------------
305: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_rec';
306: L_DEBUG_ENABLED VARCHAR2(10);
307: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
308: IS_DEBUG_PROCEDURE_ON BOOLEAN;
309: l_xmp_rec xmp_rec_type ;
303: -- DECLARE Local Variables
304: ---------------------------
305: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_rec';
306: L_DEBUG_ENABLED VARCHAR2(10);
307: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
308: IS_DEBUG_PROCEDURE_ON BOOLEAN;
309: l_xmp_rec xmp_rec_type ;
310: l_api_version NUMBER ;
311: l_init_msg_list VARCHAR2(1) ;
434: ) IS
435: ---------------------------
436: -- DECLARE Local Variables
437: ---------------------------
438: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_tbl';
439: L_DEBUG_ENABLED VARCHAR2(10);
440: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
441: IS_DEBUG_PROCEDURE_ON BOOLEAN;
442: l_xmp_tbl xmp_tbl_type ;
436: -- DECLARE Local Variables
437: ---------------------------
438: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_tbl';
439: L_DEBUG_ENABLED VARCHAR2(10);
440: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
441: IS_DEBUG_PROCEDURE_ON BOOLEAN;
442: l_xmp_tbl xmp_tbl_type ;
443: l_api_version NUMBER ;
444: l_init_msg_list VARCHAR2(1) ;
566: ) IS
567: ---------------------------
568: -- DECLARE Local Variables
569: ---------------------------
570: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.delete_xmlp_params';
571: L_DEBUG_ENABLED VARCHAR2(10);
572: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
573: IS_DEBUG_PROCEDURE_ON BOOLEAN;
574: l_batch_id OKL_XMLP_PARAMS.Batch_Id%TYPE ;
568: -- DECLARE Local Variables
569: ---------------------------
570: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.delete_xmlp_params';
571: L_DEBUG_ENABLED VARCHAR2(10);
572: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
573: IS_DEBUG_PROCEDURE_ON BOOLEAN;
574: l_batch_id OKL_XMLP_PARAMS.Batch_Id%TYPE ;
575: l_id OKL_XMLP_PARAMS.Id%TYPE ;
576: l_xmp_rec xmp_rec_type ;
709: p_xmp_rec IN xmp_rec_type) IS
710: ---------------------------
711: -- DECLARE Local Variables
712: ---------------------------
713: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_rec';
714: L_DEBUG_ENABLED VARCHAR2(10);
715: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
716: IS_DEBUG_PROCEDURE_ON BOOLEAN;
717: l_xmp_rec xmp_rec_type := p_xmp_rec;
711: -- DECLARE Local Variables
712: ---------------------------
713: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_rec';
714: L_DEBUG_ENABLED VARCHAR2(10);
715: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
716: IS_DEBUG_PROCEDURE_ON BOOLEAN;
717: l_xmp_rec xmp_rec_type := p_xmp_rec;
718: l_api_version NUMBER ;
719: l_init_msg_list VARCHAR2(1) ;
837:
838: ---------------------------
839: -- DECLARE Local Variables
840: ---------------------------
841: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_tbl';
842: L_DEBUG_ENABLED VARCHAR2(10);
843: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
844: IS_DEBUG_PROCEDURE_ON BOOLEAN;
845: l_xmp_tbl xmp_tbl_type := p_xmp_tbl;
839: -- DECLARE Local Variables
840: ---------------------------
841: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_tbl';
842: L_DEBUG_ENABLED VARCHAR2(10);
843: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
844: IS_DEBUG_PROCEDURE_ON BOOLEAN;
845: l_xmp_tbl xmp_tbl_type := p_xmp_tbl;
846: l_api_version NUMBER ;
847: l_init_msg_list VARCHAR2(1) ;