APPS.FND_APP_SYSTEM dependencies on FND_TNS_LISTENER_PORTS

Line 1418: l_rec fnd_tns_listener_ports%rowtype;

1414: Port number,
1415: server_guid raw,
1416: Listener_Port_Guid raw default null)
1417: as
1418: l_rec fnd_tns_listener_ports%rowtype;
1419: l_insert boolean := false;
1420: l_listener_name fnd_tns_listeners.listener_name%type;
1421: l_server_guid fnd_tns_listeners.server_guid%type;
1422: begin

Line 1442: from fnd_tns_listener_ports a

1438: begin
1439:
1440: select a.listener_port_guid
1441: into l_rec.listener_port_guid
1442: from fnd_tns_listener_ports a
1443: where a.listener_guid = l_rec.listener_GUID
1444: and a.port = l_rec.Port;
1445:
1446: exception

Line 1455: insert into fnd_tns_listener_ports

1451: end if;
1452:
1453: if ( l_insert )
1454: then
1455: insert into fnd_tns_listener_ports
1456: (Listener_Port_GUID,Listener_GUID,Protocol,Port,
1457: Created_By,Creation_Date,
1458: Last_Updated_By,Last_Update_Date,Last_Update_Login)
1459: values (sys_guid(),l_rec.Listener_guid,fnd_app_system.c_protocol_tcp,

Line 1463: update fnd_tns_listener_ports a

1459: values (sys_guid(),l_rec.Listener_guid,fnd_app_system.c_protocol_tcp,
1460: l_rec.Port,1,sysdate,1,sysdate,0 );
1461: else
1462:
1463: update fnd_tns_listener_ports a
1464: set a.port = nvl(l_rec.Port,a.port),
1465: a.last_update_date = SYSDATE,
1466: a.last_updated_by = 1
1467: where a.Listener_port_GUID = l_rec.Listener_port_GUID;