DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_VALIDATION_RESULTS_TYPE

Line 10: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

6: -------------------------------------------------------------------------
7: PROCEDURE need_by_date(p_id_tbl IN PO_TBL_NUMBER,
8: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,
9: p_need_by_date_tbl IN PO_TBL_DATE,
10: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
11: x_result_type OUT NOCOPY VARCHAR2);
12:
13: -------------------------------------------------------------------------
14: -- if purchase_basis is 'TEMP LABOR', the promised_date must be null

Line 19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

15: -------------------------------------------------------------------------
16: PROCEDURE promised_date(p_id_tbl IN PO_TBL_NUMBER,
17: p_purchase_basis_tbl IN PO_TBL_VARCHAR30,
18: p_promised_date_tbl IN PO_TBL_DATE,
19: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
20: x_result_type OUT NOCOPY VARCHAR2);
21:
22: -------------------------------------------------------------------------
23: -- validate shipment type

Line 29: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

25: PROCEDURE shipment_type(p_id_tbl IN PO_TBL_NUMBER,
26: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
27: p_style_id_tbl IN po_tbl_number, -- PDOI for Complex PO Project
28: p_doc_type IN VARCHAR2,
29: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
30: x_result_type OUT NOCOPY VARCHAR2);
31:
32: -------------------------------------------------------------------------
33: -- PDOI for Complex PO Project: Validate payment type.

Line 40: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

36: po_line_id_tbl IN PO_TBL_NUMBER,
37: p_style_id_tbl IN PO_TBL_NUMBER,
38: p_payment_type_tbl IN PO_TBL_VARCHAR30,
39: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
40: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
41: x_result_type OUT NOCOPY VARCHAR2);
42:
43: -------------------------------------------------------------------------
44: -- validate shipment num is not null, greater than zero and unique

Line 55: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

51: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug 4642348
52: p_style_id_tbl IN PO_TBL_NUMBER, -- PDOI for Complex PO Project
53: p_doc_type IN VARCHAR2, -- bug 4642348
54: x_result_set_id IN OUT NOCOPY NUMBER,
55: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
56: x_result_type OUT NOCOPY VARCHAR2);
57:
58: -------------------------------------------------------------------------
59: -- If order_type_lookup_code is RATE or FIXED PRICE, validate quantity is not null

Line 68: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

64: p_shipment_type_tbl IN PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
65: p_style_id_tbl IN PO_TBL_NUMBER, -- PDOI for Complex PO Project
66: p_payment_type_tbl IN PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
67: p_line_quantity_tbl IN PO_TBL_NUMBER, -- PDOI for Complex PO Project
68: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
69: x_result_type OUT NOCOPY VARCHAR2);
70:
71: -------------------------------------------------------------------------
72: -- PDOI for Complex PO Project: Validate amount at shipment, for DELIVERY

Line 81: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

77: p_shipment_type_tbl IN PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
78: p_style_id_tbl IN PO_TBL_NUMBER, -- PDOI for Complex PO Project
79: p_payment_type_tbl IN PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
80: p_line_amount_tbl IN PO_TBL_NUMBER, -- PDOI for Complex PO Project
81: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
82: x_result_type OUT NOCOPY VARCHAR2);
83:
84: -------------------------------------------------------------------------
85: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null

Line 94: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

90: p_shipment_type_tbl IN PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
91: p_style_id_tbl IN PO_TBL_NUMBER, -- PDOI for Complex PO Project
92: p_payment_type_tbl IN PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
93: p_line_unit_price_tbl IN PO_TBL_NUMBER, -- PDOI for Complex PO Project
94: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
95: x_result_type OUT NOCOPY VARCHAR2);
96:
97: -------------------------------------------------------------------------
98: -- If order_type_lookup_code is not FIXED PRICE, price_discount cannot be null

Line 105: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

101: PROCEDURE price_discount(p_id_tbl IN PO_TBL_NUMBER,
102: p_price_discount_tbl IN PO_TBL_NUMBER,
103: p_price_override_tbl IN PO_TBL_NUMBER,
104: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
105: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
106: x_result_type OUT NOCOPY VARCHAR2);
107:
108: -------------------------------------------------------------------------
109: -- validate ship_to_organization_id

Line 129: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

