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