[Home] [Help]
839: END Validate_Language_Info;
840:
841:
842: --Inserts the list of parameters contained in raw XML pointed by XPATH
843: --expression into table EGO_PUB_WS_CONFIG
844: PROCEDURE Insert_ODI_Parameter_List(p_session_id IN NUMBER,
845: p_xml_node_xpath VARCHAR2,
846: p_parameter_name VARCHAR2,
847: p_web_service_name VARCHAR2 DEFAULT NULL)
879: FOR r in c_xml_node_value_list(p_session_id,
880: p_xml_node_xpath,
881: l_node_name) LOOP
882:
883: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
884: odi_session_id,
885: Parameter_Name,
886: Data_Type,
887: Char_value,
1022:
1023: --retrieving invokation mode
1024: select char_value
1025: into l_mode
1026: from EGO_PUB_WS_CONFIG
1027: where parameter_name = 'MODE'
1028: and web_service_name = 'GET_ITEM_STRUCTURE'
1029: and session_id = p_session_id;
1030:
1065:
1066: --reading fnd user name
1067: select char_value
1068: into l_user_name
1069: from EGO_PUB_WS_CONFIG
1070: where session_id = p_session_id
1071: and web_service_name = 'GET_ITEM_STRUCTURE'
1072: and parameter_name = 'FND_USER_NAME';
1073:
1079:
1080: --reading responsibility name
1081: select char_value
1082: into l_responsibility_name
1083: from EGO_PUB_WS_CONFIG
1084: where session_id = p_session_id
1085: and web_service_name = 'GET_ITEM_STRUCTURE'
1086: and parameter_name = 'RESPONSIBILITY_NAME';
1087:
1097:
1098: --reading responsibility application name
1099: select char_value
1100: into l_responsibility_appl_name
1101: from EGO_PUB_WS_CONFIG
1102: where session_id = p_session_id
1103: and web_service_name = 'GET_ITEM_STRUCTURE'
1104: and parameter_name = 'RESPONSIBILITY_APPL_NAME';
1105:
1115:
1116: --reading security group name
1117: select char_value
1118: into l_security_group_name
1119: from EGO_PUB_WS_CONFIG
1120: where session_id = p_session_id
1121: and web_service_name = 'GET_ITEM_STRUCTURE'
1122: and parameter_name = 'SECURITY_GROUP_NAME';
1123:
1343:
1344: --retrieving invokation mode
1345: select char_value
1346: into l_mode
1347: from EGO_PUB_WS_CONFIG
1348: where parameter_name = 'MODE'
1349: and session_id = p_session_id;
1350:
1351: IF (l_mode = 'BATCH') THEN
1358:
1359: --retrieving batch_id
1360: --select Numeric_Value
1361: --into l_batch_id
1362: --from EGO_PUB_WS_CONFIG
1363: --where parameter_name = 'BATCH_ID'
1364: --and session_id = p_session_id;
1365:
1366: --selecting entity_object_id with respect to
1738:
1739: --FIRST CHECK FOR SUBROUTINE MODE
1740: select count(*)
1741: into l_exists
1742: from EGO_PUB_WS_CONFIG
1743: where session_id = p_session_id
1744: and web_service_name = 'GET_ITEM_STRUCTURE'
1745: and parameter_name = 'MODE'
1746: and char_value = 'SUBROUTINE';
1850: END Invocation_Mode_Structure;
1851:
1852:
1853:
1854: --Inserts language options in EGO_PUB_WS_CONFIG table
1855: PROCEDURE Config_Languages(p_session_id IN NUMBER,
1856: p_odi_session_id IN NUMBER,
1857: p_lang_search_str IN VARCHAR2,
1858: p_web_service_name VARCHAR2 DEFAULT NULL)
1958: FOR i IN 1..l_count
1959: LOOP
1960:
1961: IF l_lang_code_tab(i) IS NOT NULL THEN
1962: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1963: odi_session_id,
1964: Parameter_Name,
1965: Data_Type,
1966: Date_Value,
1984:
1985: ELSE
1986:
1987: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
1988: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1989: odi_session_id,
1990: Parameter_Name,
1991: Data_Type,
1992: Date_Value,
2012:
2013: END Config_Languages;
2014:
2015:
2016: --Inserts language options in EGO_PUB_WS_CONFIG table
2017: PROCEDURE Config_UDAs(p_session_id IN NUMBER,
2018: p_odi_session_id IN NUMBER,
2019: p_parameter_name IN VARCHAR2,
2020: p_uda_search_str IN VARCHAR2,
2105: IF l_valid_ag = TRUE THEN
2106:
2107: --Dbms_Output.put_line('Inserting');
2108: --insert attribute name in configuration table
2109: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2110: odi_session_id,
2111: Parameter_Name,
2112: Data_Type,
2113: Date_Value,
2171: IF l_valid_ag = TRUE THEN
2172:
2173: --Dbms_Output.put_line('Inserting');
2174: --insert attribute name in configuration table
2175: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2176: odi_session_id,
2177: Parameter_Name,
2178: Data_Type,
2179: Date_Value,
2216:
2217:
2218:
2219: --creates all configurability parameters and stores them in table
2220: --EGO_PUB_WS_CONFIG
2221: PROCEDURE Create_Params_Structure(p_session_id IN NUMBER,
2222: p_odi_session_id IN NUMBER)
2223: IS
2224:
2252: --determine invokation mode for getItemStructure web service
2253: --and insert in parametes table
2254: l_mode := Invocation_Mode_Structure(p_session_id);
2255:
2256: --if mode is SUBROUTINE, all parameters in table EGO_PUB_WS_CONFIG
2257: --have already been created by invoking ODI Scenario, so quit
2258: --procedure
2259: IF l_mode = 'SUBROUTINE' THEN
2260: RETURN;
2265: values (p_session_id, 'invokation mode:' || l_mode);
2266: */
2267:
2268: --inserting invokation mode as config parameter
2269: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2270: odi_session_id,
2271: Parameter_Name,
2272: Data_Type,
2273: Char_value,
2286:
2287: /*TODO: See if this is required for chunking to work
2288: IF (l_retpayload='Y')
2289: THEN
2290: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2291: VALUES (p_session_id,p_session_id,'return_payload',2,NULL,'TRUE',NULL,SYSDATE,G_CURRENT_USER_ID);
2292: ELSE
2293: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2294: VALUES (p_session_id,p_session_id,'return_payload',2,NULL,'FALSE',NULL,SYSDATE,G_CURRENT_USER_ID);
2289: THEN
2290: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2291: VALUES (p_session_id,p_session_id,'return_payload',2,NULL,'TRUE',NULL,SYSDATE,G_CURRENT_USER_ID);
2292: ELSE
2293: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
2294: VALUES (p_session_id,p_session_id,'return_payload',2,NULL,'FALSE',NULL,SYSDATE,G_CURRENT_USER_ID);
2295: END IF;
2296: --End Chunking
2297: */
2299:
2300:
2301: --
2302: --STEP ONE: RETRIEVE ALL SINGLE-VALUE CONFIGURATION PARAMETERS
2303: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
2304: --
2305:
2306: --initialize arrays of parameter names
2307: l_parameter_name_array := parameter_name_array_type('PUBLISH_REVISIONS',
2384: END CASE;
2385:
2386:
2387: --retrieve all single-value parameters of interest from XML
2388: --and store them in table EGO_PUB_WS_CONFIG
2389: FOR position IN 1..l_parameter_name_array.COUNT
2390: LOOP
2391:
2392: l_config_option := upper(EGO_ODI_PUB.Get_ODI_Input_Parameter(p_session_id, l_xpath_expr_array(position)));
2411: END IF;
2412:
2413: IF l_config_option IS NOT NULL AND l_config_option <> '?' THEN
2414:
2415: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2416: odi_session_id,
2417: Parameter_Name,
2418: Data_Type,
2419: Char_value,
2448: into l_fnd_user_name
2449: from EGO_PUB_WS_PARAMS
2450: where session_id = p_session_id;
2451:
2452: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2453: odi_session_id,
2454: Parameter_Name,
2455: Data_Type,
2456: Char_value,
2471: into l_responsibility_name
2472: from EGO_PUB_WS_PARAMS
2473: where session_id = p_session_id;
2474:
2475: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2476: odi_session_id,
2477: Parameter_Name,
2478: Data_Type,
2479: Char_value,
2495: into l_responsibility_appl_name
2496: from EGO_PUB_WS_PARAMS
2497: where session_id = p_session_id;
2498:
2499: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2500: odi_session_id,
2501: Parameter_Name,
2502: Data_Type,
2503: Char_value,
2519: into l_security_group_name
2520: from EGO_PUB_WS_PARAMS
2521: where session_id = p_session_id;
2522:
2523: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2524: odi_session_id,
2525: Parameter_Name,
2526: Data_Type,
2527: Char_value,
2561: from fnd_user
2562: where user_id = l_user_id;
2563:
2564: --inserting user name
2565: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2566: odi_session_id,
2567: Parameter_Name,
2568: Data_Type,
2569: Char_value,
2585: from FND_RESPONSIBILITY
2586: where responsibility_id = l_responsibility_id;
2587:
2588: --inserting responsibility name
2589: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2590: odi_session_id,
2591: Parameter_Name,
2592: Data_Type,
2593: Char_value,
2615: from FND_APPLICATION
2616: where application_id = l_application_id;
2617:
2618: --inserting responsibility_appl_name
2619: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2620: odi_session_id,
2621: Parameter_Name,
2622: Data_Type,
2623: Char_value,
2634: 'GET_ITEM_STRUCTURE');
2635:
2636: --inserting security_group_name as NULL
2637: l_security_group_name := NULL;
2638: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
2639: odi_session_id,
2640: Parameter_Name,
2641: Data_Type,
2642: Char_value,
2673: where type_id = l_batch_id
2674: and parameter_name = 'LEVELS_TO_EXPLODE';
2675:
2676: --updating value of config parameter
2677: UPDATE EGO_PUB_WS_CONFIG
2678: SET Char_value = l_config_option
2679: where Parameter_Name = 'LEVELS_TO_EXPLODE'
2680: and web_service_name = 'GET_ITEM_STRUCTURE'
2681: and session_id = p_session_id
2688: where type_id = l_batch_id
2689: and parameter_name = 'EXPLODE_STD_BOM';
2690:
2691: --updating value of config parameter
2692: UPDATE EGO_PUB_WS_CONFIG
2693: SET Char_value = l_config_option
2694: where Parameter_Name = 'EXPLODE_STD_BOM'
2695: and web_service_name = 'GET_ITEM_STRUCTURE'
2696: and session_id = p_session_id
2708:
2709: IF l_config_option = '0' THEN
2710: --forcing explosion type to be CURRENT (2)
2711: l_config_option := '2';
2712: UPDATE EGO_PUB_WS_CONFIG
2713: SET Char_value = l_config_option
2714: where Parameter_Name = 'EXPLODE_OPTION'
2715: and web_service_name = 'GET_ITEM_STRUCTURE'
2716: and session_id = p_session_id
2723: where type_id = l_batch_id
2724: and parameter_name = 'EXPLODE_OPTION';
2725:
2726: --updating EXPLOSION_OPTION
2727: UPDATE EGO_PUB_WS_CONFIG
2728: SET Char_value = l_config_option
2729: where Parameter_Name = 'EXPLODE_OPTION'
2730: and web_service_name = 'GET_ITEM_STRUCTURE'
2731: and session_id = p_session_id
2739: END IF;
2740:
2741: --
2742: --STEP TWO: RETRIEVE ALL MULTI-VALUE CONFIGURATION PARAMETERS
2743: -- AND STORE THEM IN TABLE EGO_PUB_WS_CONFIG
2744: --
2745:
2746:
2747: --RETRIEVING LIST OF LANGUAGES
2913:
2914: --Cursor to retrieve list of end-items for SUBROUTINE mode
2915: CURSOR c_subroutine_end_items(p_session_id NUMBER) IS
2916: SELECT CHAR_VALUE
2917: from EGO_PUB_WS_CONFIG
2918: where session_id = p_session_id
2919: and web_service_name = 'GET_ITEM_STRUCTURE'
2920: and parameter_name = 'ITEM_INFORMATION';
2921:
2924:
2925: --identify getItemStructure web service invocation mode
2926: select char_value
2927: into l_mode
2928: from EGO_PUB_WS_CONFIG
2929: where session_id = p_session_id
2930: and web_service_name = 'GET_ITEM_STRUCTURE'
2931: and parameter_name = 'MODE';
2932:
2932:
2933: --populate odi input table depending on mode from different data sources
2934: CASE
2935:
2936: --if mode is SUBROUTINE, get item information from EGO_PUB_WS_CONFIG table
2937: WHEN l_mode = 'SUBROUTINE' THEN
2938:
2939: /*extract list of inventory item ids */
2940: SELECT to_number(char_value)
2938:
2939: /*extract list of inventory item ids */
2940: SELECT to_number(char_value)
2941: BULK COLLECT INTO l_item_id_tab
2942: from EGO_PUB_WS_CONFIG
2943: where session_id = p_session_id
2944: and web_service_name = 'GET_ITEM_STRUCTURE'
2945: and parameter_name like 'INVENTORY_ITEM_ID_%'
2946: order by parameter_name;
2947:
2948: /*extract list of organization ids */
2949: SELECT to_number(char_value)
2950: BULK COLLECT INTO l_org_id_tab
2951: from EGO_PUB_WS_CONFIG
2952: where session_id = p_session_id
2953: and web_service_name = 'GET_ITEM_STRUCTURE'
2954: and parameter_name like 'ORGANIZATION_ID_%'
2955: order by parameter_name;
2956:
2957: /*extract list of revision ids */
2958: SELECT to_number(char_value)
2959: BULK COLLECT INTO l_rev_id_tab
2960: from EGO_PUB_WS_CONFIG
2961: where session_id = p_session_id
2962: and web_service_name = 'GET_ITEM_STRUCTURE'
2963: and parameter_name like 'REVISION_ID_%'
2964: order by parameter_name;
2965:
2966: /*extract list of structure names */
2967: SELECT char_value
2968: BULK COLLECT INTO l_structure_name_tab
2969: from EGO_PUB_WS_CONFIG
2970: where session_id = p_session_id
2971: and web_service_name = 'GET_ITEM_STRUCTURE'
2972: and parameter_name like 'STRUCTURE_NAME_%'
2973: order by parameter_name;
2974:
2975: /*extract list of root node ids */
2976: SELECT to_number(char_value)
2977: BULK COLLECT INTO l_root_node_id_tab
2978: from EGO_PUB_WS_CONFIG
2979: where session_id = p_session_id
2980: and web_service_name = 'GET_ITEM_STRUCTURE'
2981: and parameter_name like 'ROOT_NODE_ID_%'
2982: order by parameter_name;
4400: 1. Finds all the first level components of the ICC-Structure that have been
4401: previously retrieved by the EGO_GETICCSTRUCTURE ODI Package
4402: 2. loops through the first level components and identifies which ones
4403: are of type OPTION_CLASS
4404: 3. ODI_SESSION_ID un table EGO_PUB_WS_CONFIG (that contains parameters to
4405: execute ODI scenario as subroutine) is set to -1 to avoid conflicts
4406: with ODI main scenario invoking ODI scenario as subroutine while
4407: reading input parameters.
4408: */
4497: --Generating concatenated string containing information for which the structure will be published
4498: --FORMAT: INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION_ID, STRUCTURE_TYPE, STRUCTURE_NAME
4499: --l_item_information := comp_rec.ref2_value || ',' || comp_rec.ref3_value || ',' || comp_rec.ref4_value || ',' || comp_rec.ref5_value || ',' || comp_rec.ref6_value;
4500:
4501: --INSERT NEW PARAMETER INVENTORY_ITEM_ID IN EGO_PUB_WS_CONFIG
4502: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4503: odi_session_id,
4504: Parameter_Name,
4505: Data_Type,
4498: --FORMAT: INVENTORY_ITEM_ID, ORGANIZATION_ID, REVISION_ID, STRUCTURE_TYPE, STRUCTURE_NAME
4499: --l_item_information := comp_rec.ref2_value || ',' || comp_rec.ref3_value || ',' || comp_rec.ref4_value || ',' || comp_rec.ref5_value || ',' || comp_rec.ref6_value;
4500:
4501: --INSERT NEW PARAMETER INVENTORY_ITEM_ID IN EGO_PUB_WS_CONFIG
4502: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4503: odi_session_id,
4504: Parameter_Name,
4505: Data_Type,
4506: Char_value,
4515: sysdate,
4516: 0,
4517: 'GET_ITEM_STRUCTURE');
4518:
4519: --INSERT NEW PARAMETER ORGANIZATION_ID IN EGO_PUB_WS_CONFIG
4520: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4521: odi_session_id,
4522: Parameter_Name,
4523: Data_Type,
4516: 0,
4517: 'GET_ITEM_STRUCTURE');
4518:
4519: --INSERT NEW PARAMETER ORGANIZATION_ID IN EGO_PUB_WS_CONFIG
4520: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4521: odi_session_id,
4522: Parameter_Name,
4523: Data_Type,
4524: Char_value,
4533: sysdate,
4534: 0,
4535: 'GET_ITEM_STRUCTURE');
4536:
4537: --INSERT NEW PARAMETER REVISION_ID IN EGO_PUB_WS_CONFIG
4538: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4539: odi_session_id,
4540: Parameter_Name,
4541: Data_Type,
4534: 0,
4535: 'GET_ITEM_STRUCTURE');
4536:
4537: --INSERT NEW PARAMETER REVISION_ID IN EGO_PUB_WS_CONFIG
4538: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4539: odi_session_id,
4540: Parameter_Name,
4541: Data_Type,
4542: Char_value,
4551: sysdate,
4552: 0,
4553: 'GET_ITEM_STRUCTURE');
4554:
4555: --INSERT NEW PARAMETER STRUCTURE_NAME IN EGO_PUB_WS_CONFIG
4556: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4557: odi_session_id,
4558: Parameter_Name,
4559: Data_Type,
4552: 0,
4553: 'GET_ITEM_STRUCTURE');
4554:
4555: --INSERT NEW PARAMETER STRUCTURE_NAME IN EGO_PUB_WS_CONFIG
4556: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4557: odi_session_id,
4558: Parameter_Name,
4559: Data_Type,
4560: Char_value,
4570: 0,
4571: 'GET_ITEM_STRUCTURE');
4572:
4573:
4574: --INSERT NEW PARAMETER ROOT_NODE_ID IN EGO_PUB_WS_CONFIG
4575: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4576: odi_session_id,
4577: Parameter_Name,
4578: Data_Type,
4571: 'GET_ITEM_STRUCTURE');
4572:
4573:
4574: --INSERT NEW PARAMETER ROOT_NODE_ID IN EGO_PUB_WS_CONFIG
4575: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4576: odi_session_id,
4577: Parameter_Name,
4578: Data_Type,
4579: Char_value,
4640:
4641: FOR position IN 1..l_parameter_name_array.COUNT
4642: LOOP
4643:
4644: --INSERTING PARAMETER NAME AND VALUE IN EGO_PUB_WS_CONFIG
4645: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4646: odi_session_id,
4647: Parameter_Name,
4648: Data_Type,
4641: FOR position IN 1..l_parameter_name_array.COUNT
4642: LOOP
4643:
4644: --INSERTING PARAMETER NAME AND VALUE IN EGO_PUB_WS_CONFIG
4645: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4646: odi_session_id,
4647: Parameter_Name,
4648: Data_Type,
4649: Char_value,
4666: into l_fnd_user_name
4667: from EGO_PUB_WS_PARAMS
4668: where session_id = p_session_id;
4669:
4670: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4671: odi_session_id,
4672: Parameter_Name,
4673: Data_Type,
4674: Char_value,
4689: into l_responsibility_name
4690: from EGO_PUB_WS_PARAMS
4691: where session_id = p_session_id;
4692:
4693: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4694: odi_session_id,
4695: Parameter_Name,
4696: Data_Type,
4697: Char_value,
4713: into l_responsibility_appl_name
4714: from EGO_PUB_WS_PARAMS
4715: where session_id = p_session_id;
4716:
4717: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4718: odi_session_id,
4719: Parameter_Name,
4720: Data_Type,
4721: Char_value,
4737: into l_security_group_name
4738: from EGO_PUB_WS_PARAMS
4739: where session_id = p_session_id;
4740:
4741: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4742: odi_session_id,
4743: Parameter_Name,
4744: Data_Type,
4745: Char_value,
4861: --READ CONFIGURABILITY OPTIONS FOR BOM EXPLOSION
4862: --reading levels to explode
4863: select to_number(char_value)
4864: into l_levels_to_explode
4865: from EGO_PUB_WS_CONFIG
4866: where session_id = p_session_id
4867: and web_service_name = 'GET_ITEM_STRUCTURE'
4868: and parameter_name = 'LEVELS_TO_EXPLODE';
4869:
4875:
4876: --reading explode_option
4877: select to_number(char_value)
4878: into l_explode_option
4879: from EGO_PUB_WS_CONFIG
4880: where session_id = p_session_id
4881: and web_service_name = 'GET_ITEM_STRUCTURE'
4882: and parameter_name = 'EXPLODE_OPTION';
4883:
4883:
4884: --reading EXPLODE_STD_BOM
4885: select char_value
4886: into l_explode_standard
4887: from EGO_PUB_WS_CONFIG
4888: where session_id = p_session_id
4889: and web_service_name = 'GET_ITEM_STRUCTURE'
4890: and parameter_name = 'EXPLODE_STD_BOM';
4891:
5255: CURSOR Cur_config_param(cp_session_id NUMBER,
5256: cp_odi_session_id NUMBER)
5257: IS
5258: SELECT Upper(Nvl(CHAR_VALUE,'TRUE')) param_value
5259: FROM ego_pub_ws_config
5260: WHERE session_id = cp_session_id
5261: AND odi_session_id = cp_odi_session_id
5262: AND upper(parameter_name) = 'RETURN_PAYLOAD';
5263:
5989: IF l_lang_code_tab.Count> 0 THEN
5990:
5991: FOR i IN 1..l_lang_code_tab.Count
5992: LOOP
5993: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by, web_service_name)
5994: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID, p_webservice_name);
5995: END LOOP;
5996: ELSE
5997: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
5994: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID, p_webservice_name);
5995: END LOOP;
5996: ELSE
5997: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
5998: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by, web_service_name)
5999: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,i.language_code,NULL,SYSDATE,G_CURRENT_USER_ID, p_webservice_name);
6000: END LOOP;
6001: END IF;
6002:
6018: l_retpayload:='TRUE';
6019: END;
6020:
6021:
6022: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6023: VALUES (p_session_id,p_odi_session_id,'return_payload',2,NULL,Upper(l_retpayload),NULL,SYSDATE,G_CURRENT_USER_ID);
6024:
6025:
6026:
6037: WHERE session_id=p_session_id
6038: );
6039:
6040:
6041: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6042: VALUES (p_session_id,p_odi_session_id,'PublishUDA',2,NULL,Upper(l_UserDefAttrGrps),NULL,SYSDATE,G_CURRENT_USER_ID);
6043:
6044:
6045:
6054: WHERE session_id=p_session_id
6055: );
6056:
6057:
6058: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6059: VALUES (p_session_id,p_odi_session_id,'PublishICCVersions',2,NULL,Upper(l_iccvers_config),NULL,SYSDATE,G_CURRENT_USER_ID);
6060:
6061:
6062:
6070: WHERE session_id=p_session_id
6071: );
6072:
6073:
6074: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6075: VALUES (p_session_id,p_odi_session_id,'PublishTransAttrs',2,NULL,Upper(l_transattrs_config),NULL,SYSDATE,G_CURRENT_USER_ID);
6076:
6077:
6078: /*extract configurable parameter ICCStructure and insert record into config table */
6085: WHERE session_id=p_session_id
6086: );
6087:
6088:
6089: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6090: VALUES (p_session_id,p_odi_session_id,'PublishICCStructure',2,NULL,Upper(l_structure_config),NULL,SYSDATE,G_CURRENT_USER_ID);
6091:
6092:
6093:
6093:
6094:
6095:
6096: /*Insert record into config table for parameter parent and child hierarchy*/
6097: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6098: VALUES (p_session_id,p_odi_session_id,'PublishParentICCs',2,NULL,Upper(p_parent_hier),NULL,SYSDATE,G_CURRENT_USER_ID);
6099:
6100:
6101: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6097: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6098: VALUES (p_session_id,p_odi_session_id,'PublishParentICCs',2,NULL,Upper(p_parent_hier),NULL,SYSDATE,G_CURRENT_USER_ID);
6099:
6100:
6101: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,odi_session_id,Parameter_Name,Data_Type,Date_Value,Char_value,Numeric_Value,creation_date,created_by)
6102: VALUES (p_session_id,p_odi_session_id,'PublishChildICCs',2,NULL,Upper(p_child_hier),NULL,SYSDATE,G_CURRENT_USER_ID);
6103:
6104:
6105: END IF;