eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VAL_SHIPMENTS dependencies on PO_TBL_NUMBER

Line 5: p_line_loc_id_tbl IN PO_TBL_NUMBER

1: PACKAGE PO_VAL_SHIPMENTS AUTHID CURRENT_USER AS
2: -- $Header: PO_VAL_SHIPMENTS.pls 120.17.12020000.4 2013/04/03 22:31:40 rarajar ship $
3:
4: PROCEDURE days_early_gte_zero(
5: p_line_loc_id_tbl IN PO_TBL_NUMBER
6: , p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER
7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8: , x_result_type OUT NOCOPY VARCHAR2
9: );

Line 6: , p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER

2: -- $Header: PO_VAL_SHIPMENTS.pls 120.17.12020000.4 2013/04/03 22:31:40 rarajar ship $
3:
4: PROCEDURE days_early_gte_zero(
5: p_line_loc_id_tbl IN PO_TBL_NUMBER
6: , p_days_early_rcpt_allowed_tbl IN PO_TBL_NUMBER
7: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
8: , x_result_type OUT NOCOPY VARCHAR2
9: );
10:

Line 12: p_line_loc_id_tbl IN PO_TBL_NUMBER

8: , x_result_type OUT NOCOPY VARCHAR2
9: );
10:
11: PROCEDURE days_late_gte_zero(
12: p_line_loc_id_tbl IN PO_TBL_NUMBER
13: , p_days_late_rcpt_allowed_tbl IN PO_TBL_NUMBER
14: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
15: , x_result_type OUT NOCOPY VARCHAR2
16: );

Line 13: , p_days_late_rcpt_allowed_tbl IN PO_TBL_NUMBER

9: );
10:
11: PROCEDURE days_late_gte_zero(
12: p_line_loc_id_tbl IN PO_TBL_NUMBER
13: , p_days_late_rcpt_allowed_tbl IN PO_TBL_NUMBER
14: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
15: , x_result_type OUT NOCOPY VARCHAR2
16: );
17:

Line 19: p_line_loc_id_tbl IN PO_TBL_NUMBER

15: , x_result_type OUT NOCOPY VARCHAR2
16: );
17:
18: PROCEDURE rcv_close_tol_within_range (
19: p_line_loc_id_tbl IN PO_TBL_NUMBER
20: , p_receive_close_tolerance_tbl IN PO_TBL_NUMBER
21: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
22: , x_result_type OUT NOCOPY VARCHAR2
23: );

Line 20: , p_receive_close_tolerance_tbl IN PO_TBL_NUMBER

16: );
17:
18: PROCEDURE rcv_close_tol_within_range (
19: p_line_loc_id_tbl IN PO_TBL_NUMBER
20: , p_receive_close_tolerance_tbl IN PO_TBL_NUMBER
21: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
22: , x_result_type OUT NOCOPY VARCHAR2
23: );
24:

Line 26: p_line_loc_id_tbl IN PO_TBL_NUMBER

22: , x_result_type OUT NOCOPY VARCHAR2
23: );
24:
25: PROCEDURE over_rcpt_tol_within_range (
26: p_line_loc_id_tbl IN PO_TBL_NUMBER
27: , p_qty_rcv_tolerance_tbl IN PO_TBL_NUMBER
28: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
29: , x_result_type OUT NOCOPY VARCHAR2
30: );

Line 27: , p_qty_rcv_tolerance_tbl IN PO_TBL_NUMBER

23: );
24:
25: PROCEDURE over_rcpt_tol_within_range (
26: p_line_loc_id_tbl IN PO_TBL_NUMBER
27: , p_qty_rcv_tolerance_tbl IN PO_TBL_NUMBER
28: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
29: , x_result_type OUT NOCOPY VARCHAR2
30: );
31:

Line 33: p_line_loc_id_tbl IN PO_TBL_NUMBER

29: , x_result_type OUT NOCOPY VARCHAR2
30: );
31:
32: PROCEDURE planned_item_null_date_check (
33: p_line_loc_id_tbl IN PO_TBL_NUMBER
34: , p_need_by_date_tbl IN PO_TBL_DATE
35: , p_promised_date_tbl IN PO_TBL_DATE
36: , p_item_id_tbl IN PO_TBL_NUMBER
37: , x_result_set_id IN OUT NOCOPY NUMBER

Line 36: , p_item_id_tbl IN PO_TBL_NUMBER

32: PROCEDURE planned_item_null_date_check (
33: p_line_loc_id_tbl IN PO_TBL_NUMBER
34: , p_need_by_date_tbl IN PO_TBL_DATE
35: , p_promised_date_tbl IN PO_TBL_DATE
36: , p_item_id_tbl IN PO_TBL_NUMBER
37: , x_result_set_id IN OUT NOCOPY NUMBER
38: , x_result_type OUT NOCOPY VARCHAR2
39: );
40:

Line 42: p_line_loc_id_tbl IN PO_TBL_NUMBER

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

Line 52: p_line_loc_id_tbl IN PO_TBL_NUMBER

48: , x_result_type OUT NOCOPY VARCHAR2
49: );
50:
51: PROCEDURE inv_close_tol_range_check (
52: p_line_loc_id_tbl IN PO_TBL_NUMBER
53: , p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER
54: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
55: , x_result_type OUT NOCOPY VARCHAR2
56: );

Line 53: , p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER

49: );
50:
51: PROCEDURE inv_close_tol_range_check (
52: p_line_loc_id_tbl IN PO_TBL_NUMBER
53: , p_invoice_close_tolerance_tbl IN PO_TBL_NUMBER
54: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
55: , x_result_type OUT NOCOPY VARCHAR2
56: );
57:

Line 60: p_line_loc_id_tbl IN PO_TBL_NUMBER

56: );
57:
58: --PBWC Message Change Impact: Adding a token
59: PROCEDURE need_by_date_open_period_check(
60: p_line_loc_id_tbl IN PO_TBL_NUMBER
61: , p_line_id_tbl IN PO_TBL_NUMBER
62: , p_need_by_date_tbl IN PO_TBL_DATE
63: , p_org_id_tbl IN PO_TBL_NUMBER
64: , x_result_set_id IN OUT NOCOPY NUMBER

Line 61: , p_line_id_tbl IN PO_TBL_NUMBER

57:
58: --PBWC Message Change Impact: Adding a token
59: PROCEDURE need_by_date_open_period_check(
60: p_line_loc_id_tbl IN PO_TBL_NUMBER
61: , p_line_id_tbl IN PO_TBL_NUMBER
62: , p_need_by_date_tbl IN PO_TBL_DATE
63: , p_org_id_tbl IN PO_TBL_NUMBER
64: , x_result_set_id IN OUT NOCOPY NUMBER
65: , x_result_type OUT NOCOPY VARCHAR2

Line 63: , p_org_id_tbl IN PO_TBL_NUMBER

59: PROCEDURE need_by_date_open_period_check(
60: p_line_loc_id_tbl IN PO_TBL_NUMBER
61: , p_line_id_tbl IN PO_TBL_NUMBER
62: , p_need_by_date_tbl IN PO_TBL_DATE
63: , p_org_id_tbl IN PO_TBL_NUMBER
64: , x_result_set_id IN OUT NOCOPY NUMBER
65: , x_result_type OUT NOCOPY VARCHAR2
66: );
67:

Line 70: p_line_loc_id_tbl IN PO_TBL_NUMBER

66: );
67:
68: --PBWC Message Change Impact: Adding a token
69: PROCEDURE promise_date_open_period_check(
70: p_line_loc_id_tbl IN PO_TBL_NUMBER
71: , p_line_id_tbl IN PO_TBL_NUMBER
72: , p_promised_date_tbl IN PO_TBL_DATE
73: , p_org_id_tbl IN PO_TBL_NUMBER
74: , x_result_set_id IN OUT NOCOPY NUMBER

Line 71: , p_line_id_tbl IN PO_TBL_NUMBER

67:
68: --PBWC Message Change Impact: Adding a token
69: PROCEDURE promise_date_open_period_check(
70: p_line_loc_id_tbl IN PO_TBL_NUMBER
71: , p_line_id_tbl IN PO_TBL_NUMBER
72: , p_promised_date_tbl IN PO_TBL_DATE
73: , p_org_id_tbl IN PO_TBL_NUMBER
74: , x_result_set_id IN OUT NOCOPY NUMBER
75: , x_result_type OUT NOCOPY VARCHAR2

Line 73: , p_org_id_tbl IN PO_TBL_NUMBER

69: PROCEDURE promise_date_open_period_check(
70: p_line_loc_id_tbl IN PO_TBL_NUMBER
71: , p_line_id_tbl IN PO_TBL_NUMBER
72: , p_promised_date_tbl IN PO_TBL_DATE
73: , p_org_id_tbl IN PO_TBL_NUMBER
74: , x_result_set_id IN OUT NOCOPY NUMBER
75: , x_result_type OUT NOCOPY VARCHAR2
76: );
77:

Line 79: p_line_loc_id_tbl IN PO_TBL_NUMBER

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

Line 80: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

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

Line 87: p_line_loc_id_tbl IN PO_TBL_NUMBER

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

Line 88: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER

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

Line 95: p_line_loc_id_tbl IN PO_TBL_NUMBER

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

Line 96: , p_shipment_num_tbl IN PO_TBL_NUMBER

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

Line 103: p_line_loc_id_tbl IN PO_TBL_NUMBER

99: , x_result_type OUT NOCOPY VARCHAR2
100: );
101:
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: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --

Line 104: , p_line_id_tbl IN PO_TBL_NUMBER

100: );
101:
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: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
108: , p_draft_id_tbl IN PO_TBL_NUMBER --

Line 105: , p_shipment_num_tbl IN PO_TBL_NUMBER

101:
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: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
108: , p_draft_id_tbl IN PO_TBL_NUMBER --
109: , x_result_set_id IN OUT NOCOPY NUMBER

Line 108: , p_draft_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: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
108: , p_draft_id_tbl IN PO_TBL_NUMBER --
109: , x_result_set_id IN OUT NOCOPY NUMBER
110: , x_result_type OUT NOCOPY VARCHAR2
111: );
112:

Line 115: p_line_loc_id_tbl IN PO_TBL_NUMBER

111: );
112:
113: --PBWC Message Change Impact: Adding a token
114: PROCEDURE is_org_in_current_sob_check (
115: p_line_loc_id_tbl IN PO_TBL_NUMBER
116: , p_line_id_tbl IN PO_TBL_NUMBER
117: , p_org_id_tbl IN PO_TBL_NUMBER
118: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
119: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1

Line 116: , p_line_id_tbl IN PO_TBL_NUMBER

112:
113: --PBWC Message Change Impact: Adding a token
114: PROCEDURE is_org_in_current_sob_check (
115: p_line_loc_id_tbl IN PO_TBL_NUMBER
116: , p_line_id_tbl IN PO_TBL_NUMBER
117: , p_org_id_tbl IN PO_TBL_NUMBER
118: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
119: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
120: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 117: , p_org_id_tbl IN PO_TBL_NUMBER

113: --PBWC Message Change Impact: Adding a token
114: PROCEDURE is_org_in_current_sob_check (
115: p_line_loc_id_tbl IN PO_TBL_NUMBER
116: , p_line_id_tbl IN PO_TBL_NUMBER
117: , p_org_id_tbl IN PO_TBL_NUMBER
118: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
119: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
120: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
121: , x_result_type OUT NOCOPY VARCHAR2

Line 118: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

114: PROCEDURE is_org_in_current_sob_check (
115: p_line_loc_id_tbl IN PO_TBL_NUMBER
116: , p_line_id_tbl IN PO_TBL_NUMBER
117: , p_org_id_tbl IN PO_TBL_NUMBER
118: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
119: , p_consigned_flag_tbl IN PO_TBL_VARCHAR1
120: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
121: , x_result_type OUT NOCOPY VARCHAR2
122: );

Line 125: p_line_loc_id_tbl IN PO_TBL_NUMBER

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

Line 126: , p_quantity_tbl IN PO_TBL_NUMBER

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

Line 132: , p_header_id_tbl IN PO_TBL_NUMBER --

128: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
129: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131: , x_result_type OUT NOCOPY VARCHAR2
132: , p_header_id_tbl IN PO_TBL_NUMBER --
133: );
134:
135: -- : Combine qty rcvd/billed into qty exec
136:

Line 138: p_line_loc_id_tbl IN PO_TBL_NUMBER

134:
135: -- : Combine qty rcvd/billed into qty exec
136:
137: PROCEDURE quantity_ge_quantity_exec(
138: p_line_loc_id_tbl IN PO_TBL_NUMBER
139: , p_quantity_tbl IN PO_TBL_NUMBER
140: , x_result_set_id IN OUT NOCOPY NUMBER
141: , x_result_type OUT NOCOPY VARCHAR2
142: );

Line 139: , p_quantity_tbl IN PO_TBL_NUMBER

135: -- : Combine qty rcvd/billed into qty exec
136:
137: PROCEDURE quantity_ge_quantity_exec(
138: p_line_loc_id_tbl IN PO_TBL_NUMBER
139: , p_quantity_tbl IN PO_TBL_NUMBER
140: , x_result_set_id IN OUT NOCOPY NUMBER
141: , x_result_type OUT NOCOPY VARCHAR2
142: );
143:

Line 148: p_line_loc_id_tbl IN PO_TBL_NUMBER

144: --
145:
146:
147: PROCEDURE amount_gt_zero(
148: p_line_loc_id_tbl IN PO_TBL_NUMBER
149: , p_amount_tbl IN PO_TBL_NUMBER
150: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
151: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
152: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30

Line 149: , p_amount_tbl IN PO_TBL_NUMBER

145:
146:
147: PROCEDURE amount_gt_zero(
148: p_line_loc_id_tbl IN PO_TBL_NUMBER
149: , p_amount_tbl IN PO_TBL_NUMBER
150: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
151: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
152: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
153: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 155: , p_header_id_tbl IN PO_TBL_NUMBER --

151: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
152: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
153: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
154: , x_result_type OUT NOCOPY VARCHAR2
155: , p_header_id_tbl IN PO_TBL_NUMBER --
156: );
157:
158: -- : Combine amt rcvd/billed into amt exec
159: PROCEDURE amount_ge_amount_exec(

Line 160: p_line_loc_id_tbl IN PO_TBL_NUMBER

156: );
157:
158: -- : Combine amt rcvd/billed into amt exec
159: PROCEDURE amount_ge_amount_exec(
160: p_line_loc_id_tbl IN PO_TBL_NUMBER
161: , p_amount_tbl IN PO_TBL_NUMBER
162: , x_result_set_id IN OUT NOCOPY NUMBER
163: , x_result_type OUT NOCOPY VARCHAR2
164: );

Line 161: , p_amount_tbl IN PO_TBL_NUMBER

157:
158: -- : Combine amt rcvd/billed into amt exec
159: PROCEDURE amount_ge_amount_exec(
160: p_line_loc_id_tbl IN PO_TBL_NUMBER
161: , p_amount_tbl IN PO_TBL_NUMBER
162: , x_result_set_id IN OUT NOCOPY NUMBER
163: , x_result_type OUT NOCOPY VARCHAR2
164: );
165: --

Line 170: p_line_loc_id_tbl IN PO_TBL_NUMBER

166:
167:
168: -- OPM Integration R12 Start
169: PROCEDURE ship_sec_quantity_gt_zero(
170: p_line_loc_id_tbl IN PO_TBL_NUMBER
171: , p_item_id_tbl IN PO_TBL_NUMBER
172: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
173: , p_sec_quantity_tbl IN PO_TBL_NUMBER
174: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 171: , p_item_id_tbl IN PO_TBL_NUMBER

167:
168: -- OPM Integration R12 Start
169: PROCEDURE ship_sec_quantity_gt_zero(
170: p_line_loc_id_tbl IN PO_TBL_NUMBER
171: , p_item_id_tbl IN PO_TBL_NUMBER
172: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
173: , p_sec_quantity_tbl IN PO_TBL_NUMBER
174: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
175: , x_result_type OUT NOCOPY VARCHAR2

Line 172: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

168: -- OPM Integration R12 Start
169: PROCEDURE ship_sec_quantity_gt_zero(
170: p_line_loc_id_tbl IN PO_TBL_NUMBER
171: , p_item_id_tbl IN PO_TBL_NUMBER
172: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
173: , p_sec_quantity_tbl IN PO_TBL_NUMBER
174: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
175: , x_result_type OUT NOCOPY VARCHAR2
176: );

Line 173: , p_sec_quantity_tbl IN PO_TBL_NUMBER

169: PROCEDURE ship_sec_quantity_gt_zero(
170: p_line_loc_id_tbl IN PO_TBL_NUMBER
171: , p_item_id_tbl IN PO_TBL_NUMBER
172: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
173: , p_sec_quantity_tbl IN PO_TBL_NUMBER
174: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
175: , x_result_type OUT NOCOPY VARCHAR2
176: );
177:

Line 179: p_line_loc_id_tbl IN PO_TBL_NUMBER

175: , x_result_type OUT NOCOPY VARCHAR2
176: );
177:
178: PROCEDURE ship_qtys_within_deviation (
179: p_line_loc_id_tbl IN PO_TBL_NUMBER
180: , p_item_id_tbl IN PO_TBL_NUMBER
181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182: , p_quantity_tbl IN PO_TBL_NUMBER
183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

Line 180: , p_item_id_tbl IN PO_TBL_NUMBER

176: );
177:
178: PROCEDURE ship_qtys_within_deviation (
179: p_line_loc_id_tbl IN PO_TBL_NUMBER
180: , p_item_id_tbl IN PO_TBL_NUMBER
181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182: , p_quantity_tbl IN PO_TBL_NUMBER
183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
184: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

177:
178: PROCEDURE ship_qtys_within_deviation (
179: p_line_loc_id_tbl IN PO_TBL_NUMBER
180: , p_item_id_tbl IN PO_TBL_NUMBER
181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182: , p_quantity_tbl IN PO_TBL_NUMBER
183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
184: , p_sec_quantity_tbl IN PO_TBL_NUMBER
185: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 182: , p_quantity_tbl IN PO_TBL_NUMBER

178: PROCEDURE ship_qtys_within_deviation (
179: p_line_loc_id_tbl IN PO_TBL_NUMBER
180: , p_item_id_tbl IN PO_TBL_NUMBER
181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182: , p_quantity_tbl IN PO_TBL_NUMBER
183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
184: , p_sec_quantity_tbl IN PO_TBL_NUMBER
185: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 184: , p_sec_quantity_tbl IN PO_TBL_NUMBER

180: , p_item_id_tbl IN PO_TBL_NUMBER
181: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
182: , p_quantity_tbl IN PO_TBL_NUMBER
183: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
184: , p_sec_quantity_tbl IN PO_TBL_NUMBER
185: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187: , x_result_type OUT NOCOPY VARCHAR2
188: );

Line 195: p_line_loc_id_tbl IN PO_TBL_NUMBER

191: /*
192: Bug 5385686 : Unit of measure must be checked for null on Pay Items
193: */
194: PROCEDURE unit_of_measure_not_null(
195: p_line_loc_id_tbl IN PO_TBL_NUMBER
196: , p_payment_type_tbl IN PO_TBL_VARCHAR30
197: , p_value_basis_tbl IN PO_TBL_VARCHAR30
198: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
199: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 205: p_line_loc_id_tbl IN PO_TBL_NUMBER

201: );
202:
203: --Mod Project
204: PROCEDURE mod_no_cancel_shp_complt(
205: p_line_loc_id_tbl IN PO_TBL_NUMBER
206: ,p_control_action_tbl IN PO_TBL_VARCHAR30
207: ,x_result_set_id IN OUT NOCOPY NUMBER
208: ,x_result_type OUT NOCOPY VARCHAR2
209: );

Line 213: p_line_id_tbl IN PO_TBL_NUMBER

209: );
210:
211: PROCEDURE pop_date_need_by_date
212: (
213: p_line_id_tbl IN PO_TBL_NUMBER
214: , p_start_date_tbl IN PO_TBL_DATE
215: , p_end_date_tbl IN PO_TBL_DATE
216: , p_need_by_date_tbl IN PO_TBL_DATE
217: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 223: p_line_id_tbl IN PO_TBL_NUMBER

219: );
220:
221: PROCEDURE pop_start_date_le_end_date
222: (
223: p_line_id_tbl IN PO_TBL_NUMBER
224: , p_start_date_tbl IN PO_TBL_DATE
225: , p_expiration_date_tbl IN PO_TBL_DATE
226: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
227: , x_result_type OUT NOCOPY VARCHAR2

Line 231: p_line_loc_id_tbl IN PO_TBL_NUMBER

227: , x_result_type OUT NOCOPY VARCHAR2
228: );
229:
230: PROCEDURE complex_price_or_gt_zero(
231: p_line_loc_id_tbl IN PO_TBL_NUMBER
232: , p_price_override_tbl IN PO_TBL_NUMBER
233: , p_value_basis_tbl IN PO_TBL_VARCHAR30
234: , p_payment_type_tbl IN PO_TBL_VARCHAR30
235: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 232: , p_price_override_tbl IN PO_TBL_NUMBER

228: );
229:
230: PROCEDURE complex_price_or_gt_zero(
231: p_line_loc_id_tbl IN PO_TBL_NUMBER
232: , p_price_override_tbl IN PO_TBL_NUMBER
233: , p_value_basis_tbl IN PO_TBL_VARCHAR30
234: , p_payment_type_tbl IN PO_TBL_VARCHAR30
235: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
236: , x_result_type OUT NOCOPY VARCHAR2