DBA Data[Home] [Help]

APPS.CSI_ORGANIZATION_UNIT_PVT dependencies on FND_API

Line 7: lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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;

Line 8: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 15: ou_count NUMBER := FND_API.G_MISS_NUM

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

Line 16: ,lookup_count NUMBER := FND_API.G_MISS_NUM

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

Line 21: ou_id 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;

Line 22: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

Line 135: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 136: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 137: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 146: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false

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:

Line 160: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 161: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 162: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 185: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 186: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 187: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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

Line 208: ,p_commit IN VARCHAR2 := fnd_api.g_false

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

Line 209: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

Line 210: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

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