1 PACKAGE fnd_app_server_pkg AUTHID CURRENT_USER AS
2 /* $Header: AFSCASRS.pls 120.3.12010000.3 2010/01/29 16:25:56 pdeluna ship $ */
3
4 /* create_server_id
5 **
6 ** Returns a new unique server_id. The server_id is a string of 64 characters.
7 ** The 1st 32 is a globally unique id and the next 32 is a randomnly
8 ** generated number. This is called by AdminAppServer.createServerId().
9 */
10 FUNCTION create_server_id RETURN VARCHAR2;
11
12 /* get_server_id
13 **
14 ** Returns the server_id given a unique node_name or server_address. This API is
15 ** biased towards the unique node_name. The server_address is used only when the
16 ** node_name cannot be used. server_id can be null if the node has been
17 ** deleted" using delete_server or delete_desktop_server.
18 */
19 FUNCTION get_server_id(
20 p_node_name IN VARCHAR2 DEFAULT NULL,
21 p_address IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
22
23 /* insert_server
24 **
25 ** Inserts information for a new Application Server. The function
26 ** create_server_id must be called to generate a valid id prior to
27 ** calling this api. This is called by AdminAppServer.changeServerInDB().
28 */
29 PROCEDURE insert_server(
30 p_server_id IN OUT NOCOPY VARCHAR2,
31 p_address IN VARCHAR2,
32 p_node_name IN VARCHAR2,
33 p_description IN VARCHAR2 DEFAULT NULL,
34 p_webhost IN VARCHAR2 DEFAULT NULL,
35 p_platform_code IN VARCHAR2 DEFAULT NULL,
36 p_support_cp IN VARCHAR2 DEFAULT NULL,
37 p_support_forms IN VARCHAR2 DEFAULT NULL,
38 p_support_web IN VARCHAR2 DEFAULT NULL,
39 p_support_admin IN VARCHAR2 DEFAULT NULL,
40 p_support_db IN VARCHAR2 DEFAULT NULL);
41
42 /* delete_server
43 **
44 ** This procedure used to remove an Application Server row from the database.
45 ** Due to the migration of FND_APPLICATION_SERVERS to FND_NODES,
46 ** fnd_nodes.server_id is nulled out instead in order to preserve the
47 ** node_name and avoid dangling references to the node_name. This is called by
48 ** AdminAppServer.delSvrFromDB().
49 */
50 PROCEDURE delete_server(p_address IN VARCHAR2);
51
52 /* update_server
53 **
54 ** This procedure should only be used for updating Application Server Nodes.
55 ** The server_id, description, host and domain are updated if they are not
56 ** NULL. If a new server_id is required, the create_server_id function should
57 ** be called prior to this. This is called by
58 ** AdminAppServer.changeServerInDB().
59 */
60 PROCEDURE update_server(
61 p_server_id IN VARCHAR2 DEFAULT NULL,
62 p_address IN VARCHAR2,
63 p_description IN VARCHAR2 DEFAULT NULL,
64 p_webhost IN VARCHAR2 DEFAULT NULL,
65 p_platform IN VARCHAR2 DEFAULT NULL);
66
67 /* authenticate
68 **
69 ** This procedure is used to turn toggle AUTHENTICATION for an Application
70 ** Server Node. If the AUTHENTICATION row does not exist yet, the procedure
71 ** will insert it. The row with server_address='*' indicates the authentication
72 ** value. If the row already exists, the procedure updates the value to what
73 ** has been passed. The valid AUTHENTICATION values are:
74 ** 'ON'
75 ** 'OFF'
76 ** 'SECURE'
77 ** This is called by AdminAppServer.setAuthentication().
78 **
79 ** Bug 3736714: the p_platform argument was added so that the authentication
80 ** row can be added with the correct platform. The platform is determined in
81 ** AdminAppServer.java.
82 */
83 PROCEDURE authenticate(
84 p_value IN OUT NOCOPY VARCHAR2,
85 p_platformcode IN VARCHAR2 DEFAULT NULL);
86
87 /* insert_desktop_server
88 **
89 ** This API is used for Desktop Nodes only.
90 ** It calls insert_server and sets all the SUPPORT_* collumns to 'N' and the
91 ** PLATFORM_CODE to 'Others'. It also places 'Desktop Node' as the description
92 ** if NULL was passed.
93 */
94 PROCEDURE insert_desktop_server(
95 p_node_name IN VARCHAR2,
96 p_server_id IN OUT NOCOPY VARCHAR2,
97 p_address IN VARCHAR2 DEFAULT NULL,
98 p_description IN VARCHAR2 DEFAULT NULL);
99
100 /* update_desktop_server
101 **
102 ** This API is used for Desktop Nodes only.
103 ** Update the FND_NODES row associated with p_node_name with the specified
104 ** values for server_id, address, and description. If NULLs are passed, do not
105 ** update. update_server cannot be used here because it uses p_address as the
106 ** where condition.
107 */
108 PROCEDURE update_desktop_server(
109 p_node_name IN VARCHAR2,
110 p_server_id IN VARCHAR2 DEFAULT NULL,
111 p_address IN VARCHAR2 DEFAULT NULL,
112 p_description IN VARCHAR2 DEFAULT NULL);
113
114 /* delete_desktop_server
115 **
116 ** This API is used for Desktop Nodes only.
117 ** Similar to delete_server, server_id is NULLed out, the row is not physically
118 ** deleted.
119 */
120 PROCEDURE delete_desktop_server (p_node_name IN VARCHAR2);
121
122 END fnd_app_server_pkg;
[Home] [Help]