[Home] [Help]
PACKAGE: APPS.JTS_CONFIGURATION_PVT
Source
1 PACKAGE JTS_CONFIGURATION_PVT AUTHID CURRENT_USER as
2 /* $Header: jtsvcfgs.pls 115.5 2002/04/10 18:10:13 pkm ship $ */
3
4
5 -----------------------------------------------------------
6 -- PACKAGE
7 -- JTS_CONFIGURATION_PVT
8 --
9 -- PURPOSE
10 -- Private API for Oracle Setup Online Configuration
11 -- Management
12 -- PROCEDURES
13 --
14 ------------------------------------------------------------
15
16
17 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTS_CONFIGURATION_PVT';
18 G_FILE_NAME CONSTANT VARCHAR2(12) := 'jtsvcfgs.pls';
19
20 C_RECORD_MODE_TYPE CONSTANT Varchar2(15) := 'JTS_RECORD_MODE';
21 C_FLOW_TYPE CONSTANT Varchar2(15) := 'JTS_FLOW_TYPE';
22
23 --For Configuration Summary and Detail pages
24 TYPE Config_Rec_Type IS RECORD (
25 configuration_id NUMBER,
26 config_name VARCHAR2(80),
27 description VARCHAR2(240),
28 flow_id NUMBER,
29 flow_name VARCHAR2(80),
30 flow_type_code VARCHAR2(30), --lookup_code
31 flow_type VARCHAR2(80), --meaning
32 record_mode VARCHAR2(30), --lookup_code
33 displayed_record_mode VARCHAR2(80), --meaning
34 attribute_category VARCHAR2(150),
35 attribute1 VARCHAR2(150),
36 attribute2 VARCHAR2(150),
37 attribute3 VARCHAR2(150),
38 attribute4 VARCHAR2(150),
39 attribute5 VARCHAR2(150),
40 attribute6 VARCHAR2(150),
41 attribute7 VARCHAR2(150),
42 attribute8 VARCHAR2(150),
43 attribute9 VARCHAR2(150),
44 attribute10 VARCHAR2(150),
45 attribute11 VARCHAR2(150),
46 attribute12 VARCHAR2(150),
47 attribute13 VARCHAR2(150),
48 attribute14 VARCHAR2(150),
49 attribute15 VARCHAR2(150),
50 creation_date DATE,
51 created_by NUMBER(15),
52 last_update_date DATE,
53 last_updated_by NUMBER(15),
54 last_update_login NUMBER(15),
55 created_by_name VARCHAR2(100), --derived from created_by
56 last_updated_by_name VARCHAR2(100) --derived from last_updated_by
57 ); -- end TYPE Config_Rec_Type
58
59 TYPE Config_Rec_Tbl_Type IS TABLE OF Config_Rec_Type INDEX BY BINARY_INTEGER;
60
61 -----------------------------------------------------------
62 --Creates a configuration and an initial version
63 --Values passed in:
64 --config_name config_configName,
65 --description config_desc,
66 --flow_id config_flowId,
67 --flow_type setupFlow_flowType,
68 --record_mode config_recordMode,
69 -----------------------------------------------------------
70 PROCEDURE CREATE_CONFIGURATION(
71 p_api_version IN NUMBER,
72 p_configuration_rec IN Config_Rec_Type,
73 x_config_id OUT NUMBER,
74 x_return_status OUT VARCHAR2,
75 x_msg_count OUT NUMBER,
76 x_msg_data OUT VARCHAR2
77 );
78
79 -----------------------------------------------------------
80 --Updates a configuration
81 --Values passed in:
82 --config_name config_configName,
83 --description config_desc,
84 --Updated: config_name, description, last_update_date,
85 --last_updated_by, last_update_login
86 -----------------------------------------------------------
87 PROCEDURE UPDATE_NAME_DESC (
88 p_api_version IN NUMBER,
89 p_config_id IN NUMBER,
90 p_config_name IN VARCHAR2,
91 p_config_desc IN VARCHAR2,
92 x_return_status OUT VARCHAR2,
93 x_msg_count OUT NUMBER,
94 x_msg_data OUT VARCHAR2
95 );
96
97 -- Deletes a configuration and its versions
98 PROCEDURE DELETE_CONFIGURATION(
99 p_api_version IN NUMBER,
100 p_config_id IN NUMBER,
101 x_return_status OUT VARCHAR2,
102 x_msg_count OUT NUMBER,
103 x_msg_data OUT VARCHAR2
104 );
105
106 -- Retrieves a configuration given a config_id
107 PROCEDURE GET_CONFIGURATION(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
110 p_config_id IN NUMBER,
111 x_configuration_rec OUT NOCOPY Config_Rec_Type,
112 x_return_status OUT VARCHAR2,
113 x_msg_count OUT NUMBER,
114 x_msg_data OUT VARCHAR2
115 );
116
117 -- Retrieves all configurations with a certain order by clause
118 -- Uses Dynamic SQL
119 PROCEDURE GET_CONFIGURATIONS(
120 p_api_version IN NUMBER,
121 p_where_clause IN VARCHAR2,
122 p_order_by IN VARCHAR2,
123 p_how_to_order IN VARCHAR2,
127 x_msg_data OUT VARCHAR2
124 x_configuration_tbl OUT NOCOPY Config_Rec_Tbl_Type,
125 x_return_status OUT VARCHAR2,
126 x_msg_count OUT NUMBER,
128 );
129
130 -- Retrieves flow_id for a particular configuration
131 PROCEDURE GET_FLOW_ID(
132 p_config_id IN NUMBER,
133 x_flow_id OUT NUMBER
134 );
135
136 FUNCTION GET_CONFIG_ID(p_config_name IN VARCHAR2) RETURN NUMBER;
137 FUNCTION GET_CONFIG_NAME(p_config_id IN NUMBER) RETURN VARCHAR2;
138
139 END JTS_CONFIGURATION_PVT;