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;
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: --
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
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: (
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;
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: --
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
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
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:
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
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
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
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
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
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
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
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
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