[Home] [Help]
213: l_user_id FND_USER.USER_ID%TYPE;
214:
215: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
216:
217: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
218:
219: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
220:
221: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
283:
284: else
285: begin
286:
287: l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';
288: /* l_sql := ' select responsibility_id, application_id //bug 6414726
289: from fnd_responsibility_tl where language = :l_language
290: and responsibility_name like :p_responsibility'; */
291:
285: begin
286:
287: l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';
288: /* l_sql := ' select responsibility_id, application_id //bug 6414726
289: from fnd_responsibility_tl where language = :l_language
290: and responsibility_name like :p_responsibility'; */
291:
292: EXECUTE IMMEDIATE l_sql
293: INTO l_responsibility_id, l_application_id
454:
455:
456: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
457:
458: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
459:
460: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
461:
462: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
517: x_resp_id := p_responsibility;
518: else
519: begin
520: l_sql := ' select responsibility_id, application_id
521: from fnd_responsibility_tl where language = :l_language
522: and responsibility_name like :p_responsibility';
523:
524: EXECUTE IMMEDIATE l_sql
525: INTO l_responsibility_id, l_application_id
688: l_user_id FND_USER.USER_ID%TYPE;
689:
690: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
691:
692: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
693:
694: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
695:
696: l_work_q_enable_profile_option IEU_UWQ_SEL_ENUMERATORS.WORK_Q_ENABLE_PROFILE_OPTION%TYPE;
950: l_user_id FND_USER.USER_ID%TYPE;
951:
952: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
953:
954: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
955:
956: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
957:
958: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
1188: l_user_id FND_USER.USER_ID%TYPE;
1189:
1190: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
1191:
1192: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
1193:
1194: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
1195:
1196: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
1378: l_user_id FND_USER.USER_ID%TYPE;
1379:
1380: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
1381:
1382: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
1383:
1384: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
1385:
1386: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
1620: l_user_id FND_USER.USER_ID%TYPE;
1621:
1622: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
1623:
1624: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
1625:
1626: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
1627:
1628: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
2226: l_user_id FND_USER.USER_ID%TYPE;
2227:
2228: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
2229:
2230: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
2231:
2232: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
2233:
2234: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
2442: l_user_id FND_USER.USER_ID%TYPE;
2443:
2444: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
2445:
2446: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
2447:
2448: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
2449:
2450: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
2646: where upper(user_name) like upper(:p_user_name)';
2647: EXECUTE IMMEDIATE l_sql
2648: INTO l_user_id
2649: USING in p_user_name;
2650: l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';
2651: /* l_sql := ' select responsibility_id, application_id //bug6414726
2652: from fnd_responsibility_tl where language = :l_language
2653: and responsibility_name like :p_responsibility'; */
2654:
2648: INTO l_user_id
2649: USING in p_user_name;
2650: l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';
2651: /* l_sql := ' select responsibility_id, application_id //bug6414726
2652: from fnd_responsibility_tl where language = :l_language
2653: and responsibility_name like :p_responsibility'; */
2654:
2655: EXECUTE IMMEDIATE l_sql
2656: INTO l_responsibility_id, l_application_id
3467: l_user_id FND_USER.USER_ID%TYPE;
3468:
3469: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
3470:
3471: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;
3472:
3473: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;
3474:
3475: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;