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 HZ_ORIG_SYSTEMS_B

Line 951: -- Validates system code and system name in table HZ_ORIG_SYSTEMS_B

947: --Dbms_Output.put_line('FND_GLOBAL.Login_Id: ' || FND_GLOBAL.Login_Id);
948:
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:

Line 984: FROM hz_orig_systems_b where orig_system = l_temp;

980:
981: IF l_temp IS NOT NULL THEN
982: SELECT orig_system
983: INTO p_system_code
984: FROM hz_orig_systems_b where orig_system = l_temp;
985: ELSE
986: SELECT orig_system
987: INTO p_system_code
988: FROM hz_orig_systems_b where orig_system = upper(p_system_name);

Line 988: FROM hz_orig_systems_b where orig_system = upper(p_system_name);

984: FROM hz_orig_systems_b where orig_system = l_temp;
985: ELSE
986: SELECT orig_system
987: INTO p_system_code
988: FROM hz_orig_systems_b where orig_system = upper(p_system_name);
989: END IF;
990:
991: RETURN TRUE;
992:

Line 1286: -- trudave HZ_ORIG_SYSTEMS_B

1282:
1283:
1284: -- trudave following FOR LOOP is commented by me
1285: -- trudave because, if system is invalid, we need to write errors in ODI error tables and shoud not get any systems from
1286: -- trudave HZ_ORIG_SYSTEMS_B
1287:
1288: /*FOR i IN (SELECT orig_system FROM HZ_ORIG_SYSTEMS_B WHERE ( ( END_DATE_ACTIVE IS NULL OR TRUNC(END_DATE_ACTIVE) >=TRUNC(SYSDATE) )
1289: AND ( TRUNC(START_DATE_ACTIVE) <= TRUNC(SYSDATE) )
1290: AND ( STATUS = 'A' )

Line 1288: /*FOR i IN (SELECT orig_system FROM HZ_ORIG_SYSTEMS_B WHERE ( ( END_DATE_ACTIVE IS NULL OR TRUNC(END_DATE_ACTIVE) >=TRUNC(SYSDATE) )

1284: -- trudave following FOR LOOP is commented by me
1285: -- trudave because, if system is invalid, we need to write errors in ODI error tables and shoud not get any systems from
1286: -- trudave HZ_ORIG_SYSTEMS_B
1287:
1288: /*FOR i IN (SELECT orig_system FROM HZ_ORIG_SYSTEMS_B WHERE ( ( END_DATE_ACTIVE IS NULL OR TRUNC(END_DATE_ACTIVE) >=TRUNC(SYSDATE) )
1289: AND ( TRUNC(START_DATE_ACTIVE) <= TRUNC(SYSDATE) )
1290: AND ( STATUS = 'A' )
1291: AND ( CREATED_BY_MODULE LIKE 'EGO_%' ) ) )
1292: LOOP