APPS.ARI_SELF_REGISTRATION_PKG dependencies on FND_USER

Line 926: from fnd_user

922: IF p_customer_id IS NULL THEN
923:
924: select to_char(customer_id)
925: into l_party_rel_id
926: from fnd_user
927: where user_id = p_user_id;
928:
929: ELSE
930: -- Bug 5219389 - Party Id should be passed instead of cust_account_id.

Line 938: fnd_user fu

934: from (
935: select hr1.party_id
936: from hz_relationships hr1,
937: hz_relationships hr2,
938: fnd_user fu
939: where hr1.subject_type = 'PERSON'
940: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
941: AND hr1.status = 'A'
942: and hr1.object_id = l_party_id

Line 951: fnd_user fu, hz_parties Party

947: UNION ALL
948: select hr1.party_id
949:
950: from hz_relationships hr1,
951: fnd_user fu, hz_parties Party
952: where hr1.subject_type = 'PERSON'
953: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
954: AND hr1.status = 'A'
955: and hr1.object_id = l_party_id

Line 1056: l_reg_user_name fnd_user.user_name%type;

1052: l_party_number hz_parties.party_number%type;
1053: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1054: l_profile_id NUMBER;
1055: l_reg_type VARCHAR2(50);
1056: l_reg_user_name fnd_user.user_name%type;
1057: l_email_address fnd_user.email_address%type;
1058: l_procedure_name VARCHAR2(50) := '.CreatePersonPartyInternal';
1059: l_debug_info VARCHAR2(300);
1060:

Line 1057: l_email_address fnd_user.email_address%type;

1053: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1054: l_profile_id NUMBER;
1055: l_reg_type VARCHAR2(50);
1056: l_reg_user_name fnd_user.user_name%type;
1057: l_email_address fnd_user.email_address%type;
1058: l_procedure_name VARCHAR2(50) := '.CreatePersonPartyInternal';
1059: l_debug_info VARCHAR2(300);
1060:
1061: X_Return_Status VARCHAR2(20);

Line 1146: l_debug_info := 'Call FND_USER_PKG to update user with person party id';

1142: l_reg_user_name := p_event.getvalueforparameter('REQUESTED_USERNAME');
1143: l_email_address := p_event.getvalueforparameter('EMAIL_ADDRESS');
1144:
1145: ----------------------------------------------------------------------------
1146: l_debug_info := 'Call FND_USER_PKG to update user with person party id';
1147: ----------------------------------------------------------------------------
1148: IF (PG_DEBUG = 'Y') THEN
1149: arp_standard.debug(l_debug_info);
1150: END IF;

Line 1152: FND_USER_PKG.UpdateUser (

1148: IF (PG_DEBUG = 'Y') THEN
1149: arp_standard.debug(l_debug_info);
1150: END IF;
1151:
1152: FND_USER_PKG.UpdateUser (
1153: x_user_name => l_reg_user_name,
1154: x_owner => 'CUST',
1155: x_email_address => l_email_address,
1156: x_customer_id => p_person_party_id

Line 2411: FROM fnd_user usr

2407: wf_event.addParametertoList('PRE_NAME_ADJUNCT', p_pre_name_adjunct, l_parameter_list);
2408: wf_event.addParametertoList('PERSON_SUFFIX', p_person_suffix, l_parameter_list);
2409: IF p_person_party_id IS NULL THEN
2410: SELECT usr.user_name into l_user_name
2411: FROM fnd_user usr
2412: WHERE Usr.user_id = fnd_global.user_id;
2413: wf_event.addParametertoList('REQUESTED_USERNAME', l_user_name, l_parameter_list);
2414: END IF;
2415: l_event_name := 'oracle.apps.ar.irec.addcustaccess';