1 PACKAGE PO_RELEASES_SV4 AUTHID CURRENT_USER as
2 /* $Header: POXPOR4S.pls 115.4 2004/01/21 19:16:07 jskim ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: PO_RELEASES_SV
6
7 DESCRIPTION: Contains all server side procedures that access the
8 PO_RELEASES entity
9
10 CLIENT/SERVER: SERVER
11
12 LIBRARY NAME NONE
13
14 OWNER: KPOWELL
15
16 PROCEDURES/FUNCTIONS: get_release_num()
17 get_po_release_id()
18 val_release_date()
19 val_doc_num_unique()
20 val_approval_status()
21
22 ===========================================================================*/
23
24 /*===========================================================================
25 PROCEDURE NAME: get_release_num
26
27 DESCRIPTION: Gets the next release number to be created for
28 the Blanket or Schedule Release
29
30 PARAMETERS: po_header_id IN NUMBER
31 release_num IN OUT NUMBER
32
33 DESIGN REFERENCES:
34
35
36 ALGORITHM: Get the maximum release number created for the
37 PLANNED or BLANKET purchase order
38 If there is not a maximum, set the
39 release number to 1
40
41 NOTES:
42
43 OPEN ISSUES:
44
45 CLOSED ISSUES:
46
47 CHANGE HISTORY: KPOWELL CREATED 4/15
48
49 ===========================================================================*/
50
51 PROCEDURE release_post_query
52 (
53 X_release_id IN NUMBER,
54 X_rel_total OUT NOCOPY NUMBER,
55 X_encumbered_flag OUT NOCOPY VARCHAR2,
56 X_release_type IN VARCHAR2,
57 X_po_header_id IN NUMBER,
58 X_rel_total_2 OUT NOCOPY NUMBER,
59 X_ship_via_lookup_code OUT NOCOPY VARCHAR2,
60 X_ship_num OUT NOCOPY NUMBER,
61 p_ship_to_org_id IN NUMBER, --< Bug 3378554 Start >
62 p_po_authorization_status IN VARCHAR2,
63 p_freight_terms_lookup_code IN VARCHAR2,
64 p_fob_lookup_code IN VARCHAR2,
65 p_pay_on_code IN VARCHAR2,
66 x_ship_to_org_code OUT NOCOPY VARCHAR2,
67 x_agreement_status OUT NOCOPY VARCHAR2,
68 x_freight_terms OUT NOCOPY VARCHAR2,
69 x_fob OUT NOCOPY VARCHAR2,
70 x_pay_on_dsp OUT NOCOPY VARCHAR2 --< Bug 3378554 End >
71 );
72
73 PROCEDURE get_release_num
74 (X_po_header_id IN NUMBER,
75 X_release_num IN OUT NOCOPY NUMBER);
76
77 /*===========================================================================
78 PROCEDURE NAME: get_po_release_id
79
80 DESCRIPTION: Gets the po_release_id for a given release number.
81
82 PARAMETERS: release_id_record_type IN RECORD
83
84 DESIGN REFERENCES:
85
86
87 ALGORITHM:
88
89 NOTES:
90
91 OPEN ISSUES:
92
93 CLOSED ISSUES:
94
95 CHANGE HISTORY: DFONG 12/6/96 Created
96
97 ===========================================================================*/
98
99 PROCEDURE get_po_release_id (x_po_release_id_record IN OUT NOCOPY rcv_shipment_line_sv.release_id_record_type);
100
101 /*===========================================================================
102 PROCEDURE NAME: val_release_date
103
104 DESCRIPTION: Verifies that the release date is within
105 the start and end date of the BLANKET or
106 PLANNED purchase order.
107
108 PARAMETERS: po_header_id IN NUMBER
109 release_date IN DATE
110 X_valid_release_date_flag IN OUT VARCHAR2
111
112 DESIGN REFERENCES:
113
114 ALGORITHM:
115
116 NOTES:
117
118 OPEN ISSUES:
119
120 CLOSED ISSUES:
121
122 CHANGE HISTORY: KPOWELL CREATED 4/15
123
124 ===========================================================================*/
125 PROCEDURE val_release_date
126 (X_po_header_id IN NUMBER,
127 X_release_date IN DATE,
128 X_valid_release_date_flag IN OUT NOCOPY VARCHAR2);
129
130 /*===========================================================================
131 FUNCTION NAME: val_doc_num_unique
132
133 DESCRIPTION: Verifies that the release number is unique
134 for a Planned or Blanket purchase order.
135
136 PARAMETERS: X_po_header_id IN NUMBER,
137 X_release_num IN NUMBER,
138 X_rowid IN VARCHAR2
139
140 DESIGN REFERENCES:
141
142 ALGORITHM:
143
144 NOTES:
145
146 OPEN ISSUES:
147
148 CLOSED ISSUES:
149
150 CHANGE HISTORY: KPOWELL CREATED 5/4
151
152 ===========================================================================*/
153
154 FUNCTION val_doc_num_unique
155 (X_po_header_id IN NUMBER,
156 X_release_num IN NUMBER,
157 X_rowid IN VARCHAR2)
158 RETURN BOOLEAN;
159
160
161 /*===========================================================================
162 FUNCTION NAME: val_approval_status
163
164 DESCRIPTION: Validates if the approval status of the release
165 header needs to be changed.
166
167 PARAMETERS: X_po_release_id IN NUMBER,
168 X_release_num IN NUMBER,
169 X_agent_id IN NUMBER,
170 X_release_date IN DATE,
171 X_acceptance_required_flag IN VARCHAR2,
172 X_acceptance_due_date IN VARCHAR2
173
174 DESIGN REFERENCES:
175
176 ALGORITHM: If any of the following release header values
177 have changed, return FALSE indicating that
178 the release's approval status needs to be
179 changed.
180
181 release_num
182 agent_id
183 release_date
184 acceptance_required_flag
185 acceptance_due_date
186
187 NOTES:
188
189 OPEN ISSUES:
190
191 CLOSED ISSUES:
192
193 CHANGE HISTORY: KPOWELL CREATED 5/4
194
195 ===========================================================================*/
196 FUNCTION val_approval_status
197 (X_po_release_id IN NUMBER,
198 X_release_num IN NUMBER,
199 X_agent_id IN NUMBER,
200 X_release_date IN DATE,
201 X_acceptance_required_flag IN VARCHAR2,
202 X_acceptance_due_date IN VARCHAR2,
203 p_shipping_control IN VARCHAR2
204 -- <INBOUND LOGISTICS FPJ>
205 ) RETURN BOOLEAN;
206
207
208 END PO_RELEASES_SV4;