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: , x_result_set_id IN OUT NOCOPY NUMBER
108: , x_result_type OUT NOCOPY VARCHAR2
109: );
110:

Line 125: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

121:
122: PROCEDURE quantity_gt_zero(
123: p_line_loc_id_tbl IN PO_TBL_NUMBER
124: , p_quantity_tbl IN PO_TBL_NUMBER
125: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
126: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
127: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
128: , x_result_type OUT NOCOPY VARCHAR2
129: );

Line 126: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

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

Line 145: , p_shipment_type_tbl IN PO_TBL_VARCHAR30

141:
142: PROCEDURE amount_gt_zero(
143: p_line_loc_id_tbl IN PO_TBL_NUMBER
144: , p_amount_tbl IN PO_TBL_NUMBER
145: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
146: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
147: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
148: , x_result_type OUT NOCOPY VARCHAR2
149: );

Line 146: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

142: PROCEDURE amount_gt_zero(
143: p_line_loc_id_tbl IN PO_TBL_NUMBER
144: , p_amount_tbl IN PO_TBL_NUMBER
145: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
146: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
147: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
148: , x_result_type OUT NOCOPY VARCHAR2
149: );
150:

Line 175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

171: p_line_loc_id_tbl IN PO_TBL_NUMBER
172: , p_item_id_tbl IN PO_TBL_NUMBER
173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174: , p_quantity_tbl IN PO_TBL_NUMBER
175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
176: , p_sec_quantity_tbl IN PO_TBL_NUMBER
177: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
178: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
179: , x_result_type OUT NOCOPY VARCHAR2

Line 177: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174: , p_quantity_tbl IN PO_TBL_NUMBER
175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
176: , p_sec_quantity_tbl IN PO_TBL_NUMBER
177: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
178: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
179: , x_result_type OUT NOCOPY VARCHAR2
180: );
181: -- OPM Integration R12 End

Line 188: , p_payment_type_tbl IN PO_TBL_VARCHAR30

184: Bug 5385686 : Unit of measure must be checked for null on Pay Items
185: */
186: PROCEDURE unit_of_measure_not_null(
187: p_line_loc_id_tbl IN PO_TBL_NUMBER
188: , p_payment_type_tbl IN PO_TBL_VARCHAR30
189: , p_value_basis_tbl IN PO_TBL_VARCHAR30
190: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
191: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
192: , x_result_type OUT NOCOPY VARCHAR2

Line 189: , p_value_basis_tbl IN PO_TBL_VARCHAR30

185: */
186: PROCEDURE unit_of_measure_not_null(
187: p_line_loc_id_tbl IN PO_TBL_NUMBER
188: , p_payment_type_tbl IN PO_TBL_VARCHAR30
189: , p_value_basis_tbl IN PO_TBL_VARCHAR30
190: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
191: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
192: , x_result_type OUT NOCOPY VARCHAR2
193: );

Line 190: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30

186: PROCEDURE unit_of_measure_not_null(
187: p_line_loc_id_tbl IN PO_TBL_NUMBER
188: , p_payment_type_tbl IN PO_TBL_VARCHAR30
189: , p_value_basis_tbl IN PO_TBL_VARCHAR30
190: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
191: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
192: , x_result_type OUT NOCOPY VARCHAR2
193: );
194: