APPS.FND_APP_SYSTEM dependencies on FND_APPL_TOPS

Line 138: l_rec fnd_appl_tops%rowtype;

134: Shared varchar2,
135: File_System_GUID raw,
136: Appl_Top_Guid raw default null )
137: as
138: l_rec fnd_appl_tops%rowtype;
139: l_insert boolean := false;
140:
141: begin
142:

Line 156: from fnd_appl_tops a

152: begin
153:
154: select a.appl_top_guid
155: into l_rec.Appl_Top_Guid
156: from fnd_appl_tops a
157: where a.node_id = l_rec.Node_Id
158: and a.path = l_rec.Path;
159:
160: exception

Line 169: insert into fnd_appl_tops

165:
166: if ( l_insert )
167: then
168:
169: insert into fnd_appl_tops
170: (appl_top_guid,name,Node_Id,Path,Shared,File_System_GUID,
171: last_updated_by,last_update_date,last_update_login,
172: creation_date,created_by
173: )

Line 179: update fnd_appl_tops a

175: l_rec.Shared,nvl(l_rec.File_System_GUID,sys_guid()),
176: 1,sysdate,0,sysdate,1 );
177: else
178:
179: update fnd_appl_tops a
180: set a.name = nvl(l_rec.Name,a.name),
181: a.node_id = nvl(l_rec.Node_Id,a.Node_Id),
182: a.path = nvl(l_rec.Path,a.path),
183: a.shared = nvl(l_rec.shared,a.shared),