APPS.PO_RFQ_VENDORS_PKG_S3 dependencies on PO_RFQ_VENDORS

Line 1: PACKAGE BODY PO_RFQ_VENDORS_PKG_S3 as

1: PACKAGE BODY PO_RFQ_VENDORS_PKG_S3 as
2: /* $Header: POXPIR4B.pls 115.0 99/07/17 01:50:03 porting ship $ */
3: /*========================================================================
4: ** PROCEDURE NAME : check_unique
5: ** DESCRIPTION : We need either the po_line_id OR po_release_id

Line 29: FROM po_rfq_vendors

25: SELECT 1
26: INTO dummy
27: FROM DUAL
28: WHERE not exists (SELECT 1
29: FROM po_rfq_vendors
30: WHERE po_header_id = X_po_header_id
31: AND sequence_num = X_sequence_num
32: AND ((X_rowid is null) or
33: (X_rowid != rowid)));

Line 62: FROM po_rfq_vendors

58: X_progress := '010';
59:
60: SELECT nvl(max(sequence_num),0)
61: INTO X_max_sequence_num
62: FROM po_rfq_vendors
63: WHERE po_header_id = X_po_header_id;
64:
65: X_progress := '020';
66:

Line 76: END PO_RFQ_VENDORS_PKG_S3;

72: RAISE;
73:
74: END get_max_sequence_num;
75:
76: END PO_RFQ_VENDORS_PKG_S3;