eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_ITEM_WS_PVT dependencies on EGO_PUB_WS_CONFIG

Line 84: from EGO_PUB_WS_CONFIG

80:
81: BEGIN
82:
83: select char_value INTO v_publish_udas
84: from EGO_PUB_WS_CONFIG
85: where session_id = sessionId
86: and PARAMETER_NAME = 'PUBLISH_UDA_GROUPS';
87:
88: IF ( v_publish_udas = 'Y')

Line 92: FROM EGO_PUB_WS_CONFIG

88: IF ( v_publish_udas = 'Y')
89: THEN
90:
91: SELECT Count(*) INTO v_count
92: FROM EGO_PUB_WS_CONFIG
93: WHERE SESSION_ID = sessionId
94: AND PARAMETER_NAME = 'PUBLISH_AG_NAME';
95:
96: -- Bug 12770968 : Start

Line 398: ' AG.ATTR_GROUP_NAME IN (SELECT char_value FROM EGO_PUB_WS_CONFIG '||

394:
395: -- Performance Changes : Start
396: IF (v_count <> 0) THEN
397: v_query_string_b := v_query_string_b || ' AND '||
398: ' AG.ATTR_GROUP_NAME IN (SELECT char_value FROM EGO_PUB_WS_CONFIG '||
399: ' WHERE session_id = '||sessionId||
400: ' and PARAMETER_NAME = ''PUBLISH_AG_NAME'' ) ';
401: END IF;
402: -- Performance Changes : End

Line 408: ' AG.ATTR_GROUP_NAME IN (SELECT char_value FROM EGO_PUB_WS_CONFIG '||

404: -- Bug 11738301 : Start
405: IF (datalevelId <> 43106) THEN
406: IF (v_count <> 0) THEN
407: v_query_string_Inherit_b := v_query_string_Inherit_b || ' AND '||
408: ' AG.ATTR_GROUP_NAME IN (SELECT char_value FROM EGO_PUB_WS_CONFIG '||
409: ' WHERE session_id = '||sessionId||
410: ' and PARAMETER_NAME = ''PUBLISH_AG_NAME'' ) ';
411: END IF;
412:

Line 1215: ) list , EGO_PUB_WS_FLAT_RECS flat , EGO_PUB_WS_CONFIG CONFIG

1211: ATTRIBUTE_TRANSLATABLE_VALUE as TRANSLATED_CHAR_VALUE,
1212: REVISION_ID,
1213: LANGUAGE
1214: FROM ego_all_attr_lang_v ealv
1215: ) list , EGO_PUB_WS_FLAT_RECS flat , EGO_PUB_WS_CONFIG CONFIG
1216: WHERE list.ATTRIBUTEGROUP_ID = FLAT.REF1_VALUE
1217: AND list.EXTENSION_ID = FLAT.REF2_VALUE
1218: AND list.INVENTORY_ITEM_ID = FLAT.PK1_VALUE
1219: AND list.ORGANIZATION_ID = Decode(dataLevelId , 43101, flat.REF4_VALUE,

Line 1289: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG , EGO_PUB_WS_CONFIG CONFIG

1285: 'TL_EXT_ATTR39', UDA.TL_EXT_ATTR39, 'TL_EXT_ATTR40', UDA.TL_EXT_ATTR40 )
1286: ) AS ATTRIBUTE_TRANSLATABLE_VALUE
1287:
1288: FROM EGO_MTL_SY_ITEMS_EXT_TL UDA , EGO_PUB_WS_FLAT_RECS flat ,
1289: EGO_ATTRS_V AGC, EGO_ATTR_GROUPS_V AG , EGO_PUB_WS_CONFIG CONFIG
1290:
1291: WHERE UDA.ATTR_GROUP_ID = AG.ATTR_GROUP_ID
1292: AND AGC.APPLICATION_ID = AG.APPLICATION_ID
1293: AND AGC.ATTR_GROUP_TYPE = AG.ATTR_GROUP_TYPE

Line 1418: FROM MTL_CROSS_REFERENCES_TL mcrt, EGO_PUB_WS_CONFIG config, EGO_PUB_WS_FLAT_RECS flat

1414: config.char_value AS "Language" ,
1415: mcrt.DESCRIPTION AS "GTINDescription"
1416: ).getclobval() ,
1417: SYSDATE
1418: FROM MTL_CROSS_REFERENCES_TL mcrt, EGO_PUB_WS_CONFIG config, EGO_PUB_WS_FLAT_RECS flat
1419: WHERE config.SESSION_ID = flat.SESSION_ID
1420: AND config.PARAMETER_NAME = 'LANGUAGE_CODE'
1421: AND config.CHAR_VALUE = mcrt.LANGUAGE
1422: AND flat.ENTITY_TYPE = 'GTIN_CROSS_REFERENCE'

Line 1570: FROM EGO_PUB_WS_CONFIG

1566: IF (l_item_catalog_group_id IS NOT NULL AND l_version_seq_id IS NOT NULL)
1567: THEN
1568: SELECT Count(*)
1569: INTO l_ta_entered_count
1570: FROM EGO_PUB_WS_CONFIG
1571: WHERE PARAMETER_NAME = 'PUBLISH_TA_ID'
1572: AND SESSION_ID = sessionId;
1573:
1574: FOR k IN Cur_TA_List(l_item_catalog_group_id, l_version_seq_id, l_item_create_date,l_item_start_date)

Line 1578: FROM EGO_PUB_WS_CONFIG

