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 28: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

24: -------------------------------------------------------------------------
25: PROCEDURE shipment_type(p_id_tbl IN PO_TBL_NUMBER,
26: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
27: p_doc_type IN VARCHAR2,
28: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
29: x_result_type OUT NOCOPY VARCHAR2);
30:
31: -------------------------------------------------------------------------
32: -- validate shipment num is not null, greater than zero and unique

Line 42: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

38: p_po_line_id_tbl IN PO_TBL_NUMBER,
39: p_draft_id_tbl IN PO_TBL_NUMBER, -- bug 4642348
40: p_doc_type IN VARCHAR2, -- bug 4642348
41: x_result_set_id IN OUT NOCOPY NUMBER,
42: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
43: x_result_type OUT NOCOPY VARCHAR2);
44:
45: -------------------------------------------------------------------------
46: -- If order_type_lookup_code is RATE or FIXED PRICE, validate quantity is not null

Line 51: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

47: -------------------------------------------------------------------------
48: PROCEDURE quantity(p_id_tbl IN PO_TBL_NUMBER,
49: p_quantity_tbl IN PO_TBL_NUMBER,
50: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
51: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
52: x_result_type OUT NOCOPY VARCHAR2);
53:
54: -------------------------------------------------------------------------
55: -- If order_type_lookup_code is not FIXED PRICE, price_override cannot be null

Line 60: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

56: -------------------------------------------------------------------------
57: PROCEDURE price_override(p_id_tbl IN PO_TBL_NUMBER,
58: p_price_override_tbl IN PO_TBL_NUMBER,
59: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
60: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
61: x_result_type OUT NOCOPY VARCHAR2);
62:
63: -------------------------------------------------------------------------
64: -- If order_type_lookup_code is not FIXED PRICE, price_discount cannot be null

Line 71: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

67: PROCEDURE price_discount(p_id_tbl IN PO_TBL_NUMBER,
68: p_price_discount_tbl IN PO_TBL_NUMBER,
69: p_price_override_tbl IN PO_TBL_NUMBER,
70: p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
71: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
72: x_result_type OUT NOCOPY VARCHAR2);
73:
74: -------------------------------------------------------------------------
75: -- validate ship_to_organization_id

Line 95: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

91: p_to_date_tbl IN PO_TBL_DATE,
92: p_quantity_tbl IN PO_TBL_NUMBER,
93: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
94: p_ship_to_location_id_tbl IN PO_TBL_NUMBER,
95: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
96: x_result_type OUT NOCOPY VARCHAR2);
97:
98: -------------------------------------------------------------------------
99: -- validate_effective_dates

Line 108: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

104: p_from_date_tbl IN PO_TBL_DATE,
105: p_header_start_date_tbl IN PO_TBL_DATE,
106: p_header_end_date_tbl IN PO_TBL_DATE,
107: p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30, -- bug5016163
108: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
109: x_result_type OUT NOCOPY VARCHAR2);
110:
111: -------------------------------------------------------------------------
112: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

Line 118: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

114: -------------------------------------------------------------------------
115: PROCEDURE enforce_ship_to_loc_code(p_id_tbl IN PO_TBL_NUMBER,
116: p_enforce_ship_to_loc_code_tbl IN PO_TBL_VARCHAR30,
117: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
118: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
119: x_result_type OUT NOCOPY VARCHAR2);
120:
121: -------------------------------------------------------------------------
122: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal

Line 128: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

124: -------------------------------------------------------------------------
125: PROCEDURE allow_sub_receipts_flag(p_id_tbl IN PO_TBL_NUMBER,
126: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
127: p_allow_sub_receipts_flag_tbl IN PO_TBL_VARCHAR1,
128: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
129: x_result_type OUT NOCOPY VARCHAR2);
130:
131: -------------------------------------------------------------------------
132: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

Line 138: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

134: -------------------------------------------------------------------------
135: PROCEDURE days_early_receipt_allowed(p_id_tbl IN PO_TBL_NUMBER,
136: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
137: p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER,
138: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
139: x_result_type OUT NOCOPY VARCHAR2);
140:
141: -------------------------------------------------------------------------
142: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

Line 148: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

144: -------------------------------------------------------------------------
145: PROCEDURE receipt_days_exception_code(p_id_tbl IN PO_TBL_NUMBER,
146: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
147: p_rcpt_days_exception_code_tbl IN PO_TBL_VARCHAR30,
148: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
149: x_result_type OUT NOCOPY VARCHAR2);
150:
151: -------------------------------------------------------------------------
152: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

Line 158: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

154: -------------------------------------------------------------------------
155: PROCEDURE invoice_close_tolerance(p_id_tbl IN PO_TBL_NUMBER,
156: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
157: p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER,
158: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
159: x_result_type OUT NOCOPY VARCHAR2);
160:
161: -------------------------------------------------------------------------
162: -- If shipment_type is STANDARD and receive_close_tolerance is not null

Line 168: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

164: -------------------------------------------------------------------------
165: PROCEDURE receive_close_tolerance(p_id_tbl IN PO_TBL_NUMBER,
166: p_shipment_type_tbl IN PO_TBL_VARCHAR30,
167: p_receive_close_tolerance_tbl IN PO_TBL_NUMBER,
168: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
169: x_result_type OUT NOCOPY VARCHAR2);
170:
171: -------------------------------------------------------------------------
172: -- Validate that receiving routing id exists in rcv_routing_headers

Line 185: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

181: -- Validate accrue_on_receipt_flag is Y or N, if not null.
182: -------------------------------------------------------------------------
183: PROCEDURE accrue_on_receipt_flag(p_id_tbl IN PO_TBL_NUMBER,
184: p_accrue_on_receipt_flag_tbl IN PO_TBL_VARCHAR1,
185: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
186: x_result_type OUT NOCOPY VARCHAR2);
187:
188: -------------------------------------------------------------------------------------
189: -- Validate price_breaks_flag = Y for the given style

Line 251: x_results IN OUT NOCOPY po_validation_results_type,

247: -------------------------------------------------------------------------
248: PROCEDURE price_break(
249: p_id_tbl IN po_tbl_number,
250: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
251: x_results IN OUT NOCOPY po_validation_results_type,
252: x_result_type OUT NOCOPY VARCHAR2);
253:
254: END PO_VAL_SHIPMENTS2;