APPS.IGI_STP_TABLE_HANDLER_PKG dependencies on IGI_PO_VENDORS

Line 1646: CURSOR C1 IS SELECT vendor_id FROM igi_po_vendors

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);
1649:
1650: v_rowid VARCHAR2(25);

Line 1728: INSERT INTO igi_po_vendors(

1724: Raise NO_DATA_FOUND;
1725: END IF;
1726: CLOSE C;
1727:
1728: INSERT INTO igi_po_vendors(
1729: vendor_id,
1730: stp_enforce_threshold,
1731: customer_id,
1732: creation_date,

Line 1839: UPDATE igi_po_vendors ipv

1835:
1836:
1837:
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);

Line 1865: FROM igi_po_vendors ipv

1861:
1862: RecSupp C%ROWTYPE;
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;