APPS.GMDFMLAP_WF_PKG SQL Statements

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

Line: 9

      p_requester         IN   FM_FORM_MST_B.LAST_UPDATED_BY%TYPE,
      p_last_update_date  IN   FM_FORM_MST_B.LAST_UPDATE_DATE%TYPE
                )
   IS
      /* procedure to initialize and run Workflow */

      l_itemtype                WF_ITEMS.ITEM_TYPE%TYPE :=  'GMDFMLAP';

Line: 16

      l_itemkey                 WF_ITEMS.ITEM_KEY%TYPE  :=  to_char(p_formula_id)||'-'||to_char(p_last_update_date,'dd-MON-yyyy   HH24:mi:ss');

Line: 83

      SELECT USER_NAME , DESCRIPTION
      INTO   l_performer_name ,l_performer_display_name
      FROM   FND_USER
      WHERE  USER_ID = p_Requester;

Line: 93

      SELECT FORMULA_DESC1, OWNER_ID, FORMULA_CLASS, DECODE(SCALE_TYPE, 1, 'Yes', 0, 'No')
      INTO   l_formula_desc, l_owner_id, l_formula_class, l_scale_type
      FROM FM_FORM_MST
      WHERE FORMULA_ID  = p_formula_id;

Line: 98

      SELECT USER_NAME , DESCRIPTION
      INTO   l_performer_name ,l_performer_display_name
      FROM   FND_USER
      WHERE  USER_ID = l_owner_id;

Line: 198

        UPDATE FM_FORM_MST_B
        SET FORMULA_STATUS  = l_target_status
        WHERE FORMULA_ID    = l_formula_id;

Line: 262

      SELECT 1
      FROM   sys.dual
      WHERE  EXISTS (SELECT 1
                     FROM   gmd_recipes_b
                     WHERE  formula_id = V_formula_id);

Line: 269

     	SELECT owner_organization_id
     	FROM   fm_form_mst_b
     	WHERE  formula_id = V_formula_id;

Line: 276

        SELECT creation_type
        FROM   gmd_recipe_generation
        WHERE  organization_id = V_orgn_id
        AND    creation_type IN (1,2)
        UNION
        SELECT creation_type
        FROM   gmd_recipe_generation
        WHERE  organization_id IS NULL
        AND    creation_type IN (1,2)
        AND    NOT EXISTS (SELECT 1
                           FROM   gmd_recipe_generation
                           WHERE  organization_id = V_orgn_id);

Line: 294

          UPDATE FM_FORM_MST_B
          SET FORMULA_STATUS  = l_target_status
          WHERE FORMULA_ID    = l_formula_id;

Line: 338

          SELECT rework_status into l_rework_status
          FROM GMD_STATUS_NEXT
          WHERE current_status = l_start_status
            AND target_status  = l_target_status
            AND pending_status IS NOT NULL;

Line: 343

          UPDATE FM_FORM_MST_B
          SET FORMULA_STATUS  = l_rework_status
          WHERE FORMULA_ID    = l_formula_id;

Line: 360

          UPDATE FM_FORM_MST_B
          SET FORMULA_STATUS  = l_start_status
          WHERE FORMULA_ID    = l_formula_id;