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 AUTHID CURRENT_USER AS
2: -- $Header: PO_VAL_LINES.pls 120.28.12020000.10 2013/04/25 12:33:02 akyanama ship $
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.28.12020000.10 2013/04/25 12:33:02 akyanama ship $
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: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
23: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

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: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
23: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
24: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 26: , p_header_id_tbl IN PO_TBL_NUMBER --

22: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
23: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
24: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
25: , x_result_type OUT NOCOPY VARCHAR2
26: , p_header_id_tbl IN PO_TBL_NUMBER --
27: );
28:
29: --
30: -- Removed: quantity_ge_quantity_billed, quantity_ge_quantity_rcvd,

Line 33: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 34: , p_quantity_tbl IN PO_TBL_NUMBER

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

Line 40: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 41: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

37: );
38:
39: PROCEDURE recoupment_rate_range_check (
40: p_line_id_tbl IN PO_TBL_NUMBER
41: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
42: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
43: , x_result_type OUT NOCOPY VARCHAR2
44: );
45:

Line 47: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 48: , p_retainage_rate_tbl IN PO_TBL_NUMBER

44: );
45:
46: PROCEDURE retainage_rate_range_check (
47: p_line_id_tbl IN PO_TBL_NUMBER
48: , p_retainage_rate_tbl IN PO_TBL_NUMBER
49: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
50: , x_result_type OUT NOCOPY VARCHAR2
51: );
52:

Line 54: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 55: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

51: );
52:
53: PROCEDURE prog_pay_rate_range_check (
54: p_line_id_tbl IN PO_TBL_NUMBER
55: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
56: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
57: , x_result_type OUT NOCOPY VARCHAR2
58: );
59:

Line 62: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 63: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

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

Line 70: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 71: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

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

Line 80: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 81: , p_quantity_tbl IN PO_TBL_NUMBER

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

Line 87: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 88: , p_quantity_tbl IN PO_TBL_NUMBER

84: );
85:
86: PROCEDURE quantity_notif_change(
87: p_line_id_tbl IN PO_TBL_NUMBER
88: , p_quantity_tbl IN PO_TBL_NUMBER
89: , x_result_set_id IN OUT NOCOPY NUMBER
90: , x_result_type OUT NOCOPY VARCHAR2
91: );
92:

Line 94: p_line_id_tbl IN PO_TBL_NUMBER

90: , x_result_type OUT NOCOPY VARCHAR2
91: );
92:
93: PROCEDURE amount_gt_zero(
94: p_line_id_tbl IN PO_TBL_NUMBER
95: , p_amount_tbl IN PO_TBL_NUMBER
96: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
97: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
98: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes

Line 95: , p_amount_tbl IN PO_TBL_NUMBER

91: );
92:
93: PROCEDURE amount_gt_zero(
94: p_line_id_tbl IN PO_TBL_NUMBER
95: , p_amount_tbl IN PO_TBL_NUMBER
96: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
97: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
98: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
99: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 101: , p_header_id_tbl IN PO_TBL_NUMBER --

97: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
98: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
99: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
100: , x_result_type OUT NOCOPY VARCHAR2
101: , p_header_id_tbl IN PO_TBL_NUMBER --
102: );
103:
104: --
105: -- Removed: amount_ge_amount_billed, amount_ge_amount_rcvd,

Line 109: p_line_id_tbl IN PO_TBL_NUMBER

105: -- Removed: amount_ge_amount_billed, amount_ge_amount_rcvd,
106: -- Added: amount_ge_amount_exec
107:
108: PROCEDURE amount_ge_amount_exec(
109: p_line_id_tbl IN PO_TBL_NUMBER
110: , p_amount_tbl IN PO_TBL_NUMBER
111: , p_currency_code_tbl IN PO_TBL_VARCHAR30
112: , x_result_set_id IN OUT NOCOPY NUMBER
113: , x_result_type OUT NOCOPY VARCHAR2

Line 110: , p_amount_tbl IN PO_TBL_NUMBER

106: -- Added: amount_ge_amount_exec
107:
108: PROCEDURE amount_ge_amount_exec(
109: p_line_id_tbl IN PO_TBL_NUMBER
110: , p_amount_tbl IN PO_TBL_NUMBER
111: , p_currency_code_tbl IN PO_TBL_VARCHAR30
112: , x_result_set_id IN OUT NOCOPY NUMBER
113: , x_result_type OUT NOCOPY VARCHAR2
114: );

Line 120: p_line_id_tbl IN PO_TBL_NUMBER

116: --
117:
118:
119: PROCEDURE amount_ge_timecard(
120: p_line_id_tbl IN PO_TBL_NUMBER
121: , p_amount_tbl IN PO_TBL_NUMBER
122: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
123: , x_result_type OUT NOCOPY VARCHAR2
124: );

Line 121: , p_amount_tbl IN PO_TBL_NUMBER

117:
118:
119: PROCEDURE amount_ge_timecard(
120: p_line_id_tbl IN PO_TBL_NUMBER
121: , p_amount_tbl IN PO_TBL_NUMBER
122: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
123: , x_result_type OUT NOCOPY VARCHAR2
124: );
125:

Line 127: p_line_id_tbl IN PO_TBL_NUMBER

123: , x_result_type OUT NOCOPY VARCHAR2
124: );
125:
126: PROCEDURE line_num_unique(
127: p_line_id_tbl IN PO_TBL_NUMBER
128: , p_header_id_tbl IN PO_TBL_NUMBER
129: , p_line_num_tbl IN PO_TBL_NUMBER
130: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
131: , p_draft_id_tbl IN PO_TBL_NUMBER --

Line 128: , p_header_id_tbl IN PO_TBL_NUMBER

124: );
125:
126: PROCEDURE line_num_unique(
127: p_line_id_tbl IN PO_TBL_NUMBER
128: , p_header_id_tbl IN PO_TBL_NUMBER
129: , p_line_num_tbl IN PO_TBL_NUMBER
130: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
131: , p_draft_id_tbl IN PO_TBL_NUMBER --
132: , x_result_set_id IN OUT NOCOPY NUMBER

Line 129: , p_line_num_tbl IN PO_TBL_NUMBER

125:
126: PROCEDURE line_num_unique(
127: p_line_id_tbl IN PO_TBL_NUMBER
128: , p_header_id_tbl IN PO_TBL_NUMBER
129: , p_line_num_tbl IN PO_TBL_NUMBER
130: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
131: , p_draft_id_tbl IN PO_TBL_NUMBER --
132: , x_result_set_id IN OUT NOCOPY NUMBER
133: , x_result_type OUT NOCOPY VARCHAR2

Line 131: , p_draft_id_tbl IN PO_TBL_NUMBER --

127: p_line_id_tbl IN PO_TBL_NUMBER
128: , p_header_id_tbl IN PO_TBL_NUMBER
129: , p_line_num_tbl IN PO_TBL_NUMBER
130: , p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL --
131: , p_draft_id_tbl IN PO_TBL_NUMBER --
132: , x_result_set_id IN OUT NOCOPY NUMBER
133: , x_result_type OUT NOCOPY VARCHAR2
134: );
135:

Line 137: p_line_id_tbl IN PO_TBL_NUMBER

133: , x_result_type OUT NOCOPY VARCHAR2
134: );
135:
136: PROCEDURE line_num_gt_zero(
137: p_line_id_tbl IN PO_TBL_NUMBER
138: , p_line_num_tbl IN PO_TBL_NUMBER
139: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
140: , x_result_type OUT NOCOPY VARCHAR2
141: );

Line 138: , p_line_num_tbl IN PO_TBL_NUMBER

134: );
135:
136: PROCEDURE line_num_gt_zero(
137: p_line_id_tbl IN PO_TBL_NUMBER
138: , p_line_num_tbl IN PO_TBL_NUMBER
139: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
140: , x_result_type OUT NOCOPY VARCHAR2
141: );
142:

Line 144: p_line_id_tbl IN PO_TBL_NUMBER

140: , x_result_type OUT NOCOPY VARCHAR2
141: );
142:
143: PROCEDURE vmi_asl_exists(
144: p_line_id_tbl IN PO_TBL_NUMBER
145: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
146: , p_item_id_tbl IN PO_TBL_NUMBER
147: , p_org_id_tbl IN PO_TBL_NUMBER
148: , p_vendor_id_tbl IN PO_TBL_NUMBER

Line 146: , p_item_id_tbl IN PO_TBL_NUMBER

142:
143: PROCEDURE vmi_asl_exists(
144: p_line_id_tbl IN PO_TBL_NUMBER
145: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
146: , p_item_id_tbl IN PO_TBL_NUMBER
147: , p_org_id_tbl IN PO_TBL_NUMBER
148: , p_vendor_id_tbl IN PO_TBL_NUMBER
149: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
150: , x_result_set_id IN OUT NOCOPY NUMBER

Line 147: , p_org_id_tbl IN PO_TBL_NUMBER

143: PROCEDURE vmi_asl_exists(
144: p_line_id_tbl IN PO_TBL_NUMBER
145: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
146: , p_item_id_tbl IN PO_TBL_NUMBER
147: , p_org_id_tbl IN PO_TBL_NUMBER
148: , p_vendor_id_tbl IN PO_TBL_NUMBER
149: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
150: , x_result_set_id IN OUT NOCOPY NUMBER
151: , x_result_type OUT NOCOPY VARCHAR2

Line 148: , p_vendor_id_tbl IN PO_TBL_NUMBER

144: p_line_id_tbl IN PO_TBL_NUMBER
145: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
146: , p_item_id_tbl IN PO_TBL_NUMBER
147: , p_org_id_tbl IN PO_TBL_NUMBER
148: , p_vendor_id_tbl IN PO_TBL_NUMBER
149: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
150: , x_result_set_id IN OUT NOCOPY NUMBER
151: , x_result_type OUT NOCOPY VARCHAR2
152: );

Line 149: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

145: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
146: , p_item_id_tbl IN PO_TBL_NUMBER
147: , p_org_id_tbl IN PO_TBL_NUMBER
148: , p_vendor_id_tbl IN PO_TBL_NUMBER
149: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
150: , x_result_set_id IN OUT NOCOPY NUMBER
151: , x_result_type OUT NOCOPY VARCHAR2
152: );
153:

Line 155: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 163: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 170: p_line_id_tbl IN PO_TBL_NUMBER

166: , x_result_type OUT NOCOPY VARCHAR2
167: );
168:
169: PROCEDURE otl_invalid_end_date_change(
170: p_line_id_tbl IN PO_TBL_NUMBER
171: , p_expiration_date_tbl IN PO_TBL_DATE
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 unit_price_ge_zero(
177: p_line_id_tbl IN PO_TBL_NUMBER
178: , p_unit_price_tbl IN PO_TBL_NUMBER
179: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
180: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
181: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 178: , p_unit_price_tbl IN PO_TBL_NUMBER

174: );
175:
176: PROCEDURE unit_price_ge_zero(
177: p_line_id_tbl IN PO_TBL_NUMBER
178: , p_unit_price_tbl IN PO_TBL_NUMBER
179: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
180: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
181: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
182: , x_result_type OUT NOCOPY VARCHAR2

Line 186: p_line_id_tbl IN PO_TBL_NUMBER

182: , x_result_type OUT NOCOPY VARCHAR2
183: );
184:
185: PROCEDURE list_price_ge_zero(
186: p_line_id_tbl IN PO_TBL_NUMBER
187: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
189: , x_result_type OUT NOCOPY VARCHAR2
190: );

Line 187: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER

183: );
184:
185: PROCEDURE list_price_ge_zero(
186: p_line_id_tbl IN PO_TBL_NUMBER
187: , p_list_price_per_unit_tbl IN PO_TBL_NUMBER
188: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
189: , x_result_type OUT NOCOPY VARCHAR2
190: );
191:

Line 193: p_line_id_tbl IN PO_TBL_NUMBER

189: , x_result_type OUT NOCOPY VARCHAR2
190: );
191:
192: PROCEDURE market_price_ge_zero(
193: p_line_id_tbl IN PO_TBL_NUMBER
194: , p_market_price_tbl IN PO_TBL_NUMBER
195: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
196: , x_result_type OUT NOCOPY VARCHAR2
197: );

Line 194: , p_market_price_tbl IN PO_TBL_NUMBER

190: );
191:
192: PROCEDURE market_price_ge_zero(
193: p_line_id_tbl IN PO_TBL_NUMBER
194: , p_market_price_tbl IN PO_TBL_NUMBER
195: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
196: , x_result_type OUT NOCOPY VARCHAR2
197: );
198:

Line 200: p_line_id_tbl IN PO_TBL_NUMBER

196: , x_result_type OUT NOCOPY VARCHAR2
197: );
198:
199: PROCEDURE validate_unit_price_change(
200: p_line_id_tbl IN PO_TBL_NUMBER
201: , p_unit_price_tbl IN PO_TBL_NUMBER
202: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
203: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1 ----
204: , x_result_set_id IN OUT NOCOPY NUMBER

Line 201: , p_unit_price_tbl IN PO_TBL_NUMBER

197: );
198:
199: PROCEDURE validate_unit_price_change(
200: p_line_id_tbl IN PO_TBL_NUMBER
201: , p_unit_price_tbl IN PO_TBL_NUMBER
202: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
203: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1 ----
204: , x_result_set_id IN OUT NOCOPY NUMBER
205: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 210: p_line_id_tbl IN PO_TBL_NUMBER

206: , x_result_type OUT NOCOPY VARCHAR2
207: );
208:
209: PROCEDURE expiration_ge_blanket_start(
210: p_line_id_tbl IN PO_TBL_NUMBER
211: , p_blanket_start_date_tbl IN PO_TBL_DATE
212: , p_expiration_date_tbl IN PO_TBL_DATE
213: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
214: , x_result_type OUT NOCOPY VARCHAR2

Line 218: p_line_id_tbl IN PO_TBL_NUMBER

214: , x_result_type OUT NOCOPY VARCHAR2
215: );
216:
217: PROCEDURE expiration_le_blanket_end(
218: p_line_id_tbl IN PO_TBL_NUMBER
219: , p_blanket_end_date_tbl IN PO_TBL_DATE
220: , p_expiration_date_tbl IN PO_TBL_DATE
221: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
222: , x_result_type OUT NOCOPY VARCHAR2

Line 228: p_line_id_tbl IN PO_TBL_NUMBER

224:
225: --
226:
227: PROCEDURE qty_ge_qty_milestone_exec(
228: p_line_id_tbl IN PO_TBL_NUMBER
229: , p_quantity_tbl IN PO_TBL_NUMBER
230: , x_result_set_id IN OUT NOCOPY NUMBER
231: , x_result_type OUT NOCOPY VARCHAR2
232: );

Line 229: , p_quantity_tbl IN PO_TBL_NUMBER

225: --
226:
227: PROCEDURE qty_ge_qty_milestone_exec(
228: p_line_id_tbl IN PO_TBL_NUMBER
229: , p_quantity_tbl IN PO_TBL_NUMBER
230: , x_result_set_id IN OUT NOCOPY NUMBER
231: , x_result_type OUT NOCOPY VARCHAR2
232: );
233:

Line 235: p_line_id_tbl IN PO_TBL_NUMBER

231: , x_result_type OUT NOCOPY VARCHAR2
232: );
233:
234: PROCEDURE price_ge_price_milestone_exec(
235: p_line_id_tbl IN PO_TBL_NUMBER
236: , p_price_tbl IN PO_TBL_NUMBER
237: , x_result_set_id IN OUT NOCOPY NUMBER
238: , x_result_type OUT NOCOPY VARCHAR2
239: );

Line 236: , p_price_tbl IN PO_TBL_NUMBER

232: );
233:
234: PROCEDURE price_ge_price_milestone_exec(
235: p_line_id_tbl IN PO_TBL_NUMBER
236: , p_price_tbl IN PO_TBL_NUMBER
237: , x_result_set_id IN OUT NOCOPY NUMBER
238: , x_result_type OUT NOCOPY VARCHAR2
239: );
240:

Line 243: p_line_id_tbl IN PO_TBL_NUMBER

