DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on PO_TBL_NUMBER

Line 5: p_dist_id_tbl IN PO_TBL_NUMBER

1: PACKAGE PO_VAL_DISTRIBUTIONS AS
2: -- $Header: PO_VAL_DISTRIBUTIONS.pls 120.12.12010000.2 2008/12/08 10:42:35 cvardia ship $
3:
4: PROCEDURE dist_num_unique(
5: p_dist_id_tbl IN PO_TBL_NUMBER
6: , p_line_loc_id_tbl IN PO_TBL_NUMBER
7: , p_dist_num_tbl IN PO_TBL_NUMBER
8: , x_result_set_id IN OUT NOCOPY NUMBER
9: , x_result_type OUT NOCOPY VARCHAR2

Line 6: , p_line_loc_id_tbl IN PO_TBL_NUMBER

2: -- $Header: PO_VAL_DISTRIBUTIONS.pls 120.12.12010000.2 2008/12/08 10:42:35 cvardia ship $
3:
4: PROCEDURE dist_num_unique(
5: p_dist_id_tbl IN PO_TBL_NUMBER
6: , p_line_loc_id_tbl IN PO_TBL_NUMBER
7: , p_dist_num_tbl IN PO_TBL_NUMBER
8: , x_result_set_id IN OUT NOCOPY NUMBER
9: , x_result_type OUT NOCOPY VARCHAR2
10: );

Line 7: , p_dist_num_tbl IN PO_TBL_NUMBER

3:
4: PROCEDURE dist_num_unique(
5: p_dist_id_tbl IN PO_TBL_NUMBER
6: , p_line_loc_id_tbl IN PO_TBL_NUMBER
7: , p_dist_num_tbl IN PO_TBL_NUMBER
8: , x_result_set_id IN OUT NOCOPY NUMBER
9: , x_result_type OUT NOCOPY VARCHAR2
10: );
11:

Line 13: p_dist_id_tbl IN PO_TBL_NUMBER

9: , x_result_type OUT NOCOPY VARCHAR2
10: );
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: );

Line 14: , p_dist_num_tbl IN PO_TBL_NUMBER

10: );
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:

Line 20: p_dist_id_tbl IN PO_TBL_NUMBER

16: , x_result_type OUT NOCOPY VARCHAR2
17: );
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

Line 21: , p_qty_ordered_tbl IN PO_TBL_NUMBER

17: );
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: );

Line 31: p_dist_id_tbl IN PO_TBL_NUMBER

27: -- :
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

Line 33: , p_qty_ordered_tbl IN PO_TBL_NUMBER

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: );
37:

Line 41: p_dist_id_tbl IN PO_TBL_NUMBER

37:
38: --
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

Line 42: , p_amt_ordered_tbl IN PO_TBL_NUMBER

38: --
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: );

Line 52: p_dist_id_tbl IN PO_TBL_NUMBER

48: -- :
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

Line 54: , p_amt_ordered_tbl IN PO_TBL_NUMBER

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: );
58:

Line 62: p_dist_id_tbl IN PO_TBL_NUMBER

58:
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

Line 64: , p_item_id_tbl IN PO_TBL_NUMBER

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
68: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 65: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

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
68: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
69: , x_result_type OUT NOCOPY VARCHAR2

Line 73: p_dist_id_tbl IN PO_TBL_NUMBER

69: , x_result_type OUT NOCOPY VARCHAR2
70: );
71:
72: PROCEDURE oop_enter_all_fields(
73: p_dist_id_tbl IN PO_TBL_NUMBER
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

Line 74: , p_line_line_type_id_tbl IN PO_TBL_NUMBER

70: );
71:
72: PROCEDURE oop_enter_all_fields(
73: p_dist_id_tbl IN PO_TBL_NUMBER
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

Line 75: , p_wip_entity_id_tbl IN PO_TBL_NUMBER

71:
72: PROCEDURE oop_enter_all_fields(
73: p_dist_id_tbl IN PO_TBL_NUMBER
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

Line 76: , p_wip_line_id_tbl IN PO_TBL_NUMBER

72: PROCEDURE oop_enter_all_fields(
73: p_dist_id_tbl IN PO_TBL_NUMBER
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

Line 77: , p_wip_operation_seq_num_tbl IN PO_TBL_NUMBER

73: p_dist_id_tbl IN PO_TBL_NUMBER
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

Line 79: , p_wip_resource_seq_num_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: );
83:

Line 85: p_dist_id_tbl IN PO_TBL_NUMBER

81: , x_result_type OUT NOCOPY VARCHAR2
82: );
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: );

Line 86: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

82: );
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:

Line 92: p_dist_id_tbl IN PO_TBL_NUMBER

88: , x_result_type OUT NOCOPY VARCHAR2
89: );
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: );

Line 93: , p_budget_account_id_tbl IN PO_TBL_NUMBER

89: );
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:

Line 99: p_dist_id_tbl IN PO_TBL_NUMBER

95: , x_result_type OUT NOCOPY VARCHAR2
96: );
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: );

Line 106: p_dist_id_tbl IN PO_TBL_NUMBER

102: , x_result_type OUT NOCOPY VARCHAR2
103: );
104:
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

Line 107: , p_org_id_tbl IN PO_TBL_NUMBER

103: );
104:
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: );

Line 114: p_dist_id_tbl IN PO_TBL_NUMBER

110: , x_result_type OUT NOCOPY VARCHAR2
111: );
112:
113: PROCEDURE gms_data_valid(
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

Line 115: , p_project_id_tbl IN PO_TBL_NUMBER

111: );
112:
113: PROCEDURE gms_data_valid(
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

Line 116: , p_task_id_tbl IN PO_TBL_NUMBER

112:
113: PROCEDURE gms_data_valid(
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

Line 125: p_dist_id_tbl IN PO_TBL_NUMBER

121: , x_result_type OUT NOCOPY VARCHAR2
122: );
123:
124: PROCEDURE check_fv_validations(
125: p_dist_id_tbl IN PO_TBL_NUMBER
126: , p_ccid_tbl IN PO_TBL_NUMBER
127: , p_org_id_tbl IN PO_TBL_NUMBER
128: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
129: , p_attribute2_tbl IN PO_TBL_VARCHAR2000

Line 126: , p_ccid_tbl IN PO_TBL_NUMBER

122: );
123:
124: PROCEDURE check_fv_validations(
125: p_dist_id_tbl IN PO_TBL_NUMBER
126: , p_ccid_tbl IN PO_TBL_NUMBER
127: , p_org_id_tbl IN PO_TBL_NUMBER
128: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
129: , p_attribute2_tbl IN PO_TBL_VARCHAR2000
130: , p_attribute3_tbl IN PO_TBL_VARCHAR2000

Line 127: , p_org_id_tbl IN PO_TBL_NUMBER

123:
124: PROCEDURE check_fv_validations(
125: p_dist_id_tbl IN PO_TBL_NUMBER
126: , p_ccid_tbl IN PO_TBL_NUMBER
127: , p_org_id_tbl IN PO_TBL_NUMBER
128: , p_attribute1_tbl IN PO_TBL_VARCHAR2000
129: , p_attribute2_tbl IN PO_TBL_VARCHAR2000
130: , p_attribute3_tbl IN PO_TBL_VARCHAR2000
131: , p_attribute4_tbl IN PO_TBL_VARCHAR2000

Line 148: p_dist_id_tbl IN PO_TBL_NUMBER

144: , x_result_type OUT NOCOPY VARCHAR2
145: );
146:
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

Line 149: , p_amount_to_encumber_tbl IN PO_TBL_NUMBER

145: );
146:
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: );

Line 150: , p_unencumbered_amount_tbl IN PO_TBL_NUMBER

146:
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:

Line 159: p_dist_id_tbl IN PO_TBL_NUMBER

155: -- Bug 7558385
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

Line 161: , p_project_id_tbl IN PO_TBL_NUMBER

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
165: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER

Line 162: , p_task_id_tbl IN PO_TBL_NUMBER

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
165: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER
166: , p_expenditure_item_date_tbl IN PO_TBL_DATE

Line 163: , p_award_id_tbl IN PO_TBL_NUMBER

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
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

Line 165: , p_expenditure_org_id_tbl IN PO_TBL_NUMBER

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
169: , x_result_type OUT NOCOPY VARCHAR2

Line 167: , p_ship_to_org_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
169: , x_result_type OUT NOCOPY VARCHAR2
170: );
171: