[Home] [Help]
PACKAGE: APPS.PO_SHIPMENTS_SV8
Source
1 PACKAGE PO_SHIPMENTS_SV8 AS
2 /* $Header: POXPOS8S.pls 120.1 2005/07/03 02:20:56 manram noship $*/
3 /*===========================================================================
4 FUNCTION NAME: val_start_dates()
5
6 DESCRIPTION: This function verifies that the start date that is
7 entered on the header is less than the earliest
8 shipment effective date on the document.
9
10 PARAMETERS: X_start_date IN DATE
11 X_po_header_id IN NUMBER
12
13 RETURN VALUE: BOOLEAN
14
15 DESIGN REFERENCES: ../POXSCERQ.dd
16
17 ALGORITHM:
18
19 NOTES:
20
21 OPEN ISSUES:
22
23 CLOSED ISSUES:
24
25 CHANGE HISTORY: Created 08-MAY-95 MSNYDER
26 ===========================================================================*/
27
28 FUNCTION val_start_dates
29 (X_start_date IN DATE,
30 X_po_header_id IN NUMBER) RETURN BOOLEAN;
31
32
33 /*===========================================================================
34 FUNCTION NAME: val_end_dates()
35
36 DESCRIPTION: This function verifies that the end date that is
37 entered on the header is greater than the latest
38 shipment expiration date on the document.
39
40 PARAMETERS: X_end_date IN DATE
41 X_po_header_id IN NUMBER
42
43 RETURN VALUE: BOOLEAN
44
45 DESIGN REFERENCES: ../POXSCERQ.dd
46
47 ALGORITHM:
48
49 NOTES:
50
51 OPEN ISSUES:
52
53 CLOSED ISSUES:
54
55 CHANGE HISTORY: Created 08-MAY-95 MSNYDER
56 ===========================================================================*/
57
58 FUNCTION val_end_dates
59 (X_end_date IN DATE,
60 X_po_header_id IN NUMBER) RETURN BOOLEAN;
61
62
63 /*===========================================================================
64 PROCEDURE NAME: autocreate_ship()
65
66 DESCRIPTION: This procedure autocreates ONE shipment
67 and attempts to autocreate ONE distribution.
68
69 PARAMETERS:
70
71 RETURN VALUE:
72
73 DESIGN REFERENCES:
74
75 ALGORITHM:
76
77 NOTES:
78
79 OPEN ISSUES:
80
81 CLOSED ISSUES:
82
83 CHANGE HISTORY: Created 07-28-95 SIYER
84 bug 451195 07-28-97 ssomasek added the X_ussgl_transaction_code
85
86 Modified 26-FEB-01 MCHANDAK(OPM-GML)
87 Bug# 1548597.. Added 3 process related fields.
88 X_secondary_unit_of_measure,X_secondary_quantity and
89 X_preferred_grade.
90 ===========================================================================*/
91
92 procedure autocreate_ship ( X_line_location_id IN OUT NOCOPY NUMBER,
93 X_last_update_date DATE,
94 X_last_updated_by NUMBER,
95 X_creation_date DATE,
96 X_created_by NUMBER,
97 X_last_update_login NUMBER,
98 X_po_header_id NUMBER,
99 X_po_line_id NUMBER,
100 X_type_lookup_code VARCHAR2,
101 X_quantity NUMBER,
102 X_ship_to_location_id NUMBER,
103 X_ship_org_id NUMBER,
104 X_need_by_date DATE,
105 X_promised_date DATE,
106 X_unit_price NUMBER,
107 X_tax_code_id NUMBER,
108 X_taxable_flag VARCHAR2,
109 X_enforce_ship_to_location VARCHAR2,
110 X_receiving_routing_id NUMBER,
111 X_inspection_required_flag VARCHAR2,
112 X_receipt_required_flag VARCHAR2,
113 X_qty_rcv_tolerance NUMBER,
114 X_qty_rcv_exception_code VARCHAR2,
115 X_days_early_receipt_allowed NUMBER,
116 X_days_late_receipt_allowed NUMBER,
117 X_allow_substitute_receipts VARCHAR2,
118 X_receipt_days_exception_code VARCHAR2,
119 X_invoice_close_tolerance NUMBER,
120 X_receive_close_tolerance NUMBER,
121 X_item_status VARCHAR2,
122 X_outside_operation_flag VARCHAR2,
123 X_destination_type_code VARCHAR2,
124 X_expense_accrual_code VARCHAR2,
125 X_item_id NUMBER,
126 X_ussgl_transaction_code VARCHAR2,
127 X_accrue_on_receipt_flag IN OUT NOCOPY VARCHAR2,
128 X_autocreated_ship IN OUT NOCOPY BOOLEAN,
129 X_unit_meas_lookup_code IN VARCHAR2, -- Added Bug 731564
130 p_value_basis IN VARCHAR2, -- <Complex Work R12>
131 p_matching_basis IN VARCHAR2, -- <Complex Work R12>
132 -- start of bug# 1548597
133 X_secondary_unit_of_measure IN VARCHAR2 default null,
134 X_secondary_quantity IN NUMBER default null,
135 X_preferred_grade IN VARCHAR2 default null,
136 p_consigned_from_supplier_flag IN VARCHAR2 default null --bug 3523348
137 -- end of bug# 1548597
138 ,p_org_id IN NUMBER default null -- <R12.MOAC>
139 ,p_outsourced_assembly IN NUMBER -- <R12 SHIKYU>
140 );
141 /*===========================================================================
142 PROCEDURE NAME: get_matching_controls
143
144 DESCRIPTION: Get receipt required and inspection required fields.
145
146 PARAMETERS:
147
148 RETURN VALUE:
149
150 DESIGN REFERENCES:
151
152 ALGORITHM:
153
154 NOTES:
155
156 OPEN ISSUES:
157
158 CLOSED ISSUES:
159
160 CHANGE HISTORY: Created 10-28-95 kpowell
161 ===========================================================================*/
162 PROCEDURE get_matching_controls(
163 X_vendor_id IN number,
164 X_line_type_id IN number,
165 X_item_id IN number,
166 X_receipt_required_flag IN OUT NOCOPY VARCHAR2,
167 X_inspection_required_flag IN OUT NOCOPY VARCHAR2);
168
169
170
171 /* <TIMEPHASED FPI START> */
172 /*===========================================================================
173 PROCEDURE NAME: validate_effective_dates
174
175 DESCRIPTION:
176
177 PARAMETERS:
178
179 RETURN VALUE:
180
181 DESIGN REFERENCES: Family Pack 'I': Time Phased Pricing DLD
182
183 ALGORITHM:
184
185 NOTES:
186
187 OPEN ISSUES:
188
189 CLOSED ISSUES:
190
191 CHANGE HISTORY: Created 09-16-2002 davidng
192 ===========================================================================*/
193 PROCEDURE validate_effective_dates(p_start_date IN date, /* Header Start Date */
194 p_end_date IN date, /* Header End Date */
195 p_from_date IN date, /* Price Break Start Date */
196 p_to_date IN date, /* Price Break End Date */
197 p_expiration_date IN date, /* Line Expiration Date */
198 x_errormsg OUT NOCOPY varchar2); /* Error Message Name */
199
200
201
202 /*===========================================================================
203 PROCEDURE NAME: validate_pricebreak_attributes
204
205 DESCRIPTION:
206
207 PARAMETERS:
208
209 RETURN VALUE:
210
211 DESIGN REFERENCES: Family Pack 'I': Time Phased Pricing DLD
212
213 ALGORITHM:
214
215 NOTES:
216
217 OPEN ISSUES:
218
219 CLOSED ISSUES:
220
221 CHANGE HISTORY: Created 09-16-2002 davidng
222 ===========================================================================*/
223 PROCEDURE validate_pricebreak_attributes(p_from_date IN date, /* Price Break Start Date */
224 p_to_date IN date, /* Price Break End Date */
225 p_quantity IN varchar2, /* Price Break Quantity */
226 p_ship_to_org IN varchar2, /* Price Break Ship To Organization Code */
227 p_ship_to_location IN varchar2, /* Price Break Ship to Location Code */
228 x_errormsg_name OUT NOCOPY varchar2); /* Error Message Name */
229
230 /* <TIMEPHASED FPI END> */
231
232
233
234 END PO_SHIPMENTS_SV8;