239: );
240:
241: -- Bug 5070210 Start
242: PROCEDURE advance_amt_le_amt(
243: p_line_id_tbl IN PO_TBL_NUMBER
244: , p_advance_tbl IN PO_TBL_NUMBER
245: , p_amount_tbl IN PO_TBL_NUMBER
246: , p_quantity_tbl IN PO_TBL_NUMBER
247: , p_price_tbl IN PO_TBL_NUMBER

Line 244: , p_advance_tbl IN PO_TBL_NUMBER

240:
241: -- Bug 5070210 Start
242: PROCEDURE advance_amt_le_amt(
243: p_line_id_tbl IN PO_TBL_NUMBER
244: , p_advance_tbl IN PO_TBL_NUMBER
245: , p_amount_tbl IN PO_TBL_NUMBER
246: , p_quantity_tbl IN PO_TBL_NUMBER
247: , p_price_tbl IN PO_TBL_NUMBER
248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 245: , p_amount_tbl IN PO_TBL_NUMBER

241: -- Bug 5070210 Start
242: PROCEDURE advance_amt_le_amt(
243: p_line_id_tbl IN PO_TBL_NUMBER
244: , p_advance_tbl IN PO_TBL_NUMBER
245: , p_amount_tbl IN PO_TBL_NUMBER
246: , p_quantity_tbl IN PO_TBL_NUMBER
247: , p_price_tbl IN PO_TBL_NUMBER
248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
249: , x_result_type OUT NOCOPY VARCHAR2

Line 246: , p_quantity_tbl IN PO_TBL_NUMBER

242: PROCEDURE advance_amt_le_amt(
243: p_line_id_tbl IN PO_TBL_NUMBER
244: , p_advance_tbl IN PO_TBL_NUMBER
245: , p_amount_tbl IN PO_TBL_NUMBER
246: , p_quantity_tbl IN PO_TBL_NUMBER
247: , p_price_tbl IN PO_TBL_NUMBER
248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
249: , x_result_type OUT NOCOPY VARCHAR2
250: );

Line 247: , p_price_tbl IN PO_TBL_NUMBER

243: p_line_id_tbl IN PO_TBL_NUMBER
244: , p_advance_tbl IN PO_TBL_NUMBER
245: , p_amount_tbl IN PO_TBL_NUMBER
246: , p_quantity_tbl IN PO_TBL_NUMBER
247: , p_price_tbl IN PO_TBL_NUMBER
248: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
249: , x_result_type OUT NOCOPY VARCHAR2
250: );
251: -- Bug 5070210 End

Line 255: p_line_id_tbl IN PO_TBL_NUMBER

251: -- Bug 5070210 End
252:
253: --
254: PROCEDURE complex_po_attributes_check(
255: p_line_id_tbl IN PO_TBL_NUMBER
256: , p_style_id_tbl IN PO_TBL_NUMBER
257: , p_retainage_rate_tbl IN PO_TBL_NUMBER
258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

Line 256: , p_style_id_tbl IN PO_TBL_NUMBER

252:
253: --
254: PROCEDURE complex_po_attributes_check(
255: p_line_id_tbl IN PO_TBL_NUMBER
256: , p_style_id_tbl IN PO_TBL_NUMBER
257: , p_retainage_rate_tbl IN PO_TBL_NUMBER
258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
260: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

Line 257: , p_retainage_rate_tbl IN PO_TBL_NUMBER

253: --
254: PROCEDURE complex_po_attributes_check(
255: p_line_id_tbl IN PO_TBL_NUMBER
256: , p_style_id_tbl IN PO_TBL_NUMBER
257: , p_retainage_rate_tbl IN PO_TBL_NUMBER
258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
260: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
261: , p_advance_tbl IN PO_TBL_NUMBER

Line 258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER

254: PROCEDURE complex_po_attributes_check(
255: p_line_id_tbl IN PO_TBL_NUMBER
256: , p_style_id_tbl IN PO_TBL_NUMBER
257: , p_retainage_rate_tbl IN PO_TBL_NUMBER
258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
260: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
261: , p_advance_tbl IN PO_TBL_NUMBER
262: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER

255: p_line_id_tbl IN PO_TBL_NUMBER
256: , p_style_id_tbl IN PO_TBL_NUMBER
257: , p_retainage_rate_tbl IN PO_TBL_NUMBER
258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
260: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
261: , p_advance_tbl IN PO_TBL_NUMBER
262: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
263: , x_result_type OUT NOCOPY VARCHAR2

Line 260: , p_recoupment_rate_tbl IN PO_TBL_NUMBER

256: , p_style_id_tbl IN PO_TBL_NUMBER
257: , p_retainage_rate_tbl IN PO_TBL_NUMBER
258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
260: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
261: , p_advance_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_advance_tbl IN PO_TBL_NUMBER

257: , p_retainage_rate_tbl IN PO_TBL_NUMBER
258: , p_max_retain_amt_tbl IN PO_TBL_NUMBER
259: , p_prog_pay_rate_tbl IN PO_TBL_NUMBER
260: , p_recoupment_rate_tbl IN PO_TBL_NUMBER
261: , p_advance_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 270: p_line_id_tbl IN PO_TBL_NUMBER

266:
267: --
268:
269: PROCEDURE unit_meas_not_null(
270: p_line_id_tbl IN PO_TBL_NUMBER
271: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
272: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
273: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
274: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 279: p_line_id_tbl IN PO_TBL_NUMBER

275: , x_result_type OUT NOCOPY VARCHAR2
276: );
277:
278: PROCEDURE item_description_not_null(
279: p_line_id_tbl IN PO_TBL_NUMBER
280: , p_item_description_tbl IN PO_TBL_VARCHAR2000
281: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
282: , x_result_type OUT NOCOPY VARCHAR2
283: );

Line 286: p_line_id_tbl IN PO_TBL_NUMBER

282: , x_result_type OUT NOCOPY VARCHAR2
283: );
284:
285: PROCEDURE category_id_not_null(
286: p_line_id_tbl IN PO_TBL_NUMBER
287: , p_category_id_tbl IN PO_TBL_NUMBER
288: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
289: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
290: , x_result_type OUT NOCOPY VARCHAR2

Line 287: , p_category_id_tbl IN PO_TBL_NUMBER

283: );
284:
285: PROCEDURE category_id_not_null(
286: p_line_id_tbl IN PO_TBL_NUMBER
287: , p_category_id_tbl IN PO_TBL_NUMBER
288: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
289: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
290: , x_result_type OUT NOCOPY VARCHAR2
291: );

Line 294: p_id_tbl IN PO_TBL_NUMBER

290: , x_result_type OUT NOCOPY VARCHAR2
291: );
292:
293: PROCEDURE item_id_not_null(
294: p_id_tbl IN PO_TBL_NUMBER
295: , p_item_id_tbl IN PO_TBL_NUMBER
296: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
297: , p_line_type_id_tbl IN PO_TBL_NUMBER
298: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

Line 295: , p_item_id_tbl IN PO_TBL_NUMBER

291: );
292:
293: PROCEDURE item_id_not_null(
294: p_id_tbl IN PO_TBL_NUMBER
295: , p_item_id_tbl IN PO_TBL_NUMBER
296: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
297: , p_line_type_id_tbl IN PO_TBL_NUMBER
298: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
299: , p_message_name IN VARCHAR2

Line 297: , p_line_type_id_tbl IN PO_TBL_NUMBER

293: PROCEDURE item_id_not_null(
294: p_id_tbl IN PO_TBL_NUMBER
295: , p_item_id_tbl IN PO_TBL_NUMBER
296: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
297: , p_line_type_id_tbl IN PO_TBL_NUMBER
298: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
299: , p_message_name IN VARCHAR2
300: , x_result_set_id IN OUT NOCOPY NUMBER
301: , x_result_type OUT NOCOPY VARCHAR2

Line 305: p_line_id_tbl IN PO_TBL_NUMBER

301: , x_result_type OUT NOCOPY VARCHAR2
302: );
303:
304: PROCEDURE temp_labor_job_id_not_null(
305: p_line_id_tbl IN PO_TBL_NUMBER
306: , p_job_id_tbl IN PO_TBL_NUMBER
307: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
309: , x_result_type OUT NOCOPY VARCHAR2

Line 306: , p_job_id_tbl IN PO_TBL_NUMBER

302: );
303:
304: PROCEDURE temp_labor_job_id_not_null(
305: p_line_id_tbl IN PO_TBL_NUMBER
306: , p_job_id_tbl IN PO_TBL_NUMBER
307: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
308: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
309: , x_result_type OUT NOCOPY VARCHAR2
310: );

Line 313: p_line_id_tbl IN PO_TBL_NUMBER

309: , x_result_type OUT NOCOPY VARCHAR2
310: );
311:
312: PROCEDURE line_type_id_not_null(
313: p_line_id_tbl IN PO_TBL_NUMBER
314: , p_line_type_id_tbl IN PO_TBL_NUMBER
315: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
316: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
317: , x_result_type OUT NOCOPY VARCHAR2

Line 314: , p_line_type_id_tbl IN PO_TBL_NUMBER

310: );
311:
312: PROCEDURE line_type_id_not_null(
313: p_line_id_tbl IN PO_TBL_NUMBER
314: , p_line_type_id_tbl IN PO_TBL_NUMBER
315: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
316: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
317: , x_result_type OUT NOCOPY VARCHAR2
318: );

Line 321: p_line_id_tbl IN PO_TBL_NUMBER

317: , x_result_type OUT NOCOPY VARCHAR2
318: );
319:
320: PROCEDURE temp_lbr_start_date_not_null(
321: p_line_id_tbl IN PO_TBL_NUMBER
322: , p_start_date_tbl IN PO_TBL_DATE
323: , p_purchase_basis_tbl IN PO_TBL_VARCHAR30
324: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
325: , x_result_type OUT NOCOPY VARCHAR2

Line 329: p_line_id_tbl IN PO_TBL_NUMBER

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

Line 330: , p_from_header_id_tbl IN PO_TBL_NUMBER

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

Line 331: , p_from_line_id_tbl IN PO_TBL_NUMBER

327:
328: PROCEDURE src_doc_line_not_null(
329: p_line_id_tbl IN PO_TBL_NUMBER
330: , p_from_header_id_tbl IN PO_TBL_NUMBER
331: , p_from_line_id_tbl IN PO_TBL_NUMBER
332: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
333: , x_result_type OUT NOCOPY VARCHAR2
334: );
335: -- OPM Integration R12 Start

Line 337: p_line_id_tbl IN PO_TBL_NUMBER

333: , x_result_type OUT NOCOPY VARCHAR2
334: );
335: -- OPM Integration R12 Start
336: PROCEDURE line_sec_quantity_gt_zero(
337: p_line_id_tbl IN PO_TBL_NUMBER
338: , p_item_id_tbl IN PO_TBL_NUMBER
339: , p_sec_quantity_tbl IN PO_TBL_NUMBER
340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
341: , x_result_type OUT NOCOPY VARCHAR2

Line 338: , p_item_id_tbl IN PO_TBL_NUMBER

334: );
335: -- OPM Integration R12 Start
336: PROCEDURE line_sec_quantity_gt_zero(
337: p_line_id_tbl IN PO_TBL_NUMBER
338: , p_item_id_tbl IN PO_TBL_NUMBER
339: , p_sec_quantity_tbl IN PO_TBL_NUMBER
340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
341: , x_result_type OUT NOCOPY VARCHAR2
342: );

Line 339: , p_sec_quantity_tbl IN PO_TBL_NUMBER

335: -- OPM Integration R12 Start
336: PROCEDURE line_sec_quantity_gt_zero(
337: p_line_id_tbl IN PO_TBL_NUMBER
338: , p_item_id_tbl IN PO_TBL_NUMBER
339: , p_sec_quantity_tbl IN PO_TBL_NUMBER
340: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
341: , x_result_type OUT NOCOPY VARCHAR2
342: );
343:

Line 345: p_line_id_tbl IN PO_TBL_NUMBER

341: , x_result_type OUT NOCOPY VARCHAR2
342: );
343:
344: PROCEDURE line_qtys_within_deviation (
345: p_line_id_tbl IN PO_TBL_NUMBER
346: , p_item_id_tbl IN PO_TBL_NUMBER
347: , p_quantity_tbl IN PO_TBL_NUMBER
348: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
349: , p_sec_quantity_tbl IN PO_TBL_NUMBER

Line 346: , p_item_id_tbl IN PO_TBL_NUMBER

342: );
343:
344: PROCEDURE line_qtys_within_deviation (
345: p_line_id_tbl IN PO_TBL_NUMBER
346: , p_item_id_tbl IN PO_TBL_NUMBER
347: , p_quantity_tbl IN PO_TBL_NUMBER
348: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
349: , p_sec_quantity_tbl IN PO_TBL_NUMBER
350: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30

Line 347: , p_quantity_tbl IN PO_TBL_NUMBER

343:
344: PROCEDURE line_qtys_within_deviation (
345: p_line_id_tbl IN PO_TBL_NUMBER
346: , p_item_id_tbl IN PO_TBL_NUMBER
347: , p_quantity_tbl IN PO_TBL_NUMBER
348: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
349: , p_sec_quantity_tbl IN PO_TBL_NUMBER
350: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 349: , p_sec_quantity_tbl IN PO_TBL_NUMBER

345: p_line_id_tbl IN PO_TBL_NUMBER
346: , p_item_id_tbl IN PO_TBL_NUMBER
347: , p_quantity_tbl IN PO_TBL_NUMBER
348: , p_primary_uom_tbl IN PO_TBL_VARCHAR30
349: , p_sec_quantity_tbl IN PO_TBL_NUMBER
350: , p_secondary_uom_tbl IN PO_TBL_VARCHAR30
351: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
352: , x_result_type OUT NOCOPY VARCHAR2
353: );

Line 357: p_line_id_tbl IN PO_TBL_NUMBER

353: );
354: -- OPM Integration R12 End
355:
356: PROCEDURE from_line_id_not_null (
357: p_line_id_tbl IN PO_TBL_NUMBER
358: , p_from_header_id_tbl IN PO_TBL_NUMBER
359: , p_from_line_id_tbl IN PO_TBL_NUMBER
360: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
361: , x_result_type OUT NOCOPY VARCHAR2

Line 358: , p_from_header_id_tbl IN PO_TBL_NUMBER

354: -- OPM Integration R12 End
355:
356: PROCEDURE from_line_id_not_null (
357: p_line_id_tbl IN PO_TBL_NUMBER
358: , p_from_header_id_tbl IN PO_TBL_NUMBER
359: , p_from_line_id_tbl IN PO_TBL_NUMBER
360: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
361: , x_result_type OUT NOCOPY VARCHAR2
362: );

Line 359: , p_from_line_id_tbl IN PO_TBL_NUMBER

355:
356: PROCEDURE from_line_id_not_null (
357: p_line_id_tbl IN PO_TBL_NUMBER
358: , p_from_header_id_tbl IN PO_TBL_NUMBER
359: , p_from_line_id_tbl IN PO_TBL_NUMBER
360: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
361: , x_result_type OUT NOCOPY VARCHAR2
362: );
363:

Line 367: p_line_id_tbl IN PO_TBL_NUMBER

363:
364: -- CLM changes start
365:
366: PROCEDURE option_from_date_not_null (
367: p_line_id_tbl IN PO_TBL_NUMBER
368: , p_option_ind_tbl IN PO_TBL_VARCHAR1
369: ,p_option_from_date_tbl IN PO_TBL_DATE
370: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
371: , x_result_type OUT NOCOPY VARCHAR2

Line 375: p_line_id_tbl IN PO_TBL_NUMBER

371: , x_result_type OUT NOCOPY VARCHAR2
372: );
373:
374: PROCEDURE option_to_date_not_null (
375: p_line_id_tbl IN PO_TBL_NUMBER
376: , p_option_ind_tbl IN PO_TBL_VARCHAR1
377: ,p_option_to_Date_tbl IN PO_TBL_DATE
378: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
379: , x_result_type OUT NOCOPY VARCHAR2

Line 383: p_line_id_tbl IN PO_TBL_NUMBER

379: , x_result_type OUT NOCOPY VARCHAR2
380: );
381:
382: PROCEDURE option_to_date_le_from_date (
383: p_line_id_tbl IN PO_TBL_NUMBER
384: , p_option_ind_tbl IN PO_TBL_VARCHAR1
385: ,p_option_from_date_tbl IN PO_TBL_DATE
386: ,p_option_to_Date_tbl IN PO_TBL_DATE
387: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 392: p_line_id_tbl IN PO_TBL_NUMBER

388: , x_result_type OUT NOCOPY VARCHAR2
389: );
390:
391: PROCEDURE option_from_date_le_sysdate (
392: p_line_id_tbl IN PO_TBL_NUMBER
393: , p_option_ind_tbl IN PO_TBL_VARCHAR1
394: ,p_option_from_date_tbl IN PO_TBL_DATE
395: , p_draft_id_tbl IN PO_TBL_NUMBER
396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 395: , p_draft_id_tbl IN PO_TBL_NUMBER

391: PROCEDURE option_from_date_le_sysdate (
392: p_line_id_tbl IN PO_TBL_NUMBER
393: , p_option_ind_tbl IN PO_TBL_VARCHAR1
394: ,p_option_from_date_tbl IN PO_TBL_DATE
395: , p_draft_id_tbl IN PO_TBL_NUMBER
396: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
397: , x_result_type OUT NOCOPY VARCHAR2
398: );
399:

Line 401: p_line_id_tbl IN PO_TBL_NUMBER

397: , x_result_type OUT NOCOPY VARCHAR2
398: );
399:
400: PROCEDURE option_fm_date_le_ex_date (
401: p_line_id_tbl IN PO_TBL_NUMBER
402: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
403: , p_option_from_date_tbl IN PO_TBL_DATE
404: , p_option_exer_date_tbl IN PO_TBL_DATE
405: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 411: p_line_id_tbl IN PO_TBL_NUMBER

407: );
408:
409:
410: PROCEDURE line_num_disp_check (
411: p_line_id_tbl IN PO_TBL_NUMBER
412: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
413: , p_group_line_id_tbl IN PO_TBL_NUMBER
414: ,p_clm_exhibit_name_tbl IN PO_TBL_VARCHAR20
415: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 413: , p_group_line_id_tbl IN PO_TBL_NUMBER

409:
410: PROCEDURE line_num_disp_check (
411: p_line_id_tbl IN PO_TBL_NUMBER
412: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
413: , p_group_line_id_tbl IN PO_TBL_NUMBER
414: ,p_clm_exhibit_name_tbl IN PO_TBL_VARCHAR20
415: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
416: , x_result_type OUT NOCOPY VARCHAR2
417: );

Line 422: p_line_id_tbl IN PO_TBL_NUMBER

418:
419: -- CLM END
420: -- Mod Project
421: PROCEDURE mod_no_cancel_shp_complt(
422: p_line_id_tbl IN PO_TBL_NUMBER
423: ,p_control_action_tbl IN PO_TBL_VARCHAR30
424: ,x_result_set_id IN OUT NOCOPY NUMBER
425: ,x_result_type OUT NOCOPY VARCHAR2
426: );

Line 431: p_line_id_tbl IN PO_TBL_NUMBER

427:
428: -- For Fed Fileds CLM
429: PROCEDURE order_start_date_le_end_date
430: (
431: p_line_id_tbl IN PO_TBL_NUMBER
432: , p_start_date_tbl IN PO_TBL_DATE
433: , p_expiration_date_tbl IN PO_TBL_DATE
434: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
435: , x_result_type OUT NOCOPY VARCHAR2

Line 440: p_line_id_tbl IN PO_TBL_NUMBER

436: );
437:
438: PROCEDURE order_start_date_gt_sysdate
439: (
440: p_line_id_tbl IN PO_TBL_NUMBER
441: , p_order_from_date_tbl IN PO_TBL_DATE
442: , p_draft_id_tbl IN PO_TBL_NUMBER
443: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
444: , x_result_type OUT NOCOPY VARCHAR2

Line 442: , p_draft_id_tbl IN PO_TBL_NUMBER

438: PROCEDURE order_start_date_gt_sysdate
439: (
440: p_line_id_tbl IN PO_TBL_NUMBER
441: , p_order_from_date_tbl IN PO_TBL_DATE
442: , p_draft_id_tbl IN PO_TBL_NUMBER
443: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
444: , x_result_type OUT NOCOPY VARCHAR2
445: );
446:

Line 449: p_line_id_tbl IN PO_TBL_NUMBER

445: );
446:
447: PROCEDURE max_tot_amt_le_line_tot_amt
448: (
449: p_line_id_tbl IN PO_TBL_NUMBER
450: , p_max_total_amt_tbl IN PO_TBL_NUMBER
451: , p_line_amount_tbl IN PO_TBL_NUMBER
452: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
453: , x_result_type OUT NOCOPY VARCHAR2

Line 450: , p_max_total_amt_tbl IN PO_TBL_NUMBER

446:
447: PROCEDURE max_tot_amt_le_line_tot_amt
448: (
449: p_line_id_tbl IN PO_TBL_NUMBER
450: , p_max_total_amt_tbl IN PO_TBL_NUMBER
451: , p_line_amount_tbl IN PO_TBL_NUMBER
452: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
453: , x_result_type OUT NOCOPY VARCHAR2
454: );

Line 451: , p_line_amount_tbl IN PO_TBL_NUMBER

447: PROCEDURE max_tot_amt_le_line_tot_amt
448: (
449: p_line_id_tbl IN PO_TBL_NUMBER
450: , p_max_total_amt_tbl IN PO_TBL_NUMBER
451: , p_line_amount_tbl IN PO_TBL_NUMBER
452: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
453: , x_result_type OUT NOCOPY VARCHAR2
454: );
455:

Line 458: p_line_id_tbl IN PO_TBL_NUMBER

454: );
455:
456: PROCEDURE max_tot_amt_ge_min_tot_amt
457: (
458: p_line_id_tbl IN PO_TBL_NUMBER
459: , p_max_total_amt_tbl IN PO_TBL_NUMBER
460: , p_min_total_amt_tbl IN PO_TBL_NUMBER
461: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
462: , x_result_type OUT NOCOPY VARCHAR2

Line 459: , p_max_total_amt_tbl IN PO_TBL_NUMBER

455:
456: PROCEDURE max_tot_amt_ge_min_tot_amt
457: (
458: p_line_id_tbl IN PO_TBL_NUMBER
459: , p_max_total_amt_tbl IN PO_TBL_NUMBER
460: , p_min_total_amt_tbl IN PO_TBL_NUMBER
461: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
462: , x_result_type OUT NOCOPY VARCHAR2
463: );

Line 460: , p_min_total_amt_tbl IN PO_TBL_NUMBER

456: PROCEDURE max_tot_amt_ge_min_tot_amt
457: (
458: p_line_id_tbl IN PO_TBL_NUMBER
459: , p_max_total_amt_tbl IN PO_TBL_NUMBER
460: , p_min_total_amt_tbl IN PO_TBL_NUMBER
461: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
462: , x_result_type OUT NOCOPY VARCHAR2
463: );
464:

Line 467: p_line_id_tbl IN PO_TBL_NUMBER

463: );
464:
465: PROCEDURE max_tot_qty_le_line_tot_qty
466: (
467: p_line_id_tbl IN PO_TBL_NUMBER
468: , p_max_total_qty_tbl IN PO_TBL_NUMBER
469: , p_line_qty_tbl IN PO_TBL_NUMBER
470: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
471: , x_result_type OUT NOCOPY VARCHAR2

Line 468: , p_max_total_qty_tbl IN PO_TBL_NUMBER

464:
465: PROCEDURE max_tot_qty_le_line_tot_qty
466: (
467: p_line_id_tbl IN PO_TBL_NUMBER
468: , p_max_total_qty_tbl IN PO_TBL_NUMBER
469: , p_line_qty_tbl IN PO_TBL_NUMBER
470: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
471: , x_result_type OUT NOCOPY VARCHAR2
472: );

Line 469: , p_line_qty_tbl IN PO_TBL_NUMBER

465: PROCEDURE max_tot_qty_le_line_tot_qty
466: (
467: p_line_id_tbl IN PO_TBL_NUMBER
468: , p_max_total_qty_tbl IN PO_TBL_NUMBER
469: , p_line_qty_tbl IN PO_TBL_NUMBER
470: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
471: , x_result_type OUT NOCOPY VARCHAR2
472: );
473:

Line 476: p_line_id_tbl IN PO_TBL_NUMBER

472: );
473:
474: PROCEDURE max_tot_qty_ge_min_tot_qty
475: (
476: p_line_id_tbl IN PO_TBL_NUMBER
477: , p_max_total_qty_tbl IN PO_TBL_NUMBER
478: , p_min_total_qty_tbl IN PO_TBL_NUMBER
479: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
480: , x_result_type OUT NOCOPY VARCHAR2

Line 477: , p_max_total_qty_tbl IN PO_TBL_NUMBER

473:
474: PROCEDURE max_tot_qty_ge_min_tot_qty
475: (
476: p_line_id_tbl IN PO_TBL_NUMBER
477: , p_max_total_qty_tbl IN PO_TBL_NUMBER
478: , p_min_total_qty_tbl IN PO_TBL_NUMBER
479: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
480: , x_result_type OUT NOCOPY VARCHAR2
481: );

Line 478: , p_min_total_qty_tbl IN PO_TBL_NUMBER

474: PROCEDURE max_tot_qty_ge_min_tot_qty
475: (
476: p_line_id_tbl IN PO_TBL_NUMBER
477: , p_max_total_qty_tbl IN PO_TBL_NUMBER
478: , p_min_total_qty_tbl IN PO_TBL_NUMBER
479: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
480: , x_result_type OUT NOCOPY VARCHAR2
481: );
482:

Line 485: p_line_id_tbl IN PO_TBL_NUMBER

481: );
482:
483: PROCEDURE max_ord_amt_le_max_tot_amt
484: (
485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_max_order_amt_tbl IN PO_TBL_NUMBER
487: , p_max_tot_amount_tbl IN PO_TBL_NUMBER
488: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
489: , x_result_type OUT NOCOPY VARCHAR2

Line 486: , p_max_order_amt_tbl IN PO_TBL_NUMBER

482:
483: PROCEDURE max_ord_amt_le_max_tot_amt
484: (
485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_max_order_amt_tbl IN PO_TBL_NUMBER
487: , p_max_tot_amount_tbl IN PO_TBL_NUMBER
488: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
489: , x_result_type OUT NOCOPY VARCHAR2
490: );

Line 487: , p_max_tot_amount_tbl IN PO_TBL_NUMBER

483: PROCEDURE max_ord_amt_le_max_tot_amt
484: (
485: p_line_id_tbl IN PO_TBL_NUMBER
486: , p_max_order_amt_tbl IN PO_TBL_NUMBER
487: , p_max_tot_amount_tbl IN PO_TBL_NUMBER
488: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
489: , x_result_type OUT NOCOPY VARCHAR2
490: );
491:

Line 494: p_line_id_tbl IN PO_TBL_NUMBER

490: );
491:
492: PROCEDURE max_ord_amt_ge_min_ord_amt
493: (
494: p_line_id_tbl IN PO_TBL_NUMBER
495: , p_max_ord_amt_tbl IN PO_TBL_NUMBER
496: , p_min_ord_amt_tbl IN PO_TBL_NUMBER
497: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
498: , x_result_type OUT NOCOPY VARCHAR2

Line 495: , p_max_ord_amt_tbl IN PO_TBL_NUMBER

491:
492: PROCEDURE max_ord_amt_ge_min_ord_amt
493: (
494: p_line_id_tbl IN PO_TBL_NUMBER
495: , p_max_ord_amt_tbl IN PO_TBL_NUMBER
496: , p_min_ord_amt_tbl IN PO_TBL_NUMBER
497: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
498: , x_result_type OUT NOCOPY VARCHAR2
499: );

Line 496: , p_min_ord_amt_tbl IN PO_TBL_NUMBER

492: PROCEDURE max_ord_amt_ge_min_ord_amt
493: (
494: p_line_id_tbl IN PO_TBL_NUMBER
495: , p_max_ord_amt_tbl IN PO_TBL_NUMBER
496: , p_min_ord_amt_tbl IN PO_TBL_NUMBER
497: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
498: , x_result_type OUT NOCOPY VARCHAR2
499: );
500:

Line 503: p_line_id_tbl IN PO_TBL_NUMBER

499: );
500:
501: PROCEDURE max_ord_qty_le_max_tot_qty
502: (
503: p_line_id_tbl IN PO_TBL_NUMBER
504: , p_max_order_qty_tbl IN PO_TBL_NUMBER
505: , p_max_tot_qty_tbl IN PO_TBL_NUMBER
506: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
507: , x_result_type OUT NOCOPY VARCHAR2

Line 504: , p_max_order_qty_tbl IN PO_TBL_NUMBER

500:
501: PROCEDURE max_ord_qty_le_max_tot_qty
502: (
503: p_line_id_tbl IN PO_TBL_NUMBER
504: , p_max_order_qty_tbl IN PO_TBL_NUMBER
505: , p_max_tot_qty_tbl IN PO_TBL_NUMBER
506: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
507: , x_result_type OUT NOCOPY VARCHAR2
508: );

Line 505: , p_max_tot_qty_tbl IN PO_TBL_NUMBER

501: PROCEDURE max_ord_qty_le_max_tot_qty
502: (
503: p_line_id_tbl IN PO_TBL_NUMBER
504: , p_max_order_qty_tbl IN PO_TBL_NUMBER
505: , p_max_tot_qty_tbl IN PO_TBL_NUMBER
506: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
507: , x_result_type OUT NOCOPY VARCHAR2
508: );
509:

Line 512: p_line_id_tbl IN PO_TBL_NUMBER

508: );
509:
510: PROCEDURE max_ord_qty_ge_min_ord_qty
511: (
512: p_line_id_tbl IN PO_TBL_NUMBER
513: , p_max_ord_qty_tbl IN PO_TBL_NUMBER
514: , p_min_ord_qty_tbl IN PO_TBL_NUMBER
515: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
516: , x_result_type OUT NOCOPY VARCHAR2

Line 513: , p_max_ord_qty_tbl IN PO_TBL_NUMBER

509:
510: PROCEDURE max_ord_qty_ge_min_ord_qty
511: (
512: p_line_id_tbl IN PO_TBL_NUMBER
513: , p_max_ord_qty_tbl IN PO_TBL_NUMBER
514: , p_min_ord_qty_tbl IN PO_TBL_NUMBER
515: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
516: , x_result_type OUT NOCOPY VARCHAR2
517: );

Line 514: , p_min_ord_qty_tbl IN PO_TBL_NUMBER

510: PROCEDURE max_ord_qty_ge_min_ord_qty
511: (
512: p_line_id_tbl IN PO_TBL_NUMBER
513: , p_max_ord_qty_tbl IN PO_TBL_NUMBER
514: , p_min_ord_qty_tbl IN PO_TBL_NUMBER
515: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
516: , x_result_type OUT NOCOPY VARCHAR2
517: );
518:

Line 520: p_header_id_tbl IN PO_TBL_NUMBER,

516: , x_result_type OUT NOCOPY VARCHAR2
517: );
518:
519: PROCEDURE clin_slin_num_check(
520: p_header_id_tbl IN PO_TBL_NUMBER,
521: p_draft_id_tbl IN PO_TBL_NUMBER,
522: p_line_id_tbl IN PO_TBL_NUMBER,
523: p_group_line_id_tbl IN PO_TBL_NUMBER,
524: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

Line 521: p_draft_id_tbl IN PO_TBL_NUMBER,

517: );
518:
519: PROCEDURE clin_slin_num_check(
520: p_header_id_tbl IN PO_TBL_NUMBER,
521: p_draft_id_tbl IN PO_TBL_NUMBER,
522: p_line_id_tbl IN PO_TBL_NUMBER,
523: p_group_line_id_tbl IN PO_TBL_NUMBER,
524: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
525: p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --

Line 522: p_line_id_tbl IN PO_TBL_NUMBER,

518:
519: PROCEDURE clin_slin_num_check(
520: p_header_id_tbl IN PO_TBL_NUMBER,
521: p_draft_id_tbl IN PO_TBL_NUMBER,
522: p_line_id_tbl IN PO_TBL_NUMBER,
523: p_group_line_id_tbl IN PO_TBL_NUMBER,
524: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
525: p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --
526: x_result_set_id IN OUT NOCOPY NUMBER,

Line 523: p_group_line_id_tbl IN PO_TBL_NUMBER,

519: PROCEDURE clin_slin_num_check(
520: p_header_id_tbl IN PO_TBL_NUMBER,
521: p_draft_id_tbl IN PO_TBL_NUMBER,
522: p_line_id_tbl IN PO_TBL_NUMBER,
523: p_group_line_id_tbl IN PO_TBL_NUMBER,
524: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
525: p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --
526: x_result_set_id IN OUT NOCOPY NUMBER,
527: x_result_type OUT NOCOPY VARCHAR2

Line 532: p_line_id_tbl IN PO_TBL_NUMBER,

528: );
529:
530: --CLM PDOI Integration Starts
531: PROCEDURE clin_slin_structure(
532: p_line_id_tbl IN PO_TBL_NUMBER,
533: --p_draft_id_tbl IN PO_TBL_NUMBER,
534: p_intf_line_id_tbl IN PO_TBL_NUMBER,
535: p_group_line_id_tbl IN PO_TBL_NUMBER,
536: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 533: --p_draft_id_tbl IN PO_TBL_NUMBER,

529:
530: --CLM PDOI Integration Starts
531: PROCEDURE clin_slin_structure(
532: p_line_id_tbl IN PO_TBL_NUMBER,
533: --p_draft_id_tbl IN PO_TBL_NUMBER,
534: p_intf_line_id_tbl IN PO_TBL_NUMBER,
535: p_group_line_id_tbl IN PO_TBL_NUMBER,
536: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
537: x_result_type OUT NOCOPY VARCHAR2

Line 534: p_intf_line_id_tbl IN PO_TBL_NUMBER,

530: --CLM PDOI Integration Starts
531: PROCEDURE clin_slin_structure(
532: p_line_id_tbl IN PO_TBL_NUMBER,
533: --p_draft_id_tbl IN PO_TBL_NUMBER,
534: p_intf_line_id_tbl IN PO_TBL_NUMBER,
535: p_group_line_id_tbl IN PO_TBL_NUMBER,
536: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
537: x_result_type OUT NOCOPY VARCHAR2
538: );

Line 535: p_group_line_id_tbl IN PO_TBL_NUMBER,

531: PROCEDURE clin_slin_structure(
532: p_line_id_tbl IN PO_TBL_NUMBER,
533: --p_draft_id_tbl IN PO_TBL_NUMBER,
534: p_intf_line_id_tbl IN PO_TBL_NUMBER,
535: p_group_line_id_tbl IN PO_TBL_NUMBER,
536: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
537: x_result_type OUT NOCOPY VARCHAR2
538: );
539:

Line 541: p_intf_line_id_tbl IN PO_TBL_NUMBER

537: x_result_type OUT NOCOPY VARCHAR2
538: );
539:
540: PROCEDURE validate_contract_type(
541: p_intf_line_id_tbl IN PO_TBL_NUMBER
542: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
543: , p_contract_type_tbl IN PO_TBL_VARCHAR240
544: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
545: , x_result_type OUT NOCOPY VARCHAR2

Line 549: p_intf_line_id_tbl IN PO_TBL_NUMBER

545: , x_result_type OUT NOCOPY VARCHAR2
546: );
547:
548: PROCEDURE validate_cost_constraint(
549: p_intf_line_id_tbl IN PO_TBL_NUMBER
550: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30
551: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
552: , x_result_type OUT NOCOPY VARCHAR2
553: );

Line 556: p_intf_line_id_tbl IN PO_TBL_NUMBER

552: , x_result_type OUT NOCOPY VARCHAR2
553: );
554:
555: PROCEDURE check_contract_num_and_ver(
556: p_intf_line_id_tbl IN PO_TBL_NUMBER
557: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
558: , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
559: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
560: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 557: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER

553: );
554:
555: PROCEDURE check_contract_num_and_ver(
556: p_intf_line_id_tbl IN PO_TBL_NUMBER
557: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
558: , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
559: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
560: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
561: , x_result_type OUT NOCOPY VARCHAR2

Line 559: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER

555: PROCEDURE check_contract_num_and_ver(
556: p_intf_line_id_tbl IN PO_TBL_NUMBER
557: , p_oke_contract_header_id_tbl IN PO_TBL_NUMBER
558: , p_oke_contract_header_num_tbl IN PO_TBL_VARCHAR240
559: , p_oke_contract_version_id_tbl IN PO_TBL_NUMBER
560: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
561: , x_result_type OUT NOCOPY VARCHAR2
562: );
563:

Line 565: p_intf_line_id_tbl IN PO_TBL_NUMBER

561: , x_result_type OUT NOCOPY VARCHAR2
562: );
563:
564: PROCEDURE validate_option_indicator(
565: p_intf_line_id_tbl IN PO_TBL_NUMBER
566: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
567: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
568: , x_result_type OUT NOCOPY VARCHAR2
569: );

Line 572: p_intf_line_id_tbl IN PO_TBL_NUMBER

568: , x_result_type OUT NOCOPY VARCHAR2
569: );
570:
571: PROCEDURE validate_clm_base_line_num(
572: p_intf_line_id_tbl IN PO_TBL_NUMBER
573: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
574: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
575: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
576: , x_result_type OUT NOCOPY VARCHAR2

Line 574: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER

570:
571: PROCEDURE validate_clm_base_line_num(
572: p_intf_line_id_tbl IN PO_TBL_NUMBER
573: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
574: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
575: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
576: , x_result_type OUT NOCOPY VARCHAR2
577: );
578:

Line 580: p_intf_line_id_tbl IN PO_TBL_NUMBER

576: , x_result_type OUT NOCOPY VARCHAR2
577: );
578:
579: PROCEDURE validate_clm_option_num(
580: p_intf_line_id_tbl IN PO_TBL_NUMBER
581: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
582: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
583: , p_clm_option_num_tbl IN PO_TBL_NUMBER
584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 582: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER

578:
579: PROCEDURE validate_clm_option_num(
580: p_intf_line_id_tbl IN PO_TBL_NUMBER
581: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
582: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
583: , p_clm_option_num_tbl IN PO_TBL_NUMBER
584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
585: , x_result_type OUT NOCOPY VARCHAR2
586: );

Line 583: , p_clm_option_num_tbl IN PO_TBL_NUMBER

579: PROCEDURE validate_clm_option_num(
580: p_intf_line_id_tbl IN PO_TBL_NUMBER
581: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
582: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
583: , p_clm_option_num_tbl IN PO_TBL_NUMBER
584: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
585: , x_result_type OUT NOCOPY VARCHAR2
586: );
587:

Line 589: p_intf_line_id_tbl IN PO_TBL_NUMBER

585: , x_result_type OUT NOCOPY VARCHAR2
586: );
587:
588: PROCEDURE validate_clm_idc_type(
589: p_intf_line_id_tbl IN PO_TBL_NUMBER
590: , p_clm_idc_type_tbl IN PO_TBL_VARCHAR240
591: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
592: , x_result_type OUT NOCOPY VARCHAR2
593: );

Line 596: p_intf_line_id_tbl IN PO_TBL_NUMBER

592: , x_result_type OUT NOCOPY VARCHAR2
593: );
594:
595: PROCEDURE validate_clin_line_num_disp(
596: p_intf_line_id_tbl IN PO_TBL_NUMBER
597: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
598: , p_group_line_id_tbl IN PO_TBL_NUMBER
599: , p_intf_header_id_tbl IN PO_TBL_NUMBER
600: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 598: , p_group_line_id_tbl IN PO_TBL_NUMBER

594:
595: PROCEDURE validate_clin_line_num_disp(
596: p_intf_line_id_tbl IN PO_TBL_NUMBER
597: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
598: , p_group_line_id_tbl IN PO_TBL_NUMBER
599: , p_intf_header_id_tbl IN PO_TBL_NUMBER
600: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
601: , x_result_type OUT NOCOPY VARCHAR2
602: );

Line 599: , p_intf_header_id_tbl IN PO_TBL_NUMBER

595: PROCEDURE validate_clin_line_num_disp(
596: p_intf_line_id_tbl IN PO_TBL_NUMBER
597: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
598: , p_group_line_id_tbl IN PO_TBL_NUMBER
599: , p_intf_header_id_tbl IN PO_TBL_NUMBER
600: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
601: , x_result_type OUT NOCOPY VARCHAR2
602: );
603:

Line 605: p_intf_line_id_tbl IN PO_TBL_NUMBER

601: , x_result_type OUT NOCOPY VARCHAR2
602: );
603:
604: PROCEDURE idv_reference_equal_check(
605: p_intf_line_id_tbl IN PO_TBL_NUMBER
606: , p_from_header_id_tbl IN PO_TBL_NUMBER
607: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
608: , x_result_type OUT NOCOPY VARCHAR2
609: );

Line 606: , p_from_header_id_tbl IN PO_TBL_NUMBER

602: );
603:
604: PROCEDURE idv_reference_equal_check(
605: p_intf_line_id_tbl IN PO_TBL_NUMBER
606: , p_from_header_id_tbl IN PO_TBL_NUMBER
607: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
608: , x_result_type OUT NOCOPY VARCHAR2
609: );
610:

Line 612: p_intf_line_id_tbl IN PO_TBL_NUMBER

608: , x_result_type OUT NOCOPY VARCHAR2
609: );
610:
611: PROCEDURE validate_clm_line_type_id(
612: p_intf_line_id_tbl IN PO_TBL_NUMBER
613: , p_line_type_id_tbl IN PO_TBL_NUMBER
614: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
615: , x_result_type OUT NOCOPY VARCHAR2
616: );

Line 613: , p_line_type_id_tbl IN PO_TBL_NUMBER

609: );
610:
611: PROCEDURE validate_clm_line_type_id(
612: p_intf_line_id_tbl IN PO_TBL_NUMBER
613: , p_line_type_id_tbl IN PO_TBL_NUMBER
614: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
615: , x_result_type OUT NOCOPY VARCHAR2
616: );
617: --CLM PDOI Integration Ends

Line 620: p_line_id_tbl IN PO_TBL_NUMBER

616: );
617: --CLM PDOI Integration Ends
618:
619: PROCEDURE validate_comments_not_null(
620: p_line_id_tbl IN PO_TBL_NUMBER
621: , p_draft_id_tbl IN PO_TBL_NUMBER
622: , p_draft_type_tbl IN PO_TBL_VARCHAR30
623: , p_comments_tbl IN PO_TBL_VARCHAR2000
624: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 621: , p_draft_id_tbl IN PO_TBL_NUMBER

617: --CLM PDOI Integration Ends
618:
619: PROCEDURE validate_comments_not_null(
620: p_line_id_tbl IN PO_TBL_NUMBER
621: , p_draft_id_tbl IN PO_TBL_NUMBER
622: , p_draft_type_tbl IN PO_TBL_VARCHAR30
623: , p_comments_tbl IN PO_TBL_VARCHAR2000
624: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
625: , x_result_type OUT NOCOPY VARCHAR2

Line 630: p_header_id_tbl IN PO_TBL_NUMBER,

626: );
627:
628: -- CLM Phase 4 - Elins project
629: PROCEDURE validate_exhibit_name (
630: p_header_id_tbl IN PO_TBL_NUMBER,
631: p_draft_id_tbl IN PO_TBL_NUMBER,
632: p_line_id_tbl IN PO_TBL_NUMBER,
633: p_exhibit_name_tbl IN PO_TBL_VARCHAR20,
634: x_result_set_id IN OUT NOCOPY NUMBER,

Line 631: p_draft_id_tbl IN PO_TBL_NUMBER,

627:
628: -- CLM Phase 4 - Elins project
629: PROCEDURE validate_exhibit_name (
630: p_header_id_tbl IN PO_TBL_NUMBER,
631: p_draft_id_tbl IN PO_TBL_NUMBER,
632: p_line_id_tbl IN PO_TBL_NUMBER,
633: p_exhibit_name_tbl IN PO_TBL_VARCHAR20,
634: x_result_set_id IN OUT NOCOPY NUMBER,
635: x_result_type OUT NOCOPY VARCHAR2

Line 632: p_line_id_tbl IN PO_TBL_NUMBER,

628: -- CLM Phase 4 - Elins project
629: PROCEDURE validate_exhibit_name (
630: p_header_id_tbl IN PO_TBL_NUMBER,
631: p_draft_id_tbl IN PO_TBL_NUMBER,
632: p_line_id_tbl IN PO_TBL_NUMBER,
633: p_exhibit_name_tbl IN PO_TBL_VARCHAR20,
634: x_result_set_id IN OUT NOCOPY NUMBER,
635: x_result_type OUT NOCOPY VARCHAR2
636: );

Line 639: p_po_line_id IN PO_TBL_NUMBER,

635: x_result_type OUT NOCOPY VARCHAR2
636: );
637: -- bug 16461105
638: PROCEDURE validate_undef_amt_le_line_amt(
639: p_po_line_id IN PO_TBL_NUMBER,
640: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
641: p_unit_price IN PO_TBL_NUMBER,
642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,

Line 641: p_unit_price IN PO_TBL_NUMBER,

637: -- bug 16461105
638: PROCEDURE validate_undef_amt_le_line_amt(
639: p_po_line_id IN PO_TBL_NUMBER,
640: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
641: p_unit_price IN PO_TBL_NUMBER,
642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,

Line 642: p_quantity IN PO_TBL_NUMBER,

638: PROCEDURE validate_undef_amt_le_line_amt(
639: p_po_line_id IN PO_TBL_NUMBER,
640: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
641: p_unit_price IN PO_TBL_NUMBER,
642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,
646: p_undef_amount IN PO_TBL_NUMBER,

Line 643: p_old_quantity IN PO_TBL_NUMBER,

639: p_po_line_id IN PO_TBL_NUMBER,
640: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
641: p_unit_price IN PO_TBL_NUMBER,
642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,
646: p_undef_amount IN PO_TBL_NUMBER,
647: p_po_line_uca_id IN PO_TBL_NUMBER,

Line 644: p_old_unit_price IN PO_TBL_NUMBER,

640: p_order_type_lookup_code IN PO_TBL_VARCHAR30,
641: p_unit_price IN PO_TBL_NUMBER,
642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,
646: p_undef_amount IN PO_TBL_NUMBER,
647: p_po_line_uca_id IN PO_TBL_NUMBER,
648: p_ucas_po_line_id IN PO_TBL_NUMBER,

Line 645: p_draft_id IN PO_TBL_NUMBER,

641: p_unit_price IN PO_TBL_NUMBER,
642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,
646: p_undef_amount IN PO_TBL_NUMBER,
647: p_po_line_uca_id IN PO_TBL_NUMBER,
648: p_ucas_po_line_id IN PO_TBL_NUMBER,
649: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,

Line 646: p_undef_amount IN PO_TBL_NUMBER,

642: p_quantity IN PO_TBL_NUMBER,
643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,
646: p_undef_amount IN PO_TBL_NUMBER,
647: p_po_line_uca_id IN PO_TBL_NUMBER,
648: p_ucas_po_line_id IN PO_TBL_NUMBER,
649: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
650: x_result_type OUT nocopy VARCHAR2);

Line 647: p_po_line_uca_id IN PO_TBL_NUMBER,

643: p_old_quantity IN PO_TBL_NUMBER,
644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,
646: p_undef_amount IN PO_TBL_NUMBER,
647: p_po_line_uca_id IN PO_TBL_NUMBER,
648: p_ucas_po_line_id IN PO_TBL_NUMBER,
649: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
650: x_result_type OUT nocopy VARCHAR2);
651: -- bug 16461105

Line 648: p_ucas_po_line_id IN PO_TBL_NUMBER,

644: p_old_unit_price IN PO_TBL_NUMBER,
645: p_draft_id IN PO_TBL_NUMBER,
646: p_undef_amount IN PO_TBL_NUMBER,
647: p_po_line_uca_id IN PO_TBL_NUMBER,
648: p_ucas_po_line_id IN PO_TBL_NUMBER,
649: x_results IN OUT nocopy PO_VALIDATION_RESULTS_TYPE,
650: x_result_type OUT nocopy VARCHAR2);
651: -- bug 16461105
652: