APPS.FND_NET_SERVICES dependencies on FND_APPS_SYSTEM

Line 856: from fnd_apps_system a

852: system_guid => null);
853:
854: select a.System_Guid
855: into l_System_Guid
856: from fnd_apps_system a
857: where a.name = SystemName;
858:
859: l_node_name := buildNodeName( p_host_name => HostName,
860: p_domain => Domain,

Line 1727: from fnd_apps_system a

1723: System_guid=>null);
1724:
1725: select a.System_Guid
1726: into l_System_Guid
1727: from fnd_apps_system a
1728: where a.name = SystemName;
1729:
1730: l_node_name := buildNodeName( p_host_name => HostName,
1731: p_domain => Domain,

Line 2450: from fnd_apps_system

2446:
2447: procedure show ( SystemName in varchar2)
2448: as
2449: cursor c1 is select name,Version,Owner,CSI_Number,System_GUID
2450: from fnd_apps_system
2451: where name = SystemName;
2452:
2453: cursor c2(p_System_Guid raw)
2454: is select a.Server_GUID,a.name,a.Node_Id,a.Internal,a.Appl_Top_Guid,

Line 2632: from fnd_apps_system a

2628: -- Always lock the system when doing major structural changes.
2629:
2630: cursor c1(p_SystemName varchar2) is
2631: select a.System_Guid
2632: from fnd_apps_system a
2633: where a.name = p_SystemName
2634: for update of a.System_Guid;
2635:
2636: cursor c2(p_System_GUID raw, p_ServerName varchar2) is

Line 2781: from fnd_apps_system a

2777: -- Always lock the system when doing major structural changes.
2778:
2779: cursor c1(p_SystemName varchar2) is
2780: select a.System_Guid
2781: from fnd_apps_system a
2782: where a.name = p_SystemName
2783: for update of a.System_Guid;
2784:
2785: cursor c2(p_System_GUID raw, p_ServerName varchar2) is

Line 2910: from fnd_apps_system a

2906: -- Always lock the system when doing major structural changes.
2907:
2908: cursor c1(p_SystemName varchar2) is
2909: select a.System_Guid
2910: from fnd_apps_system a
2911: where a.name = p_SystemName
2912: for update of a.System_Guid;
2913:
2914: cursor c2(p_System_GUID raw, p_ServerName varchar2) is

Line 3019: from fnd_apps_system a

3015: -- Always lock the system when doing major structural changes.
3016:
3017: cursor c1(p_SystemName varchar2) is
3018: select a.System_Guid
3019: from fnd_apps_system a
3020: where a.name = p_SystemName
3021: for update of a.System_Guid;
3022:
3023: cursor c2(p_System_GUID raw) is

Line 3038: delete from fnd_apps_system a

3034: remove_Server(SystemName,f_server.Name);
3035:
3036: end loop;
3037:
3038: delete from fnd_apps_system a
3039: where a.System_GUID = f_system.System_Guid ;
3040:
3041: end loop;
3042: