DBA Data[Home] [Help]

APPS.PO_VAL_LINES dependencies on PO_TBL_VARCHAR1

Line 22: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

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
25: , x_result_type OUT NOCOPY VARCHAR2
26: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 97: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

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
100: , x_result_type OUT NOCOPY VARCHAR2
101: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 180: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

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
183: );
184:

Line 203: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1 ----

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

Line 273: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

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
275: , x_result_type OUT NOCOPY VARCHAR2
276: );
277:

Line 288: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

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

Line 298: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

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

Line 315: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

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

Line 368: , p_option_ind_tbl IN PO_TBL_VARCHAR1

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

Line 376: , p_option_ind_tbl IN PO_TBL_VARCHAR1

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

Line 384: , p_option_ind_tbl IN PO_TBL_VARCHAR1

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

Line 393: , p_option_ind_tbl IN PO_TBL_VARCHAR1

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

Line 402: , p_exer_flag_tbl IN PO_TBL_VARCHAR1

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

Line 412: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100

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

Line 524: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

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

Line 566: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1

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

Line 573: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1

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

Line 581: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1

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

Line 597: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100

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