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 BEN_PROCESS_USER_UTILITY

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 8: g_void_fnd_resp_rec ben_process_user_utility.fnd_resp_record;

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
12: (p_item_type in varchar2

Line 461: defined in ben_process_user_utility package header.The value of

457: in user page, by calling update_user_details(passing all
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,

Line 469: us from hooks via global variables in ben_process_user_utility

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,
468: email_address,fax,description,employee_id can be passed to
469: us from hooks via global variables in ben_process_user_utility
470: package header.*/
471:
472: /************************************************************/
473:

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 479: ben_process_user_utility.g_fnd_resp_record := g_void_fnd_resp_rec;

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
483: p_responsibility_id is null and

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 583: if (l_respons_id is not null or ben_process_user_utility.g_fnd_resp_record.responsibility_id is not null)

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)
584: and (l_respons_appl_id is not null or ben_process_user_utility.g_fnd_resp_record.respons_application_id is not null) then
585: --
586: -- Get the profile option value for 'ENABLE_SECURITY_GROUPS'
587: -- Use value_specific because you want the value of the resp being

Line 584: and (l_respons_appl_id is not null or ben_process_user_utility.g_fnd_resp_record.respons_application_id is not null) then

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)
584: and (l_respons_appl_id is not null or ben_process_user_utility.g_fnd_resp_record.respons_application_id is not null) then
585: --
586: -- Get the profile option value for 'ENABLE_SECURITY_GROUPS'
587: -- Use value_specific because you want the value of the resp being
588: -- assigned, not the resp you used to login.

Line 593: , nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)

589: --
590: l_enable_sec_groups := nvl(fnd_profile_server.value_specific(
591: 'ENABLE_SECURITY_GROUPS'
592: ,l_user_id
593: , nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
594: , nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id))
595: ,'N');
596:
597: if l_enable_sec_groups = 'N' then

Line 594: , nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id))

590: l_enable_sec_groups := nvl(fnd_profile_server.value_specific(
591: 'ENABLE_SECURITY_GROUPS'
592: ,l_user_id
593: , nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
594: , nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id))
595: ,'N');
596:
597: if l_enable_sec_groups = 'N' then
598:

Line 611: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)

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
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)

Line 612: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)

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
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

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 630: if (ben_process_user_utility.g_fnd_resp_record.security_group_id is null

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;
633: fetch lc_get_sec_group_id into l_sec_group_id;
634: if lc_get_sec_group_id%NOTFOUND then

Line 631: or ben_process_user_utility.g_fnd_resp_record.security_profile_id is null) then

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;
633: fetch lc_get_sec_group_id into l_sec_group_id;
634: if lc_get_sec_group_id%NOTFOUND then
635:

Line 651: ,responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)

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
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)

Line 652: ,responsibility_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)

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
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

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 673: ,p_sec_group_id => ben_process_user_utility.g_fnd_resp_record.security_group_id

669:
670: -- Insert this row into per_sec_profile_assignments
671: create_sec_profile_asg
672: (p_user_id => l_user_id
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)

Line 674: ,p_sec_profile_id => ben_process_user_utility.g_fnd_resp_record.security_profile_id

670: -- Insert this row into per_sec_profile_assignments
671: create_sec_profile_asg
672: (p_user_id => l_user_id
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)

Line 675: ,p_resp_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)

671: create_sec_profile_asg
672: (p_user_id => l_user_id
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: );

Line 676: ,p_resp_app_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)

672: (p_user_id => l_user_id
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:

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 697: (p_resp_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)

693:
694: hr_utility.set_location(l_proc, 60);
695: --
696: /*add_func_sec_exclusion_rules
697: (p_resp_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
698: ,p_resp_app_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id));
699: */
700: --
701: --

Line 698: ,p_resp_app_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id));

694: hr_utility.set_location(l_proc, 60);
695: --
696: /*add_func_sec_exclusion_rules
697: (p_resp_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
698: ,p_resp_app_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id));
699: */
700: --
701: --
702:

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 728: ,p_responsibility_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_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
732: );

Line 729: ,p_respons_application_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id)

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
732: );
733:

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 1078: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id);

1074: l_transaction_table(l_count).param_data_type := 'NUMBER';
1075: --
1076: l_count := l_count + 1;
1077: l_transaction_table(l_count).param_name := 'P_RESPONSIBILITY_ID';
1078: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id);
1079: l_transaction_table(l_count).param_data_type := 'NUMBER';
1080: --
1081: l_count := l_count + 1;
1082: l_transaction_table(l_count).param_name := 'P_RESPONSIBILITY_APPL_ID';

Line 1083: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id);

1079: l_transaction_table(l_count).param_data_type := 'NUMBER';
1080: --
1081: l_count := l_count + 1;
1082: l_transaction_table(l_count).param_name := 'P_RESPONSIBILITY_APPL_ID';
1083: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id);
1084: l_transaction_table(l_count).param_data_type := 'NUMBER';
1085: --
1086: --
1087: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee7', 5);

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 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