DBA Data[Home] [Help]

APPS.FND_APP_SYSTEM dependencies on FND_TNS_ALIAS_SET_USAGE

Line 1530: l_rec fnd_tns_alias_set_usage%rowtype;

1526: procedure register_aliasset_usage ( TNS_ALIAS_set_GUID raw,
1527: server_guid raw
1528: )
1529: as
1530: l_rec fnd_tns_alias_set_usage%rowtype;
1531: l_insert boolean := false;
1532:
1533: begin
1534:

Line 1542: from fnd_tns_alias_set_usage a

1538: begin
1539:
1540: select a.TNS_ALIAS_set_GUID,a.server_guid
1541: into l_rec.TNS_ALIAS_set_GUID,l_rec.server_guid
1542: from fnd_tns_alias_set_usage a
1543: where a.TNS_ALIAS_set_GUID = l_rec.TNS_ALIAS_set_GUID
1544: and a.server_guid = l_rec.server_guid;
1545:
1546: exception

Line 1554: insert into fnd_tns_alias_set_usage

1550:
1551: if ( l_insert )
1552: then
1553:
1554: insert into fnd_tns_alias_set_usage
1555: (TNS_ALIAS_set_guid,server_guid,
1556: last_updated_by,last_update_date,last_update_login,
1557: creation_date,created_by
1558: )

Line 1564: update fnd_tns_alias_set_usage a

1560: l_rec.TNS_ALIAS_set_GUID,l_rec.server_guid,
1561: 1,sysdate,0,sysdate,1 );
1562: else
1563:
1564: update fnd_tns_alias_set_usage a
1565: set a.server_guid=nvl(l_rec.server_guid,a.server_guid),
1566: a.last_update_date = SYSDATE,
1567: a.last_updated_by = 1
1568: where a.TNS_ALIAS_set_GUID = l_rec.TNS_ALIAS_set_GUID