APPS.AMS_WFMOD_PVT SQL Statements

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

Line: 126

                          , p_select_list       IN VARCHAR2
                          , p_enqueue_message   IN VARCHAR2
                          , p_itemtype          IN VARCHAR2
                          , p_itemkey           IN VARCHAR2
                         ) IS
   l_return_status   VARCHAR2(1);

Line: 218

      , aname       =>   'SELECT_LIST'
      , avalue      =>   p_select_list
   );

Line: 295

                       , p_select_list       IN    VARCHAR2 DEFAULT NULL
                       , p_enqueue_message   IN    VARCHAR2 DEFAULT NULL
                       , processowner        IN    VARCHAR2 DEFAULT NULL
                       , workflowprocess     IN    VARCHAR2 DEFAULT NULL
                       , itemtype            IN    VARCHAR2 DEFAULT G_DEFAULT_ITEMTYPE
                       , x_itemkey           OUT NOCOPY   VARCHAR2
                      )  IS
   L_API_NAME     CONSTANT VARCHAR2(30) := 'STARTPROCESS';

Line: 306

      SELECT owner_user_id
      FROM ams_dm_models_vl model
      WHERE model_id = p_obj_id
      ;

Line: 312

      SELECT score.owner_user_id
      FROM ams_dm_scores_vl score
      WHERE score_id = p_obj_id
      ;

Line: 403

                     , p_select_list      => p_select_list
                     , p_enqueue_message  => p_enqueue_message
                     , p_itemtype         => l_itemtype
                     , p_itemkey          => itemkey
                    );

Line: 475

PROCEDURE selector (  itemtype    IN      VARCHAR2
                    , itemkey     IN      VARCHAR2
                    , actid       IN      NUMBER
                    , funcmode    IN      VARCHAR2
                    , resultout   OUT NOCOPY     VARCHAR2
                    )  IS
   L_API_NAME     CONSTANT VARCHAR2(30) := 'SELECTOR';

Line: 538

      wf_core.context (G_PKG_NAME, 'Selector', itemtype, itemkey, actid, funcmode);

Line: 541

END Selector;

Line: 585

      SELECT model.model_type
         , target.data_source_id
         , target_positive_value
         , model_name
         , status_code
         , owner_user_id
	 , target.active_flag
      FROM ams_dm_models_vl model, ams_dm_targets_b target
      WHERE model_id = p_obj_id
      AND   target.target_id = model.target_id
      ;

Line: 598

      SELECT model.model_type
         , target.data_source_id
         , model.target_positive_value
         , score.score_name
         , score.status_code
         , score.owner_user_id
	 , target.active_flag
      FROM ams_dm_models_all_b model, ams_dm_scores_vl score, ams_dm_targets_b target
      WHERE score_id = p_obj_id
      AND   score.model_id = model.model_id
      AND   target.target_id = model.target_id
      ;

Line: 881

      AMS_DMSelection_PVT.Aggregate_Selections (
           p_arc_object      =>  l_object_type
         , p_object_id       =>  l_object_id
         , x_return_status   =>  l_return_status
      );

Line: 1018

      SELECT target_id
      FROM   ams_dm_models_v
      WHERE  model_id = p_model_id
      ;

Line: 1024

      SELECT model.target_id
      FROM   ams_dm_models_v model , ams_dm_scores_v score
      WHERE  score.score_id = p_score_id
      AND    score.model_id = model.model_id
      ;

Line: 1257

   l_select_list     VARCHAR2(2000);

Line: 1275

      SELECT model_id
      FROM   ams_dm_scores_all_b
      WHERE  score_id = p_score_id;

Line: 1318

      l_select_list := WF_ENGINE.GetItemAttrText(
                                   itemtype     => itemtype
                                 , itemkey      => itemkey
                                 , aname        => 'SELECT_LIST'
                                 );

Line: 1947

PROCEDURE Update_Obj_Status(  itemtype  IN   VARCHAR2
                            , itemkey   IN   VARCHAR2
                            , actid     IN   NUMBER
                            , funcmode  IN   VARCHAR2
                            , result    OUT NOCOPY   VARCHAR2
                           ) IS
   L_API_NAME     CONSTANT VARCHAR2(30) := 'UPDATE_OBJ_STATUS';

Line: 2112

      wf_core.context(G_PKG_NAME,'Update_Obj_Status',itemtype,itemkey,to_char(actid),funcmode);

Line: 2122

END Update_Obj_Status ;

Line: 2132

    SELECT employee_id source_id
      FROM ams_jtf_rs_emp_v
     WHERE resource_id = p_user_id ;

Line: 2173

      UPDATE ams_dm_models_all_b
      SET logs_flag = 'Y',
          last_update_date = SYSDATE,
          last_updated_by = FND_GLOBAL.user_id,
          last_update_login = FND_GLOBAL.conc_login_id
      WHERE model_id = p_object_id
      AND   logs_flag = 'N';

Line: 2181

      UPDATE ams_dm_scores_all_b
      SET logs_flag = 'Y',
          last_update_date = SYSDATE,
          last_updated_by = FND_GLOBAL.user_id,
          last_update_login = FND_GLOBAL.conc_login_id
      WHERE score_id = p_object_id
      AND   logs_flag = 'N';

Line: 2320

      p_select_list     => NULL,
      x_itemkey         => x_new_itemkey
   );

Line: 2373

      SELECT wf_itemkey
      FROM   ams_dm_models_all_b
      WHERE  status_code = G_STATUS_BUILDING
         OR  status_code = G_STATUS_SCORING
         OR  status_code = G_STATUS_PREVIEWING
        AND  wf_itemkey <> p_itemkey;

Line: 2383

      SELECT wf_itemkey
      FROM   ams_dm_scores_all_b
      WHERE  status_code = G_STATUS_SCORING
         OR  status_code = G_STATUS_PREVIEWING
        AND  wf_itemkey <> p_itemkey;

Line: 2907

      SELECT target_id
      FROM   ams_dm_models_all_b
      WHERE  model_id = p_model_id
      ;

Line: 2913

      SELECT m.target_id
      FROM   ams_dm_models_all_b m , ams_dm_scores_all_b s
      WHERE  m.model_id = s.model_id
      AND    s.score_id = p_score_id
      ;