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

Line 5: p_header_id_tbl IN PO_TBL_NUMBER

1: PACKAGE PO_VAL_HEADERS AUTHID CURRENT_USER AS
2: -- $Header: PO_VAL_HEADERS.pls 120.14.12020000.4 2013/04/03 04:45:30 amalick ship $
3:
4: PROCEDURE price_update_tol_ge_zero(
5: p_header_id_tbl IN PO_TBL_NUMBER
6: , p_price_update_tol_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_price_update_tol_tbl IN PO_TBL_NUMBER

2: -- $Header: PO_VAL_HEADERS.pls 120.14.12020000.4 2013/04/03 04:45:30 amalick ship $
3:
4: PROCEDURE price_update_tol_ge_zero(
5: p_header_id_tbl IN PO_TBL_NUMBER
6: , p_price_update_tol_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_header_id_tbl IN PO_TBL_NUMBER

8: , x_result_type OUT NOCOPY VARCHAR2
9: );
10:
11: PROCEDURE amount_limit_ge_zero(
12: p_header_id_tbl IN PO_TBL_NUMBER
13: , p_amount_limit_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_amount_limit_tbl IN PO_TBL_NUMBER

9: );
10:
11: PROCEDURE amount_limit_ge_zero(
12: p_header_id_tbl IN PO_TBL_NUMBER
13: , p_amount_limit_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_header_id_tbl IN PO_TBL_NUMBER

15: , x_result_type OUT NOCOPY VARCHAR2
16: );
17:
18: PROCEDURE amt_limit_ge_amt_agreed(
19: p_header_id_tbl IN PO_TBL_NUMBER
20: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
21: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
22: , p_amount_limit_tbl IN PO_TBL_NUMBER
23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 20: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599

16: );
17:
18: PROCEDURE amt_limit_ge_amt_agreed(
19: p_header_id_tbl IN PO_TBL_NUMBER
20: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
21: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
22: , p_amount_limit_tbl IN PO_TBL_NUMBER
23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24: , x_result_type OUT NOCOPY VARCHAR2

Line 21: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

17:
18: PROCEDURE amt_limit_ge_amt_agreed(
19: p_header_id_tbl IN PO_TBL_NUMBER
20: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
21: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
22: , p_amount_limit_tbl IN PO_TBL_NUMBER
23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24: , x_result_type OUT NOCOPY VARCHAR2
25: );

Line 22: , p_amount_limit_tbl IN PO_TBL_NUMBER

18: PROCEDURE amt_limit_ge_amt_agreed(
19: p_header_id_tbl IN PO_TBL_NUMBER
20: , p_style_id_tbl IN PO_TBL_NUMBER --Bug 12660599
21: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
22: , p_amount_limit_tbl IN PO_TBL_NUMBER
23: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
24: , x_result_type OUT NOCOPY VARCHAR2
25: );
26:

Line 28: p_header_id_tbl IN PO_TBL_NUMBER

24: , x_result_type OUT NOCOPY VARCHAR2
25: );
26:
27: PROCEDURE amount_agreed_ge_zero(
28: p_header_id_tbl IN PO_TBL_NUMBER
29: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
30: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
31: , x_result_type OUT NOCOPY VARCHAR2
32: );

Line 29: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

25: );
26:
27: PROCEDURE amount_agreed_ge_zero(
28: p_header_id_tbl IN PO_TBL_NUMBER
29: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
30: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
31: , x_result_type OUT NOCOPY VARCHAR2
32: );
33:

Line 35: p_header_id_tbl IN PO_TBL_NUMBER

31: , x_result_type OUT NOCOPY VARCHAR2
32: );
33:
34: PROCEDURE amount_agreed_not_null(
35: p_header_id_tbl IN PO_TBL_NUMBER
36: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
37: , p_amount_limit_tbl IN PO_TBL_NUMBER
38: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
39: , x_result_type OUT NOCOPY VARCHAR2

Line 36: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER

32: );
33:
34: PROCEDURE amount_agreed_not_null(
35: p_header_id_tbl IN PO_TBL_NUMBER
36: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
37: , p_amount_limit_tbl IN PO_TBL_NUMBER
38: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
39: , x_result_type OUT NOCOPY VARCHAR2
40: );

Line 37: , p_amount_limit_tbl IN PO_TBL_NUMBER

33:
34: PROCEDURE amount_agreed_not_null(
35: p_header_id_tbl IN PO_TBL_NUMBER
36: , p_blanket_total_amount_tbl IN PO_TBL_NUMBER
37: , p_amount_limit_tbl IN PO_TBL_NUMBER
38: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
39: , x_result_type OUT NOCOPY VARCHAR2
40: );
41:

Line 43: p_header_id_tbl IN PO_TBL_NUMBER

39: , x_result_type OUT NOCOPY VARCHAR2
40: );
41:
42: PROCEDURE warn_supplier_on_hold(
43: p_header_id_tbl IN PO_TBL_NUMBER
44: , p_vendor_id_tbl IN PO_TBL_NUMBER
45: , x_result_set_id IN OUT NOCOPY NUMBER
46: , x_result_type OUT NOCOPY VARCHAR2
47: );

Line 44: , p_vendor_id_tbl IN PO_TBL_NUMBER

40: );
41:
42: PROCEDURE warn_supplier_on_hold(
43: p_header_id_tbl IN PO_TBL_NUMBER
44: , p_vendor_id_tbl IN PO_TBL_NUMBER
45: , x_result_set_id IN OUT NOCOPY NUMBER
46: , x_result_type OUT NOCOPY VARCHAR2
47: );
48:

Line 50: p_header_id_tbl IN PO_TBL_NUMBER

46: , x_result_type OUT NOCOPY VARCHAR2
47: );
48:
49: PROCEDURE rate_gt_zero(
50: p_header_id_tbl IN PO_TBL_NUMBER
51: , p_rate_tbl IN PO_TBL_NUMBER
52: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
53: , x_result_type OUT NOCOPY VARCHAR2
54: );

Line 51: , p_rate_tbl IN PO_TBL_NUMBER

47: );
48:
49: PROCEDURE rate_gt_zero(
50: p_header_id_tbl IN PO_TBL_NUMBER
51: , p_rate_tbl IN PO_TBL_NUMBER
52: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
53: , x_result_type OUT NOCOPY VARCHAR2
54: );
55:

Line 57: p_header_id_tbl IN PO_TBL_NUMBER

53: , x_result_type OUT NOCOPY VARCHAR2
54: );
55:
56: PROCEDURE rate_combination_valid(
57: p_header_id_tbl IN PO_TBL_NUMBER
58: , p_org_id_tbl IN PO_TBL_NUMBER
59: , p_currency_code_tbl IN PO_TBL_VARCHAR30
60: , p_rate_type_tbl IN PO_TBL_VARCHAR30
61: , p_rate_date_tbl IN PO_TBL_DATE

Line 58: , p_org_id_tbl IN PO_TBL_NUMBER

54: );
55:
56: PROCEDURE rate_combination_valid(
57: p_header_id_tbl IN PO_TBL_NUMBER
58: , p_org_id_tbl IN PO_TBL_NUMBER
59: , p_currency_code_tbl IN PO_TBL_VARCHAR30
60: , p_rate_type_tbl IN PO_TBL_VARCHAR30
61: , p_rate_date_tbl IN PO_TBL_DATE
62: , p_rate_tbl IN PO_TBL_NUMBER

Line 62: , p_rate_tbl IN PO_TBL_NUMBER

58: , p_org_id_tbl IN PO_TBL_NUMBER
59: , p_currency_code_tbl IN PO_TBL_VARCHAR30
60: , p_rate_type_tbl IN PO_TBL_VARCHAR30
61: , p_rate_date_tbl IN PO_TBL_DATE
62: , p_rate_tbl IN PO_TBL_NUMBER
63: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
64: , x_result_type OUT NOCOPY VARCHAR2
65: );
66:

Line 68: p_header_id_tbl IN PO_TBL_NUMBER

64: , x_result_type OUT NOCOPY VARCHAR2
65: );
66:
67: PROCEDURE fax_email_address_valid(
68: p_header_id_tbl IN PO_TBL_NUMBER
69: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30
70: , p_fax_tbl IN PO_TBL_VARCHAR30
71: , p_email_address_tbl IN PO_TBL_VARCHAR2000
72: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 77: p_header_id_tbl IN PO_TBL_NUMBER

73: , x_result_type OUT NOCOPY VARCHAR2
74: );
75:
76: PROCEDURE effective_le_expiration(
77: p_header_id_tbl IN PO_TBL_NUMBER
78: , p_start_date_tbl IN PO_TBL_DATE
79: , p_end_date_tbl IN PO_TBL_DATE
80: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
81: , x_result_type OUT NOCOPY VARCHAR2

Line 85: p_header_id_tbl IN PO_TBL_NUMBER

81: , x_result_type OUT NOCOPY VARCHAR2
82: );
83:
84: PROCEDURE effective_from_le_order_date(
85: p_header_id_tbl IN PO_TBL_NUMBER
86: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
87: , p_start_date_tbl IN PO_TBL_DATE
88: , x_result_set_id IN OUT NOCOPY NUMBER
89: , x_result_type OUT NOCOPY VARCHAR2

Line 93: p_header_id_tbl IN PO_TBL_NUMBER

89: , x_result_type OUT NOCOPY VARCHAR2
90: );
91:
92: PROCEDURE effective_to_ge_order_date(
93: p_header_id_tbl IN PO_TBL_NUMBER
94: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
95: , p_end_date_tbl IN PO_TBL_DATE
96: , x_result_set_id IN OUT NOCOPY NUMBER
97: , x_result_type OUT NOCOPY VARCHAR2

Line 101: p_header_id_tbl IN PO_TBL_NUMBER

97: , x_result_type OUT NOCOPY VARCHAR2
98: );
99:
100: PROCEDURE contract_start_le_order_date(
101: p_header_id_tbl IN PO_TBL_NUMBER
102: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
103: , p_start_date_tbl IN PO_TBL_DATE
104: , x_result_set_id IN OUT NOCOPY NUMBER
105: , x_result_type OUT NOCOPY VARCHAR2

Line 109: p_header_id_tbl IN PO_TBL_NUMBER

105: , x_result_type OUT NOCOPY VARCHAR2
106: );
107:
108: PROCEDURE contract_end_ge_order_date(
109: p_header_id_tbl IN PO_TBL_NUMBER
110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
111: , p_end_date_tbl IN PO_TBL_DATE
112: , x_result_set_id IN OUT NOCOPY NUMBER
113: , x_result_type OUT NOCOPY VARCHAR2

Line 117: p_header_id_tbl IN PO_TBL_NUMBER

113: , x_result_type OUT NOCOPY VARCHAR2
114: );
115:
116: PROCEDURE doc_num_chars_valid(
117: p_header_id_tbl IN PO_TBL_NUMBER
118: , p_org_id_tbl IN PO_TBL_NUMBER
119: , p_style_id_tbl IN PO_TBL_NUMBER
120: , p_segment1_tbl IN PO_TBL_VARCHAR30
121: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 118: , p_org_id_tbl IN PO_TBL_NUMBER

114: );
115:
116: PROCEDURE doc_num_chars_valid(
117: p_header_id_tbl IN PO_TBL_NUMBER
118: , p_org_id_tbl IN PO_TBL_NUMBER
119: , p_style_id_tbl IN PO_TBL_NUMBER
120: , p_segment1_tbl IN PO_TBL_VARCHAR30
121: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
122: , x_result_type OUT NOCOPY VARCHAR2

Line 119: , p_style_id_tbl IN PO_TBL_NUMBER

115:
116: PROCEDURE doc_num_chars_valid(
117: p_header_id_tbl IN PO_TBL_NUMBER
118: , p_org_id_tbl IN PO_TBL_NUMBER
119: , p_style_id_tbl IN PO_TBL_NUMBER
120: , p_segment1_tbl IN PO_TBL_VARCHAR30
121: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
122: , x_result_type OUT NOCOPY VARCHAR2
123: );

Line 126: p_header_id_tbl IN PO_TBL_NUMBER

122: , x_result_type OUT NOCOPY VARCHAR2
123: );
124:
125: PROCEDURE doc_num_unique(
126: p_header_id_tbl IN PO_TBL_NUMBER
127: , p_org_id_tbl IN PO_TBL_NUMBER
128: , p_segment1_tbl IN PO_TBL_VARCHAR30
129: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 127: , p_org_id_tbl IN PO_TBL_NUMBER

123: );
124:
125: PROCEDURE doc_num_unique(
126: p_header_id_tbl IN PO_TBL_NUMBER
127: , p_org_id_tbl IN PO_TBL_NUMBER
128: , p_segment1_tbl IN PO_TBL_VARCHAR30
129: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
130: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
131: , x_result_type OUT NOCOPY VARCHAR2

Line 142: p_header_id_tbl IN PO_TBL_NUMBER

138: , x_sequence IN OUT NOCOPY NUMBER
139: );
140:
141: PROCEDURE agent_id_not_null(
142: p_header_id_tbl IN PO_TBL_NUMBER
143: , p_agent_id_tbl IN PO_TBL_NUMBER
144: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
145: , x_result_type OUT NOCOPY VARCHAR2
146: );

Line 143: , p_agent_id_tbl IN PO_TBL_NUMBER

139: );
140:
141: PROCEDURE agent_id_not_null(
142: p_header_id_tbl IN PO_TBL_NUMBER
143: , p_agent_id_tbl IN PO_TBL_NUMBER
144: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
145: , x_result_type OUT NOCOPY VARCHAR2
146: );
147:

Line 149: p_header_id_tbl IN PO_TBL_NUMBER

145: , x_result_type OUT NOCOPY VARCHAR2
146: );
147:
148: PROCEDURE ship_to_loc_not_null(
149: p_header_id_tbl IN PO_TBL_NUMBER
150: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
151: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
152: , x_result_type OUT NOCOPY VARCHAR2
153: );

Line 150: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER

146: );
147:
148: PROCEDURE ship_to_loc_not_null(
149: p_header_id_tbl IN PO_TBL_NUMBER
150: , p_ship_to_loc_id_tbl IN PO_TBL_NUMBER
151: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
152: , x_result_type OUT NOCOPY VARCHAR2
153: );
154:

Line 156: p_header_id_tbl IN PO_TBL_NUMBER

152: , x_result_type OUT NOCOPY VARCHAR2
153: );
154:
155: PROCEDURE vendor_id_not_null(
156: p_header_id_tbl IN PO_TBL_NUMBER
157: , p_vendor_id_tbl IN PO_TBL_NUMBER
158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
159: , x_result_type OUT NOCOPY VARCHAR2
160: );

Line 157: , p_vendor_id_tbl IN PO_TBL_NUMBER

153: );
154:
155: PROCEDURE vendor_id_not_null(
156: p_header_id_tbl IN PO_TBL_NUMBER
157: , p_vendor_id_tbl IN PO_TBL_NUMBER
158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
159: , x_result_type OUT NOCOPY VARCHAR2
160: );
161:

Line 163: p_header_id_tbl IN PO_TBL_NUMBER

159: , x_result_type OUT NOCOPY VARCHAR2
160: );
161:
162: PROCEDURE vendor_site_id_not_null(
163: p_header_id_tbl IN PO_TBL_NUMBER
164: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
166: , x_result_type OUT NOCOPY VARCHAR2
167: );

Line 164: , p_vendor_site_id_tbl IN PO_TBL_NUMBER

160: );
161:
162: PROCEDURE vendor_site_id_not_null(
163: p_header_id_tbl IN PO_TBL_NUMBER
164: , p_vendor_site_id_tbl IN PO_TBL_NUMBER
165: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
166: , x_result_type OUT NOCOPY VARCHAR2
167: );
168:

Line 171: p_header_id_tbl IN PO_TBL_NUMBER

167: );
168:
169: -- EXCEPTION WHEN SAVE PO WO/ NUMBER IF DOCUMENT NUMBERING IS SET TO MANUAL
170: PROCEDURE segment1_not_null(
171: p_header_id_tbl IN PO_TBL_NUMBER
172: , p_segment1_tbl IN PO_TBL_VARCHAR30
173: , p_org_id_tbl IN PO_TBL_NUMBER
174: , x_result_set_id IN OUT NOCOPY NUMBER
175: , x_result_type OUT NOCOPY VARCHAR2

Line 173: , p_org_id_tbl IN PO_TBL_NUMBER

169: -- EXCEPTION WHEN SAVE PO WO/ NUMBER IF DOCUMENT NUMBERING IS SET TO MANUAL
170: PROCEDURE segment1_not_null(
171: p_header_id_tbl IN PO_TBL_NUMBER
172: , p_segment1_tbl IN PO_TBL_VARCHAR30
173: , p_org_id_tbl IN PO_TBL_NUMBER
174: , x_result_set_id IN OUT NOCOPY NUMBER
175: , x_result_type OUT NOCOPY VARCHAR2
176: );
177: --

Line 179: PROCEDURE ship_via_lookup_code_valid(p_header_id_tbl IN po_tbl_number,

175: , x_result_type OUT NOCOPY VARCHAR2
176: );
177: --
178: -- Error when the ship_via field has an invalid value.
179: PROCEDURE ship_via_lookup_code_valid(p_header_id_tbl IN po_tbl_number,
180: p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,
181: --Bug 12409257 start. Bug 13771850-Revert 12409257 changes
182: p_org_id_tbl IN PO_TBL_NUMBER ,
183: -- p_ship_to_location_id_tbl IN PO_TBL_NUMBER ,

Line 182: p_org_id_tbl IN PO_TBL_NUMBER ,

178: -- Error when the ship_via field has an invalid value.
179: PROCEDURE ship_via_lookup_code_valid(p_header_id_tbl IN po_tbl_number,
180: p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,
181: --Bug 12409257 start. Bug 13771850-Revert 12409257 changes
182: p_org_id_tbl IN PO_TBL_NUMBER ,
183: -- p_ship_to_location_id_tbl IN PO_TBL_NUMBER ,
184: --Bug 12409257 end. Bug 13771850 end
185: x_result_set_id IN OUT NOCOPY NUMBER,
186: x_result_type OUT NOCOPY VARCHAR2);

Line 183: -- p_ship_to_location_id_tbl IN PO_TBL_NUMBER ,

179: PROCEDURE ship_via_lookup_code_valid(p_header_id_tbl IN po_tbl_number,
180: p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,
181: --Bug 12409257 start. Bug 13771850-Revert 12409257 changes
182: p_org_id_tbl IN PO_TBL_NUMBER ,
183: -- p_ship_to_location_id_tbl IN PO_TBL_NUMBER ,
184: --Bug 12409257 end. Bug 13771850 end
185: x_result_set_id IN OUT NOCOPY NUMBER,
186: x_result_type OUT NOCOPY VARCHAR2);
187:

Line 192: p_header_id_tbl IN PO_TBL_NUMBER

188: --
189:
190: --Mod Project
191: PROCEDURE mod_eff_dt_lt_need_by_dt(
192: p_header_id_tbl IN PO_TBL_NUMBER
193: ,p_mod_eff_date_tbl IN PO_TBL_DATE
194: ,x_result_set_id IN OUT NOCOPY NUMBER
195: ,x_result_type OUT NOCOPY VARCHAR2
196: );

Line 199: p_header_id_tbl IN PO_TBL_NUMBER

195: ,x_result_type OUT NOCOPY VARCHAR2
196: );
197:
198: PROCEDURE mod_eff_dt_not_null(
199: p_header_id_tbl IN PO_TBL_NUMBER
200: ,p_draft_type_tbl IN PO_TBL_VARCHAR30
201: ,p_mod_eff_date_tbl IN PO_TBL_DATE
202: ,x_result_set_id IN OUT NOCOPY NUMBER
203: ,x_result_type OUT NOCOPY VARCHAR2

Line 207: p_header_id_tbl IN PO_TBL_NUMBER

203: ,x_result_type OUT NOCOPY VARCHAR2
204: );
205:
206: PROCEDURE mod_no_cancel_shp_complt(
207: p_header_id_tbl IN PO_TBL_NUMBER
208: ,p_control_action_tbl IN PO_TBL_VARCHAR30
209: ,x_result_set_id IN OUT NOCOPY NUMBER
210: ,x_result_type OUT NOCOPY VARCHAR2
211: );

Line 214: p_header_id_tbl IN PO_TBL_NUMBER

210: ,x_result_type OUT NOCOPY VARCHAR2
211: );
212:
213: PROCEDURE print_form_format_valid(
214: p_header_id_tbl IN PO_TBL_NUMBER
215: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
216: , p_style_id_tbl IN PO_TBL_NUMBER
217: ,p_draft_type_tbl IN PO_TBL_VARCHAR30
218: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000

Line 216: , p_style_id_tbl IN PO_TBL_NUMBER

212:
213: PROCEDURE print_form_format_valid(
214: p_header_id_tbl IN PO_TBL_NUMBER
215: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
216: , p_style_id_tbl IN PO_TBL_NUMBER
217: ,p_draft_type_tbl IN PO_TBL_VARCHAR30
218: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
219: , p_document_format_tbl IN PO_TBL_VARCHAR2000
220: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER

Line 220: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER

216: , p_style_id_tbl IN PO_TBL_NUMBER
217: ,p_draft_type_tbl IN PO_TBL_VARCHAR30
218: , p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000
219: , p_document_format_tbl IN PO_TBL_VARCHAR2000
220: , p_clm_src_doc_id_tbl IN PO_TBL_NUMBER
221: , p_clm_ext_idv_tbl IN PO_TBL_VARCHAR2000
222: , p_clm_award_type_tbl IN PO_TBL_VARCHAR30 -- bug 10389450
223: , x_result_set_id IN OUT NOCOPY NUMBER
224: , x_result_type OUT NOCOPY VARCHAR2

Line 228: p_header_id_tbl IN PO_TBL_NUMBER

224: , x_result_type OUT NOCOPY VARCHAR2
225: );
226:
227: PROCEDURE clm_eff_from_le_order_date(
228: p_header_id_tbl IN PO_TBL_NUMBER
229: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
230: , p_start_date_tbl IN PO_TBL_DATE
231: , p_clm_effective_date_tbl IN PO_TBL_DATE
232: , x_result_set_id IN OUT NOCOPY NUMBER

Line 237: p_header_id_tbl IN PO_TBL_NUMBER

233: , x_result_type OUT NOCOPY VARCHAR2
234: );
235:
236: PROCEDURE max_ceil_awd_amt_gt_min(
237: p_header_id_tbl IN PO_TBL_NUMBER
238: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
239: , p_amount_limit_tbl IN PO_TBL_NUMBER
240: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
241: , x_result_set_id IN OUT NOCOPY NUMBER

Line 239: , p_amount_limit_tbl IN PO_TBL_NUMBER

235:
236: PROCEDURE max_ceil_awd_amt_gt_min(
237: p_header_id_tbl IN PO_TBL_NUMBER
238: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
239: , p_amount_limit_tbl IN PO_TBL_NUMBER
240: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
241: , x_result_set_id IN OUT NOCOPY NUMBER
242: , x_result_type OUT NOCOPY VARCHAR2
243: );

Line 240: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER

236: PROCEDURE max_ceil_awd_amt_gt_min(
237: p_header_id_tbl IN PO_TBL_NUMBER
238: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
239: , p_amount_limit_tbl IN PO_TBL_NUMBER
240: , p_min_grnt_awd_amt_tbl IN PO_TBL_NUMBER
241: , x_result_set_id IN OUT NOCOPY NUMBER
242: , x_result_type OUT NOCOPY VARCHAR2
243: );
244:

Line 246: p_header_id_tbl IN PO_TBL_NUMBER

242: , x_result_type OUT NOCOPY VARCHAR2
243: );
244:
245: PROCEDURE max_ord_amt_gt_min(
246: p_header_id_tbl IN PO_TBL_NUMBER
247: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
248: , p_min_order_amt_tbl IN PO_TBL_NUMBER
249: , p_max_order_amt_tbl IN PO_TBL_NUMBER
250: , x_result_set_id IN OUT NOCOPY NUMBER

Line 248: , p_min_order_amt_tbl IN PO_TBL_NUMBER

244:
245: PROCEDURE max_ord_amt_gt_min(
246: p_header_id_tbl IN PO_TBL_NUMBER
247: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
248: , p_min_order_amt_tbl IN PO_TBL_NUMBER
249: , p_max_order_amt_tbl IN PO_TBL_NUMBER
250: , x_result_set_id IN OUT NOCOPY NUMBER
251: , x_result_type OUT NOCOPY VARCHAR2
252: );

Line 249: , p_max_order_amt_tbl IN PO_TBL_NUMBER

245: PROCEDURE max_ord_amt_gt_min(
246: p_header_id_tbl IN PO_TBL_NUMBER
247: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
248: , p_min_order_amt_tbl IN PO_TBL_NUMBER
249: , p_max_order_amt_tbl IN PO_TBL_NUMBER
250: , x_result_set_id IN OUT NOCOPY NUMBER
251: , x_result_type OUT NOCOPY VARCHAR2
252: );
253:

Line 255: p_header_id_tbl IN PO_TBL_NUMBER

251: , x_result_type OUT NOCOPY VARCHAR2
252: );
253:
254: PROCEDURE min_guar_perc_range_check(
255: p_header_id_tbl IN PO_TBL_NUMBER
256: , p_min_guar_perc_tbl IN PO_TBL_NUMBER
257: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
258: , x_result_type OUT NOCOPY VARCHAR2
259: );

Line 256: , p_min_guar_perc_tbl IN PO_TBL_NUMBER

252: );
253:
254: PROCEDURE min_guar_perc_range_check(
255: p_header_id_tbl IN PO_TBL_NUMBER
256: , p_min_guar_perc_tbl IN PO_TBL_NUMBER
257: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
258: , x_result_type OUT NOCOPY VARCHAR2
259: );
260:

Line 262: p_header_id_tbl IN PO_TBL_NUMBER

258: , x_result_type OUT NOCOPY VARCHAR2
259: );
260:
261: PROCEDURE max_ceil_amt_gt_min_ord (
262: p_header_id_tbl IN PO_TBL_NUMBER
263: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
264: , p_amount_limit_tbl IN PO_TBL_NUMBER
265: , p_min_order_amt_tbl IN PO_TBL_NUMBER
266: , x_result_set_id IN OUT NOCOPY NUMBER

Line 264: , p_amount_limit_tbl IN PO_TBL_NUMBER

260:
261: PROCEDURE max_ceil_amt_gt_min_ord (
262: p_header_id_tbl IN PO_TBL_NUMBER
263: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
264: , p_amount_limit_tbl IN PO_TBL_NUMBER
265: , p_min_order_amt_tbl IN PO_TBL_NUMBER
266: , x_result_set_id IN OUT NOCOPY NUMBER
267: , x_result_type OUT NOCOPY VARCHAR2
268: );

Line 265: , p_min_order_amt_tbl IN PO_TBL_NUMBER

261: PROCEDURE max_ceil_amt_gt_min_ord (
262: p_header_id_tbl IN PO_TBL_NUMBER
263: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
264: , p_amount_limit_tbl IN PO_TBL_NUMBER
265: , p_min_order_amt_tbl IN PO_TBL_NUMBER
266: , x_result_set_id IN OUT NOCOPY NUMBER
267: , x_result_type OUT NOCOPY VARCHAR2
268: );
269:

Line 272: p_header_id_tbl IN PO_TBL_NUMBER

268: );
269:
270:
271: PROCEDURE max_ceil_amt_gt_max_ord (
272: p_header_id_tbl IN PO_TBL_NUMBER
273: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
274: , p_amount_limit_tbl IN PO_TBL_NUMBER
275: , p_max_order_amt_tbl IN PO_TBL_NUMBER
276: , x_result_set_id IN OUT NOCOPY NUMBER

Line 274: , p_amount_limit_tbl IN PO_TBL_NUMBER

270:
271: PROCEDURE max_ceil_amt_gt_max_ord (
272: p_header_id_tbl IN PO_TBL_NUMBER
273: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
274: , p_amount_limit_tbl IN PO_TBL_NUMBER
275: , p_max_order_amt_tbl IN PO_TBL_NUMBER
276: , x_result_set_id IN OUT NOCOPY NUMBER
277: , x_result_type OUT NOCOPY VARCHAR2
278: );

Line 275: , p_max_order_amt_tbl IN PO_TBL_NUMBER

271: PROCEDURE max_ceil_amt_gt_max_ord (
272: p_header_id_tbl IN PO_TBL_NUMBER
273: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30
274: , p_amount_limit_tbl IN PO_TBL_NUMBER
275: , p_max_order_amt_tbl IN PO_TBL_NUMBER
276: , x_result_set_id IN OUT NOCOPY NUMBER
277: , x_result_type OUT NOCOPY VARCHAR2
278: );
279:

Line 283: p_intf_header_id IN PO_TBL_NUMBER,

279:
280: --CLM PDOI Integration starts
281: PROCEDURE validate_clm_standard_form (
282:
283: p_intf_header_id IN PO_TBL_NUMBER,
284: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
285: p_style_id_tbl IN PO_TBL_NUMBER,
286: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
287: x_result_type OUT NOCOPY VARCHAR2

Line 285: p_style_id_tbl IN PO_TBL_NUMBER,

281: PROCEDURE validate_clm_standard_form (
282:
283: p_intf_header_id IN PO_TBL_NUMBER,
284: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
285: p_style_id_tbl IN PO_TBL_NUMBER,
286: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
287: x_result_type OUT NOCOPY VARCHAR2
288: );
289:

Line 291: p_intf_header_id IN PO_TBL_NUMBER,

287: x_result_type OUT NOCOPY VARCHAR2
288: );
289:
290: PROCEDURE validate_clm_document_format(
291: p_intf_header_id IN PO_TBL_NUMBER,
292: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
293: p_clm_document_format_tbl IN PO_TBL_VARCHAR2000,
294: p_style_id_tbl IN PO_TBL_NUMBER,
295: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 294: p_style_id_tbl IN PO_TBL_NUMBER,

290: PROCEDURE validate_clm_document_format(
291: p_intf_header_id IN PO_TBL_NUMBER,
292: p_clm_standard_form_tbl IN PO_TBL_VARCHAR2000,
293: p_clm_document_format_tbl IN PO_TBL_VARCHAR2000,
294: p_style_id_tbl IN PO_TBL_NUMBER,
295: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
296: x_result_type OUT NOCOPY VARCHAR2
297: );
298:

Line 301: p_intf_header_id in PO_TBL_NUMBER,

297: );
298:
299: PROCEDURE validate_source_idv
300: (
301: p_intf_header_id in PO_TBL_NUMBER,
302: p_src_doc_id_tbl IN PO_TBL_NUMBER,
303: p_currency_code_tbl in PO_TBL_VARCHAR30,
304: p_org_id_tbl in PO_TBL_NUMBER,
305: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,

Line 302: p_src_doc_id_tbl IN PO_TBL_NUMBER,

298:
299: PROCEDURE validate_source_idv
300: (
301: p_intf_header_id in PO_TBL_NUMBER,
302: p_src_doc_id_tbl IN PO_TBL_NUMBER,
303: p_currency_code_tbl in PO_TBL_VARCHAR30,
304: p_org_id_tbl in PO_TBL_NUMBER,
305: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
306: x_result_type OUT NOCOPY VARCHAR2

Line 304: p_org_id_tbl in PO_TBL_NUMBER,

300: (
301: p_intf_header_id in PO_TBL_NUMBER,
302: p_src_doc_id_tbl IN PO_TBL_NUMBER,
303: p_currency_code_tbl in PO_TBL_VARCHAR30,
304: p_org_id_tbl in PO_TBL_NUMBER,
305: x_results in OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
306: x_result_type OUT NOCOPY VARCHAR2
307: );
308:

Line 311: p_intf_header_id IN PO_TBL_NUMBER,

307: );
308:
309: PROCEDURE validate_award_admin
310: (
311: p_intf_header_id IN PO_TBL_NUMBER,
312: p_award_admin_tbl IN PO_TBL_VARCHAR2000,
313: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
314: x_result_type OUT NOCOPY VARCHAR2
315: );

Line 319: p_intf_header_id IN PO_TBL_NUMBER,

315: );
316:
317: PROCEDURE validate_contract_officer
318: (
319: p_intf_header_id IN PO_TBL_NUMBER,
320: p_contract_officer_tbl IN PO_TBL_NUMBER,
321: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
322: x_result_type OUT NOCOPY VARCHAR2
323: );

Line 320: p_contract_officer_tbl IN PO_TBL_NUMBER,

316:
317: PROCEDURE validate_contract_officer
318: (
319: p_intf_header_id IN PO_TBL_NUMBER,
320: p_contract_officer_tbl IN PO_TBL_NUMBER,
321: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
322: x_result_type OUT NOCOPY VARCHAR2
323: );
324:

Line 327: p_intf_header_id IN PO_TBL_NUMBER,

323: );
324:
325: PROCEDURE validate_umbrella_program_id
326: (
327: p_intf_header_id IN PO_TBL_NUMBER,
328: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
329: p_src_doc_id_tbl IN PO_TBL_NUMBER,
330: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
331: x_result_type OUT NOCOPY VARCHAR2

Line 328: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,

324:
325: PROCEDURE validate_umbrella_program_id
326: (
327: p_intf_header_id IN PO_TBL_NUMBER,
328: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
329: p_src_doc_id_tbl IN PO_TBL_NUMBER,
330: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
331: x_result_type OUT NOCOPY VARCHAR2
332: );

Line 329: p_src_doc_id_tbl IN PO_TBL_NUMBER,

325: PROCEDURE validate_umbrella_program_id
326: (
327: p_intf_header_id IN PO_TBL_NUMBER,
328: p_umbrella_program_id_tbl IN PO_TBL_NUMBER,
329: p_src_doc_id_tbl IN PO_TBL_NUMBER,
330: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
331: x_result_type OUT NOCOPY VARCHAR2
332: );
333:

Line 336: p_intf_header_id IN PO_TBL_NUMBER,

332: );
333:
334: PROCEDURE validate_clm_award_type
335: (
336: p_intf_header_id IN PO_TBL_NUMBER,
337: p_clm_award_type_tbl IN PO_TBL_VARCHAR30,
338: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,
339: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
340: x_result_type OUT NOCOPY VARCHAR2

Line 345: p_intf_header_id IN PO_TBL_NUMBER,

341: );
342:
343: PROCEDURE validate_style_id
344: (
345: p_intf_header_id IN PO_TBL_NUMBER,
346: p_style_id_tbl IN PO_TBL_NUMBER,
347: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
348: x_result_type OUT NOCOPY VARCHAR2
349: );

Line 346: p_style_id_tbl IN PO_TBL_NUMBER,

342:
343: PROCEDURE validate_style_id
344: (
345: p_intf_header_id IN PO_TBL_NUMBER,
346: p_style_id_tbl IN PO_TBL_NUMBER,
347: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
348: x_result_type OUT NOCOPY VARCHAR2
349: );
350:

Line 353: p_intf_header_id IN PO_TBL_NUMBER,

349: );
350:
351: PROCEDURE validate_idv_style_id
352: (
353: p_intf_header_id IN PO_TBL_NUMBER,
354: p_style_id_tbl IN PO_TBL_NUMBER,
355: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
356: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
357: x_result_type OUT NOCOPY VARCHAR2

Line 354: p_style_id_tbl IN PO_TBL_NUMBER,

350:
351: PROCEDURE validate_idv_style_id
352: (
353: p_intf_header_id IN PO_TBL_NUMBER,
354: p_style_id_tbl IN PO_TBL_NUMBER,
355: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
356: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
357: x_result_type OUT NOCOPY VARCHAR2
358: );

Line 355: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

351: PROCEDURE validate_idv_style_id
352: (
353: p_intf_header_id IN PO_TBL_NUMBER,
354: p_style_id_tbl IN PO_TBL_NUMBER,
355: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
356: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
357: x_result_type OUT NOCOPY VARCHAR2
358: );
359:

Line 362: p_intf_header_id IN PO_TBL_NUMBER,

358: );
359:
360: PROCEDURE validate_po_idv_vendor_site_id
361: (
362: p_intf_header_id IN PO_TBL_NUMBER,
363: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
364: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
365: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
366: x_result_type OUT NOCOPY VARCHAR2

Line 363: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

359:
360: PROCEDURE validate_po_idv_vendor_site_id
361: (
362: p_intf_header_id IN PO_TBL_NUMBER,
363: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
364: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
365: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
366: x_result_type OUT NOCOPY VARCHAR2
367: );

Line 364: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

360: PROCEDURE validate_po_idv_vendor_site_id
361: (
362: p_intf_header_id IN PO_TBL_NUMBER,
363: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
364: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
365: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
366: x_result_type OUT NOCOPY VARCHAR2
367: );
368:

Line 371: p_intf_header_id IN PO_TBL_NUMBER,

367: );
368:
369: PROCEDURE validate_po_idv_vendor_id
370: (
371: p_intf_header_id IN PO_TBL_NUMBER,
372: p_vendor_id_tbl IN PO_TBL_NUMBER,
373: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
374: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
375: x_result_type OUT NOCOPY VARCHAR2

Line 372: p_vendor_id_tbl IN PO_TBL_NUMBER,

368:
369: PROCEDURE validate_po_idv_vendor_id
370: (
371: p_intf_header_id IN PO_TBL_NUMBER,
372: p_vendor_id_tbl IN PO_TBL_NUMBER,
373: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
374: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
375: x_result_type OUT NOCOPY VARCHAR2
376: );

Line 373: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,

369: PROCEDURE validate_po_idv_vendor_id
370: (
371: p_intf_header_id IN PO_TBL_NUMBER,
372: p_vendor_id_tbl IN PO_TBL_NUMBER,
373: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
374: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
375: x_result_type OUT NOCOPY VARCHAR2
376: );
377: --CLM PDOI Integration ends

Line 381: p_header_id_tbl IN PO_TBL_NUMBER,

377: --CLM PDOI Integration ends
378:
379: --
380: PROCEDURE validate_mod_number(
381: p_header_id_tbl IN PO_TBL_NUMBER,
382: p_draft_type_tbl IN PO_TBL_VARCHAR30,
383: p_mod_number_tbl IN PO_TBL_VARCHAR100,
384: x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE,
385: x_result_type OUT NOCOPY VARCHAR2