APPS.WF_SOA_CTX_PKG dependencies on FND_RESPONSIBILITY

Line 181: FROM fnd_responsibility

177: IF ( InStr(pResp,'{key}')=1) THEN
178: --get from key
179: SELECT RESPONSIBILITY_ID
180: INTO pRespID
181: FROM fnd_responsibility
182: WHERE APPLICATION_ID =pRespAppID
183: AND RESPONSIBILITY_KEY=SUBSTR(pResp,6);
184:
185: ELSE

Line 189: FROM FND_RESPONSIBILITY_TL T,

185: ELSE
186: --get from name
187: SELECT B.RESPONSIBILITY_ID
188: INTO pRespID
189: FROM FND_RESPONSIBILITY_TL T,
190: FND_RESPONSIBILITY B
191: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
192: AND B.APPLICATION_ID = T.APPLICATION_ID
193: AND T.LANGUAGE = pLangCode

Line 190: FND_RESPONSIBILITY B

186: --get from name
187: SELECT B.RESPONSIBILITY_ID
188: INTO pRespID
189: FROM FND_RESPONSIBILITY_TL T,
190: FND_RESPONSIBILITY B
191: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
192: AND B.APPLICATION_ID = T.APPLICATION_ID
193: AND T.LANGUAGE = pLangCode
194: AND b.application_id = pRespAppID

Line 206: FROM fnd_responsibility

202: IF ( InStr(pResp,'{key}')=1) THEN
203: --get from key
204: SELECT count(*)
205: INTO nTemp
206: FROM fnd_responsibility
207: WHERE RESPONSIBILITY_KEY=SUBSTR(pResp,6);
208: If nTemp =0 Then
209: Raise No_data_Found;
210: elsif nTemp=1 Then

Line 213: FROM fnd_responsibility

209: Raise No_data_Found;
210: elsif nTemp=1 Then
211: SELECT RESPONSIBILITY_ID,APPLICATION_ID
212: INTO pRespID, pRespAppID
213: FROM fnd_responsibility
214: WHERE RESPONSIBILITY_KEY=SUBSTR(pResp,6);
215: else
216: pStage:=3;
217: Raise No_data_found;

Line 225: FROM FND_RESPONSIBILITY_TL T,

221:
222: --SELECT B.RESPONSIBILITY_ID
223: SELECT COUNT(*)
224: INTO nTemp
225: FROM FND_RESPONSIBILITY_TL T,
226: FND_RESPONSIBILITY B
227: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
228: AND B.APPLICATION_ID = T.APPLICATION_ID
229: AND T.LANGUAGE = pLangCode

Line 226: FND_RESPONSIBILITY B

222: --SELECT B.RESPONSIBILITY_ID
223: SELECT COUNT(*)
224: INTO nTemp
225: FROM FND_RESPONSIBILITY_TL T,
226: FND_RESPONSIBILITY B
227: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
228: AND B.APPLICATION_ID = T.APPLICATION_ID
229: AND T.LANGUAGE = pLangCode
230: AND T.RESPONSIBILITY_NAME= pResp;

Line 237: FROM FND_RESPONSIBILITY_TL T,

233: Raise No_data_Found;
234: elsif nTemp=1 Then
235: SELECT B.RESPONSIBILITY_ID, B.APPLICATION_ID
236: INTO pRespID, pRespAppID
237: FROM FND_RESPONSIBILITY_TL T,
238: FND_RESPONSIBILITY B
239: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
240: AND B.APPLICATION_ID = T.APPLICATION_ID
241: AND T.LANGUAGE = pLangCode

Line 238: FND_RESPONSIBILITY B

234: elsif nTemp=1 Then
235: SELECT B.RESPONSIBILITY_ID, B.APPLICATION_ID
236: INTO pRespID, pRespAppID
237: FROM FND_RESPONSIBILITY_TL T,
238: FND_RESPONSIBILITY B
239: WHERE B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
240: AND B.APPLICATION_ID = T.APPLICATION_ID
241: AND T.LANGUAGE = pLangCode
242: AND T.RESPONSIBILITY_NAME= pResp;

Line 322: pRespId fnd_responsibility.responsibility_id%TYPE;

318: IS
319: pLangCode fnd_languages.language_code%TYPE;
320: pUserId fnd_user.user_id%TYPE;
321: pAppId fnd_application.application_id%TYPE;
322: pRespId fnd_responsibility.responsibility_id%TYPE;
323: pSecGrpId fnd_security_groups.security_group_id%TYPE;
324: x_status_code VARCHAR2(1);
325: x_error_code varchar2(50);
326: BEGIN