1 PACKAGE PO_RFQS_SV AUTHID CURRENT_USER as
2 /* $Header: POXSORFS.pls 120.0.12000000.3 2007/10/11 13:54:49 ppadilam ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: PO_RFQS_SV
6
7 DESCRIPTION: This package contains the RFQ specific
8 Application Program Interfaces (APIs).
9
10 CLIENT/SERVER: Server
11
12 OWNER: Melissa Snyder
13
14 PROCEDURE NAMES: val_header_delete()
15 val_line_delete()
16 get_vendor_count()
17 val_vendor_site()
18 val_vendor_update()
19 ===========================================================================*/
20
21
22 /*===========================================================================
23 PROCEDURE NAME: val_header_delete()
24
25 DESCRIPTION: This function verifies that the header selected for
26 deletion has not been printed and is not referenced on
27 a quotation. If it has been printed or is referenced,
28 deletion is prohibited.
29
30 PARAMETERS: X_po_header_id IN NUMBER
31 X_allow_delete IN OUT BOOLEAN
32
33 DESIGN REFERENCES: ../POXSCERQ.dd
34
35 ALGORITHM:
36
37 NOTES:
38
39 OPEN ISSUES:
40
41 CLOSED ISSUES:
42
43 CHANGE HISTORY: Created 05-MAY-95 MSNYDER
44 ===========================================================================*/
45
46 PROCEDURE test_val_header_delete(X_po_header_id IN NUMBER);
47
48 PROCEDURE val_header_delete
49 (X_po_header_id IN NUMBER,
50 X_allow_delete IN OUT NOCOPY BOOLEAN);
51
52
53 /*===========================================================================
54 PROCEDURE NAME: val_line_delete()
55
56 DESCRIPTION: This procedure verifies that the line selected for
57 deletion has not been autocreated to a quotation.
58 If it has been autocreated, deletion is prohibited.
59
60 PARAMETERS: X_po_header_id IN NUMBER
61 X_po_line_id IN NUMBER
62 X_allow_delete IN VARCHAR2
63
64 DESIGN REFERENCES: ../POXSCERQ.dd
65
66 ALGORITHM:
67
68 NOTES:
69
70 OPEN ISSUES:
71
72 CLOSED ISSUES:
73
74 CHANGE HISTORY: Created 05-MAY-95 MSNYDER
75 ===========================================================================*/
76
77 PROCEDURE test_val_line_delete
78 (X_po_line_id IN NUMBER,
79 X_po_header_id IN NUMBER);
80
81 PROCEDURE val_line_delete
82 (X_po_line_id IN NUMBER,
83 X_po_header_id IN NUMBER,
84 X_allow_delete IN OUT NOCOPY VARCHAR2);
85
86 /*===========================================================================
87 FUNCTION NAME: get_vendor_count()
88
89 DESCRIPTION: This function gets the number of vendors included
90 in a specific vendor list.
91
92 PARAMETERS: X_vendor_list_header_id IN NUMBER
93
94 DESIGN REFERENCES: ../POXSCERQ.dd
95
96 ALGORITHM:
97
98 NOTES:
99
100 OPEN ISSUES:
101
102 CLOSED ISSUES:
103
104 CHANGE HISTORY: Created 13-NOV-95 MSNYDER
105 ===========================================================================*/
106
107 FUNCTION get_vendor_count
108 (X_vendor_list_header_id IN NUMBER) RETURN NUMBER;
109
110 /*===========================================================================
111 FUNCTION NAME: val_vendor_site()
112
113 DESCRIPTION: This function verifies that a particular vendor/site
114 combination is unique to an RFQ.
115
116 PARAMETERS: X_po_header_id IN NUMBER
117 X_vendor_id IN NUMBER
118 X_vendor_site_id IN NUMBER
119 X_row_id IN NUMBER
120
121 DESIGN REFERENCES: ../POXSCERQ.dd
122
123 ALGORITHM:
124
125 NOTES:
126
127 OPEN ISSUES:
128
129 CLOSED ISSUES:
130
131 CHANGE HISTORY: Created 15-NOV-95 MSNYDER
132 ===========================================================================*/
133
134 FUNCTION val_vendor_site
135 (X_po_header_id IN NUMBER,
136 X_vendor_id IN NUMBER,
137 X_vendor_site_id IN NUMBER,
138 X_row_id IN VARCHAR2) RETURN BOOLEAN;
139
140 /*===========================================================================
141 FUNCTION NAME: val_vendor_update()
142
143 DESCRIPTION: This function performs a verification check when
144 vendor information is changed. If the vendor
145 is already referenced on a quote, the change is
146 not permitted.
147
148 PARAMETERS: X_po_header_id IN NUMBER
149 X_vendor_id IN NUMBER
150 X_vendor_site_id IN NUMBER
151 X_row_id IN NUMBER
152
153 DESIGN REFERENCES: ../POXSCERQ.dd
154
155 ALGORITHM:
156
157 NOTES:
158
159 OPEN ISSUES:
160
161 CLOSED ISSUES:
162
163 CHANGE HISTORY: Created 15-NOV-95 MSNYDER
164 ===========================================================================*/
165
166 FUNCTION val_vendor_update
167 (X_po_header_id IN NUMBER,
168 X_vendor_id IN NUMBER,
169 X_vendor_site_id IN NUMBER) RETURN BOOLEAN;
170
171 /*===========================================================================
172 PROCEDURE NAME: copy_vendor_list_to_rfq()
173
174 DESCRIPTION: This procedure inserts the vendors on a particular
175 vendor list into the PO_RFQ_VENDORS table.
176
177 PARAMETERS: X_row_id IN OUT VARCHAR2,
178 X_po_header_id IN OUT NUMBER,
179 X_max_sequence_num IN NUMBER,
180 X_last_update_date IN DATE,
181 X_last_updated_by IN NUMBER,
182 X_last_update_login IN NUMBER,
183 X_creation_date IN DATE,
184 X_created_by IN NUMBER,
185 X_list_header_id IN NUMBER
186
187 DESIGN REFERENCES: ../POXSCERQ.dd
188
189 ALGORITHM:
190
191 NOTES:
192
193 OPEN ISSUES:
194
195 CLOSED ISSUES:
196
197 CHANGE HISTORY: Created 15-DEC-95 MSNYDER
198 ===========================================================================*/
199 PROCEDURE copy_vendor_list_to_rfq
200 (X_rowid IN OUT NOCOPY VARCHAR2,
201 X_po_header_id IN OUT NOCOPY NUMBER,
202 X_max_sequence_num IN NUMBER,
203 X_last_update_date IN DATE,
204 X_last_updated_by IN NUMBER,
205 X_last_update_login IN NUMBER,
206 X_creation_date IN DATE,
207 X_created_by IN NUMBER,
208 X_list_header_id IN NUMBER,
209 x_vendors_hold IN OUT NOCOPY VARCHAR2); -- Bug # 6161855
210
211 END PO_RFQS_SV;