APPS.PO_VAL_SHIPMENTS dependencies on PO_TBL_VARCHAR30

Line 43: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

39: );
40:
41: PROCEDURE match_4way_check(
42: p_line_loc_id_tbl IN PO_TBL_NUMBER
43: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
44: , p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1
45: , p_inspection_required_flag_tbl IN PO_TBL_VARCHAR1
46: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
47: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 46: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --

42: p_line_loc_id_tbl IN PO_TBL_NUMBER
43: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
44: , p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1
45: , p_inspection_required_flag_tbl IN PO_TBL_VARCHAR1
46: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
47: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
48: , x_result_type OUT NOCOPY VARCHAR2
49: );
50:

Line 81: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

77:
78: PROCEDURE ship_to_org_null_check(
79: p_line_loc_id_tbl IN PO_TBL_NUMBER
80: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
81: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
82: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
83: , x_result_type OUT NOCOPY VARCHAR2
84: );
85:

Line 89: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

85:
86: PROCEDURE ship_to_loc_null_check(
87: p_line_loc_id_tbl IN PO_TBL_NUMBER
88: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
89: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
90: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
91: , x_result_type OUT NOCOPY VARCHAR2
92: );
93:

Line 97: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --

93:
94: PROCEDURE ship_num_gt_zero(
95: p_line_loc_id_tbl IN PO_TBL_NUMBER
96: , p_shipment_num_tbl IN PO_TBL_NUMBER
97: , p_payment_type_tbl IN PO_TBL_VARCHAR30 --
98: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
99: , x_result_type OUT NOCOPY VARCHAR2
100: );
101:

Line 106: , p_shipment_type_tbl IN PO_TBL_VARCHAR30 --

102: PROCEDURE ship_num_unique_check(
103: p_line_loc_id_tbl IN PO_TBL_NUMBER
104: , p_line_id_tbl IN PO_TBL_NUMBER
105: , p_shipment_num_tbl IN PO_TBL_NUMBER
106: , p_shipment_type_tbl IN PO_TBL_VARCHAR30 --
107: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
108: , p_draft_id_tbl IN PO_TBL_NUMBER --
109: , x_result_set_id IN OUT NOCOPY NUMBER
110: , x_result_type OUT NOCOPY VARCHAR2

Line 127: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

123:
124: PROCEDURE quantity_gt_zero(
125: p_line_loc_id_tbl IN PO_TBL_NUMBER
126: , p_quantity_tbl IN PO_TBL_NUMBER
127: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
128: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
129: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131: , x_result_type OUT NOCOPY VARCHAR2

Line 128: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

124: PROCEDURE quantity_gt_zero(
125: p_line_loc_id_tbl IN PO_TBL_NUMBER
126: , p_quantity_tbl IN PO_TBL_NUMBER
127: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
128: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
129: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131: , x_result_type OUT NOCOPY VARCHAR2
132: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 129: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

125: p_line_loc_id_tbl IN PO_TBL_NUMBER
126: , p_quantity_tbl IN PO_TBL_NUMBER
127: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
128: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
129: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131: , x_result_type OUT NOCOPY VARCHAR2
132: , p_header_id_tbl IN PO_TBL_NUMBER --
133: );

Line 150: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

146:
147: PROCEDURE amount_gt_zero(
148: p_line_loc_id_tbl IN PO_TBL_NUMBER
149: , p_amount_tbl IN PO_TBL_NUMBER
150: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
151: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
152: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
153: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
154: , x_result_type OUT NOCOPY VARCHAR2

Line 151: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

147: PROCEDURE amount_gt_zero(
148: p_line_loc_id_tbl IN PO_TBL_NUMBER
149: , p_amount_tbl IN PO_TBL_NUMBER
150: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
151: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
152: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
153: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
154: , x_result_type OUT NOCOPY VARCHAR2
155: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 152: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

148: p_line_loc_id_tbl IN PO_TBL_NUMBER
149: , p_amount_tbl IN PO_TBL_NUMBER
150: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
151: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
152: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
153: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
154: , x_result_type OUT NOCOPY VARCHAR2
155: , p_header_id_tbl IN PO_TBL_NUMBER --
156: );

Line 183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

179: p_line_loc_id_tbl IN PO_TBL_NUMBER
180: , p_item_id_tbl IN PO_TBL_NUMBER
181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182: , p_quantity_tbl IN PO_TBL_NUMBER
183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
184: , p_sec_quantity_tbl IN PO_TBL_NUMBER
185: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187: , x_result_type OUT NOCOPY VARCHAR2

Line 185: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182: , p_quantity_tbl IN PO_TBL_NUMBER
183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
184: , p_sec_quantity_tbl IN PO_TBL_NUMBER
185: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187: , x_result_type OUT NOCOPY VARCHAR2
188: );
189: -- OPM Integration R12 End

Line 196: , p_payment_type_tbl IN PO_TBL_VARCHAR30

192: Bug 5385686 : Unit of measure must be checked for null on Pay Items
193: */
194: PROCEDURE unit_of_measure_not_null(
195: p_line_loc_id_tbl IN PO_TBL_NUMBER
196: , p_payment_type_tbl IN PO_TBL_VARCHAR30
197: , p_value_basis_tbl IN PO_TBL_VARCHAR30
198: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
199: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
200: , x_result_type OUT NOCOPY VARCHAR2

Line 197: , p_value_basis_tbl IN PO_TBL_VARCHAR30

193: */
194: PROCEDURE unit_of_measure_not_null(
195: p_line_loc_id_tbl IN PO_TBL_NUMBER
196: , p_payment_type_tbl IN PO_TBL_VARCHAR30
197: , p_value_basis_tbl IN PO_TBL_VARCHAR30
198: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
199: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
200: , x_result_type OUT NOCOPY VARCHAR2
201: );

Line 198: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

194: PROCEDURE unit_of_measure_not_null(
195: p_line_loc_id_tbl IN PO_TBL_NUMBER
196: , p_payment_type_tbl IN PO_TBL_VARCHAR30
197: , p_value_basis_tbl IN PO_TBL_VARCHAR30
198: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
199: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
200: , x_result_type OUT NOCOPY VARCHAR2
201: );
202:

Line 206: ,p_control_action_tbl IN PO_TBL_VARCHAR30

202:
203: --Mod Project
204: PROCEDURE mod_no_cancel_shp_complt(
205: p_line_loc_id_tbl IN PO_TBL_NUMBER
206: ,p_control_action_tbl IN PO_TBL_VARCHAR30
207: ,x_result_set_id IN OUT NOCOPY NUMBER
208: ,x_result_type OUT NOCOPY VARCHAR2
209: );
210:

Line 233: , p_value_basis_tbl IN PO_TBL_VARCHAR30

229:
230: PROCEDURE complex_price_or_gt_zero(
231: p_line_loc_id_tbl IN PO_TBL_NUMBER
232: , p_price_override_tbl IN PO_TBL_NUMBER
233: , p_value_basis_tbl IN PO_TBL_VARCHAR30
234: , p_payment_type_tbl IN PO_TBL_VARCHAR30
235: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
236: , x_result_type OUT NOCOPY VARCHAR2
237: );

Line 234: , p_payment_type_tbl IN PO_TBL_VARCHAR30

230: PROCEDURE complex_price_or_gt_zero(
231: p_line_loc_id_tbl IN PO_TBL_NUMBER
232: , p_price_override_tbl IN PO_TBL_NUMBER
233: , p_value_basis_tbl IN PO_TBL_VARCHAR30
234: , p_payment_type_tbl IN PO_TBL_VARCHAR30
235: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
236: , x_result_type OUT NOCOPY VARCHAR2
237: );
238: