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) ;
46:
47: BEGIN
48: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
49: IF(L_DEBUG_ENABLED='Y') THEN
50: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
51: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
52: END IF;
53: IF(IS_DEBUG_PROCEDURE_ON) THEN
54: BEGIN
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) ;
184:
185: BEGIN
186: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
187: IF(L_DEBUG_ENABLED='Y') THEN
188: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
189: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
190: END IF;
191: IF(IS_DEBUG_PROCEDURE_ON) THEN
192: BEGIN
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) ;
319:
320: BEGIN
321: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
322: IF(L_DEBUG_ENABLED='Y') THEN
323: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
324: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
325: END IF;
326: IF(IS_DEBUG_PROCEDURE_ON) THEN
327: BEGIN
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) ;
452:
453: BEGIN
454: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
455: IF(L_DEBUG_ENABLED='Y') THEN
456: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
457: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
458: END IF;
459: IF(IS_DEBUG_PROCEDURE_ON) THEN
460: BEGIN
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 ;
593:
594: BEGIN
595: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
596: IF(L_DEBUG_ENABLED='Y') THEN
597: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
598: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
599: END IF;
600: IF(IS_DEBUG_PROCEDURE_ON) THEN
601: BEGIN
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) ;
728:
729: BEGIN
730: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
731: IF(L_DEBUG_ENABLED='Y') THEN
732: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
733: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
734: END IF;
735: IF(IS_DEBUG_PROCEDURE_ON) THEN
736: BEGIN
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) ;
853:
854: BEGIN
855: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
856: IF(L_DEBUG_ENABLED='Y') THEN
857: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
858: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
859: END IF;
860: IF(IS_DEBUG_PROCEDURE_ON) THEN
861: BEGIN