APPS.UMX_USERNAME_POLICY_PVT dependencies on UMX_REG_SERVICES_B

Line 292: p_reg_serv_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE,

288: -- x_error_msg: Description why the Username Policy failed
289: --
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,

Line 349: p_reg_serv_code in UMX_REG_SERVICES_B.REG_SERVICE_CODE%TYPE,

345: -- x_exist_per_party_id: Person party ID of the existing person.
346: --
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,

Line 361: cursor getRegTypeCode (l_reg_serv_code in UMX_reg_services_b.reg_service_code%type) is

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
364: where reg_service_code = l_reg_serv_code;
365:

Line 363: from UMX_reg_services_b

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

Line 371: l_reg_type_code UMX_reg_services_b.reg_service_type%type;

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';
373:
374: begin
375:

Line 383: -- Get the Registration Type Code from UMX_REG_SERVICES_B

379: 'p_reg_serv_code: ' || p_reg_serv_code ||
380: ' | p_person_party_id: ' || p_person_party_id);
381: end if;
382:
383: -- Get the Registration Type Code from UMX_REG_SERVICES_B
384: open getRegTypeCode (p_reg_serv_code);
385: fetch getRegTypeCode into l_reg_type_code;
386: if (getRegTypeCode%notfound) then
387: -- Cannot find the Registration Type Code, raise error