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.FND_APP_SYSTEM dependencies on FND_TNS_ALIAS_ADDRESSES

Line 1161: l_rec fnd_tns_alias_addresses%rowtype;

1157: procedure register_tnsalias_address ( TNS_ALIAS_ADDRESS_LIST_GUID raw,
1158: Listener_port_GUID raw
1159: )
1160: as
1161: l_rec fnd_tns_alias_addresses%rowtype;
1162: l_insert boolean := false;
1163:
1164: begin
1165:

Line 1173: from fnd_tns_alias_addresses a

1169: begin
1170:
1171: select a.TNS_ALIAS_ADDRESS_LIST_GUID,a.Listener_port_GUID
1172: into l_rec.TNS_ALIAS_ADDRESS_LIST_GUID,l_rec.Listener_port_GUID
1173: from fnd_tns_alias_addresses a
1174: where a.TNS_ALIAS_ADDRESS_LIST_GUID = l_rec.TNS_ALIAS_ADDRESS_LIST_GUID
1175: and a.Listener_port_GUID = l_rec.Listener_port_GUID;
1176:
1177: exception

Line 1185: insert into fnd_tns_alias_addresses

1181:
1182: if ( l_insert )
1183: then
1184:
1185: insert into fnd_tns_alias_addresses
1186: (TNS_ALIAS_ADDRESS_LIST_GUID,Listener_port_GUID,
1187: last_updated_by,last_update_date,last_update_login,
1188: creation_date,created_by
1189: )

Line 1195: update fnd_tns_alias_addresses a

1191: l_rec.TNS_ALIAS_ADDRESS_LIST_GUID,l_rec.Listener_port_GUID,
1192: 1,sysdate,0,sysdate,1 );
1193: else
1194:
1195: update fnd_tns_alias_addresses a
1196: set a.Listener_port_GUID=nvl(l_rec.Listener_port_GUID,
1197: a.Listener_port_GUID),
1198: a.last_update_date = SYSDATE,
1199: a.last_updated_by = 1