1 PACKAGE PO_CORE_SV1 AUTHID CURRENT_USER AS
2 /* $Header: POXPICOS.pls 120.1 2006/04/20 11:31:42 bao noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_effective_date()
6
7 DESCRIPTION: This API is used to validate if x_effective_date
8 is within the range of x_start_date and X_end_date
9
10 PARAMETERS: x_effective_date IN DATE,
11 x_po_header_id IN NUMBER
12
13 DESIGN
14 REFERENCES: 832vlapl.doc
15
16 ALGORITHM: API return TRUE if validation succeeds; FALSE
17 otherwise.
18
19 NOTES:
20
21 OPEN ISSUES:
22
23 CLOSE ISSUES:
24
25 CHANGE
26 HISTORY: Created 22-FEB-1996 DXYU
27
28
29 =======================================================================*/
30 FUNCTION val_effective_date(x_effective_date IN DATE,
31 x_po_header_id IN NUMBER)
32 RETURN BOOLEAN;
33
34 /*==================================================================
35 FUNCTION NAME: val_numeric_value()
36
37 DESCRIPTION: This API is used to validate if x_value is a numeric
38 value
39
40 PARAMETERS: x_value IN VARCHAR2
41
42 DESIGN
43 REFERENCES: 832vlapi.doc
44
45 ALGORITHM: API return TRUE if validation succeeds; FALSE
46 otherwise.
47
48 NOTES:
49
50 OPEN ISSUES:
51
52 CLOSE ISSUES:
53
54 CHANGE
55 HISTORY: Created 22-FEB-1996 SODAYAR
56
57
58 =======================================================================*/
59 FUNCTION val_numeric_value(x_value IN VARCHAR2) RETURN BOOLEAN;
60
61
62 /*==================================================================
63 FUNCTION NAME: val_start_and_end_date()
64
65 DESCRIPTION: This API is used to validate if x_start_date <=
66 x_end_date;
67
68 PARAMETERS: x_start_date IN DATE
69 x_end_date IN DATE
70 DESIGN
71 REFERENCES: 832vlapi.doc
72
73 ALGORITHM: API will return TRUE if validation succeeds, FALSE
74 otherwise.
75
76 NOTES:
77
78 OPEN ISSUES:
79
80 CLOSE ISSUES:
81
82 CHANGE
83 HISTORY: Created 22-FEB-1996 SODAYAR
84
85
86 =======================================================================*/
87 FUNCTION val_start_and_end_date(X_start_date IN DATE,
88 X_end_date IN DATE)
89 RETURN BOOLEAN;
90
91 /*==================================================================
92 FUNCTION NAME: val_flag_value()
93
94 DESCRIPTION: This API is used to validate if x_flag_value is valid
95 (the valid flag value is 'Y' or 'N')
96
97 PARAMETERS: x_flag_value IN VARCHAR2
98
99 DESIGN
100 REFERENCES: 832vlapi.doc
101
102 ALGORITHM: API will return TRUE if validation succeeds; FALSE
103 otherwise.
104
105 NOTES:
106
107 OPEN ISSUES:
108
109 CLOSE ISSUES:
110
111 CHANGE
112 HISTORY: Created 22-FEB-1996 SODAYAR
113
114
115 =======================================================================*/
116 FUNCTION val_flag_value(x_flag_value IN VARCHAR2) RETURN BOOLEAN;
117
118 /*==================================================================
119 FUNCTION NAME: default_po_unique_identifier()
120
121 DESCRIPTION: This API is used to obtain the system-generated
122 numbers for Oracle Purchasing tables which
123 requires special sequencing (defined in
124 po_unique_identifier_control)
125
126 It has one input parameter which specifies the table
127 which requires the sequence number. Valid table_name
128 are:
129 PO_HEADERS
130 PO_REQUISTION_HEADERS
131 PO_VENDORS
132 RCV_SHIPMENT_HEADERS
133 PO_HEADERS_QUOTE
134 PO_HEADERS_RFQ
135
136 PARAMETERS: x_table_name IN VARCHAR2
137
138
139 DESIGN
140 REFERENCES: 832dfapi.doc
141
142 ALGORITHM: System generated number for the specified table
143 (NUMBER) if found; NULL otherwise.
144
145 NOTES:
146
147 OPEN ISSUES:
148
149 CLOSE ISSUES:
150
151 CHANGE
152 HISTORY: Created 03-Mar-1996 Rajan Odayar
153 Modified 12-MAR-1996 Daisy Yu
154
155 =======================================================================*/
156 FUNCTION default_po_unique_identifier(X_table_name IN VARCHAR2)
157 RETURN VARCHAR2;
158
159 -- bug5174177 START
160 FUNCTION default_po_unique_identifier
161 ( p_table_name IN VARCHAR2,
162 p_org_id IN NUMBER
163 ) RETURN VARCHAR2;
164 -- bug5174177 END
165
166 /*==================================================================
167 FUNCTION NAME: val_max_and_min_qty()
168
169 DESCRIPTION: This API is used to validate if minimum qty is
170 less than maximum order qty.
171
172 PARAMETERS: x_qty1 IN NUMBER,
173 x_qty2 IN NUMBER
174 DESIGN
175 REFERENCES: 832vlapl.doc
176
177 ALGORITHM: API returns TRUE if successful, FALSE otherwise.
178
179 NOTES:
180
181 OPEN ISSUES:
182
183 CLOSE ISSUES:
184
185 CHANGE
186 HISTORY: Created 19-FEB-1996 DXYU
187
188
189 =======================================================================*/
190 FUNCTION val_max_and_min_qty(x_qty1 IN NUMBER,
191 x_qty2 IN NUMBER) RETURN BOOLEAN;
192
193 /*======================================================================
194 FUNCTION NAME: val_discount()
195
196 DESCRIPTION: This API is used to validate x_discount is within
197 0 and 100 range.
198
199 PARAMETERS: x_discount IN NUMBER
200
201
202 DESIGN REFERENCES: 832vlapl.doc
203
204 ALGORITHM: Return TRUE if successful, FALSE otherwise.
205
206 NOTES:
207
208 OPEN ISSUES:
209
210 CLOSE ISSUES:
211
212 CHANGE HISTORY: Created 19-FEB-1996 DXYU
213
214 =======================================================================*/
215
216 FUNCTION val_discount(x_discount IN NUMBER) RETURN BOOLEAN;
217
218 END PO_CORE_SV1;