22: --
23: -- ARGUMENTS
24: -- IN:
25: -- p_init_msg_list Initialize message stack if it is set to
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
28: -- the completeness of business object.
29: -- p_location_obj Location business object.
30: -- p_created_by_module Created by module.
23: -- ARGUMENTS
24: -- IN:
25: -- p_init_msg_list Initialize message stack if it is set to
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- p_validate_bo_flag If it is set to FND_API.G_TRUE, validate
28: -- the completeness of business object.
29: -- p_location_obj Location business object.
30: -- p_created_by_module Created by module.
31: -- OUT:
29: -- p_location_obj Location business object.
30: -- p_created_by_module Created by module.
31: -- OUT:
32: -- x_return_status Return status after the call. The status can
33: -- be fnd_api.g_ret_sts_success (success),
34: -- fnd_api.g_ret_sts_error (error),
35: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
36: -- x_msg_count Number of messages in message stack.
37: -- x_msg_data Message text if x_msg_count is 1.
30: -- p_created_by_module Created by module.
31: -- OUT:
32: -- x_return_status Return status after the call. The status can
33: -- be fnd_api.g_ret_sts_success (success),
34: -- fnd_api.g_ret_sts_error (error),
35: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
36: -- x_msg_count Number of messages in message stack.
37: -- x_msg_data Message text if x_msg_count is 1.
38: -- x_location_id Location ID.
31: -- OUT:
32: -- x_return_status Return status after the call. The status can
33: -- be fnd_api.g_ret_sts_success (success),
34: -- fnd_api.g_ret_sts_error (error),
35: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
36: -- x_msg_count Number of messages in message stack.
37: -- x_msg_data Message text if x_msg_count is 1.
38: -- x_location_id Location ID.
39: -- x_location_os Location orig system.
46: -- 14-DEC-2004 Arnold Ng Created.
47: --
48:
49: PROCEDURE create_location_bo(
50: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
51: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
52: p_location_obj IN HZ_LOCATION_OBJ,
53: p_created_by_module IN VARCHAR2,
54: x_return_status OUT NOCOPY VARCHAR2,
47: --
48:
49: PROCEDURE create_location_bo(
50: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
51: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
52: p_location_obj IN HZ_LOCATION_OBJ,
53: p_created_by_module IN VARCHAR2,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
82: * @rep:displayname Create Location Business Object
83: * @rep:doccd 120hztig.pdf Create Location Business Object, Oracle Trading Community Architecture Technical Implementation Guide
84: */
85: PROCEDURE create_location_bo(
86: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
87: p_location_obj IN HZ_LOCATION_OBJ,
88: p_created_by_module IN VARCHAR2,
89: p_obj_source IN VARCHAR2 := null,
90: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
86: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
87: p_location_obj IN HZ_LOCATION_OBJ,
88: p_created_by_module IN VARCHAR2,
89: p_obj_source IN VARCHAR2 := null,
90: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
93: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
94: x_location_id OUT NOCOPY NUMBER,
105: --
106: -- ARGUMENTS
107: -- IN:
108: -- p_init_msg_list Initialize message stack if it is set to
109: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
110: -- p_location_obj Location business object.
111: -- p_created_by_module Created by module.
112: -- OUT:
113: -- x_return_status Return status after the call. The status can
110: -- p_location_obj Location business object.
111: -- p_created_by_module Created by module.
112: -- OUT:
113: -- x_return_status Return status after the call. The status can
114: -- be fnd_api.g_ret_sts_success (success),
115: -- fnd_api.g_ret_sts_error (error),
116: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
117: -- x_msg_count Number of messages in message stack.
118: -- x_msg_data Message text if x_msg_count is 1.
111: -- p_created_by_module Created by module.
112: -- OUT:
113: -- x_return_status Return status after the call. The status can
114: -- be fnd_api.g_ret_sts_success (success),
115: -- fnd_api.g_ret_sts_error (error),
116: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
117: -- x_msg_count Number of messages in message stack.
118: -- x_msg_data Message text if x_msg_count is 1.
119: -- x_location_id Location ID.
112: -- OUT:
113: -- x_return_status Return status after the call. The status can
114: -- be fnd_api.g_ret_sts_success (success),
115: -- fnd_api.g_ret_sts_error (error),
116: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
117: -- x_msg_count Number of messages in message stack.
118: -- x_msg_data Message text if x_msg_count is 1.
119: -- x_location_id Location ID.
120: -- x_location_os Location orig system.
127: -- 14-DEC-2004 Arnold Ng Created.
128: --
129:
130: PROCEDURE update_location_bo(
131: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
132: p_location_obj IN HZ_LOCATION_OBJ,
133: p_created_by_module IN VARCHAR2,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
164: PROCEDURE update_location_bo(
165: p_location_obj IN HZ_LOCATION_OBJ,
166: p_created_by_module IN VARCHAR2,
167: p_obj_source IN VARCHAR2 := null,
168: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
171: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
172: x_location_id OUT NOCOPY NUMBER,
183: --
184: -- ARGUMENTS
185: -- IN:
186: -- p_init_msg_list Initialize message stack if it is set to
187: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
188: -- p_location_obj Location business object.
189: -- p_created_by_module Created by module.
190: -- OUT:
191: -- x_return_status Return status after the call. The status can
188: -- p_location_obj Location business object.
189: -- p_created_by_module Created by module.
190: -- OUT:
191: -- x_return_status Return status after the call. The status can
192: -- be fnd_api.g_ret_sts_success (success),
193: -- fnd_api.g_ret_sts_error (error),
194: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
195: -- x_msg_count Number of messages in message stack.
196: -- x_msg_data Message text if x_msg_count is 1.
189: -- p_created_by_module Created by module.
190: -- OUT:
191: -- x_return_status Return status after the call. The status can
192: -- be fnd_api.g_ret_sts_success (success),
193: -- fnd_api.g_ret_sts_error (error),
194: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
195: -- x_msg_count Number of messages in message stack.
196: -- x_msg_data Message text if x_msg_count is 1.
197: -- x_location_id Location ID.
190: -- OUT:
191: -- x_return_status Return status after the call. The status can
192: -- be fnd_api.g_ret_sts_success (success),
193: -- fnd_api.g_ret_sts_error (error),
194: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
195: -- x_msg_count Number of messages in message stack.
196: -- x_msg_data Message text if x_msg_count is 1.
197: -- x_location_id Location ID.
198: -- x_location_os Location orig system.
205: -- 14-DEC-2004 Arnold Ng Created.
206: --
207:
208: PROCEDURE save_location_bo(
209: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
210: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
211: p_location_obj IN HZ_LOCATION_OBJ,
212: p_created_by_module IN VARCHAR2,
213: x_return_status OUT NOCOPY VARCHAR2,
206: --
207:
208: PROCEDURE save_location_bo(
209: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
210: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
211: p_location_obj IN HZ_LOCATION_OBJ,
212: p_created_by_module IN VARCHAR2,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
244: * @rep:displayname Save Location Business Object
245: * @rep:doccd 120hztig.pdf Save Location Business Object, Oracle Trading Community Architecture Technical Implementation Guide
246: */
247: PROCEDURE save_location_bo(
248: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
249: p_location_obj IN HZ_LOCATION_OBJ,
250: p_created_by_module IN VARCHAR2,
251: p_obj_source IN VARCHAR2 := null,
252: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
248: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
249: p_location_obj IN HZ_LOCATION_OBJ,
250: p_created_by_module IN VARCHAR2,
251: p_obj_source IN VARCHAR2 := null,
252: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
253: x_return_status OUT NOCOPY VARCHAR2,
254: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
255: x_return_obj OUT NOCOPY HZ_LOCATION_OBJ,
256: x_location_id OUT NOCOPY NUMBER,
268: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
269: --
270: -- ARGUMENTS
271: -- IN:
272: -- p_init_msg_list Initialize message stack if it is set to FND_API.G_TRUE. Default is FND_API.G_FALSE.
273: -- p_location_id location ID. If this id is not passed in, multiple site objects will be returned.
274: -- p_location_os location orig system.
275: -- p_location_osr location orig system reference.
276: -- OUT:
275: -- p_location_osr location orig system reference.
276: -- OUT:
277: -- x_location_objs Logical location records.
278: -- x_return_status Return status after the call. The status can
279: -- be fnd_api.g_ret_sts_success (success),
280: -- fnd_api.g_ret_sts_error (error),
281: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
282: -- x_msg_count Number of messages in message stack.
283: -- x_msg_data Message text if x_msg_count is 1.
276: -- OUT:
277: -- x_location_objs Logical location records.
278: -- x_return_status Return status after the call. The status can
279: -- be fnd_api.g_ret_sts_success (success),
280: -- fnd_api.g_ret_sts_error (error),
281: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
282: -- x_msg_count Number of messages in message stack.
283: -- x_msg_data Message text if x_msg_count is 1.
284: --
277: -- x_location_objs Logical location records.
278: -- x_return_status Return status after the call. The status can
279: -- be fnd_api.g_ret_sts_success (success),
280: -- fnd_api.g_ret_sts_error (error),
281: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
282: -- x_msg_count Number of messages in message stack.
283: -- x_msg_data Message text if x_msg_count is 1.
284: --
285: -- NOTES
309: Location Y N HZ_LOCATIONS
310: */
311:
312: PROCEDURE get_location_bo (
313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314: p_location_id IN NUMBER,
315: p_location_os IN VARCHAR2,
316: p_location_osr IN VARCHAR2,
317: x_location_obj OUT NOCOPY HZ_LOCATION_OBJ,