APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_TBL_VARCHAR30

Line 144: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

140: -----------------------------------------------------------------------------
141: PROCEDURE quantity_gt_zero(
142: p_dist_id_tbl IN PO_TBL_NUMBER
143: , p_qty_ordered_tbl IN PO_TBL_NUMBER
144: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
145: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
146: , x_result_type OUT NOCOPY VARCHAR2
147: )
148: IS

Line 178: , p_dist_type_tbl IN PO_TBL_VARCHAR30

174: -- current transaction quantity, since over-billing/delivery is allowed.
175: -----------------------------------------------------------------------------
176: PROCEDURE quantity_ge_quantity_exec(
177: p_dist_id_tbl IN PO_TBL_NUMBER
178: , p_dist_type_tbl IN PO_TBL_VARCHAR30
179: , p_qty_ordered_tbl IN PO_TBL_NUMBER
180: , x_result_set_id IN OUT NOCOPY NUMBER
181: , x_result_type OUT NOCOPY VARCHAR2
182: )

Line 281: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

277: -----------------------------------------------------------------------------
278: PROCEDURE amount_gt_zero(
279: p_dist_id_tbl IN PO_TBL_NUMBER
280: , p_amt_ordered_tbl IN PO_TBL_NUMBER
281: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
282: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
283: , x_result_type OUT NOCOPY VARCHAR2
284: )
285: IS

Line 314: , p_dist_type_tbl IN PO_TBL_VARCHAR30

310: -- current transaction amount, since over-delivery/billing is allowed.
311: -----------------------------------------------------------------------------
312: PROCEDURE amount_ge_amount_exec(
313: p_dist_id_tbl IN PO_TBL_NUMBER
314: , p_dist_type_tbl IN PO_TBL_VARCHAR30
315: , p_amt_ordered_tbl IN PO_TBL_NUMBER
316: , x_result_set_id IN OUT NOCOPY NUMBER
317: , x_result_type OUT NOCOPY VARCHAR2
318: )

Line 420: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30

416: -- Where clauses derived from PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM
417: ------------------------------------------------------------------------
418: PROCEDURE pjm_unit_number_effective(
419: p_dist_id_tbl IN PO_TBL_NUMBER
420: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
421: , p_item_id_tbl IN PO_TBL_NUMBER
422: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
423: -- Bug# 4338241: Checking if it is inventory and PJM is installed
424: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

Line 424: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

420: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
421: , p_item_id_tbl IN PO_TBL_NUMBER
422: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
423: -- Bug# 4338241: Checking if it is inventory and PJM is installed
424: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
425: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
426: , x_result_type OUT NOCOPY VARCHAR2
427: )
428: IS

Line 508: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

504: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
505: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
506: , p_wip_line_id_tbl IN PO_TBL_NUMBER
507: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
508: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
509: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
510: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
511: , x_result_type OUT NOCOPY VARCHAR2
512: )

Line 812: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

808: p_dist_id_tbl IN PO_TBL_NUMBER
809: , p_project_id_tbl IN PO_TBL_NUMBER
810: , p_task_id_tbl IN PO_TBL_NUMBER
811: , p_award_number_tbl IN PO_TBL_VARCHAR2000
812: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
813: , p_expenditure_item_date_tbl IN PO_TBL_DATE
814: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
815: , x_result_type OUT NOCOPY VARCHAR2
816: )

Line 1013: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30

1009: -- expenditure item type is required.
1010: ------------------------------------------------------------------------
1011: PROCEDURE check_proj_related_validations(
1012: p_dist_id_tbl IN PO_TBL_NUMBER
1013: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1014: , p_project_id_tbl IN PO_TBL_NUMBER
1015: , p_task_id_tbl IN PO_TBL_NUMBER
1016: , p_award_id_tbl IN PO_TBL_NUMBER
1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

Line 1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

1013: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
1014: , p_project_id_tbl IN PO_TBL_NUMBER
1015: , p_task_id_tbl IN PO_TBL_NUMBER
1016: , p_award_id_tbl IN PO_TBL_NUMBER
1017: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
1018: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
1019: , p_expenditure_item_date_tbl IN PO_TBL_DATE
1020: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
1021: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE