1 PACKAGE csi_cz_int AUTHID CURRENT_USER AS
2 /* $Header: csigczis.pls 120.1 2005/10/25 17:58:21 srramakr noship $ */
3
4 TYPE config_query_record IS RECORD(
5 config_header_id number := fnd_api.g_miss_num,
6 config_revision_number number := fnd_api.g_miss_num);
7
8 TYPE config_query_table IS TABLE OF config_query_record INDEX BY BINARY_INTEGER;
9
10 TYPE config_pair_record IS RECORD(
11 subject_header_id number := fnd_api.g_miss_num,
12 subject_revision_number number := fnd_api.g_miss_num,
13 subject_item_id number := fnd_api.g_miss_num,
14 object_header_id number := fnd_api.g_miss_num,
15 object_revision_number number := fnd_api.g_miss_num,
16 object_item_id number := fnd_api.g_miss_num,
17 root_header_id number := fnd_api.g_miss_num,
18 root_revision_number number := fnd_api.g_miss_num,
19 root_item_id number := fnd_api.g_miss_num, -- added the keys for root,bug 3892929
20 -- sub_header_id_locked number := fnd_api.g_miss_num, -- added all the below for MACD locking, bug4147624
21 -- sub_item_id_locked number := fnd_api.g_miss_num,
22 -- sub_rev_num_locked number := fnd_api.g_miss_num,
23 -- obj_header_id_locked number := fnd_api.g_miss_num,
24 -- obj_item_id_locked number := fnd_api.g_miss_num,
25 -- obj_rev_num_locked number := fnd_api.g_miss_num,
26 source_application_id number := fnd_api.g_miss_num,
27 source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
28 source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
29 source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
30 source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
31 lock_id number := fnd_api.g_miss_num,
32 lock_status number := fnd_api.g_miss_num);
33
34 TYPE config_pair_table IS TABLE OF config_pair_record INDEX BY BINARY_INTEGER;
35
36 -- used for outputing in generate_config_trees and add_to_config_tree procedures
37 TYPE config_model_rec_type IS RECORD
38 (
39 inventory_item_id NUMBER,
40 organization_id NUMBER,
41 config_hdr_id NUMBER,
42 config_rev_nbr NUMBER,
43 config_item_id NUMBER
44 );
45 TYPE config_model_tbl_type IS TABLE OF config_model_rec_type INDEX BY BINARY_INTEGER;
46
47 -- Added the following rec structure for the Item Instance Locking, Bug 4147624
48 TYPE config_rec IS RECORD(
49 source_application_id number := fnd_api.g_miss_num,
50 source_txn_header_ref varchar2(30) := fnd_api.g_miss_char,
51 source_txn_line_ref1 varchar2(30):= fnd_api.g_miss_char,
52 source_txn_line_ref2 varchar2(30):= fnd_api.g_miss_char,
53 source_txn_line_ref3 varchar2(30):= fnd_api.g_miss_char,
54 instance_id number := fnd_api.g_miss_num,
55 lock_id number := fnd_api.g_miss_num,
56 lock_status number := fnd_api.g_miss_num,
57 config_inst_hdr_id number := fnd_api.g_miss_num,
58 config_inst_item_id number := fnd_api.g_miss_num,
59 config_inst_rev_num number := fnd_api.g_miss_num);
60
61 TYPE config_tbl IS TABLE OF config_rec INDEX BY BINARY_INTEGER;
62
63 PROCEDURE get_configuration_revision(
64 p_config_header_id IN number,
65 p_target_commitment_date IN date,
66 px_instance_level IN OUT NOCOPY varchar2,
67 x_install_config_rec OUT NOCOPY config_rec,-- Bug 4147624, item instance locking. The config keys in the rec
68 x_return_status OUT NOCOPY varchar2, -- would actually correspond to values of the Installed Root
69 x_return_message OUT NOCOPY varchar2);
70
71 PROCEDURE get_connected_configurations(
72 p_config_query_table IN config_query_table,
73 p_instance_level IN varchar2,
74 x_config_pair_table OUT NOCOPY config_pair_table,
75 x_return_status OUT NOCOPY varchar2,
76 x_return_message OUT NOCOPY varchar2);
77
78 PROCEDURE configure_from_html_ui(
79 p_session_hdr_id IN number,
80 p_instance_id IN number,
81 -- Added the following 3 parameters for Bug 3711457
82 p_session_rev_num_old IN number,
83 p_session_rev_num_new IN number,
84 p_action IN varchar2,
85 x_error_message OUT NOCOPY varchar2,
86 x_return_status OUT NOCOPY varchar2,
87 x_msg_count OUT NOCOPY number,
88 x_msg_data OUT NOCOPY varchar2);
89
90 ----------------------------------------------------------------------------------
91 -- API name : CSI_CONFIG_LAUNCH_PRMS
92 -- Package Name: CSI_JAVA_INTERFACE_PKG
93 -- Type : Public
94 -- Pre-reqs : None
95 -- Function: Returns the parameters necessary for launching the CZ configurator.
96 -- Version : Current version 1.0
97 -- Initial version 1.0
98
99 Procedure CSI_CONFIG_LAUNCH_PRMS
100 ( p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
102 p_commit IN VARCHAR2 := FND_API.g_false,
103 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 x_configurable OUT NOCOPY VARCHAR2,
108 x_icx_sessn_tkt OUT NOCOPY VARCHAR2,
109 x_db_id OUT NOCOPY VARCHAR2,
110 x_servlet_url OUT NOCOPY VARCHAR2,
111 x_sysdate OUT NOCOPY VARCHAR2
112 );
113
114 ----------------------------------------------------------------------------------
115 -- API name : is_configurable
116 -- Package Name: CSI_JAVA_INTERFACE_PKG
117 -- Type : Public
118 -- Pre-reqs : None
119 -- Function: Checks whether a config item is independently configurable or not.
120 -- Version : Current version 1.0
121 -- Initial version 1.0
122 -- Parameters:
123 -- IN: p_api_version (required), standard IN parameter
124 -- p_config_hdr_id (required), config_hdr_id of an instance
125 -- IN: p_config_hdr_id (required), config_hdr_id of an instance
126 -- p_config_hdr_id (required), config_hdr_id of an instance
127 -- p_config_rev_nbr (required), config_rev_nbr of an instance
128 -- p_config_item_id (required), config_item_id of an instance item
129 -- OUT: x_return_value, has one of the following values FND_API.G_TRUE,
130 -- FND_API.G_FALSE,NULL
131 -- x_return_status, standard out parameter (see generate_config_trees)
132 -- x_msg_count, standard out parameter
133 -- x_msg_data, standard out parameter
134
135 PROCEDURE IS_CONFIGURABLE(p_api_version IN NUMBER
136 ,p_config_hdr_id IN NUMBER
137 ,p_config_rev_nbr IN NUMBER
138 ,p_config_item_id IN NUMBER
139 ,x_return_value OUT NOCOPY VARCHAR2
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2
143 );
144
145
146 -------------------------------------------------------------------
147 ---Start of comments
148 ---API name : generate_config_trees
149 ---Type : Public
150 ---Pre-reqs : None
151 ---Function : calls CZ_NETWORK_API_PUB.generate_conig_trees
152 ---Parameters :
153 ---IN : p_api_version IN NUMBER Required
154 --- p_tree_copy_mode IN VARCHAR2 Required
155 --- p_validation_context IN VARCHAR2 Required
156 ---OUT :
157 --- : x_return_status OUT VARCHAR2
158 --- x_msg_count OUT NUMBER
159 --- x_msg_data OUT VARCHAR2
160 ---Version: Current version :1.0
161 ---End of comments
162
163 PROCEDURE generate_config_trees(p_api_version IN NUMBER,
164 p_config_query_table IN config_query_table,
165 p_tree_copy_mode IN VARCHAR2,
166 x_cfg_model_tbl OUT NOCOPY config_model_tbl_type,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2
170 );
171
172 -- Added the following new API's for the Item Instance Locking, Bug 4147624
173
174 Function check_item_instance_lock (
175 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
176 p_config_rec IN config_rec,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2)
180 RETURN BOOLEAN;
181
182 PROCEDURE lock_item_instances(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
185 p_commit IN VARCHAR2 := FND_API.g_false,
186 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
187 px_config_tbl IN OUT NOCOPY config_tbl,
188 x_return_status OUT NOCOPY varchar2,
189 x_msg_count OUT NOCOPY NUMBER,
190 x_msg_data OUT NOCOPY VARCHAR2 );
191
192 PROCEDURE Unlock_Current_Node(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
195 p_commit IN VARCHAR2 := FND_API.g_false,
196 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
197 p_config_rec IN config_rec,
198 x_conn_config_tbl OUT NOCOPY config_tbl,
199 x_return_status OUT NOCOPY varchar2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2 );
202
203 PROCEDURE unlock_item_instances(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
206 p_commit IN VARCHAR2 := FND_API.g_false,
207 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
208 p_config_tbl IN config_tbl,
209 x_return_status OUT NOCOPY varchar2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2 );
212
213 END csi_cz_int;