APPS.FND_NET_SERVICES dependencies on FND_APPS_SYSTEM

Line 854: from fnd_apps_system a

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

Line 1725: from fnd_apps_system a

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

Line 2448: from fnd_apps_system

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

Line 2630: from fnd_apps_system a

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

Line 2779: from fnd_apps_system a

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

Line 2908: from fnd_apps_system a

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

Line 3017: from fnd_apps_system a

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

Line 3036: delete from fnd_apps_system a

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