DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on WF_EVENT

Line 1598: p_event in out nocopy wf_event_t)

1594: -- retrieves the user's information and updates the
1595: -- corresponding fnd_user as needed, if the user exists.
1596: --
1597: FUNCTION user_change(p_subscription_guid in raw,
1598: p_event in out nocopy wf_event_t)
1599: return varchar2 is
1600: my_ent_type varchar2(50);
1601: my_username varchar2(256); -- one-way code only
1602: my_mode varchar2(256); -- one-way code only

Line 1877: p_event in out nocopy wf_event_t)

1873: -- retrieves the user's information and creates the
1874: -- corresponding fnd_user if the user does not already exist.
1875: --
1876: FUNCTION user_create_rf(p_subscription_guid in raw,
1877: p_event in out nocopy wf_event_t)
1878: return varchar2
1879: is
1880: my_ent_type varchar2(50);
1881: my_cachekey varchar2(256);

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

2154: where user_name = upper(p_user_name);
2155:
2156: -- construct attribute list for wf synch --
2157: -- unstubbed the code
2158: wf_event.AddParameterToList('MAIL', my_email, mylist);
2159: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2160: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2161: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2162: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);

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

2155:
2156: -- construct attribute list for wf synch --
2157: -- unstubbed the code
2158: wf_event.AddParameterToList('MAIL', my_email, mylist);
2159: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2160: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2161: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2162: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2163: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);

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

2156: -- construct attribute list for wf synch --
2157: -- unstubbed the code
2158: wf_event.AddParameterToList('MAIL', my_email, mylist);
2159: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2160: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2161: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2162: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2163: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2164: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);

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

2157: -- unstubbed the code
2158: wf_event.AddParameterToList('MAIL', my_email, mylist);
2159: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2160: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2161: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2162: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2163: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2164: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2165: if ((my_exp is null) OR

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

2158: wf_event.AddParameterToList('MAIL', my_email, mylist);
2159: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2160: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2161: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2162: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2163: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2164: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2165: if ((my_exp is null) OR
2166: (trunc(sysdate) between my_start and my_exp)) then

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

2159: wf_event.AddParameterToList('DESCRIPTION', my_desc, mylist);
2160: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2161: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2162: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2163: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2164: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2165: if ((my_exp is null) OR
2166: (trunc(sysdate) between my_start and my_exp)) then
2167: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);

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

2160: wf_event.AddParameterToList('FACSIMILETELEPHONENUMBER', my_fax, mylist);
2161: wf_event.AddParameterToList('USER_NAME', upper(p_user_name), mylist);
2162: wf_event.AddParameterToList('CN', upper(p_user_name), mylist);
2163: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2164: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2165: if ((my_exp is null) OR
2166: (trunc(sysdate) between my_start and my_exp)) then
2167: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2168: else

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

2163: wf_event.AddParameterToList('SN', upper(p_user_name), mylist);
2164: wf_event.AddParameterToList('ORCLACTIVESTARTDATE', ch_start, mylist);
2165: if ((my_exp is null) OR
2166: (trunc(sysdate) between my_start and my_exp)) then
2167: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2168: else
2169: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2170: end if;
2171: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);

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

2165: if ((my_exp is null) OR
2166: (trunc(sysdate) between my_start and my_exp)) then
2167: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2168: else
2169: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2170: end if;
2171: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2172: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2173: -- bug 4318754

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

2167: wf_event.AddParameterToList('ORCLISENABLED', 'ACTIVE', mylist);
2168: else
2169: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2170: end if;
2171: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2172: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2173: -- bug 4318754
2174:
2175: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);

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

2168: else
2169: wf_event.AddParameterToList('ORCLISENABLED', 'INACTIVE', mylist);
2170: end if;
2171: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2172: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2173: -- bug 4318754
2174:
2175: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2176: -- end bug 4318754

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

2171: wf_event.AddParameterToList('ORCLACTIVEENDDATE', ch_exp, mylist);
2172: wf_event.AddParameterToList('ORCLGUID', my_guid, mylist);
2173: -- bug 4318754
2174:
2175: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2176: -- end bug 4318754
2177:
2178: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2179: wf_event.AddParameterToList('PER_PERSON_ID',

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

2174:
2175: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2176: -- end bug 4318754
2177:
2178: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2179: wf_event.AddParameterToList('PER_PERSON_ID',
2180: fnd_number.number_to_canonical(my_empid), mylist);
2181: wf_event.AddParameterToList('PERSON_PARTY_ID',
2182: fnd_number.number_to_canonical(my_partyid), mylist);

Line 2179: wf_event.AddParameterToList('PER_PERSON_ID',

2175: wf_event.AddParameterToList('OLD_ORCLGUID', g_old_user_guid, mylist);
2176: -- end bug 4318754
2177:
2178: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2179: wf_event.AddParameterToList('PER_PERSON_ID',
2180: fnd_number.number_to_canonical(my_empid), mylist);
2181: wf_event.AddParameterToList('PERSON_PARTY_ID',
2182: fnd_number.number_to_canonical(my_partyid), mylist);
2183: -- bug 4318754

Line 2181: wf_event.AddParameterToList('PERSON_PARTY_ID',

2177:
2178: wf_event.AddParameterToList('USERPASSWORD', my_pwd, mylist);
2179: wf_event.AddParameterToList('PER_PERSON_ID',
2180: fnd_number.number_to_canonical(my_empid), mylist);
2181: wf_event.AddParameterToList('PERSON_PARTY_ID',
2182: fnd_number.number_to_canonical(my_partyid), mylist);
2183: -- bug 4318754
2184: wf_event.AddParameterToList('OLD_PERSON_PARTY_ID',
2185: fnd_number.number_to_canonical(g_old_person_party_id), mylist);

Line 2184: wf_event.AddParameterToList('OLD_PERSON_PARTY_ID',

2180: fnd_number.number_to_canonical(my_empid), mylist);
2181: wf_event.AddParameterToList('PERSON_PARTY_ID',
2182: fnd_number.number_to_canonical(my_partyid), mylist);
2183: -- bug 4318754
2184: wf_event.AddParameterToList('OLD_PERSON_PARTY_ID',
2185: fnd_number.number_to_canonical(g_old_person_party_id), mylist);
2186: -- end bug 4318754
2187:
2188: -- begin 2850261

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

2191: exception
2192: when no_data_found then
2193: ptyName := p_user_name;
2194: end;
2195: wf_event.AddParameterToList('DISPLAYNAME', upper(ptyName), mylist);
2196: -- end 2852061
2197:
2198: -- begin bug 2504562
2199: wf_event.AddParameterToList('OLD_USER_NAME', g_old_user_name, mylist);

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

2195: wf_event.AddParameterToList('DISPLAYNAME', upper(ptyName), mylist);
2196: -- end 2852061
2197:
2198: -- begin bug 2504562
2199: wf_event.AddParameterToList('OLD_USER_NAME', g_old_user_name, mylist);
2200: /* set g_old_user_name to null here to cover calls to user_synch initiated
2201: from Forms or from the fnd_user_pkg.change_user_name PL/SQL api */
2202: --Comment out this following call because I need it to do the pk children
2203: --later. After pk children update, then I will reset g_old_user_name.

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

2207: --
2208: -- Added calls for the lang/territory and notification preference.
2209: fnd_profile.get_specific(name_z=>'ICX_LANGUAGE', user_id_z=>my_userid,
2210: val_z=>myLang, defined_z=>l_defined_z);
2211: wf_event.AddParameterToList('PREFERREDLANGUAGE', myLang, myList);
2212:
2213: fnd_profile.get_specific(name_z=>'ICX_TERRITORY', user_id_z=>my_userid,
2214: val_z=>myTerr, defined_z=>l_defined_z);
2215:

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

2212:
2213: fnd_profile.get_specific(name_z=>'ICX_TERRITORY', user_id_z=>my_userid,
2214: val_z=>myTerr, defined_z=>l_defined_z);
2215:
2216: wf_event.AddParameterToList('ORCLNLSTERRITORY', myTerr, myList);
2217:
2218: -- begin bug 3280951
2219: -- Retrieve the notification preference for the user
2220: -- using substr since fnd_preference.get returns varchar2(240)

Line 2230: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',

2226: l_userNTFPref := substr(fnd_preference.get('-WF_DEFAULT-', 'WF', 'MAILTYPE'), 1, 8);
2227:
2228: end if;
2229:
2230: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',
2231: nvl(l_userNTFPref, 'MAILHTML'), mylist);
2232:
2233: -- end bug 3280951
2234:

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

2233: -- end bug 3280951
2234:
2235: --Bug 3277794
2236: --Add the over-write parameter to the attribute list
2237: wf_event.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',mylist);
2238:
2239: --
2240:
2241: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

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

3354: else
3355: -- we pass the generic validation, it is time to call any
3356: -- customized user name validation if there is any.
3357: begin
3358: wf_event.raise(p_event_name => 'oracle.apps.fnd.user.name.validate',
3359: p_event_key => x_user_name,
3360: p_event_data => NULL,
3361: p_parameters => NULL,
3362: p_send_date => Sysdate);