DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_TBL_DATE

Line 9: p_need_by_date_tbl IN PO_TBL_DATE,

5: -- if purchase_basis is 'TEMP LABOR', the need_by_date column must be null
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: -------------------------------------------------------------------------

Line 18: p_promised_date_tbl IN PO_TBL_DATE,

14: -- if purchase_basis is 'TEMP LABOR', the promised_date must be null
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: -------------------------------------------------------------------------

Line 124: p_from_date_tbl IN PO_TBL_DATE,

120: -------------------------------------------------------------------------
121: -- validate price break attributes
122: -------------------------------------------------------------------------
123: PROCEDURE price_break_attributes(p_id_tbl IN PO_TBL_NUMBER,
124: p_from_date_tbl IN PO_TBL_DATE,
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,

Line 125: p_to_date_tbl IN PO_TBL_DATE,

121: -- validate price break attributes
122: -------------------------------------------------------------------------
123: PROCEDURE price_break_attributes(p_id_tbl IN PO_TBL_NUMBER,
124: p_from_date_tbl IN PO_TBL_DATE,
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,

Line 136: p_line_expiration_date_tbl IN PO_TBL_DATE,

132: -------------------------------------------------------------------------
133: -- validate_effective_dates
134: -------------------------------------------------------------------------
135: PROCEDURE effective_dates(p_id_tbl IN PO_TBL_NUMBER,
136: p_line_expiration_date_tbl IN PO_TBL_DATE,
137: p_to_date_tbl IN PO_TBL_DATE,
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,

Line 137: p_to_date_tbl IN PO_TBL_DATE,

133: -- validate_effective_dates
134: -------------------------------------------------------------------------
135: PROCEDURE effective_dates(p_id_tbl IN PO_TBL_NUMBER,
136: p_line_expiration_date_tbl IN PO_TBL_DATE,
137: p_to_date_tbl IN PO_TBL_DATE,
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

Line 138: p_from_date_tbl IN PO_TBL_DATE,

134: -------------------------------------------------------------------------
135: PROCEDURE effective_dates(p_id_tbl IN PO_TBL_NUMBER,
136: p_line_expiration_date_tbl IN PO_TBL_DATE,
137: p_to_date_tbl IN PO_TBL_DATE,
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,

Line 139: p_header_start_date_tbl IN PO_TBL_DATE,

135: PROCEDURE effective_dates(p_id_tbl IN PO_TBL_NUMBER,
136: p_line_expiration_date_tbl IN PO_TBL_DATE,
137: p_to_date_tbl IN PO_TBL_DATE,
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);

Line 140: p_header_end_date_tbl IN PO_TBL_DATE,

136: p_line_expiration_date_tbl IN PO_TBL_DATE,
137: p_to_date_tbl IN PO_TBL_DATE,
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:

Line 250: p_need_by_date_tbl IN PO_TBL_DATE,

246: -------------------------------------------------------------------------
247: PROCEDURE tax_name(p_id_tbl IN PO_TBL_NUMBER,
248: p_tax_name_tbl IN PO_TBL_VARCHAR30,
249: p_tax_code_id_tbl IN PO_TBL_NUMBER,
250: p_need_by_date_tbl IN PO_TBL_DATE,
251: p_allow_tax_code_override IN VARCHAR2,
252: p_operating_unit IN NUMBER,
253: x_result_set_id IN OUT NOCOPY NUMBER,
254: x_result_type OUT NOCOPY VARCHAR2);