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 AS
2: -- $Header: PO_VAL_SHIPMENTS.pls 120.11 2006/09/01 09:18:47 nlondhe noship $
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.11 2006/09/01 09:18:47 nlondhe noship $
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: , x_result_set_id IN OUT NOCOPY NUMBER

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: , x_result_set_id IN OUT NOCOPY NUMBER
108: , x_result_type OUT NOCOPY VARCHAR2

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: , x_result_set_id IN OUT NOCOPY NUMBER
108: , x_result_type OUT NOCOPY VARCHAR2
109: );

Line 113: p_line_loc_id_tbl IN PO_TBL_NUMBER

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

Line 114: , p_line_id_tbl IN PO_TBL_NUMBER

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

Line 115: , p_org_id_tbl IN PO_TBL_NUMBER

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

Line 116: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

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

Line 123: p_line_loc_id_tbl IN PO_TBL_NUMBER

119: , x_result_type OUT NOCOPY VARCHAR2
120: );
121:
122: PROCEDURE quantity_gt_zero(
123: p_line_loc_id_tbl IN PO_TBL_NUMBER
124: , p_quantity_tbl IN PO_TBL_NUMBER
125: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
126: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
127: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 124: , p_quantity_tbl IN PO_TBL_NUMBER

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

Line 134: p_line_loc_id_tbl IN PO_TBL_NUMBER

130:
131: -- : Combine qty rcvd/billed into qty exec
132:
133: PROCEDURE quantity_ge_quantity_exec(
134: p_line_loc_id_tbl IN PO_TBL_NUMBER
135: , p_quantity_tbl IN PO_TBL_NUMBER
136: , x_result_set_id IN OUT NOCOPY NUMBER
137: , x_result_type OUT NOCOPY VARCHAR2
138: );

Line 135: , p_quantity_tbl IN PO_TBL_NUMBER

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

Line 143: p_line_loc_id_tbl IN PO_TBL_NUMBER

139:
140: --
141:
142: PROCEDURE amount_gt_zero(
143: p_line_loc_id_tbl IN PO_TBL_NUMBER
144: , p_amount_tbl IN PO_TBL_NUMBER
145: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
146: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
147: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 144: , p_amount_tbl IN PO_TBL_NUMBER

140: --
141:
142: PROCEDURE amount_gt_zero(
143: p_line_loc_id_tbl IN PO_TBL_NUMBER
144: , p_amount_tbl IN PO_TBL_NUMBER
145: , p_shipment_type_tbl IN PO_TBL_VARCHAR30
146: , p_value_basis_tbl IN PO_TBL_VARCHAR30 --
147: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
148: , x_result_type OUT NOCOPY VARCHAR2

Line 153: p_line_loc_id_tbl IN PO_TBL_NUMBER

149: );
150:
151: -- : Combine amt rcvd/billed into amt exec
152: PROCEDURE amount_ge_amount_exec(
153: p_line_loc_id_tbl IN PO_TBL_NUMBER
154: , p_amount_tbl IN PO_TBL_NUMBER
155: , x_result_set_id IN OUT NOCOPY NUMBER
156: , x_result_type OUT NOCOPY VARCHAR2
157: );

Line 154: , p_amount_tbl IN PO_TBL_NUMBER

150:
151: -- : Combine amt rcvd/billed into amt exec
152: PROCEDURE amount_ge_amount_exec(
153: p_line_loc_id_tbl IN PO_TBL_NUMBER
154: , p_amount_tbl IN PO_TBL_NUMBER
155: , x_result_set_id IN OUT NOCOPY NUMBER
156: , x_result_type OUT NOCOPY VARCHAR2
157: );
158: --

Line 162: p_line_loc_id_tbl IN PO_TBL_NUMBER

158: --
159:
160: -- OPM Integration R12 Start
161: PROCEDURE ship_sec_quantity_gt_zero(
162: p_line_loc_id_tbl IN PO_TBL_NUMBER
163: , p_item_id_tbl IN PO_TBL_NUMBER
164: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
165: , p_sec_quantity_tbl IN PO_TBL_NUMBER
166: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 163: , p_item_id_tbl IN PO_TBL_NUMBER

159:
160: -- OPM Integration R12 Start
161: PROCEDURE ship_sec_quantity_gt_zero(
162: p_line_loc_id_tbl IN PO_TBL_NUMBER
163: , p_item_id_tbl IN PO_TBL_NUMBER
164: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
165: , p_sec_quantity_tbl IN PO_TBL_NUMBER
166: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
167: , x_result_type OUT NOCOPY VARCHAR2

Line 164: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

160: -- OPM Integration R12 Start
161: PROCEDURE ship_sec_quantity_gt_zero(
162: p_line_loc_id_tbl IN PO_TBL_NUMBER
163: , p_item_id_tbl IN PO_TBL_NUMBER
164: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
165: , p_sec_quantity_tbl IN PO_TBL_NUMBER
166: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
167: , x_result_type OUT NOCOPY VARCHAR2
168: );

Line 165: , p_sec_quantity_tbl IN PO_TBL_NUMBER

161: PROCEDURE ship_sec_quantity_gt_zero(
162: p_line_loc_id_tbl IN PO_TBL_NUMBER
163: , p_item_id_tbl IN PO_TBL_NUMBER
164: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
165: , p_sec_quantity_tbl IN PO_TBL_NUMBER
166: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
167: , x_result_type OUT NOCOPY VARCHAR2
168: );
169:

Line 171: p_line_loc_id_tbl IN PO_TBL_NUMBER

167: , x_result_type OUT NOCOPY VARCHAR2
168: );
169:
170: PROCEDURE ship_qtys_within_deviation (
171: p_line_loc_id_tbl IN PO_TBL_NUMBER
172: , p_item_id_tbl IN PO_TBL_NUMBER
173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174: , p_quantity_tbl IN PO_TBL_NUMBER
175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30

Line 172: , p_item_id_tbl IN PO_TBL_NUMBER

168: );
169:
170: PROCEDURE ship_qtys_within_deviation (
171: p_line_loc_id_tbl IN PO_TBL_NUMBER
172: , p_item_id_tbl IN PO_TBL_NUMBER
173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174: , p_quantity_tbl IN PO_TBL_NUMBER
175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
176: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER

169:
170: PROCEDURE ship_qtys_within_deviation (
171: p_line_loc_id_tbl IN PO_TBL_NUMBER
172: , p_item_id_tbl IN PO_TBL_NUMBER
173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174: , p_quantity_tbl IN PO_TBL_NUMBER
175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
176: , p_sec_quantity_tbl IN PO_TBL_NUMBER
177: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 174: , p_quantity_tbl IN PO_TBL_NUMBER

170: PROCEDURE ship_qtys_within_deviation (
171: p_line_loc_id_tbl IN PO_TBL_NUMBER
172: , p_item_id_tbl IN PO_TBL_NUMBER
173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174: , p_quantity_tbl IN PO_TBL_NUMBER
175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
176: , p_sec_quantity_tbl IN PO_TBL_NUMBER
177: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
178: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 176: , p_sec_quantity_tbl IN PO_TBL_NUMBER

172: , p_item_id_tbl IN PO_TBL_NUMBER
173: , p_ship_to_org_id_tbl IN PO_TBL_NUMBER
174: , p_quantity_tbl IN PO_TBL_NUMBER
175: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
176: , p_sec_quantity_tbl IN PO_TBL_NUMBER
177: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
178: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
179: , x_result_type OUT NOCOPY VARCHAR2
180: );

Line 187: p_line_loc_id_tbl IN PO_TBL_NUMBER

183: /*
184: Bug 5385686 : Unit of measure must be checked for null on Pay Items
185: */
186: PROCEDURE unit_of_measure_not_null(
187: p_line_loc_id_tbl IN PO_TBL_NUMBER
188: , p_payment_type_tbl IN PO_TBL_VARCHAR30
189: , p_value_basis_tbl IN PO_TBL_VARCHAR30
190: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
191: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE