[Home] [Help]
PACKAGE: APPS.JTS_CONFIG_VERSION_PVT
Source
1 PACKAGE JTS_CONFIG_VERSION_PVT AUTHID CURRENT_USER as
2 /* $Header: jtsvcvrs.pls 115.6 2002/04/10 18:10:22 pkm ship $ */
3
4
5 -----------------------------------------------------------
6 -- PACKAGE
7 -- JTS_CONFIG_VERSION_PVT
8 --
9 -- PURPOSE
10 -- Private API for Oracle Setup Online Configuration Management
11 --
12 -- PROCEDURES
13 --
14 ------------------------------------------------------------
15
16 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTS_CONFIG_VERSION_PVT';
17 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtsvcvrb.pls';
18
19 C_QUEUE_PREFIX CONSTANT Varchar2(30) := 'JTSCONFIGXMLAQ';
20
21 --For Version Summary and Version Details pages
22 TYPE Config_Version_Rec_Type IS RECORD (
23 configuration_id NUMBER,
24 version_id NUMBER,
25 version_name VARCHAR2(80),
26 version_number NUMBER,
27 description VARCHAR2(240),
28
29 queue_name VARCHAR2(30),
30 attribute_category VARCHAR2(150),
31 attribute1 VARCHAR2(150),
32 attribute2 VARCHAR2(150),
33 attribute3 VARCHAR2(150),
34 attribute4 VARCHAR2(150),
35 attribute5 VARCHAR2(150),
36 attribute6 VARCHAR2(150),
37 attribute7 VARCHAR2(150),
38 attribute8 VARCHAR2(150),
39 attribute9 VARCHAR2(150),
40 attribute10 VARCHAR2(150),
41 attribute11 VARCHAR2(150),
42 attribute12 VARCHAR2(150),
43 attribute13 VARCHAR2(150),
44 attribute14 VARCHAR2(150),
45 attribute15 VARCHAR2(150),
46 creation_date DATE,
47 created_by NUMBER(15),
48 last_update_date DATE,
49 last_updated_by NUMBER(15),
50 last_update_login NUMBER(15),
51 created_by_name VARCHAR2(100),
52 last_updated_by_name VARCHAR2(100),
53
54 --start jts_configurations records
55 config_name VARCHAR2(80),
56 config_desc VARCHAR2(240),
57 config_flow_id NUMBER,
58 config_flow_name VARCHAR2(80), --from jts_setup_flows_vl
59 config_flow_type VARCHAR2(30),
60 config_record_mode VARCHAR2(30),
61 config_disp_record_mode VARCHAR2(80),--from fnd_lookup_values_vl
62 --end jts_configurations records
63
64 --start jts_config_version_statuses records
65 replayed_date DATE,
66 replayed_by_name VARCHAR2(100),
67 replay_status_code VARCHAR2(30),
68 version_status_code VARCHAR2(30),
69 replay_status VARCHAR2(80),
70 version_status VARCHAR2(80),
71 --end jts_config_version_statuses records
72
73 --start jts_config_version_flows record
74 percent_completed NUMBER
75 --end jts_config_version_flows record
76 ); --End Record Config_Version_Rec_Type
77
78 TYPE Config_Version_Tbl_Type IS TABLE OF Config_Version_Rec_Type INDEX BY BINARY_INTEGER;
79
80 TYPE Version_Id_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
81
82 --
83 -- Returns the versionin jts_config_versions for
84 -- version_name and configuration_id
85 FUNCTION GET_VERSION_ID(p_version_name IN VARCHAR2,
86 p_config_id IN NUMBER) return NUMBER;
87
88 -----------------------------------------------------------------
89 -- Creates a version, version flows for the setup summary data,
90 -- and version status with "NEW" as the value
91 -- Values passed in:
92 -- version_name
93 -- description
94 -- configuration_id
95 -----------------------------------------------------------------
96 PROCEDURE CREATE_VERSION(p_api_version IN Number,
97 P_commit IN Varchar2 DEFAULT FND_API.G_FALSE,
98 p_configuration_id IN NUMBER,
99 p_init_version IN VARCHAR2 DEFAULT FND_API.G_FALSE,
100 x_version_id OUT NUMBER,
101 x_return_status OUT VARCHAR2,
102 x_msg_count OUT NUMBER,
103 x_msg_data OUT VARCHAR2);
104
105 -- Updates version name and description.
106 -- May insert into version_statuses table
107 PROCEDURE UPDATE_NAME_DESC(p_api_version IN NUMBER,
108 p_version_id IN NUMBER,
109 p_config_id IN NUMBER,
110 p_version_name IN VARCHAR2,
111 p_version_desc IN VARCHAR2,
112 x_return_status OUT VARCHAR2,
113 x_msg_count OUT NUMBER,
114 x_msg_data OUT VARCHAR2
115 );
116
117 -- Updates version_status_code, last_update_date, last_updated_by
118 PROCEDURE UPDATE_VERSION_STAT(p_api_version IN NUMBER,
119 p_version_id IN NUMBER,
120 p_status IN VARCHAR2
121 );
122
126 p_status IN VARCHAR2
123 -- Updates version_status_code, last_update_date, last_updated_by
124 PROCEDURE UPDATE_REPLAY_DATA(p_api_version IN NUMBER,
125 p_version_id IN NUMBER,
127 );
128
129 -- Updates last_update_date and last_updated_by
130 PROCEDURE UPDATE_LAST_MODIFIED(p_api_version IN NUMBER,
131 p_version_id IN NUMBER);
132
133 -- Deletes a version and its corresponding version_statuses and
134 -- version_flows
135 PROCEDURE DELETE_VERSION(p_api_version IN Number,
136 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
137 p_version_id IN NUMBER
138 );
139
140 -- Deletes versions and their corresponding version_statuses and
141 -- version_flows given a table of version ids
142 PROCEDURE DELETE_SOME_VERSIONS(p_api_version IN Number,
143 p_version_tbl IN Version_Id_Tbl_Type
144 );
145
146 -- Deletes all versions of a configuration and their corresponding -- version_statuses and version_flows
147 -- Commit is done in Configurations Pkg
148 PROCEDURE DELETE_VERSIONS(p_api_version IN NUMBER,
149 p_config_id IN NUMBER
150 );
151
152 -- Gets version data based on version_id
153 PROCEDURE GET_VERSION(p_api_version IN NUMBER,
154 p_version_id IN NUMBER,
155 x_version_rec OUT NOCOPY Config_Version_Rec_Type,
156 x_return_status OUT VARCHAR2,
160 -- Retrieves all versions under a configuration with a certain order by clause
157 x_msg_count OUT NUMBER,
158 x_msg_data OUT VARCHAR2);
159
161 -- Uses Dynamic SQL
162 PROCEDURE GET_VERSIONS(
163 p_api_version IN NUMBER,
164 p_config_id IN NUMBER,
165 p_order_by IN VARCHAR2,
166 p_how_to_order IN VARCHAR2,
167 x_version_tbl OUT NOCOPY Config_Version_Tbl_Type,
168 x_return_status OUT VARCHAR2,
169 x_msg_count OUT NUMBER,
170 x_msg_data OUT VARCHAR2
171 );
172
173 END JTS_CONFIG_VERSION_PVT;