DBA Data[Home] [Help]

APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on FND_USER

Line 374: l_fnd_user_id NUMBER;

370: p_inactive_date IN DATE DEFAULT NULL
371: )
372: IS
373: l_person_party_id NUMBER;
374: l_fnd_user_id NUMBER;
375: l_step VARCHAR2(100);
376: l_method VARCHAR2(30);
377: l_lock_id NUMBER;
378: cursor l_cont_addr_cur is

Line 443: -- create fnd user account

439:
440: -- handling user account
441: IF p_request_rec.create_user_account IS NOT NULL
442: AND p_request_rec.create_user_account = 'Y' THEN
443: -- create fnd user account
444: l_step := 'call create_fnd_user';
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
446: fnd_log.string
447: ( fnd_log.level_statement

Line 444: l_step := 'call create_fnd_user';

440: -- handling user account
441: IF p_request_rec.create_user_account IS NOT NULL
442: AND p_request_rec.create_user_account = 'Y' THEN
443: -- create fnd user account
444: l_step := 'call create_fnd_user';
445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
446: fnd_log.string
447: ( fnd_log.level_statement
448: , g_module || '.' || l_method

Line 464: x_user_id => l_fnd_user_id,

460: p_password => null,
461: x_return_status => x_return_status,
462: x_msg_count => x_msg_count,
463: x_msg_data => x_msg_data,
464: x_user_id => l_fnd_user_id,
465: x_password => x_password
466: );
467:
468: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN

Line 474: ( p_user_id => l_fnd_user_id,

470: RETURN;
471: END IF;
472:
473: pos_user_admin_pkg.createsecattr
474: ( p_user_id => l_fnd_user_id,
475: p_attribute_code => 'ICX_SUPPLIER_ORG_ID',
476: p_app_id => 177,
477: p_number_value => p_vendor_id
478: );

Line 977: l_user_name fnd_user.user_name%TYPE;

973: l_rec2 l_cur2%ROWTYPE;
974:
975: l_method VARCHAR2(30);
976:
977: l_user_name fnd_user.user_name%TYPE;
978:
979: /*Begin Supplier Hub -- Supplier Management */
980:
981: /* Added to assign party usage as SUPPLIER_CONTACT for existing party

Line 2662: FROM fnd_user fu, pos_contact_requests pcr

2658: if p_create_user_acc = 'Y' then
2659:
2660: SELECT fu.user_id,fu.PERSON_PARTY_ID
2661: into x_user_id, x_cont_party_id
2662: FROM fnd_user fu, pos_contact_requests pcr
2663: WHERE pcr.CONTACT_PARTY_ID = fu.PERSON_PARTY_ID
2664: and pcr.contact_request_id = p_request_id;
2665:
2666: ELSE