APPS.POS_MERGE_SUPPLIER_PKG dependencies on AP_SUPPLIERS

Line 171: FROM ap_suppliers

167: fnd_file.put_line(fnd_file.log, 'Rowcount: ' || SQL%ROWCOUNT);
168:
169: SELECT vendor_id
170: INTO l_to_vendor_id
171: FROM ap_suppliers
172: WHERE party_id = p_to_fk_id;
173:
174: fnd_file.put_line(fnd_file.log,
175: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_to_vendor_id: ' ||

Line 280: p_vendor_id IN ap_suppliers.vendor_id%TYPE,

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,
283: x_msg_data OUT NOCOPY VARCHAR2
284: ) IS

Line 439: p_from_vendor_id IN ap_suppliers.vendor_id%TYPE,

435: END create_prod_serv;
436:
437: FUNCTION get_prod_serv_rec
438: (
439: p_from_vendor_id IN ap_suppliers.vendor_id%TYPE,
440: p_to_vendor_id IN ap_suppliers.vendor_id%TYPE,
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,

Line 440: p_to_vendor_id IN ap_suppliers.vendor_id%TYPE,

436:
437: FUNCTION get_prod_serv_rec
438: (
439: p_from_vendor_id IN ap_suppliers.vendor_id%TYPE,
440: p_to_vendor_id IN ap_suppliers.vendor_id%TYPE,
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,

Line 572: FROM ap_suppliers

568: ' p_from_id : ' || p_from_id);
569:
570: SELECT vendor_id
571: INTO l_from_vendor_id
572: FROM ap_suppliers
573: WHERE party_id = p_from_fk_id;
574:
575: SELECT vendor_id
576: INTO l_to_vendor_id

Line 577: FROM ap_suppliers

573: WHERE party_id = p_from_fk_id;
574:
575: SELECT vendor_id
576: INTO l_to_vendor_id
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

Line 690: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_MERGE';

686:
687: l_party_usg_validation_level := hz_party_usg_assignment_pvt.g_valid_level_none;
688: l_party_usg_rec.party_id := l_party_id;
689: l_party_usg_rec.party_usage_code := 'SUPPLIER_CONTACT';
690: l_party_usg_rec.created_by_module := 'AP_SUPPLIERS_MERGE';
691:
692: /* Enable party contact as supplier contact by
693: setting usage code as SUPPLIER_CONTACT */
694: hz_party_usg_assignment_pvt.assign_party_usage(p_validation_level => l_party_usg_validation_level,

Line 2869: FROM ap_suppliers

2865: ELSIF (p_data_level_id = 17703) THEN
2866: BEGIN
2867: SELECT party_id
2868: INTO l_party_id
2869: FROM ap_suppliers
2870: WHERE vendor_id = p_vendor_id;
2871:
2872: EXCEPTION
2873: WHEN no_data_found THEN

Line 3594: FROM ap_suppliers

3590: ELSIF (p_data_level_id = 17703) THEN
3591: BEGIN
3592: SELECT party_id
3593: INTO l_party_id
3594: FROM ap_suppliers
3595: WHERE vendor_id = p_vendor_id;
3596:
3597: EXCEPTION
3598: WHEN no_data_found THEN

Line 4417: UPDATE ap_suppliers

4413: fnd_file.put_line(fnd_file.log,
4414: 'Inside POS_MERGE_SUPPLIER_PKG.enable_party_as_supplier p_to_fk_id: ' ||
4415: p_to_fk_id || ' p_to_fk_id: ' || p_from_fk_id);
4416:
4417: UPDATE ap_suppliers
4418: SET end_date_active = SYSDATE
4419: WHERE party_id = p_from_fk_id;
4420:
4421: SELECT COUNT(vendor_id)

Line 4423: FROM ap_suppliers

4419: WHERE party_id = p_from_fk_id;
4420:
4421: SELECT COUNT(vendor_id)
4422: INTO l_to_vendor_id
4423: FROM ap_suppliers
4424: WHERE party_id = p_to_fk_id;
4425:
4426: fnd_file.put_line(fnd_file.log, 'l_to_vendor_id: ' || l_to_vendor_id);
4427: