[Home] [Help]
11:
12: PROCEDURE dist_num_gt_zero(
13: p_dist_id_tbl IN PO_TBL_NUMBER
14: , p_dist_num_tbl IN PO_TBL_NUMBER
15: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
16: , x_result_type OUT NOCOPY VARCHAR2
17: );
18:
19: PROCEDURE quantity_gt_zero(
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:
27: --
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:
48: --
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:
72: PROCEDURE oop_enter_all_fields(
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: );
83:
84: PROCEDURE amount_to_encumber_ge_zero(
83:
84: PROCEDURE amount_to_encumber_ge_zero(
85: p_dist_id_tbl IN PO_TBL_NUMBER
86: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
87: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
88: , x_result_type OUT NOCOPY VARCHAR2
89: );
90:
91: PROCEDURE budget_account_id_not_null(
90:
91: PROCEDURE budget_account_id_not_null(
92: p_dist_id_tbl IN PO_TBL_NUMBER
93: , p_budget_account_id_tbl IN PO_TBL_NUMBER
94: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
95: , x_result_type OUT NOCOPY VARCHAR2
96: );
97:
98: PROCEDURE gl_encumbered_date_not_null(
97:
98: PROCEDURE gl_encumbered_date_not_null(
99: p_dist_id_tbl IN PO_TBL_NUMBER
100: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
101: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
102: , x_result_type OUT NOCOPY VARCHAR2
103: );
104:
105: PROCEDURE gl_enc_date_not_null_open(
105: PROCEDURE gl_enc_date_not_null_open(
106: p_dist_id_tbl IN PO_TBL_NUMBER
107: , p_org_id_tbl IN PO_TBL_NUMBER
108: , p_gl_encumbered_date_tbl IN PO_TBL_DATE
109: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
110: , x_result_type OUT NOCOPY VARCHAR2
111: );
112:
113: PROCEDURE gms_data_valid(
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: );
123:
124: PROCEDURE check_fv_validations(
139: , p_attribute12_tbl IN PO_TBL_VARCHAR2000
140: , p_attribute13_tbl IN PO_TBL_VARCHAR2000
141: , p_attribute14_tbl IN PO_TBL_VARCHAR2000
142: , p_attribute15_tbl IN PO_TBL_VARCHAR2000
143: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
144: , x_result_type OUT NOCOPY VARCHAR2
145: );
146:
147: PROCEDURE unencum_amt_le_amt_to_encum(
147: PROCEDURE unencum_amt_le_amt_to_encum(
148: p_dist_id_tbl IN PO_TBL_NUMBER
149: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER
150: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER
151: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
152: , x_result_type OUT NOCOPY VARCHAR2
153: );
154:
155: -- Bug 7558385
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
169: , x_result_type OUT NOCOPY VARCHAR2
170: );
171:
172: END PO_VAL_DISTRIBUTIONS;