APPS.FND_APP_SYSTEM dependencies on FND_TNS_ALIAS_ADDRESS_LISTS

Line 1081: l_rec fnd_tns_alias_address_lists%rowtype;

1077: TNS_ALIAS_ADDRESS_LIST_GUID
1078: raw default null
1079: )
1080: as
1081: l_rec fnd_tns_alias_address_lists%rowtype;
1082: l_insert boolean := false;
1083:
1084: begin
1085:

Line 1099: from fnd_tns_alias_address_lists a

1095: begin
1096:
1097: select a.TNS_ALIAS_ADDRESS_LIST_GUID,a.TNS_ALIAS_DESCRIPTION_GUID
1098: into l_rec.TNS_ALIAS_ADDRESS_LIST_GUID,l_rec.TNS_ALIAS_DESCRIPTION_GUID
1099: from fnd_tns_alias_address_lists a
1100: where a.TNS_ALIAS_DESCRIPTION_GUID = l_rec.TNS_ALIAS_DESCRIPTION_GUID
1101: and a.sequence_number = l_rec.Sequence_Number;
1102:
1103: exception

Line 1115: from fnd_tns_alias_address_lists a

1111: begin
1112:
1113: select a.TNS_ALIAS_ADDRESS_LIST_GUID,a.TNS_ALIAS_DESCRIPTION_GUID
1114: into l_rec.TNS_ALIAS_ADDRESS_LIST_GUID,l_rec.TNS_ALIAS_DESCRIPTION_GUID
1115: from fnd_tns_alias_address_lists a
1116: where a.TNS_ALIAS_ADDRESS_LIST_GUID = l_rec.TNS_ALIAS_ADDRESS_LIST_GUID;
1117:
1118: exception
1119: when no_data_found then

Line 1128: insert into fnd_tns_alias_address_lists

1124:
1125: if ( l_insert )
1126: then
1127:
1128: insert into fnd_tns_alias_address_lists
1129: (TNS_ALIAS_ADDRESS_LIST_GUID,TNS_ALIAS_DESCRIPTION_GUID,
1130: Sequence_Number,Failover,Load_Balance,
1131: last_updated_by,last_update_date,last_update_login,
1132: creation_date,created_by

Line 1143: update fnd_tns_alias_address_lists a

1139: l_rec.Load_Balance,
1140: 1,sysdate,0,sysdate,1 );
1141: else
1142:
1143: update fnd_tns_alias_address_lists a
1144: set a.Failover = nvl(l_rec.Failover,a.Failover),
1145: a.Load_Balance=nvl(l_rec.Load_Balance,a.Load_Balance),
1146: a.sequence_number=nvl(l_rec.Sequence_Number,a.sequence_number),
1147: a.last_update_date = SYSDATE,