[Home] [Help]
63: * DEFAULTING LOGIC
64: *
65: * 1. User_name from fnd_user where email_address = p_requester_email_Address
66: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
67: * per_all_people_f using the email_address)
68: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
69: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
70: * and contact_point = p_requester_email_Address
71: *
91: union
92:
93: -- from HR tables
94: select fnd.user_name
95: from fnd_user fnd, per_all_people_f per
96: where per.person_id = fnd.employee_id
97: and per.effective_end_date > sysdate
98: and (nvl(fnd.end_date, sysdate+1) > sysdate or
99: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))
189: * Other Comments :
190: * DEFAULTING LOGIC
191: * If only the user name is passed then the email is defaulted using the following logic
192: * 1. Email address from fnd_users where user_name = p_requester_user_name
193: * 2. Email from per_all_people_F where person_id = employee_id
194: * (retrieved from fnd_users using the user_name)
195: * 3. Email from hz_contact_points where owner_type_id = party_id and
196: * owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.
197: * Party_id here is obtained from the customer id stored in fnd_user where
215: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
216:
217: cursor c_employee(p_employee_id in number) is
218: select email_address
219: from per_all_people_f
220: where person_id = p_employee_id
221: and effective_end_date > sysdate;
222: /*
223: cursor c_customer(p_customer_id in number) is
281: if not validate_email(p_requester_email, x_email) then
282: x_email := null;
283: end if;
284:
285: -- if email is still null check if it can be found in per_all_people_F
286: if x_email is null and l_employee_id is not NULL then
287: open c_employee(l_employee_id);
288: fetch c_employee into x_email;
289: close c_employee;
379: * DEFAULTING LOGIC
380: *
381: * 1. User_name from fnd_user where email_address = p_requester_email_Address
382: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
383: * per_all_people_f using the email_address)
384: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
385: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
386: * and contact_point = p_requester_email_Address
387: *
405: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
406:
407: cursor c_employee is
408: select fnd.user_name
409: from fnd_user fnd, per_all_people_f per
410: where per.person_id = fnd.employee_id
411: and per.effective_end_date > sysdate
412: and (nvl(fnd.end_date, sysdate+1) > sysdate or
413: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))
521: * Other Comments :
522: * DEFAULTING LOGIC
523: * If only the user name is passed then the email is defaulted using the following logic
524: * 1. Email address from fnd_users where user_name = x_requester_user_name
525: * 2. Email from per_all_people_F where person_id = employee_id
526: * (retrieved from fnd_users using the user_name)
527: * 3. Email from hz_contact_points where owner_type_id = party_id
528: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'.
529: * Party_id here is obtained from the customer id stored in fnd_user where
532: *
533: * If only the email address is specified, the user name is determined using a similar logic
534: * 1. User_name from fnd_user where email_address = x_requester_email_Address
535: * 2. User_name from fnd_user where employee_id = person_id (retrieved from
536: * per_all_people_f using the email_address)
537: * 3. User_name from fnd_user where customer_id = hz_contact_points.owner_type_id
538: * and owner_table = 'HZ_PARTIES' and contact_point_type = 'EMAIL'
539: * and contact_point = x_requester_email_Address
540: *