APPS.POS_PRODUCT_SERVICE_BO_PKG dependencies on POS_PRODUCT_SERVICE_BO_TBL

Line 169: * @param x_pos_product_service_bo_tbl The product service bo list

165: * @param p_init_msg_list The Initialization message list
166: * @param p_party_id The Party id
167: * @param p_orig_system The Orig System
168: * @param p_orig_system_reference The Orig System Reference
169: * @param x_pos_product_service_bo_tbl The product service bo list
170: * @param x_return_status The return status
171: * @param x_msg_count The message count
172: * @param x_msg_data The message data
173: * @rep:scope public

Line 178: PROCEDURE get_pos_product_service_bo_tbl

174: * @rep:lifecycle active
175: * @rep:displayname Get Supplier Product Service
176: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
177: */
178: PROCEDURE get_pos_product_service_bo_tbl
179: (
180: p_api_version IN NUMBER DEFAULT NULL,
181: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
182: p_party_id IN NUMBER,

Line 185: x_pos_product_service_bo_tbl OUT NOCOPY pos_product_service_bo_tbl,

181: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
182: p_party_id IN NUMBER,
183: p_orig_system IN VARCHAR2,
184: p_orig_system_reference IN VARCHAR2,
185: x_pos_product_service_bo_tbl OUT NOCOPY pos_product_service_bo_tbl,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2
189: ) IS

Line 191: l_pos_product_service_bo_tbl pos_product_service_bo_tbl := pos_product_service_bo_tbl();

187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2
189: ) IS
190:
191: l_pos_product_service_bo_tbl pos_product_service_bo_tbl := pos_product_service_bo_tbl();
192: l_party_id NUMBER;
193:
194: BEGIN
195:

Line 232: INTO l_pos_product_service_bo_tbl

228: ps.creation_date,
229: ps.last_updated_by,
230: ps.last_update_date,
231: ps.last_update_login) BULK COLLECT
232: INTO l_pos_product_service_bo_tbl
233: FROM pos_sup_products_services ps,
234: ap_suppliers ap
235: WHERE ap.party_id = l_party_id
236: AND ps.vendor_id = ap.vendor_id;

Line 238: x_pos_product_service_bo_tbl := l_pos_product_service_bo_tbl;

234: ap_suppliers ap
235: WHERE ap.party_id = l_party_id
236: AND ps.vendor_id = ap.vendor_id;
237:
238: x_pos_product_service_bo_tbl := l_pos_product_service_bo_tbl;
239: x_return_status := fnd_api.g_ret_sts_success;
240: x_msg_data := 'SUCCESS';
241: EXCEPTION
242: WHEN fnd_api.g_exc_error THEN

Line 258: END get_pos_product_service_bo_tbl;

254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255:
256: x_msg_count := 1;
257: x_msg_data := SQLCODE || SQLERRM;
258: END get_pos_product_service_bo_tbl;
259:
260: /*#
261: * Use this routine to create approved product service
262: * @param p_api_version The version of API

Line 280: p_vendor_prodsrv_rec IN pos_product_service_bo_tbl,

276: PROCEDURE create_pos_product_service
277: (
278: p_api_version IN NUMBER DEFAULT NULL,
279: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
280: p_vendor_prodsrv_rec IN pos_product_service_bo_tbl,
281: p_request_status IN VARCHAR2,
282: p_party_id IN NUMBER,
283: p_orig_system IN VARCHAR2,
284: p_orig_system_reference IN VARCHAR2,