DBA Data[Home] [Help]

APPS.UMX_USERNAME_POLICY_PVT dependencies on FND_USER

Line 24: x_suggested_username out nocopy FND_USER.USER_NAME%TYPE) is

20: -- x_suggested_username: Username generated by the Username Policy. May return null.
21: --
22: --
23: procedure get_suggested_username (p_person_party_id in HZ_PARTIES.PARTY_ID%TYPE default null,
24: x_suggested_username out nocopy FND_USER.USER_NAME%TYPE) is
25:
26: l_parameter_list wf_parameter_list_t;
27: l_event_key varchar2 (240);
28:

Line 99: -- is copied into the fnd_user.email_address field

95: -- Meaning: User name should be defined as Email Address.
96: -- Product teams may choose to hide the email
97: -- field in any account creation / registration
98: -- UI's as long as the entered username (email)
99: -- is copied into the fnd_user.email_address field
100: -- as well.
101: --
102: -- Code: UMX_USERNAME_POLICY:NONE
103: -- Meaning: No username policy / format defined, freetext

Line 227: l_username fnd_user.user_name%type;

223: function policy_subscription (p_subscription_guid in raw,
224: p_event in out nocopy WF_EVENT_T) return varchar2 is
225:
226: l_person_party_id HZ_PARTIES.PARTY_ID%type;
227: l_username fnd_user.user_name%type;
228:
229: begin
230:
231: l_person_party_id := p_event.getValueForParameter ('UMX_PERSON_PARTY_ID');

Line 294: x_generated_username out NOCOPY FND_USER.USER_NAME%TYPE,

290: --
291: Procedure run_policy (
292: p_reg_serv_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE,
293: p_person_party_id in HZ_PARTIES.PARTY_ID%TYPE,
294: x_generated_username out NOCOPY FND_USER.USER_NAME%TYPE,
295: x_policy_override out NOCOPY varchar2,
296: x_policy_code out NOCOPY varchar2,
297: x_policy_name out NOCOPY varchar2,
298: x_policy_desc out NOCOPY varchar2,

Line 303: l_user_id FND_USER.USER_ID%type;

299: x_result_code out NOCOPY varchar2,
300: x_error_msg out NOCOPY varchar2
301: ) is
302:
303: l_user_id FND_USER.USER_ID%type;
304: l_person_party_id FND_USER.PERSON_PARTY_ID%type;
305:
306: begin
307:

Line 304: l_person_party_id FND_USER.PERSON_PARTY_ID%type;

300: x_error_msg out NOCOPY varchar2
301: ) is
302:
303: l_user_id FND_USER.USER_ID%type;
304: l_person_party_id FND_USER.PERSON_PARTY_ID%type;
305:
306: begin
307:
308: run_policy (p_reg_serv_code, p_person_party_id, x_generated_username,

Line 351: x_generated_username out NOCOPY FND_USER.USER_NAME%TYPE,

347: --
348: Procedure run_policy (
349: p_reg_serv_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE,
350: p_person_party_id in HZ_PARTIES.PARTY_ID%TYPE,
351: x_generated_username out NOCOPY FND_USER.USER_NAME%TYPE,
352: x_policy_override out NOCOPY varchar2,
353: x_policy_code out NOCOPY varchar2,
354: x_policy_name out NOCOPY varchar2,
355: x_policy_desc out NOCOPY varchar2,

Line 358: x_exist_user_id out NOCOPY FND_USER.USER_ID%TYPE,

354: x_policy_name out NOCOPY varchar2,
355: x_policy_desc out NOCOPY varchar2,
356: x_result_code out NOCOPY varchar2,
357: x_error_msg out NOCOPY varchar2,
358: x_exist_user_id out NOCOPY FND_USER.USER_ID%TYPE,
359: x_exist_per_party_id out NOCOPY FND_USER.PERSON_PARTY_ID%TYPE
360: ) is
361: cursor getRegTypeCode (l_reg_serv_code in UMX_reg_services_b.reg_service_code%type) is
362: select reg_service_type

Line 359: x_exist_per_party_id out NOCOPY FND_USER.PERSON_PARTY_ID%TYPE

355: x_policy_desc out NOCOPY varchar2,
356: x_result_code out NOCOPY varchar2,
357: x_error_msg out NOCOPY varchar2,
358: x_exist_user_id out NOCOPY FND_USER.USER_ID%TYPE,
359: x_exist_per_party_id out NOCOPY FND_USER.PERSON_PARTY_ID%TYPE
360: ) is
361: cursor getRegTypeCode (l_reg_serv_code in UMX_reg_services_b.reg_service_code%type) is
362: select reg_service_type
363: from UMX_reg_services_b

Line 366: cursor get_person_party_id (p_user_name in FND_USER.USER_NAME%type) is

362: select reg_service_type
363: from UMX_reg_services_b
364: where reg_service_code = l_reg_serv_code;
365:
366: cursor get_person_party_id (p_user_name in FND_USER.USER_NAME%type) is
367: select user_id, person_party_id
368: from fnd_user
369: where user_name = p_user_name;
370:

Line 368: from fnd_user

364: where reg_service_code = l_reg_serv_code;
365:
366: cursor get_person_party_id (p_user_name in FND_USER.USER_NAME%type) is
367: select user_id, person_party_id
368: from fnd_user
369: where user_name = p_user_name;
370:
371: l_reg_type_code UMX_reg_services_b.reg_service_type%type;
372: l_itemkey varchar2 (6) := '#SYNCH';

Line 597: -- (OBSOLETED) Check if the username is available in FND_USER table

593: -- Procedure
594: -- chk_username_avail
595: --
596: -- Description
597: -- (OBSOLETED) Check if the username is available in FND_USER table
598: -- IN
599: -- itemtype - A valid item type from (WF_ITEM_TYPES table).
600: -- itemkey - A string generated from the application object's primary key.
601: -- actid - The function activity(instance id).

Line 615: cursor checkUsername (l_username in fnd_user.user_name%type)is

611:
612: l_username wf_item_attribute_values.text_value%type;
613: errorMess varchar2 (30) := null;
614:
615: cursor checkUsername (l_username in fnd_user.user_name%type)is
616: select 1
617: from fnd_user
618: where user_name = l_username;
619:

Line 617: from fnd_user

613: errorMess varchar2 (30) := null;
614:
615: cursor checkUsername (l_username in fnd_user.user_name%type)is
616: select 1
617: from fnd_user
618: where user_name = l_username;
619:
620: begin
621: