APPS.IRC_PARTY_PERSON_UTL dependencies on FND_USER

Line 113: from fnd_user usr1

109: and sysdate between hzpp.effective_start_date and nvl(hzpp.effective_end_date,sysdate);
110:
111: cursor get_email_rec(p_party_id number) is
112: select usr1.email_address,usr1.start_date
113: from fnd_user usr1
114: where usr1.customer_id=p_party_id
115: and usr1.start_date < sysdate
116: union
117: select usr1.email_address,usr1.start_date

Line 118: from fnd_user usr1

114: where usr1.customer_id=p_party_id
115: and usr1.start_date < sysdate
116: union
117: select usr1.email_address,usr1.start_date
118: from fnd_user usr1
119: ,per_all_people_f per1
120: where usr1.employee_id=per1.person_id
121: and usr1.start_date < sysdate
122: and per1.party_id=p_party_id

Line 162: from fnd_user

158: and ppt.system_person_type='IRC_REG_USER';
159:
160: cursor get_user_rec(p_party_id number) is
161: select user_name,employee_id
162: from fnd_user
163: where customer_id=p_party_id
164: and employee_id is null
165: and sysdate between start_date and nvl(end_date,sysdate);
166:

Line 462: fnd_user_pkg.updateUser

458: --
459: -- get any user records
460: --
461: for usr_rec in get_user_rec(l_party_ids(i)) loop
462: fnd_user_pkg.updateUser
463: (x_user_name=>usr_rec.user_name
464: ,x_owner=>'CUST'
465: ,x_employee_id=>l_person_ids(i)
466: ,x_customer_id=>fnd_user_pkg.null_number);

Line 466: ,x_customer_id=>fnd_user_pkg.null_number);

462: fnd_user_pkg.updateUser
463: (x_user_name=>usr_rec.user_name
464: ,x_owner=>'CUST'
465: ,x_employee_id=>l_person_ids(i)
466: ,x_customer_id=>fnd_user_pkg.null_number);
467: end loop;
468: --
469: -- update the phone records directly for performance
470: --