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.FND_USER_PKG dependencies on WF_EVENT

Line 171: l_parameter_list wf_parameter_list_t; -- bug 8227171 WF event parameter list

167: l_old_person_party_id number;
168: l_old_user_guid RAW(16);
169: l_old_supplier_id number; -- bug 10371150
170:
171: l_parameter_list wf_parameter_list_t; -- bug 8227171 WF event parameter list
172:
173: -- bug 10371150 Add supplier_id
174: cursor usercur is
175: select customer_id, employee_id, person_party_id, user_guid, supplier_id

Line 463: -- Raise WF event oracle.apps.fnd.pre.email.update

459: end if;
460: end if;
461:
462: -- Bug 8227171 UpdateUserInternal
463: -- Raise WF event oracle.apps.fnd.pre.email.update
464: begin
465: wf_event.AddParameterToList('NEW_EMAIL', l_email_address, l_parameter_list);
466: wf_event.raise3(p_event_name =>'oracle.apps.fnd.pre.email.update',
467: p_event_key => l_user_id,

Line 465: wf_event.AddParameterToList('NEW_EMAIL', l_email_address, l_parameter_list);

461:
462: -- Bug 8227171 UpdateUserInternal
463: -- Raise WF event oracle.apps.fnd.pre.email.update
464: begin
465: wf_event.AddParameterToList('NEW_EMAIL', l_email_address, l_parameter_list);
466: wf_event.raise3(p_event_name =>'oracle.apps.fnd.pre.email.update',
467: p_event_key => l_user_id,
468: p_event_data => NULL,
469: p_parameter_list => l_parameter_list,

Line 466: wf_event.raise3(p_event_name =>'oracle.apps.fnd.pre.email.update',

462: -- Bug 8227171 UpdateUserInternal
463: -- Raise WF event oracle.apps.fnd.pre.email.update
464: begin
465: wf_event.AddParameterToList('NEW_EMAIL', l_email_address, l_parameter_list);
466: wf_event.raise3(p_event_name =>'oracle.apps.fnd.pre.email.update',
467: p_event_key => l_user_id,
468: p_event_data => NULL,
469: p_parameter_list => l_parameter_list,
470: p_send_date => Sysdate);

Line 845: -- Raise WF event oracle.apps.fnd.post.user.update

841: -- Sync user change to LDAP
842: fnd_user_pkg.user_synch(x_user_name);
843:
844: -- Bug 8227171 UpdateUserInternal
845: -- Raise WF event oracle.apps.fnd.post.user.update
846: if (nvl(g_event_controller, 'XXXX') <> 'CREATE') then
847: begin
848:
849: -- Bug 14673409 - set the new_customer_id to be passed to the event if the association is changed.

Line 887: wf_event.AddParameterToList('NEW_EMAIL_ADDRESS', x_email_address, l_parameter_list);

883:
884: -- Bug 8683723
885: -- Passing some of the desired columns that may be updated to the Workflow
886: -- event in case of special handling requirements.
887: wf_event.AddParameterToList('NEW_EMAIL_ADDRESS', x_email_address, l_parameter_list);
888: wf_event.AddParameterToList('NEW_DESCRIPTION', x_description, l_parameter_list);
889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);
890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);

Line 888: wf_event.AddParameterToList('NEW_DESCRIPTION', x_description, l_parameter_list);

884: -- Bug 8683723
885: -- Passing some of the desired columns that may be updated to the Workflow
886: -- event in case of special handling requirements.
887: wf_event.AddParameterToList('NEW_EMAIL_ADDRESS', x_email_address, l_parameter_list);
888: wf_event.AddParameterToList('NEW_DESCRIPTION', x_description, l_parameter_list);
889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);
890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);

Line 889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);

885: -- Passing some of the desired columns that may be updated to the Workflow
886: -- event in case of special handling requirements.
887: wf_event.AddParameterToList('NEW_EMAIL_ADDRESS', x_email_address, l_parameter_list);
888: wf_event.AddParameterToList('NEW_DESCRIPTION', x_description, l_parameter_list);
889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);
890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);

Line 890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);

886: -- event in case of special handling requirements.
887: wf_event.AddParameterToList('NEW_EMAIL_ADDRESS', x_email_address, l_parameter_list);
888: wf_event.AddParameterToList('NEW_DESCRIPTION', x_description, l_parameter_list);
889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);
890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);
894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);

Line 891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);

887: wf_event.AddParameterToList('NEW_EMAIL_ADDRESS', x_email_address, l_parameter_list);
888: wf_event.AddParameterToList('NEW_DESCRIPTION', x_description, l_parameter_list);
889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);
890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);
894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);
895: wf_event.AddParameterToList('NEW_EMPLOYEE_ID', new_employee_id, l_parameter_list);

Line 892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);

888: wf_event.AddParameterToList('NEW_DESCRIPTION', x_description, l_parameter_list);
889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);
890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);
894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);
895: wf_event.AddParameterToList('NEW_EMPLOYEE_ID', new_employee_id, l_parameter_list);
896: wf_event.raise(p_event_name =>'oracle.apps.fnd.post.user.update',

Line 893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);

889: wf_event.AddParameterToList('NEW_CUSTOMER_ID', new_customer_id, l_parameter_list);
890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);
894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);
895: wf_event.AddParameterToList('NEW_EMPLOYEE_ID', new_employee_id, l_parameter_list);
896: wf_event.raise(p_event_name =>'oracle.apps.fnd.post.user.update',
897: p_event_key => l_user_id,

Line 894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);

890: wf_event.AddParameterToList('NEW_FAX', x_fax, l_parameter_list);
891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);
894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);
895: wf_event.AddParameterToList('NEW_EMPLOYEE_ID', new_employee_id, l_parameter_list);
896: wf_event.raise(p_event_name =>'oracle.apps.fnd.post.user.update',
897: p_event_key => l_user_id,
898: p_event_data => NULL,

Line 895: wf_event.AddParameterToList('NEW_EMPLOYEE_ID', new_employee_id, l_parameter_list);

891: wf_event.AddParameterToList('NEW_USER_GUID', x_user_guid, l_parameter_list);
892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);
894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);
895: wf_event.AddParameterToList('NEW_EMPLOYEE_ID', new_employee_id, l_parameter_list);
896: wf_event.raise(p_event_name =>'oracle.apps.fnd.post.user.update',
897: p_event_key => l_user_id,
898: p_event_data => NULL,
899: p_parameters => l_parameter_list,

Line 896: wf_event.raise(p_event_name =>'oracle.apps.fnd.post.user.update',

892: wf_event.AddParameterToList('NEW_END_DATE', x_end_date, l_parameter_list);
893: wf_event.AddParameterToList('NEW_PERSON_PARTY_ID', new_person_party_id, l_parameter_list);
894: wf_event.AddParameterToList('NEW_SUPPLIER_ID', x_supplier_id, l_parameter_list);
895: wf_event.AddParameterToList('NEW_EMPLOYEE_ID', new_employee_id, l_parameter_list);
896: wf_event.raise(p_event_name =>'oracle.apps.fnd.post.user.update',
897: p_event_key => l_user_id,
898: p_event_data => NULL,
899: p_parameters => l_parameter_list,
900: p_send_date => Sysdate);

Line 1421: -- Raise the WF event oracle.apps.fnd.post.user.create

1417: x_change_source => fnd_user_pkg.change_source_oid);
1418: end if;
1419:
1420: -- bug 8227171 CreateUserIdInternal
1421: -- Raise the WF event oracle.apps.fnd.post.user.create
1422: begin
1423: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1424: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1425: 'Raising oracle.apps.fnd.post.user.create event');

Line 1428: wf_event.raise(p_event_name => 'oracle.apps.fnd.post.user.create',

1424: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,
1425: 'Raising oracle.apps.fnd.post.user.create event');
1426: end if;
1427: g_event_controller := NULL; -- we try once then reset
1428: wf_event.raise(p_event_name => 'oracle.apps.fnd.post.user.create',
1429: p_event_key => to_char(user_id),
1430: p_event_data => NULL,
1431: p_send_date => Sysdate);
1432:

Line 2205: p_event in out nocopy wf_event_t)

2201: -- retrieves the user's information and updates the
2202: -- corresponding fnd_user as needed, if the user exists.
2203: --
2204: FUNCTION user_change(p_subscription_guid in raw,
2205: p_event in out nocopy wf_event_t)
2206: return varchar2 is
2207: my_ent_type varchar2(50);
2208: my_username varchar2(256); -- one-way code only
2209: my_mode varchar2(256); -- one-way code only

Line 2484: p_event in out nocopy wf_event_t)

2480: -- retrieves the user's information and creates the
2481: -- corresponding fnd_user if the user does not already exist.
2482: --
2483: FUNCTION user_create_rf(p_subscription_guid in raw,
2484: p_event in out nocopy wf_event_t)
2485: return varchar2
2486: is
2487: my_ent_type varchar2(50);
2488: my_cachekey varchar2(256);

Line 2765: wf_event.AddParameterToList('MAIL', my_email, mylist);

2761: where user_name = upper(p_user_name);
2762:
2763: -- construct attribute list for wf synch --
2764: -- unstubbed the code
2765: wf_event.AddParameterToList('MAIL', my_email, mylist);
2766: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);

Line 2766: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);

2762:
2763: -- construct attribute list for wf synch --
2764: -- unstubbed the code
2765: wf_event.AddParameterToList('MAIL', my_email, mylist);
2766: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);

Line 2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);

2763: -- construct attribute list for wf synch --
2764: -- unstubbed the code
2765: wf_event.AddParameterToList('MAIL', my_email, mylist);
2766: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2771: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);

Line 2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);

2764: -- unstubbed the code
2765: wf_event.AddParameterToList('MAIL', my_email, mylist);
2766: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2771: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2772: if ((my_exp is null) OR

Line 2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);

2765: wf_event.AddParameterToList('MAIL', my_email, mylist);
2766: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2771: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2772: if ((my_exp is null) OR
2773: (trunc(sysdate) between my_start and my_exp)) then

Line 2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);

2766: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2771: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2772: if ((my_exp is null) OR
2773: (trunc(sysdate) between my_start and my_exp)) then
2774: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);

Line 2771: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);

2767: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2768: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2769: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2771: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2772: if ((my_exp is null) OR
2773: (trunc(sysdate) between my_start and my_exp)) then
2774: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2775: else

Line 2774: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);

2770: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2771: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2772: if ((my_exp is null) OR
2773: (trunc(sysdate) between my_start and my_exp)) then
2774: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2775: else
2776: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2777: end if;
2778: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);

Line 2776: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);

2772: if ((my_exp is null) OR
2773: (trunc(sysdate) between my_start and my_exp)) then
2774: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2775: else
2776: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2777: end if;
2778: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2779: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2780: -- bug 4318754

Line 2778: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);

2774: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2775: else
2776: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2777: end if;
2778: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2779: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2780: -- bug 4318754
2781:
2782: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);

Line 2779: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);

2775: else
2776: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2777: end if;
2778: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2779: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2780: -- bug 4318754
2781:
2782: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2783: -- end bug 4318754

Line 2782: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);

2778: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2779: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2780: -- bug 4318754
2781:
2782: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2783: -- end bug 4318754
2784:
2785: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2786: wf_event.AddParameterToList('PER_PERSON_ID',

Line 2785: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);

2781:
2782: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2783: -- end bug 4318754
2784:
2785: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2786: wf_event.AddParameterToList('PER_PERSON_ID',
2787: fnd_number.number_to_canonical(my_empid), mylist);
2788: wf_event.AddParameterToList('PERSON_PARTY_ID',
2789: fnd_number.number_to_canonical(my_partyid), mylist);