125: p_to_date_tbl IN PO_TBL_DATE,
126: p_quantity_tbl IN PO_TBL_NUMBER,
127: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
128: p_ship_to_location_id_tbl IN PO_TBL_NUMBER,
129: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
130: x_result_type OUT NOCOPY VARCHAR2);
131:
132: -------------------------------------------------------------------------
133: -- validate_effective_dates

Line 142: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

138: p_from_date_tbl IN PO_TBL_DATE,
139: p_header_start_date_tbl IN PO_TBL_DATE,
140: p_header_end_date_tbl IN PO_TBL_DATE,
141: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
142: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
143: x_result_type OUT NOCOPY VARCHAR2);
144:
145: -------------------------------------------------------------------------
146: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

Line 152: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

148: -------------------------------------------------------------------------
149: PROCEDURE enforce_ship_to_loc_code(p_id_tbl IN PO_TBL_NUMBER,
150: p_enforce_ship_to_loc_code_tbl IN PO_TBL_VARCHAR30,
151: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
152: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
153: x_result_type OUT NOCOPY VARCHAR2);
154:
155: -------------------------------------------------------------------------
156: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal

Line 162: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

158: -------------------------------------------------------------------------
159: PROCEDURE allow_sub_receipts_flag(p_id_tbl IN PO_TBL_NUMBER,
160: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
161: p_allow_sub_receipts_flag_tbl IN PO_TBL_VARCHAR1,
162: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
163: x_result_type OUT NOCOPY VARCHAR2);
164:
165: -------------------------------------------------------------------------
166: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

Line 172: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

168: -------------------------------------------------------------------------
169: PROCEDURE days_early_receipt_allowed(p_id_tbl IN PO_TBL_NUMBER,
170: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
171: p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER,
172: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
173: x_result_type OUT NOCOPY VARCHAR2);
174:
175: -------------------------------------------------------------------------
176: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

Line 182: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

178: -------------------------------------------------------------------------
179: PROCEDURE receipt_days_exception_code(p_id_tbl IN PO_TBL_NUMBER,
180: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
181: p_rcpt_days_exception_code_tbl IN PO_TBL_VARCHAR30,
182: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
183: x_result_type OUT NOCOPY VARCHAR2);
184:
185: -------------------------------------------------------------------------
186: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

Line 192: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

188: -------------------------------------------------------------------------
189: PROCEDURE invoice_close_tolerance(p_id_tbl IN PO_TBL_NUMBER,
190: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
191: p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER,
192: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
193: x_result_type OUT NOCOPY VARCHAR2);
194:
195: -------------------------------------------------------------------------
196: -- If shipment_type is STANDARD and receive_close_tolerance is not null

Line 202: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

198: -------------------------------------------------------------------------
199: PROCEDURE receive_close_tolerance(p_id_tbl IN PO_TBL_NUMBER,
200: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
201: p_receive_close_tolerance_tbl IN PO_TBL_NUMBER,
202: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
203: x_result_type OUT NOCOPY VARCHAR2);
204:
205: -------------------------------------------------------------------------
206: -- Validate that receiving routing id exists in rcv_routing_headers

Line 219: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

215: -- Validate accrue_on_receipt_flag is Y or N, if not null.
216: -------------------------------------------------------------------------
217: PROCEDURE accrue_on_receipt_flag(p_id_tbl IN PO_TBL_NUMBER,
218: p_accrue_on_receipt_flag_tbl IN PO_TBL_VARCHAR1,
219: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
220: x_result_type OUT NOCOPY VARCHAR2);
221:
222: -------------------------------------------------------------------------
223: -- PDOI for Complex PO Project: Validate advance amount at shipment.

Line 231: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

227: p_advance_tbl IN PO_TBL_NUMBER,
228: p_amount_tbl IN PO_TBL_NUMBER,
229: p_quantity_tbl IN PO_TBL_NUMBER,
230: p_price_tbl IN PO_TBL_NUMBER,
231: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
232: x_result_type OUT NOCOPY VARCHAR2);
233:
234: -------------------------------------------------------------------------------------
235: -- Validate price_breaks_flag = Y for the given style

Line 297: x_results IN OUT NOCOPY po_validation_results_type,

293: -------------------------------------------------------------------------
294: PROCEDURE price_break(
295: p_id_tbl IN po_tbl_number,
296: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
297: x_results IN OUT NOCOPY po_validation_results_type,
298: x_result_type OUT NOCOPY VARCHAR2);
299:
300: END PO_VAL_SHIPMENTS2;