APPS.FND_APP_SYSTEM dependencies on FND_TNS_ALIASES

Line 794: l_tns_alias_name fnd_tns_aliases.alias_name%type;

790: as
791: l_rec fnd_tns_listeners%rowtype;
792: l_insert boolean := false;
793: l_server_name fnd_app_servers.name%type;
794: l_tns_alias_name fnd_tns_aliases.alias_name%type;
795: l_alias_set_guid fnd_tns_alias_sets.tns_alias_set_guid%type;
796: l_alias_set_name fnd_tns_alias_sets.tns_alias_set_name%type;
797:
798: begin

Line 820: from fnd_tns_aliases a

816: begin
817:
818: select a.tns_alias_guid
819: into l_rec.tns_alias_guid
820: from fnd_tns_aliases a
821: where a.alias_name = l_tns_alias_name
822: and a.alias_set_guid = l_alias_set_guid;
823:
824: exception

Line 880: l_rec fnd_tns_aliases%rowtype;

876: TNS_ALIAS_GUID raw default null,
877: alias_set_name varchar2
878: )
879: as
880: l_rec fnd_tns_aliases%rowtype;
881: l_insert boolean := false;
882: l_tns_alias_set_name fnd_tns_alias_sets.tns_alias_set_name%type;
883:
884: begin

Line 905: from fnd_tns_aliases a

901: begin
902:
903: select a.TNS_ALIAS_GUID
904: into l_rec.TNS_ALIAS_GUID
905: from fnd_tns_aliases a
906: where a.alias_set_guid = l_rec.alias_set_guid
907: and a.alias_name = l_rec.alias_name;
908:
909: exception

Line 919: from fnd_tns_aliases a

915: begin
916:
917: select a.TNS_ALIAS_GUID
918: into l_rec.TNS_ALIAS_GUID
919: from fnd_tns_aliases a
920: where a.tns_alias_guid = l_rec.TNS_ALIAS_GUID;
921:
922: exception
923: when no_data_found then

Line 931: insert into fnd_tns_aliases

927:
928: if ( l_insert )
929: then
930:
931: insert into fnd_tns_aliases
932: (TNS_ALIAS_GUID,Alias_Name,Alias_set_guid,Alias_Type,
933: Failover,Load_Balance,
934: last_updated_by,last_update_date,last_update_login,
935: creation_date,created_by

Line 945: update fnd_tns_aliases a

941: l_rec.Load_Balance,
942: 1,sysdate,0,sysdate,1 );
943: else
944:
945: update fnd_tns_aliases a
946: set a.alias_name = nvl(l_rec.Alias_Name,a.alias_name),
947: a.alias_set_guid = nvl(l_rec.alias_set_GUID,a.alias_set_guid),
948: a.Alias_Type = nvl(l_rec.Alias_Type,a.Alias_Type),
949: a.Failover = nvl(l_rec.Failover,a.Failover),

Line 978: l_tns_alias_name fnd_tns_aliases.alias_name%type;

974: as
975: l_rec fnd_tns_alias_descriptions%rowtype;
976: l_insert boolean := false;
977: l_tns_alias_set_name fnd_tns_alias_sets.tns_alias_set_name%type;
978: l_tns_alias_name fnd_tns_aliases.alias_name%type;
979:
980: begin
981:
982: l_rec.TNS_ALIAS_DESCRIPTION_GUID := TNS_ALIAS_DESCRIPTION_GUID;

Line 997: from fnd_tns_alias_sets a, fnd_tns_aliases b

993: l_tns_alias_set_name := alias_set_name;
994:
995: select b.tns_alias_GUID
996: into l_rec.tns_alias_guid
997: from fnd_tns_alias_sets a, fnd_tns_aliases b
998: where a.tns_alias_set_name = l_tns_alias_set_name
999: and b.alias_set_guid = a.tns_alias_set_guid
1000: and b.alias_name = l_tns_alias_name;
1001: