APPS.WF_SOA_CTX_PKG SQL Statements

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

Line: 14

         	SELECT language_code
        	INTO   WF_SOA_CTX_PKG.pAppsBaseLang
        	FROM   fnd_languages
        	WHERE  Installed_flag = 'B';

Line: 30

                            SELECT language_code
                            INTO   lang_code
                            FROM   fnd_languages
                            WHERE  nls_language = pTemp
                            and Installed_flag in ('B','I');

Line: 82

                                SELECT 'X'
                                INTO   pTemp
                                FROM   hr_operating_units
                                WHERE  usable_flag IS NULL
                                   AND ORGANIZATION_ID =pOrgID;

Line: 132

        SELECT user_id
        INTO   pUserID
        FROM   fnd_user
        WHERE  user_name = upper(pUserName);

Line: 145

                        SELECT language_code
                        INTO   pLangCode
                        FROM   fnd_languages
                        WHERE  language_code = upper(pLang)
                        and Installed_flag in ('B','I');

Line: 152

                        SELECT language_code
                        INTO   pLangCode
                        FROM   fnd_languages
                        WHERE  nls_language = upper(pLang)
                        and Installed_flag in ('B','I');

Line: 166

		 SELECT B.APPLICATION_ID
		 INTO   pRespAppID
		 FROM   FND_APPLICATION B
                WHERE  B.APPLICATION_SHORT_NAME=Upper(pRespApp);

Line: 179

				SELECT RESPONSIBILITY_ID
				INTO   pRespID
				FROM   fnd_responsibility
				WHERE  APPLICATION_ID    =pRespAppID
				   AND RESPONSIBILITY_KEY=SUBSTR(pResp,6);

Line: 187

				SELECT B.RESPONSIBILITY_ID
				INTO   pRespID
				FROM   FND_RESPONSIBILITY_TL T,
				       FND_RESPONSIBILITY B
				WHERE  B.RESPONSIBILITY_ID  = T.RESPONSIBILITY_ID
				   AND B.APPLICATION_ID     = T.APPLICATION_ID
				   AND T.LANGUAGE           = pLangCode
				   AND b.application_id     = pRespAppID
				   AND T.RESPONSIBILITY_NAME= pResp;

Line: 204

				SELECT count(*)
				INTO   nTemp
				FROM   fnd_responsibility
				WHERE  RESPONSIBILITY_KEY=SUBSTR(pResp,6);

Line: 211

					SELECT RESPONSIBILITY_ID,APPLICATION_ID
					INTO   pRespID, pRespAppID
					FROM   fnd_responsibility
					WHERE  RESPONSIBILITY_KEY=SUBSTR(pResp,6);

Line: 222

				--SELECT B.RESPONSIBILITY_ID
				SELECT COUNT(*)
				INTO   nTemp
				FROM   FND_RESPONSIBILITY_TL T,
				       FND_RESPONSIBILITY B
				WHERE  B.RESPONSIBILITY_ID  = T.RESPONSIBILITY_ID
				   AND B.APPLICATION_ID     = T.APPLICATION_ID
				   AND T.LANGUAGE           = pLangCode
				   AND T.RESPONSIBILITY_NAME= pResp;

Line: 235

					SELECT B.RESPONSIBILITY_ID, B.APPLICATION_ID
					INTO   pRespID, pRespAppID
					FROM   FND_RESPONSIBILITY_TL T,
					       FND_RESPONSIBILITY B
					WHERE  B.RESPONSIBILITY_ID  = T.RESPONSIBILITY_ID
					   AND B.APPLICATION_ID     = T.APPLICATION_ID
					   AND T.LANGUAGE           = pLangCode
					   AND T.RESPONSIBILITY_NAME= pResp;

Line: 259

        SELECT SECURITY_GROUP_ID
        INTO   pSecurityGroupID
        FROM   FND_SECURITY_GROUPS
        WHERE  upper(SECURITY_GROUP_KEY) = upper(nvl(pSecurityGroup,'STANDARD'));

Line: 270

		       SELECT 1
			INTO   nTemp
			FROM   FND_USER_RESP_GROUPS
			WHERE  user_id=pUserID
			   AND RESPONSIBILITY_ID=pRespID
			   and SECURITY_GROUP_ID=pSecurityGroupID
			   AND rownum <2;

Line: 278

			SELECT 1
			INTO   nTemp
			FROM   FND_USER_RESP_GROUPS
			WHERE  user_id=pUserID
			AND RESPONSIBILITY_ID=pRespID
			AND rownum <2;