DBA Data[Home] [Help]

APPS.PO_VAL_LINES dependencies on PO_TBL_VARCHAR1

Line 336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

332: PROCEDURE quantity_gt_zero(
333: p_line_id_tbl IN PO_TBL_NUMBER
334: , p_quantity_tbl IN PO_TBL_NUMBER
335: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
336: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
337: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
338: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
339: , x_result_type OUT NOCOPY VARCHAR2
340: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

793: PROCEDURE amount_gt_zero(
794: p_line_id_tbl IN PO_TBL_NUMBER
795: , p_amount_tbl IN PO_TBL_NUMBER
796: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
797: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
798: , p_cost_constraint_tbl IN PO_TBL_VARCHAR30 -- CLM changes
799: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
800: , x_result_type OUT NOCOPY VARCHAR2
801: , p_header_id_tbl IN PO_TBL_NUMBER --

Line 2027: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

2023: PROCEDURE unit_price_ge_zero(
2024: p_line_id_tbl IN PO_TBL_NUMBER
2025: , p_unit_price_tbl IN PO_TBL_NUMBER
2026: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2027: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2028: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2029: , x_result_type OUT NOCOPY VARCHAR2
2030: )
2031: IS

Line 2156: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1

2152: PROCEDURE validate_unit_price_change(
2153: p_line_id_tbl IN PO_TBL_NUMBER
2154: , p_unit_price_tbl IN PO_TBL_NUMBER
2155: , p_price_break_lookup_code_tbl IN PO_TBL_VARCHAR30
2156: , p_amt_changed_flag_tbl IN PO_TBL_VARCHAR1
2157: , x_result_set_id IN OUT NOCOPY NUMBER
2158: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2159: , x_result_type OUT NOCOPY VARCHAR2
2160: )

Line 2167: l_amount_changed_flag_tbl PO_TBL_VARCHAR1; -- --

2163:
2164: l_data_key NUMBER;
2165: l_line_id_tbl PO_TBL_NUMBER;
2166: l_price_break_lookup_code_tbl PO_TBL_VARCHAR30;
2167: l_amount_changed_flag_tbl PO_TBL_VARCHAR1; -- --
2168:
2169: BEGIN
2170:
2171: IF PO_LOG.d_proc THEN

Line 2589: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

2585: PROCEDURE unit_meas_not_null(
2586: p_line_id_tbl IN PO_TBL_NUMBER
2587: , p_unit_meas_lookup_code_tbl IN PO_TBL_VARCHAR30
2588: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2589: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2590: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2591: , x_result_type OUT NOCOPY VARCHAR2
2592: )
2593: IS

Line 2681: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

2677: -------------------------------------------------------------------------------
2678: PROCEDURE category_id_not_null(
2679: p_line_id_tbl IN PO_TBL_NUMBER
2680: , p_category_id_tbl IN PO_TBL_NUMBER
2681: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2682: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2683: , x_result_type OUT NOCOPY VARCHAR2
2684: )
2685: IS

Line 2737: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

2733: p_id_tbl IN PO_TBL_NUMBER
2734: , p_item_id_tbl IN PO_TBL_NUMBER
2735: , p_order_type_lookup_code_tbl IN PO_TBL_VARCHAR30
2736: , p_line_type_id_tbl IN PO_TBL_NUMBER
2737: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2738: , p_message_name IN VARCHAR2
2739: , x_result_set_id IN OUT NOCOPY NUMBER
2740: , x_result_type OUT NOCOPY VARCHAR2
2741: )

Line 2979: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes

2975: -------------------------------------------------------------------------------
2976: PROCEDURE line_type_id_not_null(
2977: p_line_id_tbl IN PO_TBL_NUMBER
2978: , p_line_type_id_tbl IN PO_TBL_NUMBER
2979: , p_clm_info_flag_tbl IN PO_TBL_VARCHAR1 -- CLM changes
2980: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
2981: , x_result_type OUT NOCOPY VARCHAR2
2982: )
2983: IS

Line 3419: , p_option_ind_tbl IN PO_TBL_VARCHAR1

3415: --Bug 5453079 END
3416:
3417: PROCEDURE option_from_date_not_null (
3418: p_line_id_tbl IN PO_TBL_NUMBER
3419: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3420: , p_option_from_date_tbl IN PO_TBL_DATE
3421: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3422: , x_result_type OUT NOCOPY VARCHAR2
3423: )

Line 3474: , p_option_ind_tbl IN PO_TBL_VARCHAR1

3470: END option_from_date_not_null;
3471:
3472: PROCEDURE option_to_date_not_null (
3473: p_line_id_tbl IN PO_TBL_NUMBER
3474: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3475: ,p_option_to_Date_tbl IN PO_TBL_DATE
3476: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3477: , x_result_type OUT NOCOPY VARCHAR2
3478: )

Line 3529: , p_option_ind_tbl IN PO_TBL_VARCHAR1

3525: END option_to_date_not_null;
3526:
3527: PROCEDURE option_to_date_le_from_date (
3528: p_line_id_tbl IN PO_TBL_NUMBER
3529: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3530: ,p_option_from_date_tbl IN PO_TBL_DATE
3531: ,p_option_to_Date_tbl IN PO_TBL_DATE
3532: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3533: , x_result_type OUT NOCOPY VARCHAR2

Line 3590: , p_option_ind_tbl IN PO_TBL_VARCHAR1

3586: END option_to_date_le_from_date;
3587:
3588: PROCEDURE option_from_date_le_sysdate (
3589: p_line_id_tbl IN PO_TBL_NUMBER
3590: , p_option_ind_tbl IN PO_TBL_VARCHAR1
3591: ,p_option_from_date_tbl IN PO_TBL_DATE
3592: , p_draft_id_tbl IN PO_TBL_NUMBER
3593: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3594: , x_result_type OUT NOCOPY VARCHAR2

Line 3674: , p_exer_flag_tbl IN PO_TBL_VARCHAR1

3670: END option_from_date_le_sysdate;
3671:
3672: PROCEDURE option_fm_date_le_ex_date (
3673: p_line_id_tbl IN PO_TBL_NUMBER
3674: , p_exer_flag_tbl IN PO_TBL_VARCHAR1
3675: , p_option_from_date_tbl IN PO_TBL_DATE
3676: , p_option_exer_date_tbl IN PO_TBL_DATE
3677: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3678: , x_result_type OUT NOCOPY VARCHAR2

Line 3735: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100

3731: END option_fm_date_le_ex_date;
3732:
3733: PROCEDURE line_num_disp_check (
3734: p_line_id_tbl IN PO_TBL_NUMBER
3735: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
3736: , p_group_line_id_tbl IN PO_TBL_NUMBER
3737: , p_clm_exhibit_name_tbl IN PO_TBL_VARCHAR20
3738: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
3739: , x_result_type OUT NOCOPY VARCHAR2

Line 3939: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

3935: p_header_id_tbl IN PO_TBL_NUMBER,
3936: p_draft_id_tbl IN PO_TBL_NUMBER,
3937: p_line_id_tbl IN PO_TBL_NUMBER,
3938: p_group_line_id_tbl IN PO_TBL_NUMBER,
3939: p_line_num_display_tbl IN PO_TBL_VARCHAR100,
3940: p_par_draft_id_tbl IN PO_TBL_VARCHAR4000 DEFAULT NULL, --
3941: x_result_set_id IN OUT NOCOPY NUMBER,
3942: x_result_type OUT NOCOPY VARCHAR2
3943: )

Line 4461: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1

4457:
4458:
4459: PROCEDURE validate_option_indicator(
4460: p_intf_line_id_tbl IN PO_TBL_NUMBER
4461: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4462: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4463: , x_result_type OUT NOCOPY VARCHAR2
4464: ) IS
4465:

Line 4526: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1

4522:
4523:
4524: PROCEDURE validate_clm_base_line_num(
4525: p_intf_line_id_tbl IN PO_TBL_NUMBER
4526: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4527: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4528: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4529: , x_result_type OUT NOCOPY VARCHAR2
4530: ) IS

Line 4629: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1

4625:
4626:
4627: PROCEDURE validate_clm_option_num(
4628: p_intf_line_id_tbl IN PO_TBL_NUMBER
4629: , p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1
4630: , p_clm_base_line_num_tbl IN PO_TBL_NUMBER
4631: , p_clm_option_num_tbl IN PO_TBL_NUMBER
4632: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4633: , x_result_type OUT NOCOPY VARCHAR2

Line 4798: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100

4794:
4795:
4796: PROCEDURE validate_clin_line_num_disp(
4797: p_intf_line_id_tbl IN PO_TBL_NUMBER
4798: , p_line_num_disp_tbl IN PO_TBL_VARCHAR100
4799: , p_group_line_id_tbl IN PO_TBL_NUMBER
4800: , p_intf_header_id_tbl IN PO_TBL_NUMBER
4801: , x_results IN OUT NOCOPY PO_VALIDATION_RESULTS_TYPE
4802: , x_result_type OUT NOCOPY VARCHAR2