eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEU_DIAGNOSTICS_PVT dependencies on FND_RESPONSIBILITY

Line 215: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

211: l_user_name FND_USER.USER_NAME%TYPE;
212:
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;

Line 217: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;

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;

Line 219: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
222:
223: l_language VARCHAR2(4);

Line 221: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
222:
223: l_language VARCHAR2(4);
224:
225: l_valid boolean;

Line 287: l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';

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:

Line 289: from fnd_responsibility_tl where language = :l_language

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

Line 302: l_sql := ' select responsibility_id, application_id from fnd_responsibility where responsibility_id = :p_responsibility';

298:
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: begin
302: l_sql := ' select responsibility_id, application_id from fnd_responsibility where responsibility_id = :p_responsibility';
303: /* l_sql := ' select responsibility_id, application_id //bug6414726
304: from fnd_responsibility where responsibility_key like :p_responsibility'; */
305: EXECUTE IMMEDIATE l_sql
306: INTO l_responsibility_id, l_application_id

Line 304: from fnd_responsibility where responsibility_key like :p_responsibility'; */

300: WHEN NO_DATA_FOUND THEN
301: begin
302: l_sql := ' select responsibility_id, application_id from fnd_responsibility where responsibility_id = :p_responsibility';
303: /* l_sql := ' select responsibility_id, application_id //bug6414726
304: from fnd_responsibility where responsibility_key like :p_responsibility'; */
305: EXECUTE IMMEDIATE l_sql
306: INTO l_responsibility_id, l_application_id
307: USING p_responsibility;
308:

Line 322: from fnd_responsibility where responsibility_id = :p_responsibility';

318:
319: -- l_responsibility_id := p_responsibility;
320:
321: l_sql := ' select application_id
322: from fnd_responsibility where responsibility_id = :p_responsibility';
323:
324: EXECUTE IMMEDIATE l_sql
325: INTO l_application_id
326: USING p_responsibility;

Line 456: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

452: AS
453: l_object_code jtf_objects_vl.object_code%TYPE;
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;

Line 458: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;

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;

Line 460: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
463: x_appl_id number;
464: x_user_id number;

Line 462: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
463: x_appl_id number;
464: x_user_id number;
465: l_language VARCHAR2(4);
466: l_count number;

Line 521: from fnd_responsibility_tl where language = :l_language

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

Line 536: from fnd_responsibility where responsibility_key like :p_responsibility';

532: WHEN NO_DATA_FOUND THEN
533: begin
534:
535: l_sql := ' select responsibility_id, application_id
536: from fnd_responsibility where responsibility_key like :p_responsibility';
537: EXECUTE IMMEDIATE l_sql
538: INTO l_responsibility_id, l_application_id
539: USING p_responsibility;
540:

Line 551: from fnd_responsibility where responsibility_id = :p_responsibility';

547: begin
548:
549: -- l_responsibility_id := p_responsibility;
550: l_sql := ' select application_id
551: from fnd_responsibility where responsibility_id = :p_responsibility';
552:
553: EXECUTE IMMEDIATE l_sql
554: INTO l_application_id
555: USING p_responsibility;

Line 690: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

686: l_user_name FND_USER.USER_NAME%TYPE;
687:
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;

Line 692: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;

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;

Line 694: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
697:
698: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

Line 698: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
697:
698: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
699:
700: l_language VARCHAR2(4);
701:
702: l_media_type_id IEU_UWQ_SEL_ENUMERATORS.MEDIA_TYPE_ID%TYPE;

Line 952: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

948: l_user_name FND_USER.USER_NAME%TYPE;
949:
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;

Line 954: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%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;

Line 956: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
959:
960: l_language VARCHAR2(4);

Line 958: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
959:
960: l_language VARCHAR2(4);
961:
962: l_media_type_id IEU_UWQ_SEL_ENUMERATORS.MEDIA_TYPE_ID%TYPE;

Line 1190: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

1186: l_user_name FND_USER.USER_NAME%TYPE;
1187:
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;

Line 1192: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%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;

Line 1194: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
1197:
1198: l_msg_count NUMBER(2);

Line 1196: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
1197:
1198: l_msg_count NUMBER(2);
1199:
1200: l_msg_data VARCHAR2(2000);

Line 1380: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

1376: l_user_name FND_USER.USER_NAME%TYPE;
1377:
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;

Line 1382: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%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;

Line 1384: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
1387:
1388: l_msg_count NUMBER(2);

Line 1386: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
1387:
1388: l_msg_count NUMBER(2);
1389:
1390: l_msg_data VARCHAR2(2000);

Line 1622: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

1618: l_user_name FND_USER.USER_NAME%TYPE;
1619:
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;

Line 1624: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%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;

Line 1626: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
1629:
1630: l_language VARCHAR2(4);

Line 1628: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
1629:
1630: l_language VARCHAR2(4);
1631:
1632: l_msg_count NUMBER(2);

Line 2228: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

2224: l_user_name FND_USER.USER_NAME%TYPE;
2225:
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;

Line 2230: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%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;

Line 2232: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
2235:
2236: l_msg_count NUMBER(2);

Line 2234: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
2235:
2236: l_msg_count NUMBER(2);
2237:
2238: l_msg_data VARCHAR2(2000);

Line 2444: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

2440: l_user_name FND_USER.USER_NAME%TYPE;
2441:
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;

Line 2446: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%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;

Line 2448: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
2451:
2452: l_msg_count NUMBER(2);

Line 2450: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
2451:
2452: l_msg_count NUMBER(2);
2453:
2454: l_msg_data VARCHAR2(2000);

Line 2650: l_sql := ' select responsibility_id, application_id from fnd_responsibility_tl where language = :l_language and responsibility_id = :p_responsibility';

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:

Line 2652: from fnd_responsibility_tl where language = :l_language

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

Line 3469: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

3465: l_user_name FND_USER.USER_NAME%TYPE;
3466:
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;

Line 3471: l_responsibility_name FND_RESPONSIBILITY_TL.RESPONSIBILITY_NAME%TYPE;

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;

Line 3473: l_responsibility_key FND_RESPONSIBILITY.RESPONSIBILITY_KEY%TYPE;

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;
3476:
3477: l_msg_count NUMBER(2);

Line 3475: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

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;
3476:
3477: l_msg_count NUMBER(2);
3478:
3479: l_msg_data VARCHAR2(2000);

Line 3875: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

3871: )
3872: AS
3873:
3874: l_user_name FND_USER.USER_NAME%TYPE;
3875: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
3876: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
3877: l_user_id FND_USER.USER_ID%TYPE;
3878: l_language VARCHAR2(4);
3879: l_action_code VARCHAR2(60);

Line 3876: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;

3872: AS
3873:
3874: l_user_name FND_USER.USER_NAME%TYPE;
3875: l_responsibility_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
3876: l_application_id FND_RESPONSIBILITY.APPLICATION_ID%TYPE;
3877: l_user_id FND_USER.USER_ID%TYPE;
3878: l_language VARCHAR2(4);
3879: l_action_code VARCHAR2(60);
3880: l_view_name VARCHAR2(512);