DBA Data[Home] [Help]

APPS.FND_OID_USERS dependencies on FND_USER

Line 167: fnd_user_pkg.DERIVE_CUSTOMER_EMPLOYEE_ID(

163: raise l_tca_error;
164: end if;
165:
166: --Bug fix 4311778
167: fnd_user_pkg.DERIVE_CUSTOMER_EMPLOYEE_ID(
168: user_name => p_ldap_message.object_name,
169: person_party_id => x_party_id,
170: customer_id => x_customer_id,
171: employee_id => x_employee_id);

Line 173: update fnd_user

169: person_party_id => x_party_id,
170: customer_id => x_customer_id,
171: employee_id => x_employee_id);
172:
173: update fnd_user
174: set person_party_id = x_party_id, customer_id = x_customer_id,
175: employee_id = x_employee_id
176: where user_name = p_ldap_message.object_name;
177:

Line 1216: from fnd_user where user_name = p_ldap_message.object_name;

1212: then
1213:
1214: select person_party_id
1215: into l_party_id
1216: from fnd_user where user_name = p_ldap_message.object_name;
1217:
1218: x_contact_point_rec.owner_table_id := l_party_id;
1219: x_contact_point_rec.contact_point_type := p_contact_point_type;
1220: if (p_contact_point_type = G_PHONE)

Line 1420: from fnd_user where user_name = p_ldap_message.object_name;

1416: end if;
1417:
1418: select person_party_id
1419: into l_party_id
1420: from fnd_user where user_name = p_ldap_message.object_name;
1421:
1422: x_party_site_rec.party_id := l_party_id;
1423:
1424: elsif (p_action_type = G_UPDATE)

Line 1493: from fnd_user where user_name = upper(p_ldap_message.object_name);

1489: end if;
1490:
1491: select user_id
1492: into l_user_id
1493: from fnd_user where user_name = upper(p_ldap_message.object_name);
1494:
1495: x_reference := p_tag || l_user_id;
1496:
1497: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)