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_INPUT_IDENTIFIERS

Line 709: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

705: --dbms_output.put_line(' Error : Invalid Revision Details ');
706:
707: SELECT Nvl(Max(INPUT_ID),0) + 1
708: INTO l_index
709: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
710: WHERE session_id = p_session_id;
711:
712: Populate_Input_Identifier(p_session_id => p_session_id,
713: p_input_id => l_index,

Line 760: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

756: --dbms_output.put_line(' Error : Invalid Revision Details ');
757:
758: SELECT Nvl(Max(INPUT_ID),0) + 1
759: INTO l_index
760: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
761: WHERE SESSION_ID = p_session_id;
762:
763: Populate_Input_Identifier( p_session_id => p_session_id,
764: p_input_id => l_index,

Line 810: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

806: WHEN No_Data_Found THEN
807: --dbms_output.put_line(' Error : Invalid Revision Details ');
808:
809: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
810: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
811: WHERE session_id = p_session_id;
812:
813: Populate_Input_Identifier( p_session_id => p_session_id,
814: p_input_id => l_index,

Line 953: -- in table EGO_PUB_WS_INPUT_IDENTIFIERS

949: END Init_Security;
950:
951: -- Validates system code and system name in table HZ_ORIG_SYSTEMS_B
952: -- For invalid systems, writes parameter name and parameter value
953: -- in table EGO_PUB_WS_INPUT_IDENTIFIERS
954: -- And corresponding error code and error message in table EGO_PUB_WS_ERRORS
955:
956: FUNCTION Validate_System_Info(p_session_id IN NUMBER,
957: p_system_code IN OUT NOCOPY VARCHAR2,

Line 998: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

994: WHEN No_Data_Found THEN
995:
996: SELECT Nvl(Max(INPUT_ID),0) + 1
997: INTO l_index
998: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
999: WHERE session_id = p_session_id;
1000:
1001:
1002: IF l_temp IS NOT NULL THEN

Line 1142: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1138: IF l_temp_code IS NULL THEN
1139: -- write error in odi error tables
1140: SELECT Nvl(Max(INPUT_ID),0) + 1
1141: INTO l_index
1142: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1143: WHERE session_id = p_session_id;
1144:
1145: Populate_Input_Identifier( p_session_id => p_session_id,
1146: p_input_id => l_index,

Line 1161: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1157: IF l_temp_name IS NULL THEN
1158: -- write error in odi error tables
1159: SELECT Nvl(Max(INPUT_ID),0) + 1
1160: INTO l_index
1161: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1162: WHERE session_id = p_session_id;
1163:
1164: Populate_Input_Identifier( p_session_id => p_session_id,
1165: p_input_id => l_index,

Line 1320: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1316: END LOOP;*/
1317:
1318: SELECT Nvl(Max(INPUT_ID),0) + 1
1319: INTO l_index
1320: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1321: WHERE session_id = p_session_id;
1322:
1323: Populate_Input_Identifier( p_session_id => p_session_id,
1324: p_input_id => l_index,

Line 1384: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1380: WHEN No_Data_Found THEN
1381: --dbms_output.put_line(' Error : Invalid Language Code ');
1382:
1383: SELECT Nvl(Max(INPUT_ID),0) + 1 into l_index
1384: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1385: WHERE session_id = p_session_id;
1386:
1387:
1388: IF l_temp IS NOT NULL THEN

Line 1514: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1510: IF l_temp_code IS NULL THEN
1511: -- write error in odi error tables
1512: SELECT Nvl(Max(INPUT_ID),0) + 1
1513: INTO l_index
1514: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1515: WHERE session_id = p_session_id;
1516:
1517: Populate_Input_Identifier( p_session_id => p_session_id,
1518: p_input_id => l_index,

Line 1533: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1529: IF l_temp_name IS NULL THEN
1530: -- write error in odi error tables
1531: SELECT Nvl(Max(INPUT_ID),0) + 1
1532: INTO l_index
1533: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1534: WHERE session_id = p_session_id;
1535:
1536: Populate_Input_Identifier( p_session_id => p_session_id,
1537: p_input_id => l_index,

Line 1634: --- while inserting error records in EGO_PUB_WS_INPUT_IDENTIFIERS

1630: END Config_Languages;
1631:
1632: ---
1633: --- This function returns the next input identifier to be used
1634: --- while inserting error records in EGO_PUB_WS_INPUT_IDENTIFIERS
1635: --- the id used as input_id should be unique per session
1636: ---
1637: FUNCTION Get_Max_Input_Identifier ( p_session_id IN NUMBER)
1638: RETURN NUMBER

Line 1646: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1642: BEGIN
1643:
1644: SELECT Nvl(Max(INPUT_ID),0) + 1
1645: INTO l_index
1646: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1647: WHERE session_id = p_session_id;
1648:
1649: RETURN l_index;
1650: EXCEPTION

Line 1665: INSERT INTO EGO_PUB_WS_INPUT_IDENTIFIERS(session_id,

1661: IS
1662:
1663: BEGIN
1664:
1665: INSERT INTO EGO_PUB_WS_INPUT_IDENTIFIERS(session_id,
1666: odi_session_id,
1667: input_id,
1668: param_name,
1669: param_value,

Line 1755: -- Get PKs, SYSTEM_CODE from EGO_PUB_WS_INPUT_IDENTIFIERS

1751: USER_ENTERED
1752: FROM EGO_PUB_WS_ENTITIES
1753: WHERE SESSION_ID = l_session_id;
1754:
1755: -- Get PKs, SYSTEM_CODE from EGO_PUB_WS_INPUT_IDENTIFIERS
1756: CURSOR c_input_identifier(l_session_id NUMBER, l_system_code VARCHAR2)
1757: IS
1758: SELECT SESSION_ID,
1759: INPUT_ID,

Line 1768: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

1764: PK2_VALUE,
1765: PK3_VALUE,
1766: PK4_VALUE,
1767: PK5_VALUE
1768: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
1769: WHERE SESSION_ID = l_session_id
1770: AND SYSTEM_CODE = l_system_code;
1771:
1772: -- Get ERROR_CODE, ERROR_MESSAGE from EGO_PUB_WS_ERRORS

Line 2002: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS

1998: END IF;
1999:
2000: END LOOP;
2001:
2002: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS
2003: -- using INPUT_ID, SESSION_ID, and SYSTEM_CODE
2004: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS
2005: -- and update records in global temporary table accordingly using PKs.
2006:

Line 2004: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS

2000: END LOOP;
2001:
2002: -- For each record in EGO_PUB_WS_ERRORS , join with EGO_PUB_WS_INPUT_IDENTIFIERS
2003: -- using INPUT_ID, SESSION_ID, and SYSTEM_CODE
2004: -- to retrieve PKs from EGO_PUB_WS_INPUT_IDENTIFIERS, and ERR_CODE and ERR_MESSAGE from EGO_PUB_WS_ERRORS
2005: -- and update records in global temporary table accordingly using PKs.
2006:
2007: IF (l_trigger_import = 'Y' OR l_trigger_import = 'TRUE') THEN
2008:

Line 2239: -- Get PKs, SYSTEM_CODE from EGO_PUB_WS_INPUT_IDENTIFIERS

2235: WHERE SESSION_ID = l_session_id
2236: AND PARAMETER_NAME = 'SYSTEM_CODE';
2237:
2238:
2239: -- Get PKs, SYSTEM_CODE from EGO_PUB_WS_INPUT_IDENTIFIERS
2240: CURSOR c_input_identifier(l_session_id NUMBER, l_system_code VARCHAR2)
2241: IS
2242: SELECT SESSION_ID,
2243: INPUT_ID,

Line 2252: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2248: PK2_VALUE,
2249: PK3_VALUE,
2250: PK4_VALUE,
2251: PK5_VALUE
2252: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2253: WHERE SESSION_ID = l_session_id
2254: AND SYSTEM_CODE = l_system_code;
2255:
2256: -- Get ERROR_CODE, ERROR_MESSAGE from EGO_PUB_WS_ERRORS

Line 2433: FROM EGO_PUB_WS_INPUT_IDENTIFIERS

2429: cp_input_id NUMBER,
2430: cp_system_code VARCHAR2)
2431: IS
2432: SELECT session_id, param_name,param_value
2433: FROM EGO_PUB_WS_INPUT_IDENTIFIERS
2434: WHERE session_id=cp_session_id
2435: AND input_id=cp_input_id
2436: AND system_code= cp_system_code;
2437: