APPS.FND_APP_SYSTEM dependencies on FND_ORACLE_HOMES

Line 71: l_rec fnd_oracle_homes%rowtype;

67: Description varchar2,
68: File_System_GUID raw,
69: Oracle_Home_Id raw default null )
70: as
71: l_rec fnd_oracle_homes%rowtype;
72: l_insert boolean := false;
73:
74: begin
75:

Line 90: from fnd_oracle_homes a

86: begin
87:
88: select a.Oracle_Home_Id
89: into l_rec.Oracle_Home_Id
90: from fnd_oracle_homes a
91: where a.node_id = l_rec.Node_Id
92: and a.path = l_rec.Path;
93: exception
94: when no_data_found then

Line 102: insert into fnd_oracle_homes

98:
99: if ( l_insert )
100: then
101:
102: insert into fnd_oracle_homes
103: (Oracle_Home_Id,name,Node_Id,Path,Version,
104: Description,File_System_GUID,
105: last_updated_by,last_update_date,last_update_login,
106: creation_date,created_by,created

Line 114: update fnd_oracle_homes a

110: l_rec.Description,nvl(l_rec.File_System_GUID,sys_guid()),
111: 1,sysdate,0,sysdate,1,sysdate );
112: else
113:
114: update fnd_oracle_homes a
115: set a.name = nvl(l_rec.Name,a.name),
116: a.node_id = nvl(l_rec.Node_Id,a.Node_Id),
117: a.path = nvl(l_rec.Path,a.path),
118: a.version = nvl(l_rec.Version,a.version),