1574: FOR k IN Cur_TA_List(l_item_catalog_group_id, l_version_seq_id, l_item_create_date,l_item_start_date)
1575: LOOP
1576: SELECT Count(*)
1577: INTO l_ta_count
1578: FROM EGO_PUB_WS_CONFIG
1579: WHERE PARAMETER_NAME = 'PUBLISH_TA_ID'
1580: AND SESSION_ID = sessionId
1581: AND NUMERIC_VALUE = k.attr_id;
1582:

Line 1981: 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)

1977:
1978: /* Call API to find invocation mode and batch_id, Batch_Id will be -1 if mode is HMDM or LIST*/
1979: Invocation_Mode( p_session_id,p_odi_session_id,'/itemQueryParameters/BatchId',l_mode,l_batch_id);
1980:
1981: 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)
1982: VALUES (p_session_id,p_odi_session_id,'INVOCATION_MODE',2,NULL,l_mode,NULL,SYSDATE,G_CURRENT_USER_ID);
1983:
1984: IF l_batch_id > -1 THEN
1985:

Line 1986: 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)

1982: VALUES (p_session_id,p_odi_session_id,'INVOCATION_MODE',2,NULL,l_mode,NULL,SYSDATE,G_CURRENT_USER_ID);
1983:
1984: IF l_batch_id > -1 THEN
1985:
1986: 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)
1987: VALUES (p_session_id,p_odi_session_id,'BATCH_ID',2,NULL,NULL,l_batch_id,SYSDATE,G_CURRENT_USER_ID);
1988:
1989: SELECT pk1_value , pk2_value ,pk3_value
1990: BULK COLLECT INTO l_item_id_tab, l_org_id_tab, l_rev_id_tab

Line 2402: 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)

2398: FROM EGO_PUB_WS_PARAMS
2399: WHERE session_id = p_session_id;
2400:
2401: IF (l_node_exists = 0) THEN
2402: 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)
2403: VALUES (p_session_id,p_odi_session_id,'return_payload',2,NULL,'TRUE',NULL,SYSDATE,G_CURRENT_USER_ID);
2404: ELSE
2405: SELECT Upper(Nvl(extractValue(ret_pay, '/ReturnPayload'),'Y'))
2406: INTO l_retpayload

Line 2416: 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)

2412: );
2413:
2414: --Insert record for configurable parameter 'ReturnPayload'
2415: If (Upper(l_retpayload)='Y' ) then
2416: 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)
2417: VALUES (p_session_id,p_odi_session_id,'return_payload',2,NULL,'TRUE',NULL,SYSDATE,G_CURRENT_USER_ID);
2418: else
2419: 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)
2420: VALUES (p_session_id,p_odi_session_id,'return_payload',2,NULL,'FALSE',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2419: 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)

2415: If (Upper(l_retpayload)='Y' ) then
2416: 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)
2417: VALUES (p_session_id,p_odi_session_id,'return_payload',2,NULL,'TRUE',NULL,SYSDATE,G_CURRENT_USER_ID);
2418: else
2419: 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)
2420: VALUES (p_session_id,p_odi_session_id,'return_payload',2,NULL,'FALSE',NULL,SYSDATE,G_CURRENT_USER_ID);
2421: end if;
2422: END IF;
2423: /* End of Code added for Chunking */

Line 2450: 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)

2446: BEGIN
2447: SELECT language_code INTO l_lang_code_tab(i)
2448: FROM FND_LANGUAGES WHERE NLS_LANGUAGE = l_lang_name_tab(i);
2449:
2450: 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)
2451: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID);
2452: EXCEPTION
2453: WHEN No_Data_Found THEN
2454:

Line 2478: 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)

2474: BEGIN
2475: SELECT language_code INTO l_lang_code_tab(i)
2476: FROM FND_LANGUAGES WHERE language_code = l_lang_code_tab(i);
2477:
2478: 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)
2479: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,l_lang_code_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID);
2480: EXCEPTION
2481: WHEN NO_DATA_FOUND THEN
2482: SELECT Nvl(Max(INPUT_ID),0) + 1 into p_index

Line 2504: 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)

2500: END LOOP;
2501:
2502: IF (l_lang_count = l_lang_code_tab.Count) THEN
2503: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
2504: 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)
2505: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,i.language_code,NULL,SYSDATE,G_CURRENT_USER_ID);
2506: END LOOP;
2507: END IF;
2508: -- Bug 12749057 : Start : When user doens't provide any labguage details.

Line 2511: 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)

2507: END IF;
2508: -- Bug 12749057 : Start : When user doens't provide any labguage details.
2509: ELSE
2510: FOR i IN (SELECT language_code FROM FND_LANGUAGES WHERE INSTALLED_FLAG IN ('I','B') ) LOOP
2511: 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)
2512: VALUES (p_session_id,p_odi_session_id,'LANGUAGE_CODE',2,NULL,i.language_code,NULL,SYSDATE,G_CURRENT_USER_ID);
2513: END LOOP;
2514: -- Bug 12749057 : End
2515: END IF;

Line 2534: 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)

2530: );
2531:
2532: -- Need to validate the values entered by user and throw error for wrong values. ???????????
2533:
2534: 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)
2535: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OP_ATTR_GROUPS',2,NULL,Upper(L_PUBLISH_OP_ATTR_GROUPS),NULL,SYSDATE,G_CURRENT_USER_ID);
2536: ELSE
2537: 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)
2538: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OP_ATTR_GROUPS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2537: 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)

2533:
2534: 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)
2535: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OP_ATTR_GROUPS',2,NULL,Upper(L_PUBLISH_OP_ATTR_GROUPS),NULL,SYSDATE,G_CURRENT_USER_ID);
2536: ELSE
2537: 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)
2538: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OP_ATTR_GROUPS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2539: END IF; -- (l_node_exists = 1) for Operational Ags
2540:
2541: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups')

Line 2548: 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)

2544: WHERE session_id = p_session_id;
2545:
2546: IF (l_node_exists = 0) THEN
2547: -- insert 'Y' for all the operational attributes groups
2548: 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)
2549: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ITEM_CATALOG',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2550:
2551: 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)
2552: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INV_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2551: 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)

2547: -- insert 'Y' for all the operational attributes groups
2548: 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)
2549: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ITEM_CATALOG',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2550:
2551: 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)
2552: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INV_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2553:
2554: 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)
2555: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PHY_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2554: 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)

2550:
2551: 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)
2552: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INV_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2553:
2554: 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)
2555: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PHY_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2556:
2557: 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)
2558: VALUES (p_session_id,p_odi_session_id,'PUBLISH_BOM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2557: 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)

2553:
2554: 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)
2555: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PHY_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2556:
2557: 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)
2558: VALUES (p_session_id,p_odi_session_id,'PUBLISH_BOM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2559:
2560: 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)
2561: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WIP_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2560: 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)

2556:
2557: 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)
2558: VALUES (p_session_id,p_odi_session_id,'PUBLISH_BOM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2559:
2560: 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)
2561: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WIP_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2562:
2563: 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)
2564: VALUES (p_session_id,p_odi_session_id,'PUBLISH_COST_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2563: 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)

2559:
2560: 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)
2561: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WIP_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2562:
2563: 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)
2564: VALUES (p_session_id,p_odi_session_id,'PUBLISH_COST_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2565:
2566: 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)
2567: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2566: 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)

2562:
2563: 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)
2564: VALUES (p_session_id,p_odi_session_id,'PUBLISH_COST_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2565:
2566: 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)
2567: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2568:
2569: 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)
2570: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLAN_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2569: 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)

2565:
2566: 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)
2567: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2568:
2569: 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)
2570: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLAN_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2571:
2572: 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)
2573: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PURCHASE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2572: 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)

2568:
2569: 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)
2570: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLAN_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2571:
2572: 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)
2573: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PURCHASE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2574:
2575: 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)
2576: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2575: 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)

2571:
2572: 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)
2573: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PURCHASE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2574:
2575: 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)
2576: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2577:
2578: 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)
2579: VALUES (p_session_id,p_odi_session_id,'PUBLISH_RECEIVE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2578: 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)

2574:
2575: 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)
2576: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2577:
2578: 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)
2579: VALUES (p_session_id,p_odi_session_id,'PUBLISH_RECEIVE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2580:
2581: 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)
2582: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INVOICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2581: 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)

2577:
2578: 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)
2579: VALUES (p_session_id,p_odi_session_id,'PUBLISH_RECEIVE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2580:
2581: 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)
2582: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INVOICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2583:
2584: 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)
2585: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WEBOPT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2584: 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)

2580:
2581: 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)
2582: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INVOICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2583:
2584: 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)
2585: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WEBOPT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2586:
2587: 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)
2588: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SERVICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2587: 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)

2583:
2584: 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)
2585: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WEBOPT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2586:
2587: 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)
2588: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SERVICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2589:
2590: 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)
2591: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ASSET_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2590: 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)

2586:
2587: 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)
2588: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SERVICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2589:
2590: 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)
2591: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ASSET_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2592:
2593: 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)
2594: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PMFG_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);

Line 2593: 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)

2589:
2590: 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)
2591: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ASSET_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2592:
2593: 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)
2594: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PMFG_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2595:
2596: ELSE
2597: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ItemCatalog')

Line 2603: 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)

2599: FROM EGO_PUB_WS_PARAMS
2600: WHERE session_id = p_session_id;
2601:
2602: IF (l_node_exists = 0) THEN
2603: 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)
2604: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ITEM_CATALOG',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2605: ELSE
2606: SELECT Nvl(extractValue(uda_ag, '/ItemCatalog'),'Y')
2607: INTO L_PUBLISH_ITEM_CATALOG

Line 2615: 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)

2611: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ItemCatalog') )) udaag
2612: WHERE session_id=p_session_id
2613: );
2614:
2615: 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)
2616: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ITEM_CATALOG',2,NULL,Upper(L_PUBLISH_ITEM_CATALOG),NULL,SYSDATE,G_CURRENT_USER_ID);
2617: END IF;
2618:
2619: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InventoryCharacteristics')

Line 2625: 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)

2621: FROM EGO_PUB_WS_PARAMS
2622: WHERE session_id = p_session_id;
2623:
2624: IF (l_node_exists = 0) THEN
2625: 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)
2626: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INV_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2627: ELSE
2628: SELECT Nvl(extractValue(uda_ag, '/InventoryCharacteristics'),'Y')
2629: INTO L_PUBLISH_INV_CHARS

Line 2637: 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)

2633: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InventoryCharacteristics') )) udaag
2634: WHERE session_id=p_session_id
2635: );
2636:
2637: 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)
2638: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INV_CHARS',2,NULL,Upper(L_PUBLISH_INV_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2639:
2640: END IF;
2641:

