APPS.FND_APP_SYSTEM dependencies on FND_TNS_ALIAS_SETS

Line 795: l_alias_set_guid fnd_tns_alias_sets.tns_alias_set_guid%type;

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
799:

Line 796: l_alias_set_name fnd_tns_alias_sets.tns_alias_set_name%type;

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
799:
800: l_rec.Listener_GUID := Listener_GUID;

Line 813: from fnd_tns_alias_sets a

809: where a.name = l_server_name;
810:
811: select a.tns_alias_set_guid
812: into l_alias_set_guid
813: from fnd_tns_alias_sets a
814: where a.tns_alias_set_name = l_alias_set_name;
815:
816: begin
817:

Line 882: l_tns_alias_set_name fnd_tns_alias_sets.tns_alias_set_name%type;

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
885:
886: l_rec.TNS_ALIAS_GUID := TNS_ALIAS_GUID;

Line 896: from fnd_tns_alias_sets a

892: l_tns_alias_set_name := alias_set_name;
893:
894: select a.tns_alias_set_GUID
895: into l_rec.alias_set_guid
896: from fnd_tns_alias_sets a
897: where a.tns_alias_set_name = l_tns_alias_set_name;
898:
899: if ( l_rec.TNS_ALIAS_GUID is null )
900: then

Line 977: l_tns_alias_set_name fnd_tns_alias_sets.tns_alias_set_name%type;

973: )
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:

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:

Line 1478: l_rec fnd_tns_alias_sets%rowtype;

1474:
1475: procedure register_tnsalias_sets ( Alias_set_Name varchar2,
1476: Alias_set_type varchar2 )
1477: as
1478: l_rec fnd_tns_alias_sets%rowtype;
1479: l_insert boolean := false;
1480:
1481: begin
1482:

Line 1490: from fnd_tns_alias_sets a

1486: begin
1487:
1488: select tns_alias_set_guid
1489: into l_rec.tns_alias_set_guid
1490: from fnd_tns_alias_sets a
1491: where a.tns_alias_set_name = l_rec.tns_alias_set_name;
1492:
1493: exception
1494: when no_data_found then

Line 1501: insert into fnd_tns_alias_sets

1497:
1498: if ( l_insert )
1499: then
1500:
1501: insert into fnd_tns_alias_sets
1502: (TNS_ALIAS_SET_GUID,tns_Alias_set_name,tns_Alias_set_type,
1503: last_updated_by,last_update_date,last_update_login,
1504: creation_date,created_by
1505: )

Line 1511: update fnd_tns_alias_sets a

1507: sys_guid(),l_rec.tns_Alias_set_Name,l_rec.tns_alias_set_type,
1508: 1,sysdate,0,sysdate,1 );
1509: else
1510:
1511: update fnd_tns_alias_sets a
1512: set a.tns_alias_set_name = nvl(l_rec.tns_Alias_set_Name,
1513: a.tns_alias_set_name),
1514: a.tns_alias_set_type = nvl(l_rec.tns_alias_set_type,
1515: a.tns_alias_set_type),