1 PACKAGE PO_RFQ_VENDOR_SV AUTHID CURRENT_USER as
2 /* $Header: POXSORVS.pls 115.2 2002/11/25 22:38:32 sbull ship $ */
3 /*===========================================================================
4 PACKAGE NAME: PO_RFQ_VENDOR_SV
5
6 DESCRIPTION: This package contains the server side RFQ Vendor
7 related Application Program Interfaces (APIs).
8
9 CLIENT/SERVER: Server
10
11 OWNER: Melissa Snyder
12
13 PROCEDURE NAMES: get_sequence_num()
14 val_seq_num_unique()
15 ===========================================================================*/
16
17 /*===========================================================================
18
19 PROCEDURE NAME: get_sequence_num()
20
21 DESCRIPTION: This procedure will get the next sequence number
22 to be defaulted for an RFQ Vendor line.
23
24 PARAMETERS: X_po_header_id IN NUMBER
25 X_sequence_num IN OUT NUMBER
26
27 DESIGN REFERENCES: ../POXSCERQ.dd
28
29 ALGORITHM:
30
31 NOTES:
32
33 OPEN ISSUES:
34
35 CLOSED ISSUES:
36
37 CHANGE HISTORY: Created 08-MAY-95 MSNYDER
38 ===========================================================================*/
39
40 PROCEDURE test_get_sequence_num(X_po_header_id IN NUMBER);
41
42 PROCEDURE get_sequence_num
43 (X_po_header_id IN NUMBER,
44 X_sequence_num IN OUT NOCOPY NUMBER);
45
46 /*===========================================================================
47 PROCEDURE NAME: val_seq_num_unique()
48
49 DESCRIPTION: This procedure will verify the chosen sequence
50 number is unique to the RFQ Vendor list
51
52 PARAMETERS: X_po_header_id IN NUMBER
53 X_sequence_num IN NUMBER
54 X_seq_num_is_unique IN OUT VARCHAR2
55
56 DESIGN REFERENCES: ../POXSCERQ.dd
57
58 ALGORITHM:
59
60 NOTES:
61
62 OPEN ISSUES:
63
64 CLOSED ISSUES:
65
66 CHANGE HISTORY: Created 08-MAY-95 MSNYDER
67 ===========================================================================*/
68
69 PROCEDURE test_val_seq_num_unique
70 (X_po_header_id IN NUMBER,
71 X_sequence_num IN NUMBER);
72
73 PROCEDURE val_seq_num_unique
74 (X_po_header_id IN NUMBER,
75 X_sequence_num IN NUMBER,
76 X_seq_num_is_unique IN OUT NOCOPY VARCHAR2);
77
78 END PO_RFQ_VENDOR_SV;