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_VARCHAR30

Line 59: , p_currency_code_tbl IN PO_TBL_VARCHAR30

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
63: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE

Line 60: , p_rate_type_tbl IN PO_TBL_VARCHAR30

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
63: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
64: , x_result_type OUT NOCOPY VARCHAR2

Line 69: , p_supplier_notif_method_tbl IN PO_TBL_VARCHAR30

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

Line 70: , p_fax_tbl IN PO_TBL_VARCHAR30

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

Line 86: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 94: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 102: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 110: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 120: , p_segment1_tbl IN PO_TBL_VARCHAR30

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

Line 128: , p_segment1_tbl IN PO_TBL_VARCHAR30

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

Line 129: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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
132: );
133:

Line 172: , p_segment1_tbl IN PO_TBL_VARCHAR30

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

Line 180: p_ship_via_lookup_code_tbl IN PO_TBL_VARCHAR30,

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 ,
184: --Bug 12409257 end. Bug 13771850 end

Line 200: ,p_draft_type_tbl IN PO_TBL_VARCHAR30

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

Line 208: ,p_control_action_tbl IN PO_TBL_VARCHAR30

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

Line 215: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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
219: , p_document_format_tbl IN PO_TBL_VARCHAR2000

Line 217: ,p_draft_type_tbl IN PO_TBL_VARCHAR30

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
221: , p_clm_ext_idv_tbl IN PO_TBL_VARCHAR2000

Line 222: , p_clm_award_type_tbl IN PO_TBL_VARCHAR30 -- bug 10389450

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
225: );
226:

Line 229: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 238: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 247: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 263: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 273: , p_type_lookup_code_tbl IN PO_TBL_VARCHAR30

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

Line 303: p_currency_code_tbl in PO_TBL_VARCHAR30,

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

Line 337: p_clm_award_type_tbl IN PO_TBL_VARCHAR30,

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

Line 338: p_type_lookup_code_tbl IN PO_TBL_VARCHAR30,

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
341: );
342:

Line 382: p_draft_type_tbl IN PO_TBL_VARCHAR30,

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