APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_TBL_VARCHAR30

Line 22: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

18:
19: PROCEDURE quantity_gt_zero(
20: p_dist_id_tbl IN PO_TBL_NUMBER
21: , p_qty_ordered_tbl IN PO_TBL_NUMBER
22: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24: , x_result_type OUT NOCOPY VARCHAR2
25: );
26:

Line 32: , p_dist_type_tbl IN PO_TBL_VARCHAR30

28: -- Combined quantity billed/del into quantity exec
29:
30: PROCEDURE quantity_ge_quantity_exec(
31: p_dist_id_tbl IN PO_TBL_NUMBER
32: , p_dist_type_tbl IN PO_TBL_VARCHAR30
33: , p_qty_ordered_tbl IN PO_TBL_NUMBER
34: , x_result_set_id IN OUT NOCOPY NUMBER
35: , x_result_type OUT NOCOPY VARCHAR2
36: );

Line 43: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --

39:
40: PROCEDURE amount_gt_zero(
41: p_dist_id_tbl IN PO_TBL_NUMBER
42: , p_amt_ordered_tbl IN PO_TBL_NUMBER
43: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
44: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
45: , x_result_type OUT NOCOPY VARCHAR2
46: );
47:

Line 53: , p_dist_type_tbl IN PO_TBL_VARCHAR30

49: -- Combined amount billed/del into amount exec
50:
51: PROCEDURE amount_ge_amount_exec(
52: p_dist_id_tbl IN PO_TBL_NUMBER
53: , p_dist_type_tbl IN PO_TBL_VARCHAR30
54: , p_amt_ordered_tbl IN PO_TBL_NUMBER
55: , x_result_set_id IN OUT NOCOPY NUMBER
56: , x_result_type OUT NOCOPY VARCHAR2
57: );

Line 63: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30

59: --
60:
61: PROCEDURE pjm_unit_number_effective(
62: p_dist_id_tbl IN PO_TBL_NUMBER
63: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
64: , p_item_id_tbl IN PO_TBL_NUMBER
65: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
66: -- Bug# 4338241: Checking if it is inventory and PJM is installed
67: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

Line 67: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

63: , p_end_item_unit_number_tbl IN PO_TBL_VARCHAR30
64: , p_item_id_tbl IN PO_TBL_NUMBER
65: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
66: -- Bug# 4338241: Checking if it is inventory and PJM is installed
67: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
68: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
69: , x_result_type OUT NOCOPY VARCHAR2
70: );
71:

Line 78: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30

74: , p_line_line_type_id_tbl IN PO_TBL_NUMBER
75: , p_wip_entity_id_tbl IN PO_TBL_NUMBER
76: , p_wip_line_id_tbl IN PO_TBL_NUMBER
77: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER
78: , p_destination_type_code_tbl IN PO_TBL_VARCHAR30
79: , p_wip_resource_seq_num_tbl IN PO_TBL_NUMBER
80: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81: , x_result_type OUT NOCOPY VARCHAR2
82: );

Line 118: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

114: p_dist_id_tbl IN PO_TBL_NUMBER
115: , p_project_id_tbl IN PO_TBL_NUMBER
116: , p_task_id_tbl IN PO_TBL_NUMBER
117: , p_award_number_tbl IN PO_TBL_VARCHAR2000
118: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
119: , p_expenditure_item_date_tbl IN PO_TBL_DATE
120: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
121: , x_result_type OUT NOCOPY VARCHAR2
122: );

Line 160: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30

156: -- Need to check for PJM Parameters before making Task as mandatory.
157: -- For fetching the PJM paramters passing ship to org id.
158: PROCEDURE check_proj_related_validations(
159: p_dist_id_tbl IN PO_TBL_NUMBER
160: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
161: , p_project_id_tbl IN PO_TBL_NUMBER
162: , p_task_id_tbl IN PO_TBL_NUMBER
163: , p_award_id_tbl IN PO_TBL_NUMBER
164: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

Line 164: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30

160: , p_dest_type_code_tbl IN PO_TBL_VARCHAR30
161: , p_project_id_tbl IN PO_TBL_NUMBER
162: , p_task_id_tbl IN PO_TBL_NUMBER
163: , p_award_id_tbl IN PO_TBL_NUMBER
164: , p_expenditure_type_tbl IN PO_TBL_VARCHAR30
165: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
166: , p_expenditure_item_date_tbl IN PO_TBL_DATE
167: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
168: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE