DBA Data[Home] [Help]

APPS.PO_RFQ_VENDORS_PKG_S2 dependencies on PO_RFQ_VENDORS

Line 1: PACKAGE BODY PO_RFQ_VENDORS_PKG_S2 as

1: PACKAGE BODY PO_RFQ_VENDORS_PKG_S2 as
2: /* $Header: POXPIR3B.pls 120.0.12010000.1 2008/09/18 12:20:57 appldev noship $ */
3:
4: PROCEDURE Update_Row(X_Rowid VARCHAR2,
5: X_Po_Header_Id NUMBER,

Line 35: UPDATE PO_RFQ_VENDORS

31: X_Attribute15 VARCHAR2
32:
33: ) IS
34: BEGIN
35: UPDATE PO_RFQ_VENDORS
36: SET
37: po_header_id = X_Po_Header_Id,
38: sequence_num = X_Sequence_Num,
39: last_update_date = X_Last_Update_Date,

Line 74: DELETE FROM PO_RFQ_VENDORS

70: END Update_Row;
71:
72: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
73: BEGIN
74: DELETE FROM PO_RFQ_VENDORS
75: WHERE rowid = X_Rowid;
76:
77: if (SQL%NOTFOUND) then
78: Raise NO_DATA_FOUND;

Line 84: DELETE FROM PO_RFQ_VENDORS

80: END Delete_Row;
81:
82: PROCEDURE Delete_All_Vendors(X_po_header_id NUMBER) IS
83: BEGIN
84: DELETE FROM PO_RFQ_VENDORS
85: WHERE po_header_id = X_po_header_id;
86:
87: exception
88: when NO_DATA_FOUND then null;

Line 92: END PO_RFQ_VENDORS_PKG_S2;

88: when NO_DATA_FOUND then null;
89: when OTHERS then raise;
90: END Delete_All_Vendors;
91:
92: END PO_RFQ_VENDORS_PKG_S2;