APPS.CZ_TYPES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

 p_max_selected IN NUMBER) RETURN VARCHAR2 IS

  l_req_nodes_counter NUMBER;

Line: 13

  IF p_max_selected=1 THEN
    RETURN '1'; -- it's mutex

Line: 15

  ELSIF p_max_selected=-1 THEN
    RETURN '0'; -- it's not mutex

Line: 20

  SELECT COUNT(ps_node_id) INTO l_ps_counter FROM CZ_PS_NODES
  WHERE parent_id=p_ps_node_id AND deleted_flag='0' AND rownum<3;

Line: 35

  SELECT COUNT(ps_node_id) INTO l_req_nodes_counter FROM CZ_PS_NODES
  WHERE parent_id=p_ps_node_id AND deleted_flag='0' AND
        bom_required_flag='1';

Line: 39

  IF ( l_req_nodes_counter+1 = p_max_selected ) THEN
    RETURN '1'; -- it's mutex

Line: 50

  l_max_selected    NUMBER;

Line: 54

  SELECT maximum_selected INTO l_max_selected FROM CZ_PS_NODES
  WHERE ps_node_id=p_ps_node_id AND deleted_flag='0';

Line: 57

  RETURN is_Mutex(p_ps_node_id, l_max_selected);

Line: 63

 p_max_selected IN NUMBER,
 x_mutex_flag   OUT NOCOPY VARCHAR2) IS

BEGIN

  x_mutex_flag := is_Mutex(p_ps_node_id,p_max_selected);

Line: 76

  l_max_selected    NUMBER;

Line: 80

  SELECT maximum_selected INTO l_max_selected FROM CZ_PS_NODES
  WHERE ps_node_id=p_ps_node_id AND deleted_flag='0';

Line: 83

  x_mutex_flag := is_Mutex(p_ps_node_id, l_max_selected);

Line: 91

    SELECT '1' INTO l_flag FROM CZ_PS_NODES  a
    WHERE a.parent_id=p_ps_node_id AND a.deleted_flag='0' AND
          (
          (a.ps_node_type IN(PS_NODE_TYPE_BOM_MODEL,PS_NODE_TYPE_BOM_OPTION_CLASS))
          OR
          (a.ps_node_type=PS_NODE_TYPE_REFERENCE AND a.instantiable_flag=MANDATORY_EXPL_TYPE AND
           EXISTS(SELECT NULL FROM CZ_PS_NODES b
                   WHERE b.devl_project_id=a.reference_id AND
                         b.deleted_flag='0' AND b.ps_node_type=PS_NODE_TYPE_BOM_MODEL))
          )
          AND rownum<2 ;

Line: 112

    FOR l IN(SELECT ps_node_id,reference_id,ps_node_type,maximum,maximum_selected FROM CZ_PS_NODES
             WHERE  parent_id=p_ps_node_id AND deleted_flag='0')
    LOOP
       IF (l.maximum<>1 AND
           l.ps_node_type IN(PS_NODE_TYPE_BOM_MODEL,PS_NODE_TYPE_BOM_OPTION_CLASS,
                              PS_NODE_TYPE_BOM_STANDART_ITEM)) THEN
         RETURN TRUE;

Line: 120

       ELSIF (l.ps_node_type IN(PS_NODE_TYPE_REFERENCE) AND l.maximum_selected<>1) THEN
         BEGIN
           SELECT '1' INTO l_flag FROM dual
           WHERE EXISTS(SELECT NULL FROM CZ_PS_NODES
                        WHERE ps_node_id=l.reference_id AND
                              deleted_flag='0' AND ps_node_type=PS_NODE_TYPE_BOM_MODEL);

Line: 135

         FOR k IN(SELECT ps_node_id FROM CZ_PS_NODES
                  WHERE parent_id=l.reference_id AND deleted_flag='0' AND
                        ps_node_type IN(PS_NODE_TYPE_BOM_MODEL,PS_NODE_TYPE_BOM_OPTION_CLASS,
                                        PS_NODE_TYPE_BOM_STANDART_ITEM) AND
                        maximum<>1 AND rownum<2)
         LOOP
           RETURN TRUE;

Line: 165

 p_max_selected           IN NUMBER)
RETURN NUMBER IS

    v_model_type   CZ_DEVL_PROJECTS.model_type%TYPE;

Line: 228

       SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
       WHERE devl_project_id=p_reference_id AND deleted_flag='0';

Line: 231

       SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES
       WHERE ps_node_id=p_reference_id AND deleted_flag='0';

Line: 242

       SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
       WHERE devl_project_id=p_reference_id AND deleted_flag='0';

Line: 245

       SELECT ps_node_type INTO v_ps_node_type FROM CZ_PS_NODES
       WHERE ps_node_id=p_reference_id AND deleted_flag='0';

Line: 268

          is_Mutex(p_ps_node_id,p_max_selected)='1' THEN

       IF child_Nodes_Have_Quantities(p_ps_node_id) THEN
         IF contains_Nested_BOM(p_ps_node_id) THEN
            RETURN UBOM_NSTBOM_QMTX_TYPEID;

Line: 285

          is_Mutex(p_ps_node_id,p_max_selected)='0' THEN

      IF child_Nodes_Have_Quantities(p_ps_node_id) THEN
       IF contains_Nested_BOM(p_ps_node_id) THEN
          RETURN UBOM_NSTBOM_QNMTX_TYPEID;

Line: 326

    SELECT persistent_node_id INTO l_persistent_node_id FROM CZ_PS_NODES
    WHERE ps_node_id=p_ps_node_id;

Line: 340

 p_max_selected           IN NUMBER,
 p_decimal_qty_flag       IN VARCHAR2,
 p_ib_trackable           IN VARCHAR2,
 p_devl_project_id        IN NUMBER)
RETURN NUMBER IS

    v_model_type          CZ_DEVL_PROJECTS.model_type%TYPE;

Line: 351

    SELECT NVL(config_engine_type,'L') INTO v_config_engine_type FROM CZ_DEVL_PROJECTS
    WHERE devl_project_id=p_devl_project_id AND deleted_flag='0';

Line: 428

       SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
       WHERE devl_project_id=p_reference_id AND deleted_flag='0';

Line: 440

       SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
       WHERE devl_project_id=p_reference_id AND deleted_flag='0';

Line: 453

       SELECT model_type INTO v_model_type FROM CZ_DEVL_PROJECTS
       WHERE devl_project_id=p_reference_id AND deleted_flag='0';

Line: 466

    ELSIF p_ps_node_type=PS_NODE_TYPE_BOM_MODEL AND  NVL(p_max_selected,-1)=1 THEN
       IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_MODEL_MTX_TYPEID;

Line: 470

    ELSIF p_ps_node_type=PS_NODE_TYPE_BOM_MODEL AND  NVL(p_max_selected,-1)<>1 THEN
       IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_MODEL_NMTX_TYPEID;

Line: 474

    ELSIF p_ps_node_type=PS_NODE_TYPE_BOM_OPTION_CLASS AND NVL(p_max_selected,-1)=1 THEN
       IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_OC_MTX_TYPEID;

Line: 478

    ELSIF p_ps_node_type=PS_NODE_TYPE_BOM_OPTION_CLASS AND NVL(p_max_selected,-1)<>1 THEN
       IF(p_ib_trackable = '1')THEN RETURN TRACKABLE_OC_NMTX_TYPEID;

Line: 588

    SELECT 1
    INTO retval
    FROM dual
    WHERE EXISTS (
          SELECT *
          FROM CZ_NODE_NO_PROPERTIES_V lov
          WHERE lov.ps_node_id = p_ps_node_id
            AND lov.data_type = p_exp_data_type
            AND lov.mutable_flag >= Nvl(p_exp_mutable_flag,0)
            AND lov.collection_flag <= Nvl(p_exp_collection_flag,0)
         );

Line: 610

    SELECT 1
    INTO retval
    FROM dual
    WHERE EXISTS (
          SELECT *
          FROM CZ_NODE_USER_PROPERTIES_V lov
          WHERE lov.ps_node_id = p_ps_node_id
            AND lov.data_type = p_exp_data_type
            AND lov.mutable_flag >= Nvl(p_exp_mutable_flag,0)
            AND lov.collection_flag <= Nvl(p_exp_collection_flag,0)
         );

Line: 633

    SELECT 1
    INTO retval
    FROM dual
    WHERE EXISTS (
          SELECT *
          FROM CZ_NODE_CAPTION_PROPERTIES_V lov
          WHERE lov.ps_node_id = p_ps_node_id
            AND lov.data_type = p_exp_data_type
            AND lov.mutable_flag >= Nvl(p_exp_mutable_flag,0)
            AND lov.collection_flag <= Nvl(p_exp_collection_flag,0)
            AND lov.property_type <> -1
         );

Line: 653

    SELECT signature_type
    INTO sig_type
    FROM cz_data_types_v
    WHERE signature_id = p_data_type;