[Home] [Help]
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: *
72: * In all the above cases the user, employee, party etc. have to be valid.
102: union
103:
104: -- from TCA tables
105: select fnd.user_name
106: from hz_contact_points hcp, fnd_user fnd
107: where hcp.owner_table_id = fnd.customer_id
108: and hcp.owner_table_name = 'HZ_PARTIES'
109: and hcp.contact_point_type = 'EMAIL'
110: and upper(hcp.email_address) = p_requester_email;
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
198: * user_name = p_requester_user_name.
199: * In all the above cases the user, employee, party etc. have to be valid.
234: and nvl(end_date, sysdate+1) > sysdate;
235: */
236: cursor c_contact_point(p_party_id in number) is
237: select EMAIL_ADDRESS
238: from hz_contact_points
239: where owner_table_id = p_party_id
240: and owner_table_name = 'HZ_PARTIES'
241: and contact_point_type = 'EMAIL';
242:
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: *
388: * In all the above cases the user, employee, party etc. have to be valid.
414: and upper(per.email_address) = p_requester_email;
415:
416: cursor c_party is
417: select fnd.user_name
418: from hz_contact_points hcp, fnd_user fnd
419: where hcp.owner_table_id = fnd.customer_id
420: and hcp.owner_table_name = 'HZ_PARTIES'
421: and hcp.contact_point_type = 'EMAIL'
422: and upper(hcp.email_address) = p_requester_email;
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
530: * user_name = x_requester_user_name.
531: * In all the above cases the user, employee, party etc. have to be valid.
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: *
541: */