APPS.FND_APP_SYSTEM dependencies on FND_APPS_SYSTEM

Line 12: l_rec fnd_apps_system%rowtype;

8: CSI_NUMBER varchar2,
9: System_Guid raw default null
10: )
11: as
12: l_rec fnd_apps_system%rowtype;
13: l_insert boolean := false;
14:
15: begin
16:

Line 28: from fnd_apps_system a

24: begin
25:
26: select a.System_Guid
27: into l_rec.System_Guid
28: from fnd_apps_system a
29: where a.name = l_rec.Name;
30:
31: exception
32: when no_data_found then

Line 39: insert into fnd_apps_system

35: end if;
36:
37: if ( l_insert )
38: then
39: insert into fnd_apps_system
40: (name,Version,Owner,CSI_Number,System_GUID,Source_System_Guid,
41: last_updated_by,last_update_date,last_update_login,
42: creation_date,created_by
43: )

Line 49: update fnd_apps_system a

45: sys_guid(),
46: 1,sysdate,0,sysdate,1 );
47: else
48:
49: update fnd_apps_system a
50: set a.name = nvl(l_rec.Name,a.name),
51: a.owner= nvl(l_rec.Owner,a.owner),
52: a.csi_number=nvl(l_rec.CSI_NUMBER,a.csi_number),
53: a.last_update_date = SYSDATE,