DBA Data[Home] [Help]

APPS.WMS_PARAMETER_PVT dependencies on WMS_PARAMETERS_VL

Line 559: l_flex_name wms_parameters_vl.NAME%TYPE;

555: )
556: RETURN VARCHAR2 IS
557: l_if_flex_then_available VARCHAR2(1);
558: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
559: l_flex_name wms_parameters_vl.NAME%TYPE;
560: l_flex_description wms_parameters_vl.description%TYPE;
561: BEGIN
562: get_flex_info(
563: p_db_object_ref_type_code => p_db_object_ref_type_code

Line 560: l_flex_description wms_parameters_vl.description%TYPE;

556: RETURN VARCHAR2 IS
557: l_if_flex_then_available VARCHAR2(1);
558: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
559: l_flex_name wms_parameters_vl.NAME%TYPE;
560: l_flex_description wms_parameters_vl.description%TYPE;
561: BEGIN
562: get_flex_info(
563: p_db_object_ref_type_code => p_db_object_ref_type_code
564: , p_parameter_type_code => p_parameter_type_code

Line 615: l_flex_name wms_parameters_vl.NAME%TYPE;

611: )
612: RETURN NUMBER IS
613: l_if_flex_then_available VARCHAR2(1);
614: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
615: l_flex_name wms_parameters_vl.NAME%TYPE;
616: l_flex_description wms_parameters_vl.description%TYPE;
617: l_appl_short_name VARCHAR2(3);
618: BEGIN
619: get_flex_info(

Line 616: l_flex_description wms_parameters_vl.description%TYPE;

612: RETURN NUMBER IS
613: l_if_flex_then_available VARCHAR2(1);
614: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
615: l_flex_name wms_parameters_vl.NAME%TYPE;
616: l_flex_description wms_parameters_vl.description%TYPE;
617: l_appl_short_name VARCHAR2(3);
618: BEGIN
619: get_flex_info(
620: p_db_object_ref_type_code => p_db_object_ref_type_code

Line 677: l_flex_name wms_parameters_vl.NAME%TYPE;

673: )
674: RETURN VARCHAR2 IS
675: l_if_flex_then_available VARCHAR2(1);
676: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
677: l_flex_name wms_parameters_vl.NAME%TYPE;
678: l_flex_description wms_parameters_vl.description%TYPE;
679: l_appl_short_name VARCHAR2(3);
680: BEGIN
681: get_flex_info(

Line 678: l_flex_description wms_parameters_vl.description%TYPE;

674: RETURN VARCHAR2 IS
675: l_if_flex_then_available VARCHAR2(1);
676: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
677: l_flex_name wms_parameters_vl.NAME%TYPE;
678: l_flex_description wms_parameters_vl.description%TYPE;
679: l_appl_short_name VARCHAR2(3);
680: BEGIN
681: get_flex_info(
682: p_db_object_ref_type_code => p_db_object_ref_type_code

Line 734: l_flex_name wms_parameters_vl.NAME%TYPE;

730: )
731: RETURN VARCHAR2 IS
732: l_if_flex_then_available VARCHAR2(1);
733: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
734: l_flex_name wms_parameters_vl.NAME%TYPE;
735: l_flex_description wms_parameters_vl.description%TYPE;
736: l_appl_short_name VARCHAR2(3);
737: BEGIN
738: get_flex_info(

Line 735: l_flex_description wms_parameters_vl.description%TYPE;

731: RETURN VARCHAR2 IS
732: l_if_flex_then_available VARCHAR2(1);
733: l_flex_data_type_code wms_parameters_b.data_type_code%TYPE;
734: l_flex_name wms_parameters_vl.NAME%TYPE;
735: l_flex_description wms_parameters_vl.description%TYPE;
736: l_appl_short_name VARCHAR2(3);
737: BEGIN
738: get_flex_info(
739: p_db_object_ref_type_code => p_db_object_ref_type_code