Line 2648: 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)

2644: FROM EGO_PUB_WS_PARAMS
2645: WHERE session_id = p_session_id;
2646:
2647: IF (l_node_exists = 0) THEN
2648: 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)
2649: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PHY_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2650: ELSE
2651: SELECT Nvl(extractValue(uda_ag, '/PhysicalCharacteristics'),'Y')
2652: INTO L_PUBLISH_PHY_CHARS

Line 2660: 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)

2656: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PhysicalCharacteristics') )) udaag
2657: WHERE session_id=p_session_id
2658: );
2659:
2660: 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)
2661: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PHY_CHARS',2,NULL,Upper(L_PUBLISH_PHY_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2662: END IF;
2663:
2664:

Line 2671: 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)

2667: FROM EGO_PUB_WS_PARAMS
2668: WHERE session_id = p_session_id;
2669:
2670: IF (l_node_exists = 0) THEN
2671: 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)
2672: VALUES (p_session_id,p_odi_session_id,'PUBLISH_BOM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2673: ELSE
2674: SELECT Nvl(extractValue(uda_ag, '/BillsOfMaterialCharacteristics'),'Y')
2675: INTO L_PUBLISH_BOM_CHARS

Line 2683: 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)

2679: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/BillsOfMaterialCharacteristics') )) udaag
2680: WHERE session_id=p_session_id
2681: );
2682:
2683: 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)
2684: VALUES (p_session_id,p_odi_session_id,'PUBLISH_BOM_CHARS',2,NULL,Upper(L_PUBLISH_BOM_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2685: END IF;
2686:
2687:

Line 2694: 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)

2690: FROM EGO_PUB_WS_PARAMS
2691: WHERE session_id = p_session_id;
2692:
2693: IF (l_node_exists = 0) THEN
2694: 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)
2695: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WIP_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2696: ELSE
2697: SELECT Nvl(extractValue(uda_ag, '/WorkInProcessCharacteristics'),'Y')
2698: INTO L_PUBLISH_WIP_CHARS

Line 2706: 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)

2702: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/WorkInProcessCharacteristics') )) udaag
2703: WHERE session_id=p_session_id
2704: );
2705:
2706: 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)
2707: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WIP_CHARS',2,NULL,Upper(L_PUBLISH_WIP_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2708: END IF;
2709:
2710: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/CostingCharacteristics')

Line 2716: 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)

2712: FROM EGO_PUB_WS_PARAMS
2713: WHERE session_id = p_session_id;
2714:
2715: IF (l_node_exists = 0) THEN
2716: 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)
2717: VALUES (p_session_id,p_odi_session_id,'PUBLISH_COST_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2718: ELSE
2719: SELECT Nvl(extractValue(uda_ag, '/CostingCharacteristics'),'Y')
2720: INTO L_PUBLISH_COST_CHARS

Line 2728: 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)

2724: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/CostingCharacteristics') )) udaag
2725: WHERE session_id=p_session_id
2726: );
2727:
2728: 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)
2729: VALUES (p_session_id,p_odi_session_id,'PUBLISH_COST_CHARS',2,NULL,Upper(L_PUBLISH_COST_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2730: END IF;
2731:
2732: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessingLeadTimeCharacteristics')

Line 2738: 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)

2734: FROM EGO_PUB_WS_PARAMS
2735: WHERE session_id = p_session_id;
2736:
2737: IF (l_node_exists = 0) THEN
2738: 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)
2739: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2740: ELSE
2741: SELECT Nvl(extractValue(uda_ag, '/ProcessingLeadTimeCharacteristics'),'Y')
2742: INTO L_PUBLISH_PLT_CHARS

Line 2750: 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)

2746: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessingLeadTimeCharacteristics') )) udaag
2747: WHERE session_id=p_session_id
2748: );
2749:
2750: 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)
2751: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLT_CHARS',2,NULL,Upper(L_PUBLISH_PLT_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2752: END IF;
2753:
2754: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PlanningCharacteristics')

Line 2760: 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)

2756: FROM EGO_PUB_WS_PARAMS
2757: WHERE session_id = p_session_id;
2758:
2759: IF (l_node_exists = 0) THEN
2760: 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)
2761: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLAN_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2762: ELSE
2763: SELECT Nvl(extractValue(uda_ag, '/PlanningCharacteristics'),'Y')
2764: INTO L_PUBLISH_PLAN_CHARS

Line 2772: 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)

2768: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PlanningCharacteristics') )) udaag
2769: WHERE session_id=p_session_id
2770: );
2771:
2772: 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)
2773: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PLAN_CHARS',2,NULL,Upper(L_PUBLISH_PLAN_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2774: END IF;
2775:
2776: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PurchasingCharacteristics')

Line 2782: 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)

2778: FROM EGO_PUB_WS_PARAMS
2779: WHERE session_id = p_session_id;
2780:
2781: IF (l_node_exists = 0) THEN
2782: 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)
2783: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PURCHASE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2784: ELSE
2785: SELECT Nvl(extractValue(uda_ag, '/PurchasingCharacteristics'),'Y')
2786: INTO L_PUBLISH_PURCHASE_CHARS

Line 2794: 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)

2790: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/PurchasingCharacteristics') )) udaag
2791: WHERE session_id=p_session_id
2792: );
2793:
2794: 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)
2795: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PURCHASE_CHARS',2,NULL,Upper(L_PUBLISH_PURCHASE_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2796: END IF;
2797:
2798: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/OrderManagementCharacteristics')

Line 2804: 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)

2800: FROM EGO_PUB_WS_PARAMS
2801: WHERE session_id = p_session_id;
2802:
2803: IF (l_node_exists = 0) THEN
2804: 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)
2805: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OM_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2806: ELSE
2807: SELECT Nvl(extractValue(uda_ag, '/OrderManagementCharacteristics'),'Y')
2808: INTO L_PUBLISH_OM_CHARS

Line 2816: 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)

2812: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/OrderManagementCharacteristics') )) udaag
2813: WHERE session_id=p_session_id
2814: );
2815:
2816: 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)
2817: VALUES (p_session_id,p_odi_session_id,'PUBLISH_OM_CHARS',2,NULL,Upper(L_PUBLISH_OM_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2818: END IF;
2819:
2820: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ReceivingCharacteristics')

Line 2826: 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)

2822: FROM EGO_PUB_WS_PARAMS
2823: WHERE session_id = p_session_id;
2824:
2825: IF (l_node_exists = 0) THEN
2826: 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)
2827: VALUES (p_session_id,p_odi_session_id,'PUBLISH_RECEIVE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2828: ELSE
2829: SELECT Nvl(extractValue(uda_ag, '/ReceivingCharacteristics'),'Y')
2830: INTO L_PUBLISH_RECEIVE_CHARS

Line 2838: 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)

2834: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ReceivingCharacteristics') )) udaag
2835: WHERE session_id=p_session_id
2836: );
2837:
2838: 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)
2839: VALUES (p_session_id,p_odi_session_id,'PUBLISH_RECEIVE_CHARS',2,NULL,Upper(L_PUBLISH_RECEIVE_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2840: END IF;
2841:
2842: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InvoicingCharacteristics')

Line 2848: 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)

2844: FROM EGO_PUB_WS_PARAMS
2845: WHERE session_id = p_session_id;
2846:
2847: IF (l_node_exists = 0) THEN
2848: 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)
2849: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INVOICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2850: ELSE
2851: SELECT Nvl(extractValue(uda_ag, '/InvoicingCharacteristics'),'Y')
2852: INTO L_PUBLISH_INVOICE_CHARS

Line 2860: 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)

2856: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/InvoicingCharacteristics') )) udaag
2857: WHERE session_id=p_session_id
2858: );
2859:
2860: 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)
2861: VALUES (p_session_id,p_odi_session_id,'PUBLISH_INVOICE_CHARS',2,NULL,Upper(L_PUBLISH_INVOICE_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2862: END IF;
2863:
2864: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/WebOptionsCharacteristics')

Line 2870: 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)

2866: FROM EGO_PUB_WS_PARAMS
2867: WHERE session_id = p_session_id;
2868:
2869: IF (l_node_exists = 0) THEN
2870: 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)
2871: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WEBOPT_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2872: ELSE
2873: SELECT Nvl(extractValue(uda_ag, '/WebOptionsCharacteristics'),'Y')
2874: INTO L_PUBLISH_WEBOPT_CHARS

Line 2882: 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)

2878: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/WebOptionsCharacteristics') )) udaag
2879: WHERE session_id=p_session_id
2880: );
2881:
2882: 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)
2883: VALUES (p_session_id,p_odi_session_id,'PUBLISH_WEBOPT_CHARS',2,NULL,Upper(L_PUBLISH_WEBOPT_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2884: END IF;
2885:
2886: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ServiceCharacteristics')

Line 2892: 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)

2888: FROM EGO_PUB_WS_PARAMS
2889: WHERE session_id = p_session_id;
2890:
2891: IF (l_node_exists = 0) THEN
2892: 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)
2893: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SERVICE_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2894: ELSE
2895: SELECT Nvl(extractValue(uda_ag, '/ServiceCharacteristics'),'Y')
2896: INTO L_PUBLISH_SERVICE_CHARS

Line 2904: 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)

2900: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ServiceCharacteristics') )) udaag
2901: WHERE session_id=p_session_id
2902: );
2903:
2904: 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)
2905: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SERVICE_CHARS',2,NULL,Upper(L_PUBLISH_SERVICE_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2906: END IF;
2907:
2908: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/AssetCharacteristics')

Line 2914: 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)

2910: FROM EGO_PUB_WS_PARAMS
2911: WHERE session_id = p_session_id;
2912:
2913: IF (l_node_exists = 0) THEN
2914: 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)
2915: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ASSET_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2916: ELSE
2917: SELECT Nvl(extractValue(uda_ag, '/AssetCharacteristics'),'Y')
2918: INTO L_PUBLISH_ASSET_CHARS

Line 2926: 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)

2922: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/AssetCharacteristics') )) udaag
2923: WHERE session_id=p_session_id
2924: );
2925:
2926: 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)
2927: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ASSET_CHARS',2,NULL,Upper(L_PUBLISH_ASSET_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2928: END IF;
2929:
2930: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessMfgCharacteristics')

Line 2936: 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)

2932: FROM EGO_PUB_WS_PARAMS
2933: WHERE session_id = p_session_id;
2934:
2935: IF (l_node_exists = 0) THEN
2936: 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)
2937: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PMFG_CHARS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2938: ELSE
2939: SELECT Nvl(extractValue(uda_ag, '/ProcessMfgCharacteristics'),'Y')
2940: INTO L_PUBLISH_PMFG_CHARS

Line 2948: 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)

2944: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/PublishOperationalAttributeGroups/ProcessMfgCharacteristics') )) udaag
2945: WHERE session_id=p_session_id
2946: );
2947:
2948: 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)
2949: VALUES (p_session_id,p_odi_session_id,'PUBLISH_PMFG_CHARS',2,NULL,Upper(L_PUBLISH_PMFG_CHARS),NULL,SYSDATE,G_CURRENT_USER_ID);
2950: END IF;
2951:
2952: END IF; -- (l_node_exists = 0) for Publish Operational Ags

Line 2960: 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)

2956: FROM EGO_PUB_WS_PARAMS
2957: WHERE session_id = p_session_id;
2958:
2959: IF (l_node_exists = 0) THEN
2960: 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)
2961: VALUES (p_session_id,p_odi_session_id,'PUBLISH_UDA_GROUPS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2962: ELSE
2963: SELECT Nvl(extractValue(uda_ag, '/UserDefinedAttributeGroups'),'Y')
2964: INTO L_PUBLISH_UDA_GROUPS

Line 2972: 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)

2968: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/UserDefinedAttributeGroups') )) udaag
2969: WHERE session_id=p_session_id
2970: );
2971:
2972: 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)
2973: VALUES (p_session_id,p_odi_session_id,'PUBLISH_UDA_GROUPS',2,NULL,Upper(L_PUBLISH_UDA_GROUPS),NULL,SYSDATE,G_CURRENT_USER_ID);
2974: END IF;
2975:
2976:

Line 2983: 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)

2979: FROM EGO_PUB_WS_PARAMS
2980: WHERE session_id = p_session_id;
2981:
2982: IF (l_node_exists = 0) THEN
2983: 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)
2984: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ITEM_REVISION',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
2985: ELSE
2986: SELECT Nvl(extractValue(uda_ag, '/ItemRevision'),'Y')
2987: INTO L_PUBLISH_ITEM_REVISION

Line 2995: 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)

2991: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ItemRevision') )) udaag
2992: WHERE session_id=p_session_id
2993: );
2994:
2995: 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)
2996: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ITEM_REVISION',2,NULL,Upper(L_PUBLISH_ITEM_REVISION),NULL,SYSDATE,G_CURRENT_USER_ID);
2997: END IF;
2998:
2999: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/TransactionAttributes')

Line 3005: 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)

3001: FROM EGO_PUB_WS_PARAMS
3002: WHERE session_id = p_session_id;
3003:
3004: IF (l_node_exists = 0) THEN
3005: 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)
3006: VALUES (p_session_id,p_odi_session_id,'PUBLISH_TRANSACTION_ATTRS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
3007: ELSE
3008: SELECT Nvl(extractValue(uda_ag, '/TransactionAttributes'),'Y')
3009: INTO L_PUBLISH_TRANSACTION_ATTRS

Line 3017: 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)

3013: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/TransactionAttributes') )) udaag
3014: WHERE session_id=p_session_id
3015: );
3016:
3017: 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)
3018: VALUES (p_session_id,p_odi_session_id,'PUBLISH_TRANSACTION_ATTRS',2,NULL,Upper(L_PUBLISH_TRANSACTION_ATTRS),NULL,SYSDATE,G_CURRENT_USER_ID);
3019:
3020: END IF;
3021:

Line 3028: 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)

3024: FROM EGO_PUB_WS_PARAMS
3025: WHERE session_id = p_session_id;
3026:
3027: IF (l_node_exists = 0) THEN
3028: 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)
3029: VALUES (p_session_id,p_odi_session_id,'PUBLISH_RELATED_ITEMS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
3030: ELSE
3031: SELECT Nvl(extractValue(uda_ag, '/RelatedItems'),'Y')
3032: INTO L_PUBLISH_RELATED_ITEMS

Line 3040: 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)

3036: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/RelatedItems') )) udaag
3037: WHERE session_id=p_session_id
3038: );
3039:
3040: 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)
3041: VALUES (p_session_id,p_odi_session_id,'PUBLISH_RELATED_ITEMS',2,NULL,Upper(L_PUBLISH_RELATED_ITEMS),NULL,SYSDATE,G_CURRENT_USER_ID);
3042: END IF;
3043:
3044:

Line 3051: 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)

3047: FROM EGO_PUB_WS_PARAMS
3048: WHERE session_id = p_session_id;
3049:
3050: IF (l_node_exists = 0) THEN
3051: 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)
3052: VALUES (p_session_id,p_odi_session_id,'PUBLISH_CUSTOMER_ITEMS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
3053: ELSE
3054: SELECT Nvl(extractValue(uda_ag, '/CustomerItems'),'Y')
3055: INTO L_PUBLISH_CUSTOMER_ITEMS

Line 3063: 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)

3059: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/CustomerItems') )) udaag
3060: WHERE session_id=p_session_id
3061: );
3062:
3063: 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)
3064: VALUES (p_session_id,p_odi_session_id,'PUBLISH_CUSTOMER_ITEMS',2,NULL,Upper(L_PUBLISH_CUSTOMER_ITEMS),NULL,SYSDATE,G_CURRENT_USER_ID);
3065:
3066: END IF;
3067:

Line 3074: 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)

3070: FROM EGO_PUB_WS_PARAMS
3071: WHERE session_id = p_session_id;
3072:
3073: IF (l_node_exists = 0) THEN
3074: 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)
3075: VALUES (p_session_id,p_odi_session_id,'PUBLISH_MFGPART_NUMBERS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
3076: ELSE
3077: SELECT Nvl(extractValue(uda_ag, '/ManufacturerPartNumbers'),'Y')
3078: INTO L_PUBLISH_MFGPART_NUMBERS

Line 3086: 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)

3082: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/ManufacturerPartNumbers') )) udaag
3083: WHERE session_id=p_session_id
3084: );
3085:
3086: 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)
3087: VALUES (p_session_id,p_odi_session_id,'PUBLISH_MFGPART_NUMBERS',2,NULL,Upper(L_PUBLISH_MFGPART_NUMBERS),NULL,SYSDATE,G_CURRENT_USER_ID);
3088: END IF;
3089:
3090: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/GTINCrossReferences')

Line 3096: 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)

3092: FROM EGO_PUB_WS_PARAMS
3093: WHERE session_id = p_session_id;
3094:
3095: IF (l_node_exists = 0) THEN
3096: 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)
3097: VALUES (p_session_id,p_odi_session_id,'PUBLISH_GTIN_XREFS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
3098: ELSE
3099: SELECT Nvl(extractValue(uda_ag, '/GTINCrossReferences'),'Y')
3100: INTO L_PUBLISH_GTIN_XREFS

Line 3108: 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)

3104: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/GTINCrossReferences') )) udaag
3105: WHERE session_id=p_session_id
3106: );
3107:
3108: 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)
3109: VALUES (p_session_id,p_odi_session_id,'PUBLISH_GTIN_XREFS',2,NULL,Upper(L_PUBLISH_GTIN_XREFS),NULL,SYSDATE,G_CURRENT_USER_ID);
3110: END IF;
3111:
3112: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/AlternateCategoryAssignments')

Line 3118: 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)

3114: FROM EGO_PUB_WS_PARAMS
3115: WHERE session_id = p_session_id;
3116:
3117: IF (l_node_exists = 0) THEN
3118: 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)
3119: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ALTCAT_ASSIGNMENTS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
3120:
3121: ELSE
3122: SELECT Nvl(extractValue(uda_ag, '/AlternateCategoryAssignments'),'Y')

Line 3131: 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)

3127: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/AlternateCategoryAssignments') )) udaag
3128: WHERE session_id=p_session_id
3129: );
3130:
3131: 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)
3132: VALUES (p_session_id,p_odi_session_id,'PUBLISH_ALTCAT_ASSIGNMENTS',2,NULL,Upper(L_PUBLISH_ALTCAT_ASSIGNMENTS),NULL,SYSDATE,G_CURRENT_USER_ID);
3133: END IF;
3134:
3135: SELECT existsNode(xmlcontent, '/itemQueryParameters/PublishEntities/SupplierAssignments')

Line 3141: 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)

3137: FROM EGO_PUB_WS_PARAMS
3138: WHERE session_id = p_session_id;
3139:
3140: IF (l_node_exists = 0) THEN
3141: 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)
3142: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SUPPLIER_ASSIGNMNETS',2,NULL,'Y',NULL,SYSDATE,G_CURRENT_USER_ID);
3143: ELSE
3144: SELECT Nvl(extractValue(uda_ag, '/SupplierAssignments'),'Y')
3145: INTO L_PUBLISH_SUPPLIER_ASSIGNMNETS

Line 3153: 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)

3149: extract(i.xmlcontent, '/itemQueryParameters/PublishEntities/SupplierAssignments') )) udaag
3150: WHERE session_id=p_session_id
3151: );
3152:
3153: 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)
3154: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SUPPLIER_ASSIGNMNETS',2,NULL,Upper(L_PUBLISH_SUPPLIER_ASSIGNMNETS),NULL,SYSDATE,G_CURRENT_USER_ID);
3155: END IF;
3156:
3157: SELECT CHAR_VALUE INTO v_publish_udas

Line 3158: FROM EGO_PUB_WS_CONFIG

3154: VALUES (p_session_id,p_odi_session_id,'PUBLISH_SUPPLIER_ASSIGNMNETS',2,NULL,Upper(L_PUBLISH_SUPPLIER_ASSIGNMNETS),NULL,SYSDATE,G_CURRENT_USER_ID);
3155: END IF;
3156:
3157: SELECT CHAR_VALUE INTO v_publish_udas
3158: FROM EGO_PUB_WS_CONFIG
3159: WHERE Parameter_Name = 'PUBLISH_UDA_GROUPS'
3160: AND session_id = p_session_id;
3161:
3162: -- Validate the List of UDAS provided only if publishing UDAS

Line 3273: 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)

3269: END IF;
3270:
3271: IF (l_uda_attr_name_tab(i) IS NOT NULL)
3272: THEN
3273: 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)
3274: VALUES (p_session_id,p_odi_session_id,'PUBLISH_AG_NAME',2,NULL, l_uda_attr_name_tab(i),NULL,SYSDATE,G_CURRENT_USER_ID);
3275: END IF;
3276:
3277: END LOOP;

Line 3281: FROM EGO_PUB_WS_CONFIG

3277: END LOOP;
3278:
3279: -- 8667733 : Start
3280: SELECT Count(*) INTO v_ags_count
3281: FROM EGO_PUB_WS_CONFIG
3282: WHERE Parameter_Name = 'PUBLISH_AG_NAME'
3283: AND session_id = p_session_id;
3284:
3285: -- If all the AGs provided are invalid, then Do not fetch UDA at all.

Line 3287: UPDATE EGO_PUB_WS_CONFIG

3283: AND session_id = p_session_id;
3284:
3285: -- If all the AGs provided are invalid, then Do not fetch UDA at all.
3286: IF (v_ags_count = 0 AND (v_ag_null_cnt <> l_uda_attr_id_tab.Count)) THEN
3287: UPDATE EGO_PUB_WS_CONFIG
3288: SET Char_value = 'N'
3289: WHERE session_id = p_session_id
3290: AND Parameter_Name = 'PUBLISH_UDA_GROUPS';
3291: END IF;

Line 3300: FROM EGO_PUB_WS_CONFIG

3296: END IF; -- end of (v_publish_udas = 'Y')
3297:
3298:
3299: SELECT CHAR_VALUE INTO v_publish_tas
3300: FROM EGO_PUB_WS_CONFIG
3301: WHERE Parameter_Name = 'PUBLISH_TRANSACTION_ATTRS'
3302: AND session_id = p_session_id;
3303:
3304: -- Validate the List of TAs provided only if publishing TAs

Line 3374: 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)

3370: p_input_id => p_index,
3371: p_err_code => 'EGO_INVALID_TA_NAME',
3372: p_err_message => 'Invalid Transaction Attribute Name');
3373:
3374: 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)
3375: VALUES (p_session_id,p_odi_session_id,'PUBLISH_TA_ID',2,NULL, l_ta_attr_name_tab(i), NULL , SYSDATE, G_CURRENT_USER_ID);
3376: l_ta_attr_id_tab(i) := NULL;
3377: l_ta_attr_name_tab(i) := NULL;
3378:

Line 3385: 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)

3381: FROM ego_attrs_v
3382: WHERE ATTR_NAME = l_ta_attr_name_tab(i)
3383: AND ATTR_GROUP_TYPE = 'EGO_ITEM_TRANS_ATTR_GROUP')
3384: LOOP
3385: 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)
3386: VALUES (p_session_id,p_odi_session_id,'PUBLISH_TA_ID',1,NULL, NULL,j.ATTR_ID, SYSDATE, G_CURRENT_USER_ID);
3387: END LOOP;
3388:
3389: l_ta_attr_id_tab(i) := NULL;

Line 3421: 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)

3417: p_input_id => p_index,
3418: p_err_code => 'EGO_INVALID_TA_ID',
3419: p_err_message => 'Invalid Transaction Attribute Id');
3420:
3421: 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)
3422: VALUES (p_session_id,p_odi_session_id,'PUBLISH_TA_ID',2,NULL, l_ta_attr_id_tab(i), NULL , SYSDATE, G_CURRENT_USER_ID);
3423: l_ta_attr_id_tab(i) := NULL;
3424: l_ta_attr_name_tab(i) := NULL;
3425: END;

Line 3430: 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)

3426: END IF;
3427:
3428: IF (l_ta_attr_id_tab(i) IS NOT NULL)
3429: THEN
3430: 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)
3431: VALUES (p_session_id,p_odi_session_id,'PUBLISH_TA_ID',1,NULL, NULL, l_ta_attr_id_tab(i), SYSDATE, G_CURRENT_USER_ID);
3432: END IF;
3433:
3434: END LOOP;

Line 4714: from EGO_PUB_WS_CONFIG

4710: BEGIN
4711:
4712: select char_value
4713: into l_mode
4714: from EGO_PUB_WS_CONFIG
4715: where parameter_name = 'INVOCATION_MODE'
4716: and session_id = p_session_id;
4717:
4718: IF (l_mode = 'BATCH') THEN

Line 4724: from EGO_PUB_WS_CONFIG

4720: FROM EGO_USER_V WHERE USER_ID = FND_GLOBAL.USER_ID;
4721:
4722: select Numeric_Value
4723: into l_batch_id
4724: from EGO_PUB_WS_CONFIG
4725: where parameter_name = 'BATCH_ID'
4726: and session_id = p_session_id;
4727:
4728: SELECT CHAR_VALUE INTO l_structure_name FROM EGO_PUB_BAT_PARAMS_B

Line 4949: from EGO_PUB_WS_CONFIG

4945:
4946: --retrieving invocation mode
4947: select char_value
4948: into l_mode
4949: from EGO_PUB_WS_CONFIG
4950: where parameter_name = 'INVOCATION_MODE'
4951: and session_id = p_session_id;
4952:
4953: --if mode is batch, get security related information from publication

Line 4993: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

4989: into l_fnd_user_name, l_responsibility_name, l_responsibility_appl_name, l_security_group_name
4990: from EGO_PUB_WS_PARAMS
4991: where session_id = p_session_id;
4992:
4993: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
4994: odi_session_id,
4995: Parameter_Name,
4996: Data_Type,
4997: Char_value,

Line 5008: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

5004: l_fnd_user_name,
5005: sysdate,
5006: 0);
5007:
5008: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
5009: odi_session_id,
5010: Parameter_Name,
5011: Data_Type,
5012: Char_value,

Line 5023: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

5019: l_responsibility_name,
5020: sysdate,
5021: 0);
5022:
5023: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
5024: odi_session_id,
5025: Parameter_Name,
5026: Data_Type,
5027: Char_value,

Line 5038: INSERT INTO EGO_PUB_WS_CONFIG (session_id,

5034: l_responsibility_appl_name,
5035: sysdate,
5036: 0);
5037:
5038: INSERT INTO EGO_PUB_WS_CONFIG (session_id,
5039: odi_session_id,
5040: Parameter_Name,
5041: Data_Type,
5042: Char_value,