DBA Data[Home] [Help]

APPS.IEU_DIAGNOSTICS_PVT dependencies on FND_USER

Line 41: l_user_name FND_USER.USER_NAME%TYPE;

37: p_user_name IN VARCHAR2
38: )
39: As
40:
41: l_user_name FND_USER.USER_NAME%TYPE;
42:
43: l_user_id FND_USER.USER_ID%TYPE;
44:
45: l_language VARCHAR2(4);

Line 43: l_user_id FND_USER.USER_ID%TYPE;

39: As
40:
41: l_user_name FND_USER.USER_NAME%TYPE;
42:
43: l_user_id FND_USER.USER_ID%TYPE;
44:
45: l_language VARCHAR2(4);
46:
47: l_msg_count NUMBER(2);

Line 73: l_sql := ' select user_id from fnd_user

69:
70: else
71:
72: begin
73: l_sql := ' select user_id from fnd_user
74: where upper(user_name) like upper( :p_user_name)';
75:
76: EXECUTE IMMEDIATE l_sql
77: into l_user_id

Line 211: l_user_name FND_USER.USER_NAME%TYPE;

207: x_resp_id OUT NOCOPY NUMBER,
208: x_appl_id OUT NOCOPY NUMBER
209: )
210: AS
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;

Line 213: l_user_id FND_USER.USER_ID%TYPE;

209: )
210: AS
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;

Line 253: l_sql := ' select user_id from fnd_user

249:
250:
251: else
252: begin
253: l_sql := ' select user_id from fnd_user
254: where upper(user_name) like upper(:p_user_name)';
255: EXECUTE IMMEDIATE l_sql
256: INTO l_user_id
257: USING in p_user_name;

Line 686: l_user_name FND_USER.USER_NAME%TYPE;

682: )
683: AS
684:
685:
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;

Line 688: l_user_id FND_USER.USER_ID%TYPE;

684:
685:
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;

Line 948: l_user_name FND_USER.USER_NAME%TYPE;

944: )
945: AS
946:
947:
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;

Line 950: l_user_id FND_USER.USER_ID%TYPE;

946:
947:
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;

Line 1186: l_user_name FND_USER.USER_NAME%TYPE;

1182: p_responsibility IN VARCHAR2,
1183: x_valid_nodes OUT NOCOPY IEU_DIAG_VNODE_NST)
1184: AS
1185:
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;

Line 1188: l_user_id FND_USER.USER_ID%TYPE;

1184: AS
1185:
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;

Line 1376: l_user_name FND_USER.USER_NAME%TYPE;

1372: x_invalid_profile_options OUT NOCOPY IEU_DIAG_VNODE_NST
1373: )
1374: AS
1375:
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;

Line 1378: l_user_id FND_USER.USER_ID%TYPE;

1374: AS
1375:
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;

Line 1618: l_user_name FND_USER.USER_NAME%TYPE;

1614:
1615: )
1616: AS
1617:
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;

Line 1620: l_user_id FND_USER.USER_ID%TYPE;

1616: AS
1617:
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;

Line 2224: l_user_name FND_USER.USER_NAME%TYPE;

2220: p_responsibility IN VARCHAR2,
2221: x_valid_nodes OUT NOCOPY IEU_DIAG_NODE_NST
2222: )
2223: AS
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;

Line 2226: l_user_id FND_USER.USER_ID%TYPE;

2222: )
2223: AS
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;

Line 2440: l_user_name FND_USER.USER_NAME%TYPE;

2436: x_rtime_total OUT NOCOPY NUMBER
2437: )
2438: AS
2439:
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;

Line 2442: l_user_id FND_USER.USER_ID%TYPE;

2438: AS
2439:
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;

Line 2645: l_sql := ' select user_id from fnd_user

2641: -- DBMS_OUTPUT.put_line('Check_Node_Enumeration...success');
2642:
2643: -- get the user id , responsibility id and application id
2644:
2645: l_sql := ' select user_id from fnd_user
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;

Line 3465: l_user_name FND_USER.USER_NAME%TYPE;

3461: p_user_name IN VARCHAR2,
3462: p_responsibility IN VARCHAR2,
3463: x_invalid_views OUT NOCOPY IEU_DIAG_STRING_NST)
3464: AS
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;

Line 3467: l_user_id FND_USER.USER_ID%TYPE;

3463: x_invalid_views OUT NOCOPY IEU_DIAG_STRING_NST)
3464: AS
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;

Line 3874: l_user_name FND_USER.USER_NAME%TYPE;

3870: x_log OUT NOCOPY IEU_DIAG_STRING_NST
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);

Line 3877: l_user_id FND_USER.USER_ID%TYPE;

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);
3881: v_cursor NUMBER;