APPS.GMDQSPEC_APPROVAL_WF_PKG SQL Statements

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

Line: 12

      SELECT USER_NAME
      FROM FND_USER
      WHERE USER_ID = userId;

Line: 55

      SELECT SPEC.SPEC_NAME
            ,SPEC.SPEC_VERS
            ,SPEC.SPEC_DESC
            ,SPEC.GRADE
            ,SPEC.SPEC_STATUS
            ,SPEC.OWNER_ORGN_CODE
            ,SPEC.OWNER_ID
            ,SPEC.LAST_UPDATED_BY
            ,ITEM.ITEM_NO
            ,ITEM.ITEM_DESC1
            ,ORGN.ORGN_NAME
            ,QCSTAT.MEANING
            ,SPEC.SPEC_TYPE
            ,SPEC.OVERLAY_IND
            ,SPEC.BASE_SPEC_ID
      FROM GMD_SPECIFICATIONS SPEC
          ,IC_ITEM_MST ITEM
          ,SY_ORGN_MST ORGN
          ,GMD_QC_STATUS QCSTAT
      WHERE SPEC.ITEM_ID     = ITEM.ITEM_ID (+)
        AND ORGN.ORGN_CODE   = SPEC.OWNER_ORGN_CODE
        AND SPEC.SPEC_STATUS = QCSTAT.STATUS_CODE
        AND SPEC.SPEC_ID     = lSpecId;*/

Line: 84

/*      SELECT SPEC.SPEC_NAME
              ,SPEC.SPEC_VERS
              ,SPEC.SPEC_DESC
              ,SPEC.GRADE_CODE
              ,SPEC.SPEC_STATUS
              ,SPEC.OWNER_ORGANIZATION_ID
              ,SPEC.OWNER_ID
              ,SPEC.LAST_UPDATED_BY
              ,ITEM.CONCATENATED_SEGMENTS
              ,SPEC.REVISION
              ,ITEM.DESCRIPTION
              --,HAOU.NAME
	      ,MO.ORGANIZATION_NAME
	      ,MO.ORGANIZATION_CODE
              ,QCSTAT.MEANING
              ,SPEC.SPEC_TYPE
              ,SPEC.OVERLAY_IND
              ,SPEC.BASE_SPEC_ID
        FROM GMD_SPECIFICATIONS SPEC
            ,mtl_system_items_kfv ITEM
            ,mtl_parameters ORGN
            ,GMD_QC_STATUS QCSTAT
	    ,MTL_ORGANIZATIONS MO
        WHERE SPEC.INVENTORY_ITEM_ID     = ITEM.INVENTORY_ITEM_ID (+)
          AND ORGN.ORGANIZATION_ID       = SPEC.OWNER_ORGANIZATION_ID
           AND SPEC.OWNER_ORGANIZATION_ID = nvl(ITEM.ORGANIZATION_ID ,SPEC.OWNER_ORGANIZATION_ID)
          AND SPEC.SPEC_STATUS           = QCSTAT.STATUS_CODE
          AND SPEC.SPEC_ID               = lSpecId
	  AND ORGN.ORGANIZATION_ID       = MO.ORGANIZATION_ID; */

Line: 115

    SELECT SPEC.SPEC_NAME
              ,SPEC.SPEC_VERS
              ,SPEC.SPEC_DESC
              ,SPEC.GRADE_CODE
              ,SPEC.SPEC_STATUS
              ,SPEC.OWNER_ORGANIZATION_ID
              ,SPEC.OWNER_ID
              ,SPEC.LAST_UPDATED_BY
              ,ITEM.CONCATENATED_SEGMENTS
              ,SPEC.REVISION
              ,ITEM.DESCRIPTION
              --,HAOU.NAME
	      			,HR.NAME ORGANIZATION_NAME -- sql id
	      			,ORGN.ORGANIZATION_CODE   -- sql id
              ,QCSTAT.MEANING
              ,SPEC.SPEC_TYPE
              ,SPEC.OVERLAY_IND
              ,SPEC.BASE_SPEC_ID
        FROM
            GMD_SPECIFICATIONS SPEC
            ,mtl_system_items_kfv ITEM
            ,mtl_parameters ORGN
            ,GMD_QC_STATUS QCSTAT
	    --,MTL_ORGANIZATIONS MO
	    		  ,HR_ALL_ORGANIZATION_UNITS_TL HR -- sql id
        WHERE SPEC.INVENTORY_ITEM_ID     = ITEM.INVENTORY_ITEM_ID (+)
          AND ORGN.ORGANIZATION_ID       = SPEC.OWNER_ORGANIZATION_ID
          and ORGN.ORGANIZATION_ID = HR.ORGANIZATION_ID -- sql id
          and hr.language = userenv('LANG') -- sql id
           AND SPEC.OWNER_ORGANIZATION_ID = nvl(ITEM.ORGANIZATION_ID ,SPEC.OWNER_ORGANIZATION_ID)
          AND SPEC.SPEC_STATUS           = QCSTAT.STATUS_CODE
          AND SPEC.SPEC_ID               = lSpecId ;

Line: 153

     select nvl( text, '')
        from wf_Resources where name = 'WF_ADMIN_ROLE'
        and language = userenv('LANG')   ;

Line: 162

   SELECT SPEC_NAME,SPEC_VERS
   FROM GMD_SPECIFICATIONS_B
   WHERE SPEC_ID = p_spec_id;

Line: 272

          l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);

Line: 300

            SELECT DESCRIPTION INTO l_spectype_desc
            FROM GEM_LOOKUPS
            WHERE LOOKUP_TYPE = 'GMD_QC_SPEC_TYPE'
            AND LOOKUP_CODE = disp_attr_rec.SPEC_TYPE ;

Line: 626

            ame_api.updateApprovalStatus(applicationIdIn   => applicationId,
                                         transactionIdIn   => lSpecId,
                                         transactionTypeIn => transactionType,
                                         ApproverIn   => nextApprover);

Line: 692

            ame_api.updateApprovalStatus(applicationIdIn   => applicationId,
                                         transactionIdIn   => lSpecId,
                                         transactionTypeIn => transactionType,
                                         ApproverIn        => nextApprover);

Line: 709

      SELECT MEANING
      FROM GMD_QC_STATUS
      WHERE STATUS_CODE = P_STATUS_CODE
        AND ENTITY_TYPE = P_ENTITY_TYPE;

Line: 738

    l_parameter_list.DELETE;