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_PUB_WS_UTIL dependencies on EGO_PUB_WS_CONFIG

Line 18: --from ego_pub_ws_config table - For List mode

14: +==========================================================================*/
15:
16: --for a session id returns the Numeric configuration parameter value
17: --for the provided parameter name
18: --from ego_pub_ws_config table - For List mode
19: --from ego_pub_bat_params_b table - For Batch mode
20:
21: FUNCTION Get_Numeric_Param_Value( p_session_id IN NUMBER,
22: p_param_name IN VARCHAR2,

Line 37: FROM EGO_PUB_WS_CONFIG

33: BEGIN
34: IF l_mode IS NULL THEN
35: SELECT NUMERIC_VALUE
36: INTO x_param_value
37: FROM EGO_PUB_WS_CONFIG
38: WHERE PARAMETER_NAME = l_param_name
39: AND SESSION_ID = p_session_id;
40: ELSIF l_mode = 'BATCH' THEN
41: SELECT NUMERIC_VALUE

Line 55: --from ego_pub_ws_config table - For List mode

51: END;
52:
53: --for a session id returns the char configuration parameter value
54: --for the provided parameter name
55: --from ego_pub_ws_config table - For List mode
56: --from ego_pub_bat_params_b table - For Batch mode
57:
58:
59: FUNCTION Get_Char_Param_Value(p_session_id IN NUMBER,

Line 89: FROM EGO_PUB_WS_CONFIG

85: AND TYPE_ID = l_batch_id;
86: ELSE
87: SELECT CHAR_VALUE
88: INTO x_param_value
89: FROM EGO_PUB_WS_CONFIG
90: WHERE PARAMETER_NAME = l_param_name
91: AND SESSION_ID = p_session_id;
92: END IF;
93:

Line 100: --from ego_pub_ws_config table - For List mode

96: END;
97:
98: --for a session id returns the date configuration parameter value
99: --for the provided parameter name
100: --from ego_pub_ws_config table - For List mode
101: --from ego_pub_bat_params_b table - For Batch mode
102:
103:
104: FUNCTION Get_Char_Date_Value( p_session_id IN NUMBER,

Line 121: FROM EGO_PUB_WS_CONFIG

117:
118: IF l_mode IS NULL THEN
119: SELECT DATE_VALUE
120: INTO x_param_value
121: FROM EGO_PUB_WS_CONFIG
122: WHERE PARAMETER_NAME = l_param_name
123: AND SESSION_ID = p_session_id;
124: ELSIF l_mode = 'BATCH' THEN
125: SELECT DATE_VALUE

Line 441: FROM EGO_PUB_WS_CONFIG

437: BEGIN
438:
439: /*SELECT CHAR_VALUE
440: INTO l_mode
441: FROM EGO_PUB_WS_CONFIG
442: WHERE session_id = p_session_id;*/
443:
444: --RETRIEVING FND_USER_NAME, RESPONSIBILITY_NAME, RESPONSIBILITY_APPL_NAME, and
445: --SECURITY_GROUP_NAME depending on input mode

Line 460: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

456: WHERE session_id = p_session_id;
457:
458: /*INSERT INTO tr_temp (Session_id, message)
459: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/
460: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
461: odi_session_id,
462: Parameter_Name,
463: Data_Type,
464: Char_value,

Line 486: INSERT INTO EGO_PUB_WS_CONFIG( session_id,

482:
483: /*INSERT INTO tr_temp (Session_id, message)
484: values (p_session_id, 'RESPONSIBILITY_NAME:' || l_responsibility_name);*/
485:
486: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
487: odi_session_id,
488: Parameter_Name,
489: Data_Type,
490: Char_value,

Line 513: INSERT INTO EGO_PUB_WS_CONFIG( session_id,

509:
510: /*INSERT INTO tr_temp (Session_id, message)
511: values (p_session_id, 'RESPONSIBILITY_APPL_NAME:' || l_responsibility_appl_name);*/
512:
513: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
514: odi_session_id,
515: Parameter_Name,
516: Data_Type,
517: Char_value,

Line 540: INSERT INTO EGO_PUB_WS_CONFIG( session_id,

536:
537: /*INSERT INTO tr_temp (Session_id, message)
538: values (p_session_id, 'SECURITY_GROUP_NAME:' || l_security_group_name);*/
539:
540: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
541: odi_session_id,
542: Parameter_Name,
543: Data_Type,
544: Char_value,

Line 578: INSERT INTO EGO_PUB_WS_CONFIG( session_id,

574: /*INSERT INTO tr_temp (Session_id, message)
575: values (p_session_id, 'FND_USER_NAME:' || l_fnd_user_name);*/
576:
577: --inserting user name
578: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
579: odi_session_id,
580: Parameter_Name,
581: Data_Type,
582: Char_value,

Line 605: INSERT INTO EGO_PUB_WS_CONFIG( session_id,

601: /*INSERT INTO tr_temp (Session_id, message)
602: values (p_session_id, 'RESPONSIBILITY_NAME:' || l_responsibility_name);*/
603:
604: --inserting responsibility name
605: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
606: odi_session_id,
607: Parameter_Name,
608: Data_Type,
609: Char_value,

Line 641: INSERT INTO EGO_PUB_WS_CONFIG( session_id,

637: /*INSERT INTO tr_temp (Session_id, message)
638: values (p_session_id, 'SECURITY_GROUP_NAME:' || l_security_group_name);*/
639:
640: --inserting responsibility_appl_name
641: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
642: odi_session_id,
643: Parameter_Name,
644: Data_Type,
645: Char_value,

Line 660: INSERT INTO EGO_PUB_WS_CONFIG( session_id,

656: l_web_service_name);
657:
658: --inserting security_group_name as NULL
659: l_security_group_name := NULL;
660: INSERT INTO EGO_PUB_WS_CONFIG( session_id,
661: odi_session_id,
662: Parameter_Name,
663: Data_Type,
664: Char_value,

Line 857: FROM EGO_PUB_WS_CONFIG

853:
854: --reading fnd user name
855: SELECT CHAR_VALUE
856: INTO l_user_name
857: FROM EGO_PUB_WS_CONFIG
858: WHERE SESSION_ID = p_session_id
859: AND WEB_SERVICE_NAME = l_web_service_name
860: AND parameter_name = 'FND_USER_NAME';
861:

Line 871: FROM EGO_PUB_WS_CONFIG

867:
868: --reading responsibility name
869: SELECT CHAR_VALUE
870: INTO l_responsibility_name
871: FROM EGO_PUB_WS_CONFIG
872: WHERE SESSION_ID = p_session_id
873: AND WEB_SERVICE_NAME = l_web_service_name
874: AND PARAMETER_NAME = 'RESPONSIBILITY_NAME';
875:

Line 890: FROM EGO_PUB_WS_CONFIG

886:
887: --reading responsibility application name
888: SELECT CHAR_VALUE
889: INTO l_responsibility_appl_name
890: FROM EGO_PUB_WS_CONFIG
891: WHERE SESSION_ID = p_session_id
892: AND WEB_SERVICE_NAME = l_web_service_name
893: AND PARAMETER_NAME = 'RESPONSIBILITY_APPL_NAME';
894:

Line 909: FROM EGO_PUB_WS_CONFIG

905:
906: --reading security group name
907: SELECT CHAR_VALUE
908: INTO l_security_group_name
909: FROM EGO_PUB_WS_CONFIG
910: WHERE SESSION_ID = p_session_id
911: AND WEB_SERVICE_NAME = l_web_service_name
912: AND PARAMETER_NAME = 'SECURITY_GROUP_NAME';
913:

Line 1039: --Inserts system options in EGO_PUB_WS_CONFIG table

1035: RETURN FALSE;
1036:
1037: END Validate_System_Info;
1038:
1039: --Inserts system options in EGO_PUB_WS_CONFIG table
1040: PROCEDURE Config_Systems(p_session_id IN NUMBER,
1041: p_system_search_str IN VARCHAR2,
1042: p_web_service_name VARCHAR2 DEFAULT NULL)
1043: IS

Line 1064: FROM EGO_PUB_WS_CONFIG

1060: BEGIN
1061:
1062: SELECT CHAR_VALUE
1063: INTO l_mode
1064: FROM EGO_PUB_WS_CONFIG
1065: WHERE PARAMETER_NAME = 'MODE'
1066: AND session_id = p_session_id;
1067:
1068: IF l_mode = 'LIST' THEN

Line 1202: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

1198:
1199: /*INSERT INTO tr_temp (Session_id, message)
1200: values (p_session_id, 'SYSTEM_CODE:' || l_system_code_tab(i));*/
1201:
1202: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1203: odi_session_id,
1204: Parameter_Name,
1205: Data_Type,
1206: Date_Value,

Line 1228: -- trudave - read from Batch Publication Framework System table and write to EGO_PUB_WS_CONFIG table

1224: END IF;
1225:
1226: ELSIF l_mode = 'BATCH' THEN
1227:
1228: -- trudave - read from Batch Publication Framework System table and write to EGO_PUB_WS_CONFIG table
1229: -- trudave - as batch publication fwk tables are not exposed to users and systems selected from UI and validated
1230: -- trudave - do we need to validate system information ? , as per my view we do not need to validate systems to avoid rework
1231: -- trudave - double check is always good as well.
1232: SELECT NUMERIC_VALUE

Line 1234: FROM EGO_PUB_WS_CONFIG

1230: -- trudave - do we need to validate system information ? , as per my view we do not need to validate systems to avoid rework
1231: -- trudave - double check is always good as well.
1232: SELECT NUMERIC_VALUE
1233: INTO l_batch_id
1234: FROM EGO_PUB_WS_CONFIG
1235: WHERE PARAMETER_NAME = 'BATCH_ID'
1236: AND session_id = p_session_id;
1237:
1238: SELECT system_code

Line 1254: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

1250:
1251: /*INSERT INTO tr_temp (Session_id, message)
1252: values (p_session_id, 'SYSTEM_CODE:' || l_system_code_tab(i));*/
1253:
1254: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1255: odi_session_id,
1256: Parameter_Name,
1257: Data_Type,
1258: Date_Value,

Line 1296: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

1292: LOOP
1293: INSERT INTO tr_temp (Session_id, message)
1294: values (p_session_id, 'SYSTEM_CODE:' || i.orig_system);
1295:
1296: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1297: odi_session_id,
1298: Parameter_Name,
1299: Data_Type,
1300: Date_Value,

Line 1425: --Inserts language options in EGO_PUB_WS_CONFIG table

1421: RETURN FALSE;
1422:
1423: END Validate_Language_Info;
1424:
1425: --Inserts language options in EGO_PUB_WS_CONFIG table
1426: PROCEDURE Config_Languages(p_session_id IN NUMBER,
1427: p_lang_search_str IN VARCHAR2,
1428: p_web_service_name IN VARCHAR2 DEFAULT NULL)
1429: IS

Line 1576: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

1572: /*INSERT INTO tr_temp (Session_id, message)
1573: values (p_session_id, 'LANGUAGE_CODE:' || l_lang_code_tab(i));*/
1574:
1575: IF l_lang_code_tab(i) IS NOT NULL THEN
1576: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1577: odi_session_id,
1578: Parameter_Name,
1579: Data_Type,
1580: Date_Value,

Line 1606: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,

1602:
1603: /*INSERT INTO tr_temp (Session_id, message)
1604: values (p_session_id, 'LANGUAGE_CODE:' || i.language_code);
1605: */
1606: INSERT INTO EGO_PUB_WS_CONFIG ( session_id,
1607: odi_session_id,
1608: Parameter_Name,
1609: Data_Type,
1610: Date_Value,

Line 1734: -- Get System_code from EGO_PUB_WS_CONFIG table

1730: x_return_status VARCHAR2(1);
1731: x_msg_count NUMBER;
1732: x_msg_data VARCHAR2(500);
1733:
1734: -- Get System_code from EGO_PUB_WS_CONFIG table
1735:
1736: CURSOR c_system_codes(l_session_id NUMBER)
1737: IS
1738: SELECT CHAR_VALUE

Line 1739: FROM EGO_PUB_WS_CONFIG

1735:
1736: CURSOR c_system_codes(l_session_id NUMBER)
1737: IS
1738: SELECT CHAR_VALUE
1739: FROM EGO_PUB_WS_CONFIG
1740: WHERE SESSION_ID = l_session_id
1741: AND PARAMETER_NAME = 'SYSTEM_CODE';
1742:
1743: -- Get input and derived entities from EGO_PUB_BAT_ENT_OBJS_V

Line 1804: FROM EGO_PUB_WS_CONFIG

1800: BEGIN
1801:
1802: SELECT CHAR_VALUE
1803: INTO l_trigger_import
1804: FROM EGO_PUB_WS_CONFIG
1805: WHERE SESSION_ID = p_session_id
1806: AND PARAMETER_NAME = 'TRIGGER_IMPORT';
1807:
1808: -- use global temporary table (reuse the one currently of batch publication framework)

Line 2229: -- Get System_code from EGO_PUB_WS_CONFIG table

2225: v_index NUMBER;
2226: v_count NUMBER;
2227: l_system_code VARCHAR2(40);
2228:
2229: -- Get System_code from EGO_PUB_WS_CONFIG table
2230:
2231: CURSOR c_system_codes(l_session_id NUMBER)
2232: IS
2233: SELECT CHAR_VALUE

Line 2234: FROM EGO_PUB_WS_CONFIG

2230:
2231: CURSOR c_system_codes(l_session_id NUMBER)
2232: IS
2233: SELECT CHAR_VALUE
2234: FROM EGO_PUB_WS_CONFIG
2235: WHERE SESSION_ID = l_session_id
2236: AND PARAMETER_NAME = 'SYSTEM_CODE';
2237:
2238:

Line 2408: FROM ego_pub_ws_config

2404: /*Cursor to get configurable parameter 'return_payload' value*/
2405: CURSOR cur_config_param(cp_session_id NUMBER)
2406: IS
2407: SELECT CHAR_VALUE param_value
2408: FROM ego_pub_ws_config
2409: WHERE session_id = cp_session_id
2410: AND upper(parameter_name) = 'RETURN_PAYLOAD';
2411:
2412: --Start error handling