1 PACKAGE PO_QUOTES_SV AUTHID CURRENT_USER as
2 /* $Header: POXSOQUS.pls 115.2 2002/11/25 22:38:50 sbull ship $ */
3 /*===========================================================================
4 PACKAGE NAME: PO_QUOTES_SV
5
6 DESCRIPTION: This package contains the Quotation specific
7 Application Program Interfaces (APIs).
8
9 CLIENT/SERVER: Server
10
11 OWNER: Melissa Snyder
12
13 PROCEDURE NAMES: val_header_delete()
14 val_line_delete()
15 val_reply()
16 get_quote_status()
17 get_from_rfq_defaults()
18 get_approved_status()
19 ===========================================================================*/
20
21 /*===========================================================================
22 PROCEDURE NAME: val_header_delete()
23
24 DESCRIPTION: This procedure verifies that the document selected
25 for deletion is not not referenced on a Purchase
26 Order line.
27 If it is referenced, deletion is prohibited.
28
29 PARAMETERS: X_po_header_id IN NUMBER
30 X_allow_delete IN OUT BOOLEAN
31
32 DESIGN REFERENCES: ../POXSCERQ.dd
33
34 ALGORITHM:
35
36 NOTES:
37
38 OPEN ISSUES:
39
40 CLOSED ISSUES:
41
42 CHANGE HISTORY: Created 11-MAY-95 MSNYDER
43 ===========================================================================*/
44
45 PROCEDURE test_val_header_delete
46 (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 PROCEDURE NAME: val_line_delete()
54
55 DESCRIPTION: This procedure verifies that the line selected for
56 deletion is not used in autosource rules, or is
57 not referenced on a requisition or Purchase Order line.
58 If it is used or referenced, deletion is prohibited.
59
60 PARAMETERS: X_po_line_id IN NUMBER
61 X_po_line_num IN NUMBER
62 X_po_header_id IN NUMBER
63 X_allow_delete IN OUT VARCHAR2
64
65 DESIGN REFERENCES: ../POXSCERQ.dd
66
67 ALGORITHM:
68
69 NOTES:
70
71 OPEN ISSUES:
72
73 CLOSED ISSUES:
74
75 CHANGE HISTORY: Created 05-MAY-95 MSNYDER
76 ===========================================================================*/
77
78 PROCEDURE test_val_line_delete
79 (X_po_line_id IN NUMBER,
80 X_po_line_num IN NUMBER,
81 X_po_header_id IN NUMBER);
82
83 PROCEDURE val_line_delete
84 (X_po_line_id IN NUMBER,
85 X_po_line_num IN NUMBER,
86 X_po_header_id IN NUMBER,
87 X_allow_delete IN OUT NOCOPY VARCHAR2);
88
89 /*===========================================================================
90 FUNCTION NAME: val_reply()
91
92 DESCRIPTION: When entering a Quotation, if the user specifies an
93 RFQ number for reference, this function checks to see
94 if there is already a recorded quote for the selected
95 supplier/site combination, and if there is one already
96 existing, warns the user of it's existance.
97
98 PARAMETERS: X_from_header_id IN NUMBER
99 X_vendor_id IN NUMBER
100 X_vendor_site_id IN NUMBER
101
102 RETURN VALUE: BOOLEAN
103
104 DESIGN REFERENCES: ../POXSCERQ.dd
105
106 ALGORITHM:
107
108 NOTES:
109
110 OPEN ISSUES:
111
112 CLOSED ISSUES:
113
114 CHANGE HISTORY: Created 08-MAY-95 MSNYDER
115 ===========================================================================*/
116
117 PROCEDURE test_val_reply
118 (X_from_header_id IN NUMBER,
119 X_vendor_id IN NUMBER,
120 X_vendor_site_id IN NUMBER);
121
122 FUNCTION val_reply
123 (X_from_header_id IN NUMBER,
124 X_vendor_id IN NUMBER,
125 X_vendor_site_id IN NUMBER) RETURN BOOLEAN;
126
127 /*===========================================================================
128 PROCEDURE NAME: get_quote_status()
129
130 DESCRIPTION: This procedure verifies the quotation is not referenced
131 on a purchase order (line), or used in autosource rules
132 This is used when deciding if the supplier field is
133 updateable or not.
134
135 PARAMETERS: X_po_header_id IN NUMBER,
136 X_quote_referenced IN OUT VARCHAR2
137
138 DESIGN REFERENCES: ../POXSCERQ.dd
139
140 ALGORITHM:
141
142 NOTES:
143
144 OPEN ISSUES:
145
146 CLOSED ISSUES:
147
148 CHANGE HISTORY: Created 08-MAY-95 MSNYDER
149 ===========================================================================*/
150
151 PROCEDURE test_get_quote_status
152 (X_po_header_id IN NUMBER);
153
154 PROCEDURE get_quote_status
155 (X_po_header_id IN NUMBER,
156 X_quote_referenced IN OUT NOCOPY VARCHAR2);
157
158 /*===========================================================================
159 PROCEDURE NAME: get_from_rfq_defaults()
160
161 DESCRIPTION: This procedure gets the following from RFQ number
162 field defaults:
163 o rfq_close_date
164 o type_lookup_code
165 o approval_required_flag
166
167 PARAMETERS: X_po_header_id IN NUMBER
168 X_rfq_close_date IN OUT DATE
169 X_from_type_lookup_code IN OUT VARCHAR2
170 X_approval_required_flag IN OUT VARCHAR2
171
172 DESIGN REFERENCES: ../POXSCERQ.dd
173
174 ALGORITHM:
175
176 NOTES:
177
178 OPEN ISSUES: Kevin suggested defaulting more information when the user
179 enters an RFQ number for reference. I am not sure which
180 other fields should be defaulted based on the RFQ number.
181 Besides, that is what COPY function (autocreate) is for.
182 Should we encompass that functionality in Entry form?
183 For now, I am only including the fields we defaulted
184 in Release 10.
185
186 CLOSED ISSUES:
187
188 CHANGE HISTORY: Created 08-MAY-95 MSNYDER
189 ===========================================================================*/
190 PROCEDURE test_get_from_rfq_defaults
191 (X_from_header_id IN NUMBER);
192
193 PROCEDURE get_from_rfq_defaults
194 (X_from_header_id IN NUMBER,
195 X_rfq_close_date IN OUT NOCOPY DATE,
196 X_from_type_lookup_code IN OUT NOCOPY VARCHAR2,
197 X_approval_required_flag IN OUT NOCOPY VARCHAR2);
198
199
200 /*===========================================================================
201 PROCEDURE NAME: get_approval_status()
202
203 DESCRIPTION: This procedure checks if a particular shipment line
204 has been approved.
205
206 PARAMETERS: X_line_location_id IN NUMBER
207 X_approval_status IN OUT VARCHAR2
208
209 DESIGN REFERENCES: ../POXSCERQ.dd
210
211 ALGORITHM:
212
213 NOTES:
214
215 OPEN ISSUES:
216
217 CLOSED ISSUES:
218
219 CHANGE HISTORY: Created 03-JAN-96 MSNYDER
220 ===========================================================================*/
221 PROCEDURE get_approval_status
222 (X_line_location_id IN NUMBER,
223 X_approval_status IN OUT NOCOPY VARCHAR2);
224
225 END PO_QUOTES_SV;