[Home] [Help]
440: IF l_mode = 'BATCH' THEN
441:
442: SELECT numeric_value
443: INTO l_batch_id
444: FROM EGO_PUB_WS_CONFIG
445: WHERE PARAMETER_NAME = 'BATCH_ID'
446: AND session_id = p_session_id;
447:
448: debug(1, l_proc_name||'Finish fetch batch id=>'||l_batch_id);
588: --get invocation mode for the web service
589: /*
590: SELECT CHAR_VALUE
591: INTO l_mode
592: FROM EGO_PUB_WS_CONFIG
593: WHERE PARAMETER_NAME = 'MODE'
594: AND session_id = p_session_id;
595: */
596:
608: IF l_mode = 'BATCH' THEN
609:
610: SELECT numeric_value
611: INTO l_batch_id
612: FROM EGO_PUB_WS_CONFIG
613: WHERE PARAMETER_NAME = 'BATCH_ID'
614: AND session_id = p_session_id;
615:
616: g_batch_id := l_batch_id;
625:
626: l_explode_child_vs := 'TRUE'; --- Default value
627:
628:
629: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
630: odi_session_id,
631: Parameter_Name,
632: Data_Type,
633: Char_value,
650: p_batch_id => l_batch_id,
651: p_mode => 'BATCH'
652: );
653:
654: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
655: odi_session_id,
656: Parameter_Name,
657: Data_Type,
658: Char_value,
681: l_publish_sync := 'Y';
682: END IF;
683:
684:
685: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
686: odi_session_id,
687: Parameter_Name,
688: Data_Type,
689: Char_value,
703:
704:
705: l_return_payload := 'TRUE';
706:
707: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
708: odi_session_id,
709: Parameter_Name,
710: Data_Type,
711: Char_value,
728:
729: IF l_mode = 'LIST' THEN
730: --
731: --STEP ONE: RETRIEVE ALL SINGLE-VALUE CONFIGURATION PARAMETERS
732: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
733: --
734:
735: --initialize arrays of parameter names
736: l_param_names := EGO_PUB_WS_UTIL.parameter_name_array_type();
741: EGO_PUB_WS_UTIL.Get_Xpath_Expr(l_web_service_name, l_xpath_expr);
742: debug(5, l_proc_name||'Finish fetch param XML tags');
743:
744: --retrieve all single-value parameters of interest from XML
745: --and store them in table EGO_PUB_WS_CONFIG
746: FOR position IN 1..l_param_names.COUNT
747: LOOP
748:
749: l_config_option := upper(EGO_PUB_WS_UTIL.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr(position)));
752: --if parameter is not provided, assume a default value of 'Y' (Yes)
753:
754: IF l_config_option IS NOT NULL AND l_config_option <> '?' THEN
755:
756: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
757: odi_session_id,
758: Parameter_Name,
759: Data_Type,
760: Char_value,
782: );
783: debug(6, l_proc_name||'Finish security option');
784: --
785: --STEP TWO: RETRIEVE ALL MULTI-VALUE CONFIGURATION PARAMETERS
786: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
787: --
788:
789: --- this may not be required for Value Sets
790: ---
800: debug(7, l_proc_name||'Finish config language');
801:
802: EXCEPTION
803: --- bug 12755038 , if parallel session is trying to insert the same
804: --- record into EGO_PUB_WS_CONFIG, consume the exception , unique
805: --- index added to prevent duplicates from getting inerted which would subsequently fail
806: --- when the rows were queried later.
807: WHEN DUP_VAL_ON_INDEX then
808: NULL;
999: WHEN l_mode = 'BATCH' THEN
1000:
1001: SELECT numeric_value
1002: INTO l_batch_id
1003: FROM EGO_PUB_WS_CONFIG
1004: WHERE PARAMETER_NAME = 'BATCH_ID'
1005: AND session_id = p_session_id;
1006:
1007: --retrieving all value sets batch from publication framework entity tables
1197: ---
1198: ---
1199: SELECT COUNT(1)
1200: INTO l_param_count
1201: FROM EGO_PUB_WS_CONFIG
1202: WHERE SESSION_ID = p_session_id
1203: AND PARAMETER_NAME NOT IN('ODI_SESSION_ID', 'SYSTEM_CODE', 'MODE', 'BATCH_ID');
1204:
1205: