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.BEN_PROCESS_USER_SS_API dependencies on FND_USER

Line 7: g_void_fnd_user_rec ben_process_user_utility.fnd_user_record;

3:
4: -- Global variables
5: g_package constant varchar2(80):='ben_process_user_ss_api.';
6: g_data_error exception;
7: g_void_fnd_user_rec ben_process_user_utility.fnd_user_record;
8: g_void_fnd_resp_rec ben_process_user_utility.fnd_resp_record;
9:
10: --
11: function get_transaction_step_id

Line 164: (p_user_id in fnd_user.user_id%type

160: -- |---------------------- < create_sec_profile_asg > ------------------------|
161: -- ----------------------------------------------------------------------------
162: --
163: PROCEDURE create_sec_profile_asg
164: (p_user_id in fnd_user.user_id%type
165: ,p_sec_group_id in fnd_security_groups.security_group_id%type
166: ,p_sec_profile_id in per_security_profiles.security_profile_id%type
167: ,p_resp_id in fnd_responsibility.responsibility_id%type
168: ,p_resp_app_id in per_sec_profile_assignments.responsibility_application_id%type

Line 252: -- per_sec_profile_assignments as well as fnd_user_resp_groups.

248: end if;
249: end if;
250: --
251: -- Now call the per_asp_ins.ins which will insert a row into
252: -- per_sec_profile_assignments as well as fnd_user_resp_groups.
253: per_asp_ins.ins
254: (p_user_id => p_user_id
255: ,p_security_group_id => p_sec_group_id
256: ,p_business_group_id => l_bg_id

Line 392: -- Purpose: This procedure does have user hooks and actually calls fnd_user_pkg to do inserts.

388: --
389: -- ---------------------------------------------------------------------------
390: -- ---------------------- < create_user_details> -------------------------
391: -- ---------------------------------------------------------------------------
392: -- Purpose: This procedure does have user hooks and actually calls fnd_user_pkg to do inserts.
393: -- ---------------------------------------------------------------------------
394: procedure create_user_details
395: (p_validate in boolean default false
396: ,p_user_name in varchar2

Line 462: the global variables will be copied to the parameter for fnd_user_pkg.

458: parameters as null) on pressing next
459: button,putting logic in the hooks then customer can pass respo-
460: nsibility_id and responsibility_application_id via global variables
461: defined in ben_process_user_utility package header.The value of
462: the global variables will be copied to the parameter for fnd_user_pkg.
463: createuserid and fnd_user_resp_groups_api and fnd_resp_functions api.
464:
465: Also we have taken care of the fact that username,password,
466: start_date,end_date,last_logon_date,password_date,password_

Line 463: createuserid and fnd_user_resp_groups_api and fnd_resp_functions api.

459: button,putting logic in the hooks then customer can pass respo-
460: nsibility_id and responsibility_application_id via global variables
461: defined in ben_process_user_utility package header.The value of
462: the global variables will be copied to the parameter for fnd_user_pkg.
463: createuserid and fnd_user_resp_groups_api and fnd_resp_functions api.
464:
465: Also we have taken care of the fact that username,password,
466: start_date,end_date,last_logon_date,password_date,password_
467: accesses_left,password_lifespan_accesses,password_lifespan_days,

Line 478: ben_process_user_utility.g_fnd_user_record := g_void_fnd_user_rec;

474: -- Clear the global record variables first. Otherwise,these variables
475: -- may retain values from previous executions.
476: --
477:
478: ben_process_user_utility.g_fnd_user_record := g_void_fnd_user_rec;
479: ben_process_user_utility.g_fnd_resp_record := g_void_fnd_resp_rec;
480:
481: prflvalue := fnd_profile.value('BEN_NEW_USER_RESP_PROFILE');
482: if prflvalue is not null and

Line 563: l_user_id := fnd_user_pkg.createuserid

559: --
560: end;
561: --
562:
563: l_user_id := fnd_user_pkg.createuserid
564: (x_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
565: ,x_owner => p_owner
566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)

Line 564: (x_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)

560: end;
561: --
562:
563: l_user_id := fnd_user_pkg.createuserid
564: (x_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
565: ,x_owner => p_owner
566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)

Line 566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)

562:
563: l_user_id := fnd_user_pkg.createuserid
564: (x_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
565: ,x_owner => p_owner
566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)

Line 567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)

563: l_user_id := fnd_user_pkg.createuserid
564: (x_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
565: ,x_owner => p_owner
566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)

Line 568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)

564: (x_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
565: ,x_owner => p_owner
566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)

Line 569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)

565: ,x_owner => p_owner
566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)

Line 570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)

566: ,x_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)

Line 571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)

567: ,x_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)

Line 572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)

568: ,x_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)

Line 573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)

569: ,x_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)

Line 574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)

570: ,x_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
578: ,x_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)

Line 575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)

571: ,x_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
578: ,x_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
579: ,x_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)

Line 576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)

572: ,x_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
578: ,x_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
579: ,x_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
580: );

Line 577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)

573: ,x_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
578: ,x_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
579: ,x_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
580: );
581: --

Line 578: ,x_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)

574: ,x_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
578: ,x_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
579: ,x_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
580: );
581: --
582:

Line 579: ,x_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)

575: ,x_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
576: ,x_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
577: ,x_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
578: ,x_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
579: ,x_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
580: );
581: --
582:
583: if (l_respons_id is not null or ben_process_user_utility.g_fnd_resp_record.responsibility_id is not null)

Line 600: ' before create_fnd_user_resp_groups', 50);

596:
597: if l_enable_sec_groups = 'N' then
598:
599: hr_utility.set_location (l_proc ||
600: ' before create_fnd_user_resp_groups', 50);
601: --
602: -- **********************************************
603: -- Create the new fnd_user_resp_groups record
604: -- **********************************************

Line 603: -- Create the new fnd_user_resp_groups record

599: hr_utility.set_location (l_proc ||
600: ' before create_fnd_user_resp_groups', 50);
601: --
602: -- **********************************************
603: -- Create the new fnd_user_resp_groups record
604: -- **********************************************
605: -- NOTE: Only insert a row into fnd_user_resp_groups
606: -- when the profile option 'ENABLE_SECURITY_GROUPS'
607: -- is 'N'.

Line 605: -- NOTE: Only insert a row into fnd_user_resp_groups

601: --
602: -- **********************************************
603: -- Create the new fnd_user_resp_groups record
604: -- **********************************************
605: -- NOTE: Only insert a row into fnd_user_resp_groups
606: -- when the profile option 'ENABLE_SECURITY_GROUPS'
607: -- is 'N'.
608: --
609: fnd_user_resp_groups_api.insert_assignment(

Line 609: fnd_user_resp_groups_api.insert_assignment(

605: -- NOTE: Only insert a row into fnd_user_resp_groups
606: -- when the profile option 'ENABLE_SECURITY_GROUPS'
607: -- is 'N'.
608: --
609: fnd_user_resp_groups_api.insert_assignment(
610: user_id => l_user_id
611: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
612: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
613: ,security_group_id => 0

Line 614: ,start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)

610: user_id => l_user_id
611: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
612: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
613: ,security_group_id => 0
614: ,start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
615: ,end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
616: ,description => null
617: );
618:

Line 615: ,end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)

611: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
612: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
613: ,security_group_id => 0
614: ,start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
615: ,end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
616: ,description => null
617: );
618:
619: else

Line 621: -- into fnd_user_resp_groups only if view-all security profile of the

617: );
618:
619: else
620: -- 'ENABLE_SECURITY_GROUPS' = 'Y'; customers have the option to insert
621: -- into fnd_user_resp_groups only if view-all security profile of the
622: -- employee's business group is to be used.
623: -- If a restricted security
624: -- profile is to be used, then we must call hrasprhi.pkb which will
625: -- insert one row into per_sec_profile_assignments as well as to

Line 626: -- fnd_user_resp_groups.

622: -- employee's business group is to be used.
623: -- If a restricted security
624: -- profile is to be used, then we must call hrasprhi.pkb which will
625: -- insert one row into per_sec_profile_assignments as well as to
626: -- fnd_user_resp_groups.
627:
628: -- Insert into fnd_user_resp_groups only
629: -- get the security_group_id for the employee's business_group_id
630: if (ben_process_user_utility.g_fnd_resp_record.security_group_id is null

Line 628: -- Insert into fnd_user_resp_groups only

624: -- profile is to be used, then we must call hrasprhi.pkb which will
625: -- insert one row into per_sec_profile_assignments as well as to
626: -- fnd_user_resp_groups.
627:
628: -- Insert into fnd_user_resp_groups only
629: -- get the security_group_id for the employee's business_group_id
630: if (ben_process_user_utility.g_fnd_resp_record.security_group_id is null
631: or ben_process_user_utility.g_fnd_resp_record.security_profile_id is null) then
632: open lc_get_sec_group_id;

Line 647: ' before create_fnd_user_resp_groups', 53);

643: close lc_get_sec_group_id;
644: end if;
645:
646: hr_utility.set_location (l_proc ||
647: ' before create_fnd_user_resp_groups', 53);
648: --
649: fnd_user_resp_groups_api.insert_assignment(
650: user_id => l_user_id
651: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)

Line 649: fnd_user_resp_groups_api.insert_assignment(

645:
646: hr_utility.set_location (l_proc ||
647: ' before create_fnd_user_resp_groups', 53);
648: --
649: fnd_user_resp_groups_api.insert_assignment(
650: user_id => l_user_id
651: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
652: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
653: ,security_group_id => l_sec_group_id

Line 654: ,start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)

650: user_id => l_user_id
651: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
652: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
653: ,security_group_id => l_sec_group_id
654: ,start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
655: ,end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
656: ,description => null
657: );
658:

Line 655: ,end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)

651: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
652: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
653: ,security_group_id => l_sec_group_id
654: ,start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
655: ,end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
656: ,description => null
657: );
658:
659: hr_utility.set_location (l_proc ||

Line 660: ' after create_fnd_user_resp_groups', 54);

656: ,description => null
657: );
658:
659: hr_utility.set_location (l_proc ||
660: ' after create_fnd_user_resp_groups', 54);
661: --
662: else
663: -- sec_group_id and sec_profile_id are filled in
664: -- call peasprhi.pkb to insert into per_sec_profile_assignments

Line 665: -- as well as fnd_user_resp_groups.

661: --
662: else
663: -- sec_group_id and sec_profile_id are filled in
664: -- call peasprhi.pkb to insert into per_sec_profile_assignments
665: -- as well as fnd_user_resp_groups.
666:
667: hr_utility.set_location (l_proc ||
668: ' before create_sec_profile_asg', 56);
669:

Line 677: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)

673: ,p_sec_group_id => ben_process_user_utility.g_fnd_resp_record.security_group_id
674: ,p_sec_profile_id => ben_process_user_utility.g_fnd_resp_record.security_profile_id
675: ,p_resp_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
676: ,p_resp_app_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
677: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
678: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
679: );
680:
681: hr_utility.set_location (l_proc ||

Line 678: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)

674: ,p_sec_profile_id => ben_process_user_utility.g_fnd_resp_record.security_profile_id
675: ,p_resp_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
676: ,p_resp_app_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
677: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
678: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
679: );
680:
681: hr_utility.set_location (l_proc ||
682: ' after create_sec_profile_asg', 57);

Line 711: (p_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)

707: -- Start of API User Hook for the after hook of create_user_details
708: hr_utility.set_location('Calling ben_proocess_user_ss_bk1.create_user_details_a', 12);
709:
710: ben_process_user_ss_bk1.create_user_details_a
711: (p_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
712: ,p_owner => p_owner
713: ,p_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
714: ,p_session_number => p_session_number
715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)

Line 713: ,p_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)

709:
710: ben_process_user_ss_bk1.create_user_details_a
711: (p_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
712: ,p_owner => p_owner
713: ,p_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
714: ,p_session_number => p_session_number
715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)

Line 715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)

711: (p_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
712: ,p_owner => p_owner
713: ,p_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
714: ,p_session_number => p_session_number
715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)

Line 716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)

712: ,p_owner => p_owner
713: ,p_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
714: ,p_session_number => p_session_number
715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)

Line 717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)

713: ,p_unencrypted_password => nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password)
714: ,p_session_number => p_session_number
715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)

Line 718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)

714: ,p_session_number => p_session_number
715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)

Line 719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)

715: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)

Line 720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)

716: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)

Line 721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)

717: ,p_last_logon_date => nvl(ben_process_user_utility.g_fnd_user_record.last_logon_date,p_last_logon_date)
718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)

Line 722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)

718: ,p_description => nvl(ben_process_user_utility.g_fnd_user_record.description,p_description)
719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
726: ,p_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)

Line 723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)

719: ,p_password_date => nvl(ben_process_user_utility.g_fnd_user_record.password_date,p_password_date)
720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
726: ,p_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
727: ,p_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)

Line 724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)

720: ,p_password_accesses_left => nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left)
721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
726: ,p_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
727: ,p_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
728: ,p_responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)

Line 725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)

721: ,p_password_lifespan_accesses=> nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses)
722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
726: ,p_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
727: ,p_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
728: ,p_responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
729: ,p_respons_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)

Line 726: ,p_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)

722: ,p_password_lifespan_days => nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days)
723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
726: ,p_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
727: ,p_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
728: ,p_responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
729: ,p_respons_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
730: ,p_user_id => l_user_id

Line 727: ,p_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)

723: ,p_employee_id => nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id)
724: ,p_email_address => nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address)
725: ,p_fax => nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax)
726: ,p_customer_id => nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id)
727: ,p_supplier_id => nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id)
728: ,p_responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
729: ,p_respons_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)
730: ,p_user_id => l_user_id
731: ,p_business_group_id => p_business_group_id

Line 830: l_user_pswd fnd_user.encrypted_user_password%TYPE;

826: l_user_id number;
827: l_employee_id number default null;
828: l_count number := 1;
829: prflvalue varchar2(2000);
830: l_user_pswd fnd_user.encrypted_user_password%TYPE;
831:
832: begin
833: --
834: --savepoint create_user_details;

Line 984: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name);

980: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
981: --
982: l_count := l_count + 1;
983: l_transaction_table(l_count).param_name := 'P_USER_NAME';
984: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name);
985: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
986: --
987: l_count := l_count + 1;
988: l_transaction_table(l_count).param_name := 'P_OWNER';

Line 994: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password);

990: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
991: --
992: l_count := l_count + 1;
993: l_transaction_table(l_count).param_name := 'P_ENCRYPTED_PASSWORD';
994: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password,p_unencrypted_password);
995: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
996: --
997: l_count := l_count + 1;
998: l_transaction_table(l_count).param_name := 'P_SESSION_NUMBER';

Line 1004: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.start_date,hr_transaction_ss.g_date_format),to_char(p_start_date,

1000: l_transaction_table(l_count).param_data_type := 'NUMBER';
1001: --
1002: l_count := l_count + 1;
1003: l_transaction_table(l_count).param_name := 'P_START_DATE';
1004: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.start_date,hr_transaction_ss.g_date_format),to_char(p_start_date,
1005: hr_transaction_ss.g_date_format));
1006: l_transaction_table(l_count).param_data_type := 'DATE';
1007: --
1008: l_count := l_count + 1;

Line 1010: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.end_date,hr_transaction_ss.g_date_format),to_char(p_end_date,

1006: l_transaction_table(l_count).param_data_type := 'DATE';
1007: --
1008: l_count := l_count + 1;
1009: l_transaction_table(l_count).param_name := 'P_END_DATE';
1010: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.end_date,hr_transaction_ss.g_date_format),to_char(p_end_date,
1011: hr_transaction_ss.g_date_format));
1012: l_transaction_table(l_count).param_data_type := 'DATE';
1013: --
1014: l_count := l_count + 1;

Line 1016: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.last_logon_date,hr_transaction_ss.g_date_format),to_char(p_last_logon_date,

1012: l_transaction_table(l_count).param_data_type := 'DATE';
1013: --
1014: l_count := l_count + 1;
1015: l_transaction_table(l_count).param_name := 'P_LAST_LOGON_DATE';
1016: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.last_logon_date,hr_transaction_ss.g_date_format),to_char(p_last_logon_date,
1017: hr_transaction_ss.g_date_format));
1018: l_transaction_table(l_count).param_data_type := 'DATE';
1019: --
1020: l_count := l_count + 1;

Line 1022: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.description,p_description);

1018: l_transaction_table(l_count).param_data_type := 'DATE';
1019: --
1020: l_count := l_count + 1;
1021: l_transaction_table(l_count).param_name := 'P_DESCRIPTION';
1022: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.description,p_description);
1023: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1024: --
1025: l_count := l_count + 1;
1026: l_transaction_table(l_count).param_name := 'P_PASSWORD_DATE';

Line 1027: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.password_date,hr_transaction_ss.g_date_format),to_char(p_password_date,

1023: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1024: --
1025: l_count := l_count + 1;
1026: l_transaction_table(l_count).param_name := 'P_PASSWORD_DATE';
1027: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.password_date,hr_transaction_ss.g_date_format),to_char(p_password_date,
1028: hr_transaction_ss.g_date_format));
1029: l_transaction_table(l_count).param_data_type := 'DATE';
1030: --
1031: l_count := l_count + 1;

Line 1033: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left);

1029: l_transaction_table(l_count).param_data_type := 'DATE';
1030: --
1031: l_count := l_count + 1;
1032: l_transaction_table(l_count).param_name := 'P_PASSWORD_ACCESSES_LEFT';
1033: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password_accesses_left,p_password_accesses_left);
1034: l_transaction_table(l_count).param_data_type := 'NUMBER';
1035: --
1036: l_count := l_count + 1;
1037: l_transaction_table(l_count).param_name := 'P_PASSWORD_LIFESPAN_ACCESSES';

Line 1038: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses);

1034: l_transaction_table(l_count).param_data_type := 'NUMBER';
1035: --
1036: l_count := l_count + 1;
1037: l_transaction_table(l_count).param_name := 'P_PASSWORD_LIFESPAN_ACCESSES';
1038: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_accesses,p_password_lifespan_accesses);
1039: l_transaction_table(l_count).param_data_type := 'NUMBER';
1040: --
1041: l_count := l_count + 1;
1042: l_transaction_table(l_count).param_name := 'P_PASSWORD_LIFESPAN_DAYS';

Line 1043: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days);

1039: l_transaction_table(l_count).param_data_type := 'NUMBER';
1040: --
1041: l_count := l_count + 1;
1042: l_transaction_table(l_count).param_name := 'P_PASSWORD_LIFESPAN_DAYS';
1043: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.password_lifespan_days,p_password_lifespan_days);
1044: l_transaction_table(l_count).param_data_type := 'NUMBER';
1045: --
1046: l_count := l_count + 1;
1047: l_transaction_table(l_count).param_name := 'P_EMPLOYEE_ID';

Line 1048: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id);

1044: l_transaction_table(l_count).param_data_type := 'NUMBER';
1045: --
1046: l_count := l_count + 1;
1047: l_transaction_table(l_count).param_name := 'P_EMPLOYEE_ID';
1048: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.employee_id,l_employee_id);
1049: l_transaction_table(l_count).param_data_type := 'NUMBER';
1050: --
1051: l_count := l_count + 1;
1052: l_transaction_table(l_count).param_name := 'P_EMAIL_ADDRESS';

Line 1053: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address);

1049: l_transaction_table(l_count).param_data_type := 'NUMBER';
1050: --
1051: l_count := l_count + 1;
1052: l_transaction_table(l_count).param_name := 'P_EMAIL_ADDRESS';
1053: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.email_address,p_email_address);
1054: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1055: --
1056: l_count := l_count + 1;
1057: l_transaction_table(l_count).param_name := 'P_FAX';

Line 1058: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax);

1054: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1055: --
1056: l_count := l_count + 1;
1057: l_transaction_table(l_count).param_name := 'P_FAX';
1058: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.fax,p_fax);
1059: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1060: --
1061: l_count := l_count + 1;
1062: l_transaction_table(l_count).param_name := 'P_CUSTOMER_ID';

Line 1063: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id);

1059: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1060: --
1061: l_count := l_count + 1;
1062: l_transaction_table(l_count).param_name := 'P_CUSTOMER_ID';
1063: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.customer_id,p_customer_id);
1064: l_transaction_table(l_count).param_data_type := 'NUMBER';
1065: --
1066: l_count := l_count + 1;
1067: l_transaction_table(l_count).param_name := 'P_SUPPLIER_ID';

Line 1068: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id);

1064: l_transaction_table(l_count).param_data_type := 'NUMBER';
1065: --
1066: l_count := l_count + 1;
1067: l_transaction_table(l_count).param_name := 'P_SUPPLIER_ID';
1068: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_user_record.supplier_id,p_supplier_id);
1069: l_transaction_table(l_count).param_data_type := 'NUMBER';
1070: --
1071: l_count := l_count + 1;
1072: l_transaction_table(l_count).param_name := 'P_BUSINESS_GROUP_ID';

Line 1110: avalue => nvl(ben_process_user_utility.g_fnd_user_record.password,l_user_pswd));

1106: -- bug 3728862, set the USER_ACCOUNT_INFO attr. here instead of setting from UserReviewCO
1107: wf_engine.SetItemAttrText (itemtype => p_item_type,
1108: itemkey => p_item_key,
1109: aname => 'USER_ACCOUNT_INFO',
1110: avalue => nvl(ben_process_user_utility.g_fnd_user_record.password,l_user_pswd));
1111: exception
1112: when g_data_error then
1113: null;
1114:

Line 1133: l_user_name fnd_user.user_name%TYPE;

1129: (p_validate IN BOOLEAN DEFAULT FALSE
1130: ,p_transaction_step_id IN NUMBER) is
1131: --
1132: l_user_id number;
1133: l_user_name fnd_user.user_name%TYPE;
1134: l_user_pswd fnd_user.encrypted_user_password%TYPE;
1135: l_pswd_hint fnd_user.description%TYPE;
1136: l_api_error boolean;
1137: l_respons_id number ;

Line 1134: l_user_pswd fnd_user.encrypted_user_password%TYPE;

1130: ,p_transaction_step_id IN NUMBER) is
1131: --
1132: l_user_id number;
1133: l_user_name fnd_user.user_name%TYPE;
1134: l_user_pswd fnd_user.encrypted_user_password%TYPE;
1135: l_pswd_hint fnd_user.description%TYPE;
1136: l_api_error boolean;
1137: l_respons_id number ;
1138: l_respons_appl_id number ;

Line 1135: l_pswd_hint fnd_user.description%TYPE;

1131: --
1132: l_user_id number;
1133: l_user_name fnd_user.user_name%TYPE;
1134: l_user_pswd fnd_user.encrypted_user_password%TYPE;
1135: l_pswd_hint fnd_user.description%TYPE;
1136: l_api_error boolean;
1137: l_respons_id number ;
1138: l_respons_appl_id number ;
1139: l_owner number ;

Line 1246: avalue => nvl(ben_process_user_utility.g_fnd_user_record.password,l_user_pswd));

1242: -- bug 3728862, set the USER_ACCOUNT_INFO attr. here instead of setting from UserReviewCO
1243: wf_engine.SetItemAttrText (itemtype => l_item_type,
1244: itemkey => l_item_key,
1245: aname => 'USER_ACCOUNT_INFO',
1246: avalue => nvl(ben_process_user_utility.g_fnd_user_record.password,l_user_pswd));
1247:
1248: --
1249: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee1', 5);
1250: if l_api_error then