APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on AP_SUPPLIERS

Line 731: l_vendor_site_id AP_SUPPLIERS.VENDOR_ID%TYPE;

727: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
728: l_return_status varchar2(2000);
729: l_msg_count NUMBER;
730: l_msg_data VARCHAR2(2000);
731: l_vendor_site_id AP_SUPPLIERS.VENDOR_ID%TYPE;
732: l_party_site_id HZ_PARTY_SITES.party_site_id %TYPE;
733: l_location_id HZ_LOCATIONS.location_id%type;
734:
735: CURSOR C IS SELECT rowid FROM ap_supplier_sites

Line 850: l_vendor_site_id AP_SUPPLIERS.VENDOR_ID%TYPE;

846:
847: l_return_status varchar2(2000);
848: l_msg_count NUMBER;
849: l_msg_data VARCHAR2(2000);
850: l_vendor_site_id AP_SUPPLIERS.VENDOR_ID%TYPE;
851: l_party_site_id HZ_PARTY_SITES.party_site_id %TYPE;
852: l_location_id HZ_LOCATIONS.location_id%type;
853:
854:

Line 920: --l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';

916:
917:
918: l_party_site_rec.party_site_id := l_party_site_id;
919: select decode(X_pay_site_flag,'Y','A','I') into l_party_site_rec.status from dual;
920: --l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
921:
922:
923: OPEN c_obj_version_loc (l_location_id);
924: FETCH c_obj_version_loc INTO l_object_version_number;

Line 1639: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;

1635: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1636: l_return_status varchar2(2000);
1637: l_msg_count NUMBER;
1638: l_msg_data VARCHAR2(2000);
1639: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;
1640: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1641:
1642:
1643:

Line 1644: CURSOR C IS SELECT rowid FROM AP_SUPPLIERS

1640: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1641:
1642:
1643:
1644: CURSOR C IS SELECT rowid FROM AP_SUPPLIERS
1645: WHERE vendor_id = l_vendor_id;
1646: CURSOR C1 IS SELECT vendor_id FROM igi_po_vendors
1647: WHERE vendor_id = l_vendor_id;
1648: c1_vendor_id number(15);

Line 1775: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;

1771: l_vendor_rec ap_vendor_pub_pkg.r_vendor_rec_type;
1772: l_return_status varchar2(2000);
1773: l_msg_count NUMBER;
1774: l_msg_data VARCHAR2(2000);
1775: l_vendor_id AP_SUPPLIERS.VENDOR_ID%TYPE;
1776: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
1777: l_object_version_number NUMBER;
1778: l_profile_id NUMBER;
1779:

Line 1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';

1780: l_party_rec HZ_PARTY_V2PUB.PARTY_REC_TYPE;
1781: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
1782: BEGIN
1783:
1784: select party_id,nvl(object_version_number,fnd_api.G_NULL_NUM) into l_party_id,l_object_version_number from hz_parties where party_name = X_vendor_name and created_by_module = 'AP_SUPPLIERS_API';
1785:
1786: l_party_rec.party_id := l_party_id;
1787: --l_party_rec.orig_system_reference := nvl(X_orig_system_reference,fnd_api.G_NULL_CHAR);
1788: l_party_rec.status := nvl(X_status,fnd_api.G_NULL_CHAR);

Line 1842: from AP_SUPPLIERS pv

1838:
1839: UPDATE igi_po_vendors ipv
1840: SET ipv.stp_enforce_threshold = X_stp_enforce_threshold
1841: WHERE ipv.vendor_id = (select pv.vendor_id
1842: from AP_SUPPLIERS pv
1843: where pv.rowid = X_rowid);
1844:
1845: END Supplier_Update_Row;
1846:

Line 1858: FROM ap_suppliers

1854: X_end_date_active DATE) IS
1855:
1856: CURSOR C IS
1857: SELECT *
1858: FROM ap_suppliers
1859: WHERE rowid = X_rowid
1860: FOR UPDATE OF vendor_id NOWAIT;
1861:
1862: RecSupp C%ROWTYPE;

Line 1867: from ap_suppliers pv

1863: CURSOR C1 IS
1864: SELECT *
1865: FROM igi_po_vendors ipv
1866: WHERE ipv.vendor_id = (select pv.vendor_id
1867: from ap_suppliers pv
1868: where pv.rowid = X_rowid )
1869: FOR UPDATE OF ipv.vendor_id NOWAIT;
1870: RecSupp1 C1%ROWTYPE;
1871: