APPS.POS_MERGE_SUPPLIER_PKG dependencies on POS_SUP_PRODUCTS_SERVICES

Line 278: p_vendor_prodsrv_rec IN pos_sup_products_services%ROWTYPE,

274: END buss_class_merge;
275:
276: PROCEDURE create_prod_serv
277: (
278: p_vendor_prodsrv_rec IN pos_sup_products_services%ROWTYPE,
279: p_party_id IN hz_parties.party_id%TYPE,
280: p_vendor_id IN ap_suppliers.vendor_id%TYPE,
281: x_return_status OUT NOCOPY VARCHAR2,
282: x_msg_count OUT NOCOPY NUMBER,

Line 415: -- pos_sup_products_services table

411: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_concat,
412: x_mapp_id => l_mapping_id);
413:
414: -- Using the request_id make a call to the following Api to approve the data and insert it into the
415: -- pos_sup_products_services table
416: pos_profile_change_request_pkg.approve_ps_req(p_request_id => l_req_id,
417: x_return_status => l_return_status,
418: x_msg_count => l_msg_count,
419: x_msg_data => l_msg_data);

Line 445: x_prod_services_rec OUT NOCOPY pos_sup_products_services%ROWTYPE

441: p_classification_id IN pos_bus_class_attr.classification_id%TYPE,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: x_prod_services_rec OUT NOCOPY pos_sup_products_services%ROWTYPE
446: ) RETURN NUMBER IS
447: BEGIN
448: x_return_status := fnd_api.g_ret_sts_success;
449:

Line 498: FROM pos_sup_products_services

494: x_prod_services_rec.segment19,
495: x_prod_services_rec.segment20,
496: x_prod_services_rec.status,
497: x_prod_services_rec.segment_definition
498: FROM pos_sup_products_services
499: WHERE vendor_id = p_from_vendor_id
500: AND classification_id = p_classification_id
501: /* Picking the products and services that are not already
502: associated with the To Party*/

Line 528: FROM pos_sup_products_services

524: segment18,
525: segment19,
526: segment20,
527: segment_definition
528: FROM pos_sup_products_services
529: WHERE vendor_id = p_to_vendor_id);
530:
531: RETURN 1;
532:

Line 556: l_prod_services_rec pos_sup_products_services%ROWTYPE;

552: p_batch_id IN NUMBER,
553: p_batch_party_id IN NUMBER,
554: x_return_status OUT NOCOPY VARCHAR2
555: ) IS
556: l_prod_services_rec pos_sup_products_services%ROWTYPE;
557: l_from_vendor_id NUMBER;
558: l_to_vendor_id NUMBER;
559: l_msg_count NUMBER;
560: l_msg_data VARCHAR2(2000);

Line 581: UPDATE pos_sup_products_services

577: FROM ap_suppliers
578: WHERE party_id = p_to_fk_id;
579:
580: /* Set the status to MERGED */
581: UPDATE pos_sup_products_services
582: SET status = 'M',
583: last_update_date = SYSDATE,
584: last_updated_by = hz_utility_pub.user_id,
585: last_update_login = hz_utility_pub.last_update_login