APPS.PO_VALIDATION_HELPER dependencies on PO_TBL_VARCHAR30

Line 111: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

107: PROCEDURE gt_zero_order_type_filter(
108: p_calling_module IN VARCHAR2
109: , p_value_tbl IN PO_TBL_NUMBER
110: , p_entity_id_tbl IN PO_TBL_NUMBER
111: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
112: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1
113: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
114: , p_check_quantity_types_flag IN VARCHAR2
115: , p_entity_type IN VARCHAR2

Line 113: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

109: , p_value_tbl IN PO_TBL_NUMBER
110: , p_entity_id_tbl IN PO_TBL_NUMBER
111: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
112: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1
113: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
114: , p_check_quantity_types_flag IN VARCHAR2
115: , p_entity_type IN VARCHAR2
116: , p_column_name IN VARCHAR2
117: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 126: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30

122: PROCEDURE gt_zero_order_type_filter(
123: p_calling_module IN VARCHAR2
124: , p_value_tbl IN PO_TBL_NUMBER
125: , p_entity_id_tbl IN PO_TBL_NUMBER
126: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
127: , p_check_quantity_types_flag IN VARCHAR2
128: , p_entity_type IN VARCHAR2
129: , p_column_name IN VARCHAR2
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 166: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --

162: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
163: , p_draft_id_tbl IN PO_TBL_NUMBER
164: , x_result_set_id IN OUT NOCOPY NUMBER
165: , x_result_type OUT NOCOPY VARCHAR2
166: , p_entity_type_tbl IN PO_TBL_VARCHAR30 DEFAULT NULL --
167: );
168:
169: PROCEDURE price_diff_value_unique(
170: p_calling_module IN VARCHAR2

Line 173: , p_entity_type_tbl IN PO_TBL_VARCHAR30

169: PROCEDURE price_diff_value_unique(
170: p_calling_module IN VARCHAR2
171: , p_price_diff_id_tbl IN PO_TBL_NUMBER
172: , p_entity_id_tbl IN PO_TBL_NUMBER
173: , p_entity_type_tbl IN PO_TBL_VARCHAR30
174: , p_unique_value_tbl IN PO_TBL_VARCHAR4000
175: , p_column_name IN VARCHAR2
176: , p_message_name IN VARCHAR2
177: , x_result_set_id IN OUT NOCOPY NUMBER

Line 247: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

243: , p_entity_id_tbl IN PO_TBL_NUMBER
244: , p_item_id_tbl IN PO_TBL_NUMBER
245: , p_inv_org_id_tbl IN PO_TBL_NUMBER
246: , p_quantity_tbl IN PO_TBL_NUMBER
247: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
248: , p_sec_quantity_tbl IN PO_TBL_NUMBER
249: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
250: , p_column_name IN VARCHAR2
251: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 249: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

245: , p_inv_org_id_tbl IN PO_TBL_NUMBER
246: , p_quantity_tbl IN PO_TBL_NUMBER
247: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
248: , p_sec_quantity_tbl IN PO_TBL_NUMBER
249: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
250: , p_column_name IN VARCHAR2
251: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
252: , x_result_type OUT NOCOPY VARCHAR2
253: );

Line 258: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,

254:
255: PROCEDURE secondary_unit_of_measure(
256: p_id_tbl IN po_tbl_number,
257: p_entity_type IN VARCHAR2,
258: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
259: p_item_id_tbl IN po_tbl_number,
260: p_item_tbl IN po_tbl_varchar2000,
261: p_organization_id_tbl IN po_tbl_number,
262: p_doc_type IN VARCHAR2,

Line 271: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

267: PROCEDURE secondary_quantity(
268: p_id_tbl IN po_tbl_number,
269: p_entity_type IN VARCHAR2,
270: p_secondary_quantity_tbl IN po_tbl_number,
271: p_order_type_lookup_code_tbl IN po_tbl_varchar30,
272: p_item_id_tbl IN po_tbl_number,
273: p_item_tbl IN po_tbl_varchar2000,
274: p_organization_id_tbl IN po_tbl_number,
275: p_doc_type IN VARCHAR2,

Line 283: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,

279:
280: PROCEDURE secondary_uom_update(
281: p_id_tbl IN po_tbl_number,
282: p_entity_type IN VARCHAR2,
283: p_secondary_unit_of_meas_tbl IN po_tbl_varchar30,
284: p_item_id_tbl IN po_tbl_number,
285: p_organization_id_tbl IN po_tbl_number,
286: p_create_or_update_item_flag IN VARCHAR2,
287: x_result_set_id IN OUT NOCOPY NUMBER,