FND_API.G_RET_STS_SUCCESS
19: *
DELETE
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
20: * @param x_msg_count returns the number of messages in the API message list
21: * @param x_return_status returns the result of all the operations performed
22: * by the API and must have one of the following values:
23: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
21: * @param x_return_status returns the result of all the operations performed
22: * by the API and must have one of the following values:
23: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
27: */
28:
29: PROCEDURE assign_cust_to_user
30: ( p_api_version_number IN NUMBER,
31: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
32: p_user_id IN NUMBER,
33: p_party_id IN NUMBER,
34: p_operation IN VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
FND_API.G_RET_STS_SUCCESS
52: *
DELETE
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
53: * @param x_msg_count returns the number of messages in the API message list
54: * @param x_return_status returns the result of all the operations performed
55: * by the API and must have one of the following values:
56: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
54: * @param x_return_status returns the result of all the operations performed
55: * by the API and must have one of the following values:
56: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
60: */
61:
62: PROCEDURE assign_mul_cust_to_users
63: ( p_api_version_number IN NUMBER,
64: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
65: p_user_id_lst IN l_user_id_tbl_type,
66: p_party_id_lst IN l_party_id_tbl_type,
67: p_operation IN VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
FND_API.G_RET_STS_SUCCESS
86: *
DELETE
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
87: * @param x_msg_count returns the number of messages in the API message list
88: * @param x_return_status returns the result of all the operations performed
89: * by the API and must have one of the following values:
90: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
88: * @param x_return_status returns the result of all the operations performed
89: * by the API and must have one of the following values:
90: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
94: */
95:
96: PROCEDURE assign_cust_loc_to_user
97: ( p_api_version_number IN NUMBER,
98: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
99: p_user_id IN NUMBER,
100: p_party_id IN NUMBER,
101: p_location_id IN NUMBER,
102: p_operation IN VARCHAR2,
FND_API.G_RET_STS_SUCCESS
121: *
DELETE
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
122: * @param x_msg_count returns the number of messages in the API message list
123: * @param x_return_status returns the result of all the operations performed
124: * by the API and must have one of the following values:
125: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
123: * @param x_return_status returns the result of all the operations performed
124: * by the API and must have one of the following values:
125: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
129: */
130:
131: PROCEDURE assign_mul_cust_loc_to_users
132: ( p_api_version_number IN NUMBER,
133: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
134: p_user_id_lst IN l_user_id_tbl_type,
135: p_party_id IN NUMBER,
136: p_location_id_lst IN l_party_id_tbl_type,
137: p_operation IN VARCHAR2,
FND_API.G_RET_STS_SUCCESS
152: * @param p_operation the operation to be performed can be null also
153: * @param x_msg_count returns the number of messages in the API message list
154: * @param x_return_status returns the result of all the operations performed
155: * by the API and must have one of the following values:
156: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
153: * @param x_msg_count returns the number of messages in the API message list
154: * @param x_return_status returns the result of all the operations performed
155: * by the API and must have one of the following values:
156: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
154: * @param x_return_status returns the result of all the operations performed
155: * by the API and must have one of the following values:
156: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
160: */
161:
162: PROCEDURE get_parties_for_user
163: ( p_api_version_number IN NUMBER,
164: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
165: p_user_id IN NUMBER,
166: p_party_id_lst OUT NOCOPY l_party_id_tbl_type,
167: p_operation IN VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
FND_API.G_RET_STS_SUCCESS
183: * @param p_location_id the location which are fetched
184: * @param x_msg_count returns the number of messages in the API message list
185: * @param x_return_status returns the result of all the operations performed
186: * by the API and must have one of the following values:
187: * FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_ERROR
184: * @param x_msg_count returns the number of messages in the API message list
185: * @param x_return_status returns the result of all the operations performed
186: * by the API and must have one of the following values:
187: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
185: * @param x_return_status returns the result of all the operations performed
186: * by the API and must have one of the following values:
187: *
FND_API.G_RET_STS_SUCCESS
FND_API.G_RET_STS_ERROR
FND_API.G_RET_STS_UNEXP_ERROR
191: */
192:
193: PROCEDURE get_party_locations_for_user
194: ( p_api_version_number IN NUMBER,
195: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
196: p_user_id IN NUMBER,
197: p_party_id IN NUMBER,
198: p_location_id OUT NOCOPY l_party_id_tbl_type,
199: p_operation IN VARCHAR2,