APPS.AP_CARDS_PKG dependencies on AP_CARD_SUPPLIERS_V

Line 547: FROM Ap_Card_Suppliers_V

543: X_Rowid IN OUT NOCOPY VARCHAR2 ) IS
544:
545: CURSOR Fetch_Row_Id_Cur IS
546: SELECT row_id
547: FROM Ap_Card_Suppliers_V
548: WHERE Card_Id = x_card_id
549: AND Vendor_Id = x_vendor_id
550: AND Vendor_Site_Id = x_vendor_site_id;
551:

Line 554: INSERT INTO Ap_Card_Suppliers_V( Card_Id,

550: AND Vendor_Site_Id = x_vendor_site_id;
551:
552: BEGIN
553:
554: INSERT INTO Ap_Card_Suppliers_V( Card_Id,
555: Vendor_Id,
556: Vendor_Site_Id,
557: last_update_date,
558: last_updated_by,

Line 593: UPDATE Ap_Card_Suppliers_V

589: X_Last_Update_Date DATE,
590: X_Rowid VARCHAR2 ) IS
591: BEGIN
592:
593: UPDATE Ap_Card_Suppliers_V
594: SET Vendor_Site_Id = x_vendor_site_id,
595: Last_Updated_By = x_last_updated_by,
596: Last_Update_Login = x_last_update_login,
597: Last_Update_Date = x_last_update_date

Line 611: FROM ap_card_suppliers_v

607: X_Vendor_Site_Id NUMBER ) IS
608:
609: CURSOR C IS
610: SELECT *
611: FROM ap_card_suppliers_v
612: WHERE rowid = X_Rowid
613: FOR UPDATE of Card_Id NOWAIT;
614:
615: Recinfo C%ROWTYPE;

Line 640: DELETE FROM Ap_Card_Suppliers_V

636: END Supplier_Lock_Row;
637:
638: PROCEDURE Supplier_Delete_Row ( x_rowid IN VARCHAR2 ) IS
639: BEGIN
640: DELETE FROM Ap_Card_Suppliers_V
641: WHERE rowid = X_Rowid;
642:
643: IF (SQL%NOTFOUND) THEN
644: RAISE NO_DATA_FOUND;