[Home] [Help]
PACKAGE: APPS.CSI_ORGANIZATION_UNIT_PVT
Source
1 PACKAGE csi_organization_unit_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivous.pls 115.19 2003/09/04 00:47:39 sguthiva ship $ */
3
4 --
5 TYPE LOOKUP_REC IS RECORD
6 (
7 lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
8 ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9 );
10
11 TYPE LOOKUP_TBL IS TABLE OF LOOKUP_REC INDEX BY BINARY_INTEGER;
12 --
13 TYPE OU_COUNT_REC IS RECORD
14 (
15 ou_count NUMBER := FND_API.G_MISS_NUM
16 ,lookup_count NUMBER := FND_API.G_MISS_NUM
17 );
18 --
19 TYPE OU_ID_REC IS RECORD
20 (
21 ou_id NUMBER := FND_API.G_MISS_NUM
22 ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
23 );
24
25 TYPE OU_ID_TBL IS TABLE OF OU_ID_REC INDEX BY BINARY_INTEGER;
26 --
27 /*----------------------------------------------------------*/
28 /* Procedure name: Initialize_ou_rec_no_dump */
29 /* Description : This gets the first record from history */
30 /* */
31 /*----------------------------------------------------------*/
32
33 PROCEDURE Initialize_ou_rec_no_dump
34 (
35 x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,
36 p_ou_id IN NUMBER,
37 x_first_no_dump IN OUT NOCOPY DATE
38 );
39
40
41 /*----------------------------------------------------------*/
42 /* Procedure name: Initialize_ou_rec */
43 /* Description : This procudure recontructs the record */
44 /* from the history */
45 /*----------------------------------------------------------*/
46
47 PROCEDURE Initialize_ou_rec
48 ( x_ou_rec IN OUT NOCOPY csi_datastructures_pub.org_units_header_rec,
49 p_ou_h_id IN NUMBER,
50 x_nearest_full_dump IN OUT NOCOPY DATE
51 );
52
53
54 /*----------------------------------------------------------*/
55 /* Procedure name: Construct_ou_from_hist */
56 /* Description : This procudure recontructs the record */
57 /* from the history */
58 /*----------------------------------------------------------*/
59
60 PROCEDURE Construct_ou_from_hist
61 ( x_ou_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl,
62 p_time_stamp IN DATE
63 );
64
65
66 /*----------------------------------------------------------*/
67 /* Procedure name: Define_ou_Columns */
68 /* Description : This procudure defines the columns */
69 /* for the Dynamic SQL */
70 /*----------------------------------------------------------*/
71
72 PROCEDURE Define_ou_Columns
73 ( p_get_ou_cursor_id IN NUMBER
74 );
75
76 /*----------------------------------------------------------*/
77 /* Procedure name: Resolve_id_columns */
78 /* Description : This procudure gets the descriptions for */
79 /* id columns */
80 /*----------------------------------------------------------*/
81
82 PROCEDURE Resolve_id_columns
83 (p_org_units_header_tbl IN OUT NOCOPY csi_datastructures_pub.org_units_header_tbl);
84
85
86 /*----------------------------------------------------------*/
87 /* Procedure name: Get_ou_Column_Values */
88 /* Description : This procudure gets the column values */
89 /* for the Dynamic SQL */
90 /*----------------------------------------------------------*/
91
92 PROCEDURE Get_ou_Column_Values
93 (p_get_ou_cursor_id IN NUMBER,
94 x_ou_rec OUT NOCOPY csi_datastructures_pub.org_units_header_rec
95 );
96
97
98
99
100 /*----------------------------------------------------------*/
101 /* Procedure name: Bind_ou_variable */
102 /* Description : Procedure used to generate the where */
103 /* cluase for organization assignments */
104 /*----------------------------------------------------------*/
105
106 PROCEDURE Bind_ou_variable
107 ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec,
108 p_cur_get_ou IN NUMBER
109 );
110
111
112
113 /*----------------------------------------------------------*/
114 /* Procedure name: Gen_ou_Where_Clause */
115 /* Description : Procedure used to generate the where */
116 /* clause for Organization units */
117 /*----------------------------------------------------------*/
118
119 PROCEDURE Gen_ou_Where_Clause
120 ( p_ou_query_rec IN csi_datastructures_pub.organization_unit_query_rec
121 ,x_where_clause OUT NOCOPY VARCHAR2
122 );
123
124
125
126 /*-------------------------------------------------------*/
127 /* procedure name: create_organization_unit */
128 /* description : Creates new association between an */
129 /* organization unit and an item instance */
130 /* */
131 /*-------------------------------------------------------*/
132
133 PROCEDURE create_organization_unit
134 ( p_api_version IN NUMBER
135 ,p_commit IN VARCHAR2 := fnd_api.g_false
136 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
137 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
138 ,p_org_unit_rec IN OUT NOCOPY csi_datastructures_pub.organization_units_rec
139 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2
143 ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
144 ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
145 ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
146 ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
147 );
148
149
150
151 /*-------------------------------------------------------*/
152 /* procedure name: update_organization_unit */
153 /* description : Updates an existing instance-org */
154 /* association */
155 /* */
156 /*-------------------------------------------------------*/
157
158 PROCEDURE update_organization_unit
159 ( p_api_version IN NUMBER
160 ,p_commit IN VARCHAR2 := fnd_api.g_false
161 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
162 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
163 ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
164 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
165 ,x_return_status OUT NOCOPY VARCHAR2
166 ,x_msg_count OUT NOCOPY NUMBER
167 ,x_msg_data OUT NOCOPY VARCHAR2
168 ,p_lookup_tbl IN OUT NOCOPY csi_organization_unit_pvt.lookup_tbl
169 ,p_ou_count_rec IN OUT NOCOPY csi_organization_unit_pvt.ou_count_rec
170 ,p_ou_id_tbl IN OUT NOCOPY csi_organization_unit_pvt.ou_id_tbl
171 );
172
173
174
175
176 /*--------------------------------------------------*/
177 /* procedure name: expire_organization_unit */
178 /* description : Expires an existing instance-org */
179 /* association */
180 /* */
181 /*--------------------------------------------------*/
182
183 PROCEDURE expire_organization_unit
184 ( p_api_version IN NUMBER
185 ,p_commit IN VARCHAR2 := fnd_api.g_false
186 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
187 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
188 ,p_org_unit_rec IN csi_datastructures_pub.organization_units_rec
189 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
190 ,x_return_status OUT NOCOPY VARCHAR2
191 ,x_msg_count OUT NOCOPY NUMBER
192 ,x_msg_data OUT NOCOPY VARCHAR2
193 );
194
195
196
197
198
199
200 /*--------------------------------------------------*/
201 /* procedure name: get_org_unit_history */
202 /* description : Gets organization history */
203 /* */
204 /*--------------------------------------------------*/
205
206 PROCEDURE get_org_unit_history
207 ( p_api_version IN NUMBER
208 ,p_commit IN VARCHAR2 := fnd_api.g_false
209 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
210 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
211 ,p_transaction_id IN NUMBER
212 ,x_org_unit_history_tbl OUT NOCOPY csi_datastructures_pub.org_units_history_tbl
213 ,x_return_status OUT NOCOPY VARCHAR2
214 ,x_msg_count OUT NOCOPY NUMBER
215 ,x_msg_data OUT NOCOPY VARCHAR2
216 );
217
218
219 END csi_organization_unit_pvt;
220
221
222
223
224
225
226