Line 2786: wf_event.AddParameterToList('PER_PERSON_ID',

2782: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2783: -- end bug 4318754
2784:
2785: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2786: wf_event.AddParameterToList('PER_PERSON_ID',
2787: fnd_number.number_to_canonical(my_empid), mylist);
2788: wf_event.AddParameterToList('PERSON_PARTY_ID',
2789: fnd_number.number_to_canonical(my_partyid), mylist);
2790: -- bug 4318754

Line 2788: wf_event.AddParameterToList('PERSON_PARTY_ID',

2784:
2785: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2786: wf_event.AddParameterToList('PER_PERSON_ID',
2787: fnd_number.number_to_canonical(my_empid), mylist);
2788: wf_event.AddParameterToList('PERSON_PARTY_ID',
2789: fnd_number.number_to_canonical(my_partyid), mylist);
2790: -- bug 4318754
2791: wf_event.AddParameterToList('OLD_PERSON_PARTY_ID',
2792: fnd_number.number_to_canonical(g_old_person_party_id), mylist);

Line 2791: wf_event.AddParameterToList('OLD_PERSON_PARTY_ID',

2787: fnd_number.number_to_canonical(my_empid), mylist);
2788: wf_event.AddParameterToList('PERSON_PARTY_ID',
2789: fnd_number.number_to_canonical(my_partyid), mylist);
2790: -- bug 4318754
2791: wf_event.AddParameterToList('OLD_PERSON_PARTY_ID',
2792: fnd_number.number_to_canonical(g_old_person_party_id), mylist);
2793: -- end bug 4318754
2794:
2795: -- begin 2850261

Line 2802: wf_event.AddParameterToList('DISPLAYNAME', upper(ptyName), mylist);

2798: exception
2799: when no_data_found then
2800: ptyName := p_user_name;
2801: end;
2802: wf_event.AddParameterToList('DISPLAYNAME', upper(ptyName), mylist);
2803: -- end 2852061
2804:
2805: -- begin bug 2504562
2806: wf_event.AddParameterToList('OLD_USER_NAME', g_old_user_name, mylist);

Line 2806: wf_event.AddParameterToList('OLD_USER_NAME', g_old_user_name, mylist);

2802: wf_event.AddParameterToList('DISPLAYNAME', upper(ptyName), mylist);
2803: -- end 2852061
2804:
2805: -- begin bug 2504562
2806: wf_event.AddParameterToList('OLD_USER_NAME', g_old_user_name, mylist);
2807: /* set g_old_user_name to null here to cover calls to user_synch initiated
2808: from Forms or from the fnd_user_pkg.change_user_name PL/SQL api */
2809: --Comment out this following call because I need it to do the pk children
2810: --later. After pk children update, then I will reset g_old_user_name.

Line 2818: wf_event.AddParameterToList('PREFERREDLANGUAGE', myLang, myList);

2814: --
2815: -- Added calls for the lang/territory and notification preference.
2816: fnd_profile.get_specific(name_z=>'ICX_LANGUAGE', user_id_z=>my_userid,
2817: val_z=>myLang, defined_z=>l_defined_z);
2818: wf_event.AddParameterToList('PREFERREDLANGUAGE', myLang, myList);
2819:
2820: fnd_profile.get_specific(name_z=>'ICX_TERRITORY', user_id_z=>my_userid,
2821: val_z=>myTerr, defined_z=>l_defined_z);
2822:

Line 2823: wf_event.AddParameterToList('ORCLNLSTERRITORY', myTerr, myList);

2819:
2820: fnd_profile.get_specific(name_z=>'ICX_TERRITORY', user_id_z=>my_userid,
2821: val_z=>myTerr, defined_z=>l_defined_z);
2822:
2823: wf_event.AddParameterToList('ORCLNLSTERRITORY', myTerr, myList);
2824:
2825: -- begin bug 3280951
2826: -- Retrieve the notification preference for the user
2827: -- using substr since fnd_preference.get returns varchar2(240)

Line 2837: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',

2833: l_userNTFPref := substr(fnd_preference.get('-WF_DEFAULT-', 'WF', 'MAILTYPE'), 1, 8);
2834:
2835: end if;
2836:
2837: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',
2838: nvl(l_userNTFPref, 'MAILHTML'), mylist);
2839:
2840: -- end bug 3280951
2841:

Line 2844: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',mylist);

2840: -- end bug 3280951
2841:
2842: --Bug 3277794
2843: --Add the over-write parameter to the attribute list
2844: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',mylist);
2845:
2846: --
2847:
2848: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

Line 3778: l_parameter_list wf_parameter_list_t; -- bug 8227171 WF event parameter list

3774: l_api_name CONSTANT varchar2(30) := 'change_user_name';
3775: tmpbuf varchar2(240);
3776: reason varchar2(240);
3777: encpwd varchar2(100);
3778: l_parameter_list wf_parameter_list_t; -- bug 8227171 WF event parameter list
3779:
3780: begin
3781: -- 7311525 do not allow the username of GUEST to be changed
3782: if (upper(x_old_user_name) = 'GUEST') then

Line 3903: -- Raise the WF event oracle.apps.fnd.post.username.change

3899: tmpbuf);
3900: end if;
3901:
3902: -- bug 8227171 change_user_name
3903: -- Raise the WF event oracle.apps.fnd.post.username.change
3904: begin
3905: wf_event.AddParameterToList('OLD_USERNAME', x_old_user_name,
3906: l_parameter_list);
3907: wf_event.raise3(p_event_name =>'oracle.apps.fnd.post.username.change',

Line 3905: wf_event.AddParameterToList('OLD_USERNAME', x_old_user_name,

3901:
3902: -- bug 8227171 change_user_name
3903: -- Raise the WF event oracle.apps.fnd.post.username.change
3904: begin
3905: wf_event.AddParameterToList('OLD_USERNAME', x_old_user_name,
3906: l_parameter_list);
3907: wf_event.raise3(p_event_name =>'oracle.apps.fnd.post.username.change',
3908: p_event_key => x_new_user_name,
3909: p_event_data => NULL,

Line 3907: wf_event.raise3(p_event_name =>'oracle.apps.fnd.post.username.change',

3903: -- Raise the WF event oracle.apps.fnd.post.username.change
3904: begin
3905: wf_event.AddParameterToList('OLD_USERNAME', x_old_user_name,
3906: l_parameter_list);
3907: wf_event.raise3(p_event_name =>'oracle.apps.fnd.post.username.change',
3908: p_event_key => x_new_user_name,
3909: p_event_data => NULL,
3910: p_parameter_list => l_parameter_list,
3911: p_send_date => Sysdate);

Line 4040: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.name.validate',

4036: else
4037: -- we pass the generic validation, it is time to call any
4038: -- customized user name validation if there is any.
4039: begin
4040: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.name.validate',
4041: p_event_key => x_user_name,
4042: p_event_data => NULL,
4043: p_parameters => NULL,
4044: p_send_date => Sysdate);