[Home] [Help]
PACKAGE: APPS.FND_APP_SYSTEM
Source
1 package FND_APP_SYSTEM as
2 /* $Header: AFCPSYSS.pls 120.2 2005/12/19 09:49:31 ssuraj noship $ */
3
4 C_DB_SERVER_TYPE constant varchar2(20) := 'DB';
5 C_APP_SERVER_TYPE constant varchar2(20) := 'APPS';
6 C_APP_DB_ASSIGNMENT constant varchar2(20) := 'APPS';
7
8 C_FNDFS_TNS_ALIAS_TYPE constant varchar2(20) := 'FNDFS';
9 C_FNDSM_TNS_ALIAS_TYPE constant varchar2(20) := 'FNDSM';
10 C_DB_BALANCE_TNS_ALIAS_TYPE
11 constant varchar2(20) := 'DB-LOAD-BAL';
12 C_DB_INST_TNS_ALIAS_TYPE
13 constant varchar2(20) := 'DB-INST';
14 C_LOCAL_INST_TNS_ALIAS_TYPE
15 constant varchar2(20) := 'LOCAL';
16 C_REMOTE_INST_TNS_ALIAS_TYPE
17 constant varchar2(20) := 'REMOTE';
18
19 C_APPS_LISTENER_ID constant varchar2(20) := 'APPS';
20
21 C_LOCAL_ALIAS_ID constant varchar2(20) := 'LOCAL';
22 C_REMOTE_ALIAS_ID constant varchar2(20) := 'REMOTE';
23 C_BALANCE_ALIAS_ID constant varchar2(20) := 'BALANCE';
24 C_806_BALANCE_ALIAS_ID constant varchar2(20) := '806_BALANCE';
25 C_FAILOVER_ALIAS_ID constant varchar2(20) := 'FO';
26 C_PROTOCOL_TCP constant varchar2(20) := 'TCP';
27 C_ALIAS_SET_NAME_PUB constant varchar2(20) := 'PUBLIC';
28 C_ALIAS_SET_NAME_INT constant varchar2(20) := 'INTERNAL';
29
30 C_PREFERRED_INSTANCE constant varchar2(20) := 'P';
31 C_AVAILABLE_INSTANCE constant varchar2(20) := 'A';
32
33 procedure register_system ( name varchar2,
34 owner varchar2,
35 CSI_NUMBER varchar2,
36 System_Guid raw default null
37 );
38
39 procedure register_node( name varchar2,
40 platform_id number,
41 forms_tier varchar2,
42 cp_tier varchar2,
43 web_tier varchar2,
44 admin_tier varchar2,
45 p_server_id varchar2,
46 p_address varchar2,
47 p_description varchar2,
48 p_host_name varchar2,
49 p_domain varchar2,
50 db_tier varchar2,
51 p_virtual_ip varchar2 default null);
52
53 procedure register_oraclehome ( name varchar2,
54 Node_Id varchar2,
55 Path varchar2,
56 Version varchar2,
57 Description varchar2,
58 File_System_GUID raw,
59 Oracle_Home_Id raw default null );
60
61 procedure register_appltop ( name varchar2,
62 Node_Id varchar2,
63 Path varchar2,
64 Shared varchar2,
65 File_System_GUID raw,
66 Appl_Top_Guid raw default null );
67
68 procedure register_server ( Name varchar2,
69 Node_Id varchar2,
70 Internal varchar2,
71 Appl_Top_Guid raw,
72 Server_type varchar2,
73 Pri_Oracle_Home raw,
74 Aux_Oracle_Home raw,
75 Server_GUID raw default null );
76
77 procedure register_servermap ( Server_GUID raw,
78 System_Guid raw );
79
80 procedure register_database ( db_name varchar2,
81 db_domain varchar2,
82 Default_TNS_Alias_Guid raw,
83 Is_Rac_db varchar2,
84 Version varchar2,
85 db_guid raw default null
86 );
87
88 procedure register_database_asg( db_name varchar2,
89 assignment varchar2,
90 db_domain varchar2
91 );
92
93 procedure register_instance ( db_name varchar2,
94 Instance_Name varchar2,
95 Instance_Number Number,
96 Sid_GUID raw,
97 Sid varchar2,
98 Default_TNS_Alias_GUID raw,
99 Server_GUID raw,
100 Local_Listener_Alias raw,
101 Remote_Listener_Alias raw,
102 Configuration varchar2,
103 Description varchar2,
104 Interconnect_name varchar2,
105 Instance_Guid raw default null,
106 db_domain varchar2
107 ) ;
108
109 procedure register_sid ( Sid varchar2 ,
110 sid_guid raw
111 ) ;
112
113 procedure register_service ( Service_name varchar2,
114 db_name varchar2,
115 db_domain varchar2,
116 Description varchar2,
117 db_service_guid raw default null
118 );
119
120 procedure register_service_members ( db_name varchar2,
121 Instance_name varchar2,
122 Instance_type varchar2,
123 db_service_guid raw default null,
124 db_domain varchar2
125 );
126
127 procedure register_listener ( Listener_Name varchar2,
128 Server_name varchar2,
129 tns_alias_name varchar2,
130 Listener_GUID raw default null,
131 alias_set_name varchar2
132 );
133
134 procedure register_tnsalias ( Alias_Name varchar2,
135 Alias_Type varchar2,
136 Failover varchar2,
137 Load_Balance varchar2,
138 TNS_ALIAS_GUID raw default null,
139 alias_set_name varchar2
140 );
141
142 procedure register_tns_description
143 ( alias_set_name varchar2,
144 Alias_Name varchar2,
145 Sequence_Number number default null,
146 Failover varchar2,
147 Load_Balance varchar2,
148 Service_GUID raw,
149 Instance_Guid raw,
150 Service_Name varchar2,
151 Instance_Name varchar2,
152 TNS_ALIAS_DESCRIPTION_GUID
153 raw default null
154 );
155
156 procedure register_tns_address_list
157 ( TNS_ALIAS_DESCRIPTION_GUID
158 raw,
159 Sequence_Number number default null,
160 Failover varchar2,
161 Load_Balance varchar2,
162 TNS_ALIAS_ADDRESS_LIST_GUID
163 raw default null
164 );
165
166 procedure register_tnsalias_address ( TNS_ALIAS_ADDRESS_LIST_GUID raw,
167 Listener_port_GUID raw
168 );
169
170 procedure register_listener_ports (Listener_Name varchar2,
171 Port number,
172 server_guid raw,
173 Listener_Port_Guid raw default null
174 );
175
176 procedure register_tnsalias_sets ( Alias_set_Name varchar2,
177 Alias_set_type varchar2 );
178
179 procedure register_aliasset_usage ( TNS_ALIAS_set_GUID raw,
180 server_guid raw
181 ) ;
182
183
184 end FND_APP_SYSTEM ;