APPS.MISPER_WF_SYNCH_USER_ROLE dependencies on FND_USER

Line 49: l_user_name FND_USER.USER_NAME%TYPE;

45: l_param_value VARCHAR2(2000);
46: l_event_name VARCHAR2(2000);
47: l_event_key VARCHAR2(2000);
48: l_email VARCHAR2(100);
49: l_user_name FND_USER.USER_NAME%TYPE;
50: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
51: l_exists varchar2(1);
52: l_owner varchar2(30);
53:

Line 50: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;

46: l_event_name VARCHAR2(2000);
47: l_event_key VARCHAR2(2000);
48: l_email VARCHAR2(100);
49: l_user_name FND_USER.USER_NAME%TYPE;
50: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
51: l_exists varchar2(1);
52: l_owner varchar2(30);
53:
54: l_old_user_name varchar2(200);

Line 58: l_party_id fnd_user.person_party_id%type;

54: l_old_user_name varchar2(200);
55: l_new_user_name varchar2(200);
56: l_event_fired varchar2(1);
57: l_user_id number;
58: l_party_id fnd_user.person_party_id%type;
59: l_user_start_date date;
60: l_user_end_date date;
61:
62: begin

Line 81: from fnd_user

77: Begin
78:
79: select user_name, start_date, end_date, person_party_id, email_address
80: into l_user_name,l_user_start_date, l_user_end_date, l_party_id, l_email_address
81: from fnd_user
82: where user_id = l_event_key;
83:
84:
85: Exception when no_data_found then