[Home] [Help]
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.
73: *
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;
111:
112:
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.
200: *
221: and effective_end_date > sysdate;
222: /*
223: cursor c_customer(p_customer_id in number) is
224: select hzp.party_type
225: from hz_parties hzp
226: where hzp.party_id = p_customer_id;
227:
228:
229: cursor c_subject(p_customer_id in number) is
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:
243: cursor c_wf_user(l_user_name in varchar2, l_email in varchar2) is
244: select name
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.
389: *
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;
423:
424: cursor c_user1(l_party_id in number) is
462:
463: l_wf_user_name := x_user_name;
464:
465: if x_user_name is null then
466: -- try to get the name from the email in hz_parties
467: open c_party;
468: fetch c_party into x_user_name;
469: close c_party;
470:
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.
532: *
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: */
542: procedure get_wf_user(p_api_version_number in number,
1869: END GET_USERTYPE_ID;
1870:
1871: function CHECK_PARTY_TYPE(p_party_id NUMBER) return VARCHAR2
1872: is
1873: l_party_type HZ_PARTIES.party_type%type;
1874:
1875: CURSOR c_party_type
1876: is
1877: SELECT hzp.party_type
1874:
1875: CURSOR c_party_type
1876: is
1877: SELECT hzp.party_type
1878: FROM hz_parties hzp
1879: WHERE hzp.party_id = p_party_id;
1880: BEGIN
1881:
1882: OPEN c_party_type;