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_LINES dependencies on PO_TBL_NUMBER

Line 5: p_line_id_tbl IN PO_TBL_NUMBER

1: PACKAGE PO_VAL_LINES AS
2: -- $Header: PO_VAL_LINES.pls 120.16 2006/11/15 00:11:15 vinokris noship $
3:
4: PROCEDURE amt_agreed_ge_zero(
5: p_line_id_tbl IN PO_TBL_NUMBER
6: , p_committed_amount_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_committed_amount_tbl IN PO_TBL_NUMBER

2: -- $Header: PO_VAL_LINES.pls 120.16 2006/11/15 00:11:15 vinokris noship $
3:
4: PROCEDURE amt_agreed_ge_zero(
5: p_line_id_tbl IN PO_TBL_NUMBER
6: , p_committed_amount_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_id_tbl IN PO_TBL_NUMBER

8: , x_result_type OUT NOCOPY VARCHAR2
9: );
10:
11: PROCEDURE min_rel_amt_ge_zero(
12: p_line_id_tbl IN PO_TBL_NUMBER
13: , p_min_release_amount_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_min_release_amount_tbl IN PO_TBL_NUMBER

9: );
10:
11: PROCEDURE min_rel_amt_ge_zero(
12: p_line_id_tbl IN PO_TBL_NUMBER
13: , p_min_release_amount_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_id_tbl IN PO_TBL_NUMBER

15: , x_result_type OUT NOCOPY VARCHAR2
16: );
17:
18: PROCEDURE quantity_gt_zero(
19: p_line_id_tbl IN PO_TBL_NUMBER
20: , p_quantity_tbl IN PO_TBL_NUMBER
21: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23: , x_result_type OUT NOCOPY VARCHAR2

Line 20: , p_quantity_tbl IN PO_TBL_NUMBER

16: );
17:
18: PROCEDURE quantity_gt_zero(
19: p_line_id_tbl IN PO_TBL_NUMBER
20: , p_quantity_tbl IN PO_TBL_NUMBER
21: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
22: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
23: , x_result_type OUT NOCOPY VARCHAR2
24: );

Line 30: p_line_id_tbl IN PO_TBL_NUMBER

26: --
27: -- Removed: quantity_ge_quantity_billed, quantity_ge_quantity_rcvd,
28: -- Added: quantity_ge_quantity_exec
29: PROCEDURE quantity_ge_quantity_exec(
30: p_line_id_tbl IN PO_TBL_NUMBER
31: , p_quantity_tbl IN PO_TBL_NUMBER
32: , x_result_set_id IN OUT NOCOPY NUMBER
33: , x_result_type OUT NOCOPY VARCHAR2
34: );

Line 31: , p_quantity_tbl IN PO_TBL_NUMBER

27: -- Removed: quantity_ge_quantity_billed, quantity_ge_quantity_rcvd,
28: -- Added: quantity_ge_quantity_exec
29: PROCEDURE quantity_ge_quantity_exec(
30: p_line_id_tbl IN PO_TBL_NUMBER
31: , p_quantity_tbl IN PO_TBL_NUMBER
32: , x_result_set_id IN OUT NOCOPY NUMBER
33: , x_result_type OUT NOCOPY VARCHAR2
34: );
35:

Line 37: p_line_id_tbl IN PO_TBL_NUMBER

33: , x_result_type OUT NOCOPY VARCHAR2
34: );
35:
36: PROCEDURE recoupment_rate_range_check (
37: p_line_id_tbl IN PO_TBL_NUMBER
38: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
39: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
40: , x_result_type OUT NOCOPY VARCHAR2
41: );

Line 38: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

34: );
35:
36: PROCEDURE recoupment_rate_range_check (
37: p_line_id_tbl IN PO_TBL_NUMBER
38: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
39: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
40: , x_result_type OUT NOCOPY VARCHAR2
41: );
42:

Line 44: p_line_id_tbl IN PO_TBL_NUMBER

40: , x_result_type OUT NOCOPY VARCHAR2
41: );
42:
43: PROCEDURE retainage_rate_range_check (
44: p_line_id_tbl IN PO_TBL_NUMBER
45: , p_retainage_rate_tbl IN PO_TBL_NUMBER
46: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
47: , x_result_type OUT NOCOPY VARCHAR2
48: );

Line 45: , p_retainage_rate_tbl IN PO_TBL_NUMBER

41: );
42:
43: PROCEDURE retainage_rate_range_check (
44: p_line_id_tbl IN PO_TBL_NUMBER
45: , p_retainage_rate_tbl IN PO_TBL_NUMBER
46: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
47: , x_result_type OUT NOCOPY VARCHAR2
48: );
49:

Line 51: p_line_id_tbl IN PO_TBL_NUMBER

47: , x_result_type OUT NOCOPY VARCHAR2
48: );
49:
50: PROCEDURE prog_pay_rate_range_check (
51: p_line_id_tbl IN PO_TBL_NUMBER
52: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
53: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
54: , x_result_type OUT NOCOPY VARCHAR2
55: );

Line 52: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

48: );
49:
50: PROCEDURE prog_pay_rate_range_check (
51: p_line_id_tbl IN PO_TBL_NUMBER
52: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
53: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
54: , x_result_type OUT NOCOPY VARCHAR2
55: );
56:

Line 59: p_line_id_tbl IN PO_TBL_NUMBER

55: );
56:
57: --Bug 5221843
58: PROCEDURE max_retain_amt_ge_zero (
59: p_line_id_tbl IN PO_TBL_NUMBER
60: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
61: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
62: , x_result_type OUT NOCOPY VARCHAR2
63: );

Line 60: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

56:
57: --Bug 5221843
58: PROCEDURE max_retain_amt_ge_zero (
59: p_line_id_tbl IN PO_TBL_NUMBER
60: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
61: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
62: , x_result_type OUT NOCOPY VARCHAR2
63: );
64:

Line 67: p_line_id_tbl IN PO_TBL_NUMBER

63: );
64:
65: --Bug 5453079
66: PROCEDURE max_retain_amt_ge_retained (
67: p_line_id_tbl IN PO_TBL_NUMBER
68: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
69: , x_result_set_id IN OUT NOCOPY NUMBER
70: , x_result_type OUT NOCOPY VARCHAR2
71: );

Line 68: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

64:
65: --Bug 5453079
66: PROCEDURE max_retain_amt_ge_retained (
67: p_line_id_tbl IN PO_TBL_NUMBER
68: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
69: , x_result_set_id IN OUT NOCOPY NUMBER
70: , x_result_type OUT NOCOPY VARCHAR2
71: );
72:

Line 77: p_line_id_tbl IN PO_TBL_NUMBER

73:
74: --
75:
76: PROCEDURE quantity_ge_quantity_enc(
77: p_line_id_tbl IN PO_TBL_NUMBER
78: , p_quantity_tbl IN PO_TBL_NUMBER
79: , x_result_set_id IN OUT NOCOPY NUMBER
80: , x_result_type OUT NOCOPY VARCHAR2
81: );

Line 78: , p_quantity_tbl IN PO_TBL_NUMBER

74: --
75:
76: PROCEDURE quantity_ge_quantity_enc(
77: p_line_id_tbl IN PO_TBL_NUMBER
78: , p_quantity_tbl IN PO_TBL_NUMBER
79: , x_result_set_id IN OUT NOCOPY NUMBER
80: , x_result_type OUT NOCOPY VARCHAR2
81: );
82:

Line 84: p_line_id_tbl IN PO_TBL_NUMBER

80: , x_result_type OUT NOCOPY VARCHAR2
81: );
82:
83: PROCEDURE quantity_notif_change(
84: p_line_id_tbl IN PO_TBL_NUMBER
85: , p_quantity_tbl IN PO_TBL_NUMBER
86: , x_result_set_id IN OUT NOCOPY NUMBER
87: , x_result_type OUT NOCOPY VARCHAR2
88: );

Line 85: , p_quantity_tbl IN PO_TBL_NUMBER

81: );
82:
83: PROCEDURE quantity_notif_change(
84: p_line_id_tbl IN PO_TBL_NUMBER
85: , p_quantity_tbl IN PO_TBL_NUMBER
86: , x_result_set_id IN OUT NOCOPY NUMBER
87: , x_result_type OUT NOCOPY VARCHAR2
88: );
89:

Line 91: p_line_id_tbl IN PO_TBL_NUMBER

87: , x_result_type OUT NOCOPY VARCHAR2
88: );
89:
90: PROCEDURE amount_gt_zero(
91: p_line_id_tbl IN PO_TBL_NUMBER
92: , p_amount_tbl IN PO_TBL_NUMBER
93: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
94: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
95: , x_result_type OUT NOCOPY VARCHAR2

Line 92: , p_amount_tbl IN PO_TBL_NUMBER

88: );
89:
90: PROCEDURE amount_gt_zero(
91: p_line_id_tbl IN PO_TBL_NUMBER
92: , p_amount_tbl IN PO_TBL_NUMBER
93: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
94: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
95: , x_result_type OUT NOCOPY VARCHAR2
96: );

Line 103: p_line_id_tbl IN PO_TBL_NUMBER

99: -- Removed: amount_ge_amount_billed, amount_ge_amount_rcvd,
100: -- Added: amount_ge_amount_exec
101:
102: PROCEDURE amount_ge_amount_exec(
103: p_line_id_tbl IN PO_TBL_NUMBER
104: , p_amount_tbl IN PO_TBL_NUMBER
105: , p_currency_code_tbl IN PO_TBL_VARCHAR30
106: , x_result_set_id IN OUT NOCOPY NUMBER
107: , x_result_type OUT NOCOPY VARCHAR2

Line 104: , p_amount_tbl IN PO_TBL_NUMBER

100: -- Added: amount_ge_amount_exec
101:
102: PROCEDURE amount_ge_amount_exec(
103: p_line_id_tbl IN PO_TBL_NUMBER
104: , p_amount_tbl IN PO_TBL_NUMBER
105: , p_currency_code_tbl IN PO_TBL_VARCHAR30
106: , x_result_set_id IN OUT NOCOPY NUMBER
107: , x_result_type OUT NOCOPY VARCHAR2
108: );

Line 114: p_line_id_tbl IN PO_TBL_NUMBER

110: --
111:
112:
113: PROCEDURE amount_ge_timecard(
114: p_line_id_tbl IN PO_TBL_NUMBER
115: , p_amount_tbl IN PO_TBL_NUMBER
116: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
117: , x_result_type OUT NOCOPY VARCHAR2
118: );

Line 115: , p_amount_tbl IN PO_TBL_NUMBER

111:
112:
113: PROCEDURE amount_ge_timecard(
114: p_line_id_tbl IN PO_TBL_NUMBER
115: , p_amount_tbl IN PO_TBL_NUMBER
116: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
117: , x_result_type OUT NOCOPY VARCHAR2
118: );
119:

Line 121: p_line_id_tbl IN PO_TBL_NUMBER

117: , x_result_type OUT NOCOPY VARCHAR2
118: );
119:
120: PROCEDURE line_num_unique(
121: p_line_id_tbl IN PO_TBL_NUMBER
122: , p_header_id_tbl IN PO_TBL_NUMBER
123: , p_line_num_tbl IN PO_TBL_NUMBER
124: , x_result_set_id IN OUT NOCOPY NUMBER
125: , x_result_type OUT NOCOPY VARCHAR2

Line 122: , p_header_id_tbl IN PO_TBL_NUMBER

118: );
119:
120: PROCEDURE line_num_unique(
121: p_line_id_tbl IN PO_TBL_NUMBER
122: , p_header_id_tbl IN PO_TBL_NUMBER
123: , p_line_num_tbl IN PO_TBL_NUMBER
124: , x_result_set_id IN OUT NOCOPY NUMBER
125: , x_result_type OUT NOCOPY VARCHAR2
126: );

Line 123: , p_line_num_tbl IN PO_TBL_NUMBER

119:
120: PROCEDURE line_num_unique(
121: p_line_id_tbl IN PO_TBL_NUMBER
122: , p_header_id_tbl IN PO_TBL_NUMBER
123: , p_line_num_tbl IN PO_TBL_NUMBER
124: , x_result_set_id IN OUT NOCOPY NUMBER
125: , x_result_type OUT NOCOPY VARCHAR2
126: );
127:

Line 129: p_line_id_tbl IN PO_TBL_NUMBER

125: , x_result_type OUT NOCOPY VARCHAR2
126: );
127:
128: PROCEDURE line_num_gt_zero(
129: p_line_id_tbl IN PO_TBL_NUMBER
130: , p_line_num_tbl IN PO_TBL_NUMBER
131: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
132: , x_result_type OUT NOCOPY VARCHAR2
133: );

Line 130: , p_line_num_tbl IN PO_TBL_NUMBER

126: );
127:
128: PROCEDURE line_num_gt_zero(
129: p_line_id_tbl IN PO_TBL_NUMBER
130: , p_line_num_tbl IN PO_TBL_NUMBER
131: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
132: , x_result_type OUT NOCOPY VARCHAR2
133: );
134:

Line 136: p_line_id_tbl IN PO_TBL_NUMBER

132: , x_result_type OUT NOCOPY VARCHAR2
133: );
134:
135: PROCEDURE vmi_asl_exists(
136: p_line_id_tbl IN PO_TBL_NUMBER
137: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
138: , p_item_id_tbl IN PO_TBL_NUMBER
139: , p_org_id_tbl IN PO_TBL_NUMBER
140: , p_vendor_id_tbl IN PO_TBL_NUMBER

Line 138: , p_item_id_tbl IN PO_TBL_NUMBER

134:
135: PROCEDURE vmi_asl_exists(
136: p_line_id_tbl IN PO_TBL_NUMBER
137: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
138: , p_item_id_tbl IN PO_TBL_NUMBER
139: , p_org_id_tbl IN PO_TBL_NUMBER
140: , p_vendor_id_tbl IN PO_TBL_NUMBER
141: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
142: , x_result_set_id IN OUT NOCOPY NUMBER

Line 139: , p_org_id_tbl IN PO_TBL_NUMBER

135: PROCEDURE vmi_asl_exists(
136: p_line_id_tbl IN PO_TBL_NUMBER
137: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
138: , p_item_id_tbl IN PO_TBL_NUMBER
139: , p_org_id_tbl IN PO_TBL_NUMBER
140: , p_vendor_id_tbl IN PO_TBL_NUMBER
141: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
142: , x_result_set_id IN OUT NOCOPY NUMBER
143: , x_result_type OUT NOCOPY VARCHAR2

Line 140: , p_vendor_id_tbl IN PO_TBL_NUMBER

136: p_line_id_tbl IN PO_TBL_NUMBER
137: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
138: , p_item_id_tbl IN PO_TBL_NUMBER
139: , p_org_id_tbl IN PO_TBL_NUMBER
140: , p_vendor_id_tbl IN PO_TBL_NUMBER
141: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
142: , x_result_set_id IN OUT NOCOPY NUMBER
143: , x_result_type OUT NOCOPY VARCHAR2
144: );

Line 141: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

137: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
138: , p_item_id_tbl IN PO_TBL_NUMBER
139: , p_org_id_tbl IN PO_TBL_NUMBER
140: , p_vendor_id_tbl IN PO_TBL_NUMBER
141: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
142: , x_result_set_id IN OUT NOCOPY NUMBER
143: , x_result_type OUT NOCOPY VARCHAR2
144: );
145:

Line 147: p_line_id_tbl IN PO_TBL_NUMBER

143: , x_result_type OUT NOCOPY VARCHAR2
144: );
145:
146: PROCEDURE start_date_le_end_date(
147: p_line_id_tbl IN PO_TBL_NUMBER
148: , p_start_date_tbl IN PO_TBL_DATE
149: , p_expiration_date_tbl IN PO_TBL_DATE
150: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
151: , x_result_type OUT NOCOPY VARCHAR2

Line 155: p_line_id_tbl IN PO_TBL_NUMBER

151: , x_result_type OUT NOCOPY VARCHAR2
152: );
153:
154: PROCEDURE otl_invalid_start_date_change(
155: p_line_id_tbl IN PO_TBL_NUMBER
156: , p_start_date_tbl IN PO_TBL_DATE
157: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
158: , x_result_type OUT NOCOPY VARCHAR2
159: );

Line 162: p_line_id_tbl IN PO_TBL_NUMBER

158: , x_result_type OUT NOCOPY VARCHAR2
159: );
160:
161: PROCEDURE otl_invalid_end_date_change(
162: p_line_id_tbl IN PO_TBL_NUMBER
163: , p_expiration_date_tbl IN PO_TBL_DATE
164: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
165: , x_result_type OUT NOCOPY VARCHAR2
166: );

Line 169: p_line_id_tbl IN PO_TBL_NUMBER

165: , x_result_type OUT NOCOPY VARCHAR2
166: );
167:
168: PROCEDURE unit_price_ge_zero(
169: p_line_id_tbl IN PO_TBL_NUMBER
170: , p_unit_price_tbl IN PO_TBL_NUMBER
171: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
172: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
173: , x_result_type OUT NOCOPY VARCHAR2

Line 170: , p_unit_price_tbl IN PO_TBL_NUMBER

166: );
167:
168: PROCEDURE unit_price_ge_zero(
169: p_line_id_tbl IN PO_TBL_NUMBER
170: , p_unit_price_tbl IN PO_TBL_NUMBER
171: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
172: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
173: , x_result_type OUT NOCOPY VARCHAR2
174: );

Line 177: p_line_id_tbl IN PO_TBL_NUMBER

173: , x_result_type OUT NOCOPY VARCHAR2
174: );
175:
176: PROCEDURE list_price_ge_zero(
177: p_line_id_tbl IN PO_TBL_NUMBER
178: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
180: , x_result_type OUT NOCOPY VARCHAR2
181: );

Line 178: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER

174: );
175:
176: PROCEDURE list_price_ge_zero(
177: p_line_id_tbl IN PO_TBL_NUMBER
178: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
179: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
180: , x_result_type OUT NOCOPY VARCHAR2
181: );
182:

Line 184: p_line_id_tbl IN PO_TBL_NUMBER

180: , x_result_type OUT NOCOPY VARCHAR2
181: );
182:
183: PROCEDURE market_price_ge_zero(
184: p_line_id_tbl IN PO_TBL_NUMBER
185: , p_market_price_tbl IN PO_TBL_NUMBER
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187: , x_result_type OUT NOCOPY VARCHAR2
188: );

Line 185: , p_market_price_tbl IN PO_TBL_NUMBER

181: );
182:
183: PROCEDURE market_price_ge_zero(
184: p_line_id_tbl IN PO_TBL_NUMBER
185: , p_market_price_tbl IN PO_TBL_NUMBER
186: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
187: , x_result_type OUT NOCOPY VARCHAR2
188: );
189:

Line 191: p_line_id_tbl IN PO_TBL_NUMBER

187: , x_result_type OUT NOCOPY VARCHAR2
188: );
189:
190: PROCEDURE validate_unit_price_change(
191: p_line_id_tbl IN PO_TBL_NUMBER
192: , p_unit_price_tbl IN PO_TBL_NUMBER
193: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
194: , x_result_set_id IN OUT NOCOPY NUMBER
195: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 192: , p_unit_price_tbl IN PO_TBL_NUMBER

188: );
189:
190: PROCEDURE validate_unit_price_change(
191: p_line_id_tbl IN PO_TBL_NUMBER
192: , p_unit_price_tbl IN PO_TBL_NUMBER
193: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
194: , x_result_set_id IN OUT NOCOPY NUMBER
195: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
196: , x_result_type OUT NOCOPY VARCHAR2

Line 200: p_line_id_tbl IN PO_TBL_NUMBER

196: , x_result_type OUT NOCOPY VARCHAR2
197: );
198:
199: PROCEDURE expiration_ge_blanket_start(
200: p_line_id_tbl IN PO_TBL_NUMBER
201: , p_blanket_start_date_tbl IN PO_TBL_DATE
202: , p_expiration_date_tbl IN PO_TBL_DATE
203: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
204: , x_result_type OUT NOCOPY VARCHAR2

Line 208: p_line_id_tbl IN PO_TBL_NUMBER

204: , x_result_type OUT NOCOPY VARCHAR2
205: );
206:
207: PROCEDURE expiration_le_blanket_end(
208: p_line_id_tbl IN PO_TBL_NUMBER
209: , p_blanket_end_date_tbl IN PO_TBL_DATE
210: , p_expiration_date_tbl IN PO_TBL_DATE
211: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
212: , x_result_type OUT NOCOPY VARCHAR2

Line 218: p_line_id_tbl IN PO_TBL_NUMBER

214:
215: --
216:
217: PROCEDURE qty_ge_qty_milestone_exec(
218: p_line_id_tbl IN PO_TBL_NUMBER
219: , p_quantity_tbl IN PO_TBL_NUMBER
220: , x_result_set_id IN OUT NOCOPY NUMBER
221: , x_result_type OUT NOCOPY VARCHAR2
222: );

Line 219: , p_quantity_tbl IN PO_TBL_NUMBER

215: --
216:
217: PROCEDURE qty_ge_qty_milestone_exec(
218: p_line_id_tbl IN PO_TBL_NUMBER
219: , p_quantity_tbl IN PO_TBL_NUMBER
220: , x_result_set_id IN OUT NOCOPY NUMBER
221: , x_result_type OUT NOCOPY VARCHAR2
222: );
223:

Line 225: p_line_id_tbl IN PO_TBL_NUMBER

221: , x_result_type OUT NOCOPY VARCHAR2
222: );
223:
224: PROCEDURE price_ge_price_milestone_exec(
225: p_line_id_tbl IN PO_TBL_NUMBER
226: , p_price_tbl IN PO_TBL_NUMBER
227: , x_result_set_id IN OUT NOCOPY NUMBER
228: , x_result_type OUT NOCOPY VARCHAR2
229: );

Line 226: , p_price_tbl IN PO_TBL_NUMBER

222: );
223:
224: PROCEDURE price_ge_price_milestone_exec(
225: p_line_id_tbl IN PO_TBL_NUMBER
226: , p_price_tbl IN PO_TBL_NUMBER
227: , x_result_set_id IN OUT NOCOPY NUMBER
228: , x_result_type OUT NOCOPY VARCHAR2
229: );
230:

Line 233: p_line_id_tbl IN PO_TBL_NUMBER

229: );
230:
231: -- Bug 5070210 Start
232: PROCEDURE advance_amt_le_amt(
233: p_line_id_tbl IN PO_TBL_NUMBER
234: , p_advance_tbl IN PO_TBL_NUMBER
235: , p_amount_tbl IN PO_TBL_NUMBER
236: , p_quantity_tbl IN PO_TBL_NUMBER
237: , p_price_tbl IN PO_TBL_NUMBER

Line 234: , p_advance_tbl IN PO_TBL_NUMBER

230:
231: -- Bug 5070210 Start
232: PROCEDURE advance_amt_le_amt(
233: p_line_id_tbl IN PO_TBL_NUMBER
234: , p_advance_tbl IN PO_TBL_NUMBER
235: , p_amount_tbl IN PO_TBL_NUMBER
236: , p_quantity_tbl IN PO_TBL_NUMBER
237: , p_price_tbl IN PO_TBL_NUMBER
238: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 235: , p_amount_tbl IN PO_TBL_NUMBER

231: -- Bug 5070210 Start
232: PROCEDURE advance_amt_le_amt(
233: p_line_id_tbl IN PO_TBL_NUMBER
234: , p_advance_tbl IN PO_TBL_NUMBER
235: , p_amount_tbl IN PO_TBL_NUMBER
236: , p_quantity_tbl IN PO_TBL_NUMBER
237: , p_price_tbl IN PO_TBL_NUMBER
238: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
239: , x_result_type OUT NOCOPY VARCHAR2

Line 236: , p_quantity_tbl IN PO_TBL_NUMBER

232: PROCEDURE advance_amt_le_amt(
233: p_line_id_tbl IN PO_TBL_NUMBER
234: , p_advance_tbl IN PO_TBL_NUMBER
235: , p_amount_tbl IN PO_TBL_NUMBER
236: , p_quantity_tbl IN PO_TBL_NUMBER
237: , p_price_tbl IN PO_TBL_NUMBER
238: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
239: , x_result_type OUT NOCOPY VARCHAR2
240: );

Line 237: , p_price_tbl IN PO_TBL_NUMBER

233: p_line_id_tbl IN PO_TBL_NUMBER
234: , p_advance_tbl IN PO_TBL_NUMBER
235: , p_amount_tbl IN PO_TBL_NUMBER
236: , p_quantity_tbl IN PO_TBL_NUMBER
237: , p_price_tbl IN PO_TBL_NUMBER
238: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
239: , x_result_type OUT NOCOPY VARCHAR2
240: );
241: -- Bug 5070210 End

Line 245: p_line_id_tbl IN PO_TBL_NUMBER

241: -- Bug 5070210 End
242: --
243:
244: PROCEDURE unit_meas_not_null(
245: p_line_id_tbl IN PO_TBL_NUMBER
246: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
247: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
249: , x_result_type OUT NOCOPY VARCHAR2

Line 253: p_line_id_tbl IN PO_TBL_NUMBER

249: , x_result_type OUT NOCOPY VARCHAR2
250: );
251:
252: PROCEDURE item_description_not_null(
253: p_line_id_tbl IN PO_TBL_NUMBER
254: , p_item_description_tbl IN PO_TBL_VARCHAR2000
255: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
256: , x_result_type OUT NOCOPY VARCHAR2
257: );

Line 260: p_line_id_tbl IN PO_TBL_NUMBER

256: , x_result_type OUT NOCOPY VARCHAR2
257: );
258:
259: PROCEDURE category_id_not_null(
260: p_line_id_tbl IN PO_TBL_NUMBER
261: , p_category_id_tbl IN PO_TBL_NUMBER
262: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
263: , x_result_type OUT NOCOPY VARCHAR2
264: );

Line 261: , p_category_id_tbl IN PO_TBL_NUMBER

257: );
258:
259: PROCEDURE category_id_not_null(
260: p_line_id_tbl IN PO_TBL_NUMBER
261: , p_category_id_tbl IN PO_TBL_NUMBER
262: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
263: , x_result_type OUT NOCOPY VARCHAR2
264: );
265:

Line 267: p_id_tbl IN PO_TBL_NUMBER

263: , x_result_type OUT NOCOPY VARCHAR2
264: );
265:
266: PROCEDURE item_id_not_null(
267: p_id_tbl IN PO_TBL_NUMBER
268: , p_item_id_tbl IN PO_TBL_NUMBER
269: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
270: , p_line_type_id_tbl IN PO_TBL_NUMBER
271: , p_message_name IN VARCHAR2

Line 268: , p_item_id_tbl IN PO_TBL_NUMBER

264: );
265:
266: PROCEDURE item_id_not_null(
267: p_id_tbl IN PO_TBL_NUMBER
268: , p_item_id_tbl IN PO_TBL_NUMBER
269: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
270: , p_line_type_id_tbl IN PO_TBL_NUMBER
271: , p_message_name IN VARCHAR2
272: , x_result_set_id IN OUT NOCOPY NUMBER

Line 270: , p_line_type_id_tbl IN PO_TBL_NUMBER

266: PROCEDURE item_id_not_null(
267: p_id_tbl IN PO_TBL_NUMBER
268: , p_item_id_tbl IN PO_TBL_NUMBER
269: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
270: , p_line_type_id_tbl IN PO_TBL_NUMBER
271: , p_message_name IN VARCHAR2
272: , x_result_set_id IN OUT NOCOPY NUMBER
273: , x_result_type OUT NOCOPY VARCHAR2
274: );

Line 277: p_line_id_tbl IN PO_TBL_NUMBER

273: , x_result_type OUT NOCOPY VARCHAR2
274: );
275:
276: PROCEDURE temp_labor_job_id_not_null(
277: p_line_id_tbl IN PO_TBL_NUMBER
278: , p_job_id_tbl IN PO_TBL_NUMBER
279: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
280: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
281: , x_result_type OUT NOCOPY VARCHAR2

Line 278: , p_job_id_tbl IN PO_TBL_NUMBER

274: );
275:
276: PROCEDURE temp_labor_job_id_not_null(
277: p_line_id_tbl IN PO_TBL_NUMBER
278: , p_job_id_tbl IN PO_TBL_NUMBER
279: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
280: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
281: , x_result_type OUT NOCOPY VARCHAR2
282: );

Line 285: p_line_id_tbl IN PO_TBL_NUMBER

281: , x_result_type OUT NOCOPY VARCHAR2
282: );
283:
284: PROCEDURE line_type_id_not_null(
285: p_line_id_tbl IN PO_TBL_NUMBER
286: , p_line_type_id_tbl IN PO_TBL_NUMBER
287: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
288: , x_result_type OUT NOCOPY VARCHAR2
289: );

Line 286: , p_line_type_id_tbl IN PO_TBL_NUMBER

282: );
283:
284: PROCEDURE line_type_id_not_null(
285: p_line_id_tbl IN PO_TBL_NUMBER
286: , p_line_type_id_tbl IN PO_TBL_NUMBER
287: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
288: , x_result_type OUT NOCOPY VARCHAR2
289: );
290:

Line 292: p_line_id_tbl IN PO_TBL_NUMBER

288: , x_result_type OUT NOCOPY VARCHAR2
289: );
290:
291: PROCEDURE temp_lbr_start_date_not_null(
292: p_line_id_tbl IN PO_TBL_NUMBER
293: , p_start_date_tbl IN PO_TBL_DATE
294: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
295: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
296: , x_result_type OUT NOCOPY VARCHAR2

Line 300: p_line_id_tbl IN PO_TBL_NUMBER

296: , x_result_type OUT NOCOPY VARCHAR2
297: );
298:
299: PROCEDURE src_doc_line_not_null(
300: p_line_id_tbl IN PO_TBL_NUMBER
301: , p_from_header_id_tbl IN PO_TBL_NUMBER
302: , p_from_line_id_tbl IN PO_TBL_NUMBER
303: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
304: , x_result_type OUT NOCOPY VARCHAR2

Line 301: , p_from_header_id_tbl IN PO_TBL_NUMBER

297: );
298:
299: PROCEDURE src_doc_line_not_null(
300: p_line_id_tbl IN PO_TBL_NUMBER
301: , p_from_header_id_tbl IN PO_TBL_NUMBER
302: , p_from_line_id_tbl IN PO_TBL_NUMBER
303: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
304: , x_result_type OUT NOCOPY VARCHAR2
305: );

Line 302: , p_from_line_id_tbl IN PO_TBL_NUMBER

298:
299: PROCEDURE src_doc_line_not_null(
300: p_line_id_tbl IN PO_TBL_NUMBER
301: , p_from_header_id_tbl IN PO_TBL_NUMBER
302: , p_from_line_id_tbl IN PO_TBL_NUMBER
303: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
304: , x_result_type OUT NOCOPY VARCHAR2
305: );
306: -- OPM Integration R12 Start

Line 308: p_line_id_tbl IN PO_TBL_NUMBER

304: , x_result_type OUT NOCOPY VARCHAR2
305: );
306: -- OPM Integration R12 Start
307: PROCEDURE line_sec_quantity_gt_zero(
308: p_line_id_tbl IN PO_TBL_NUMBER
309: , p_item_id_tbl IN PO_TBL_NUMBER
310: , p_sec_quantity_tbl IN PO_TBL_NUMBER
311: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
312: , x_result_type OUT NOCOPY VARCHAR2

Line 309: , p_item_id_tbl IN PO_TBL_NUMBER

305: );
306: -- OPM Integration R12 Start
307: PROCEDURE line_sec_quantity_gt_zero(
308: p_line_id_tbl IN PO_TBL_NUMBER
309: , p_item_id_tbl IN PO_TBL_NUMBER
310: , p_sec_quantity_tbl IN PO_TBL_NUMBER
311: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
312: , x_result_type OUT NOCOPY VARCHAR2
313: );

Line 310: , p_sec_quantity_tbl IN PO_TBL_NUMBER

306: -- OPM Integration R12 Start
307: PROCEDURE line_sec_quantity_gt_zero(
308: p_line_id_tbl IN PO_TBL_NUMBER
309: , p_item_id_tbl IN PO_TBL_NUMBER
310: , p_sec_quantity_tbl IN PO_TBL_NUMBER
311: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
312: , x_result_type OUT NOCOPY VARCHAR2
313: );
314:

Line 316: p_line_id_tbl IN PO_TBL_NUMBER

312: , x_result_type OUT NOCOPY VARCHAR2
313: );
314:
315: PROCEDURE line_qtys_within_deviation (
316: p_line_id_tbl IN PO_TBL_NUMBER
317: , p_item_id_tbl IN PO_TBL_NUMBER
318: , p_quantity_tbl IN PO_TBL_NUMBER
319: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
320: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 317: , p_item_id_tbl IN PO_TBL_NUMBER

313: );
314:
315: PROCEDURE line_qtys_within_deviation (
316: p_line_id_tbl IN PO_TBL_NUMBER
317: , p_item_id_tbl IN PO_TBL_NUMBER
318: , p_quantity_tbl IN PO_TBL_NUMBER
319: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
320: , p_sec_quantity_tbl IN PO_TBL_NUMBER
321: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 318: , p_quantity_tbl IN PO_TBL_NUMBER

314:
315: PROCEDURE line_qtys_within_deviation (
316: p_line_id_tbl IN PO_TBL_NUMBER
317: , p_item_id_tbl IN PO_TBL_NUMBER
318: , p_quantity_tbl IN PO_TBL_NUMBER
319: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
320: , p_sec_quantity_tbl IN PO_TBL_NUMBER
321: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
322: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 320: , p_sec_quantity_tbl IN PO_TBL_NUMBER

316: p_line_id_tbl IN PO_TBL_NUMBER
317: , p_item_id_tbl IN PO_TBL_NUMBER
318: , p_quantity_tbl IN PO_TBL_NUMBER
319: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
320: , p_sec_quantity_tbl IN PO_TBL_NUMBER
321: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
322: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
323: , x_result_type OUT NOCOPY VARCHAR2
324: );

Line 328: p_line_id_tbl IN PO_TBL_NUMBER

324: );
325: -- OPM Integration R12 End
326:
327: PROCEDURE from_line_id_not_null (
328: p_line_id_tbl IN PO_TBL_NUMBER
329: , p_from_header_id_tbl IN PO_TBL_NUMBER
330: , p_from_line_id_tbl IN PO_TBL_NUMBER
331: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
332: , x_result_type OUT NOCOPY VARCHAR2

Line 329: , p_from_header_id_tbl IN PO_TBL_NUMBER

325: -- OPM Integration R12 End
326:
327: PROCEDURE from_line_id_not_null (
328: p_line_id_tbl IN PO_TBL_NUMBER
329: , p_from_header_id_tbl IN PO_TBL_NUMBER
330: , p_from_line_id_tbl IN PO_TBL_NUMBER
331: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
332: , x_result_type OUT NOCOPY VARCHAR2
333: );

Line 330: , p_from_line_id_tbl IN PO_TBL_NUMBER

326:
327: PROCEDURE from_line_id_not_null (
328: p_line_id_tbl IN PO_TBL_NUMBER
329: , p_from_header_id_tbl IN PO_TBL_NUMBER
330: , p_from_line_id_tbl IN PO_TBL_NUMBER
331: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
332: , x_result_type OUT NOCOPY VARCHAR2
333: );
334: