eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARI_SELF_REGISTRATION_PKG dependencies on FND_USER

Line 868: select user_name INTO l_user_name FROM fnd_user where user_id = l_user_id;

864: end if;
865: -------------------------------------------------------------------------
866: l_user_id := FND_PROFILE.VALUE('USER_ID');
867:
868: select user_name INTO l_user_name FROM fnd_user where user_id = l_user_id;
869:
870: if(p_cust_acct_site_id <> -1) then
871: select site_uses.site_use_id INTO l_site_use_id FROM hz_cust_site_uses site_uses
872: where site_uses.cust_acct_site_id = p_cust_acct_site_id

Line 960: from fnd_user

956: IF p_customer_id IS NULL THEN
957:
958: select to_char(customer_id)
959: into l_party_rel_id
960: from fnd_user
961: where user_id = p_user_id;
962:
963: ELSE
964: -- Bug 5219389 - Party Id should be passed instead of cust_account_id.

Line 972: fnd_user fu

968: from (
969: select hr1.party_id
970: from hz_relationships hr1,
971: hz_relationships hr2,
972: fnd_user fu
973: where hr1.subject_type = 'PERSON'
974: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
975: AND hr1.status = 'A'
976: and hr1.object_id = l_party_id

Line 985: fnd_user fu, hz_parties Party

981: UNION ALL
982: select hr1.party_id
983:
984: from hz_relationships hr1,
985: fnd_user fu, hz_parties Party
986: where hr1.subject_type = 'PERSON'
987: AND (hr1.relationship_code = 'CONTACT_OF' OR hr1.relationship_code = 'EMPLOYEE_OF')
988: AND hr1.status = 'A'
989: and hr1.object_id = l_party_id

Line 1090: l_reg_user_name fnd_user.user_name%type;

1086: l_party_number hz_parties.party_number%type;
1087: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1088: l_profile_id NUMBER;
1089: l_reg_type VARCHAR2(50);
1090: l_reg_user_name fnd_user.user_name%type;
1091: l_email_address fnd_user.email_address%type;
1092: l_procedure_name VARCHAR2(50) := '.CreatePersonPartyInternal';
1093: l_debug_info VARCHAR2(300);
1094:

Line 1091: l_email_address fnd_user.email_address%type;

1087: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
1088: l_profile_id NUMBER;
1089: l_reg_type VARCHAR2(50);
1090: l_reg_user_name fnd_user.user_name%type;
1091: l_email_address fnd_user.email_address%type;
1092: l_procedure_name VARCHAR2(50) := '.CreatePersonPartyInternal';
1093: l_debug_info VARCHAR2(300);
1094:
1095: X_Return_Status VARCHAR2(20);

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

1188: l_reg_user_name := p_event.getvalueforparameter('REQUESTED_USERNAME');
1189: l_email_address := p_event.getvalueforparameter('EMAIL_ADDRESS');
1190:
1191: ----------------------------------------------------------------------------
1192: l_debug_info := 'Call FND_USER_PKG to update user with person party id';
1193: ----------------------------------------------------------------------------
1194: IF (PG_DEBUG = 'Y') THEN
1195: arp_standard.debug(l_debug_info);
1196: END IF;

Line 1198: FND_USER_PKG.UpdateUser (

1194: IF (PG_DEBUG = 'Y') THEN
1195: arp_standard.debug(l_debug_info);
1196: END IF;
1197:
1198: FND_USER_PKG.UpdateUser (
1199: x_user_name => l_reg_user_name,
1200: x_owner => 'CUST',
1201: x_email_address => l_email_address,
1202: x_customer_id => p_person_party_id

Line 2388: select fnd.user_id into l_user_id

2384: IF (PG_DEBUG = 'Y') THEN
2385: arp_standard.debug(l_debug_info);
2386: END IF;
2387: begin
2388: select fnd.user_id into l_user_id
2389: from fnd_user fnd
2390: where user_name='GUEST';
2391: IF p_person_party_id IS NOT NULL then
2392: select fnd.user_id into l_user_id

Line 2389: from fnd_user fnd

2385: arp_standard.debug(l_debug_info);
2386: END IF;
2387: begin
2388: select fnd.user_id into l_user_id
2389: from fnd_user fnd
2390: where user_name='GUEST';
2391: IF p_person_party_id IS NOT NULL then
2392: select fnd.user_id into l_user_id
2393: from fnd_user fnd

Line 2392: select fnd.user_id into l_user_id

2388: select fnd.user_id into l_user_id
2389: from fnd_user fnd
2390: where user_name='GUEST';
2391: IF p_person_party_id IS NOT NULL then
2392: select fnd.user_id into l_user_id
2393: from fnd_user fnd
2394: where person_party_id = p_person_party_id;
2395: end if;
2396: exception

Line 2393: from fnd_user fnd

2389: from fnd_user fnd
2390: where user_name='GUEST';
2391: IF p_person_party_id IS NOT NULL then
2392: select fnd.user_id into l_user_id
2393: from fnd_user fnd
2394: where person_party_id = p_person_party_id;
2395: end if;
2396: exception
2397: when no_data_found then

Line 2711: FROM fnd_user usr

2707: wf_event.addParametertoList('REGISTRATION_ID',p_registration_id , l_parameter_list);
2708: wf_event.addParametertoList('RESPONSIBILITY_ID',p_responsibility_id, l_parameter_list);
2709: IF p_person_party_id IS NULL THEN
2710: SELECT usr.user_name into l_user_name
2711: FROM fnd_user usr
2712: WHERE Usr.user_id = fnd_global.user_id;
2713: wf_event.addParametertoList('REQUESTED_USERNAME', l_user_name, l_parameter_list);
2714:
2715: ELSE

Line 2717: FROM fnd_user usr

2713: wf_event.addParametertoList('REQUESTED_USERNAME', l_user_name, l_parameter_list);
2714:
2715: ELSE
2716: SELECT usr.user_name into l_user_name
2717: FROM fnd_user usr
2718: WHERE Usr.person_party_id = p_person_party_id;
2719: END IF;
2720: wf_event_t.initialize(l_event);
2721: l_event.setParameterList(l_parameter_list);

Line 2841: 'FND_USER',

2837:
2838:
2839: WF_ENGINE.SetItemAttrText('ARIADDAC',
2840: l_item_key,
2841: 'FND_USER',
2842: l_user_name);
2843:
2844: /*------------------------------------------------------------------+
2845: | Set the Person_party_id |