DBA Data[Home] [Help]

APPS.AMW_VIOLATION_PUB dependencies on FND_USER

Line 31: SELECT user_id INTO p_user_id FROM fnd_user WHERE user_name = p_user_name;

27: ) return NUMBER IS
28: p_user_id NUMBER;
29: BEGIN
30:
31: SELECT user_id INTO p_user_id FROM fnd_user WHERE user_name = p_user_name;
32: RETURN p_user_id;
33: END get_User_Id;
34:
35: -- ===============================================================

Line 158: -- p_user_id := input fnd user_id

154: -- Purpose
155: -- check for OICM SOD constriants that will be violated
156: -- if the user is assigned the additional responsibility
157: -- Params
158: -- p_user_id := input fnd user_id
159: -- p_responsibility_id := input fnd responsibility_id
160: -- Return
161: -- 'N' := if no SOD violation found.
162: -- 'Y' := if SOD violation exists.

Line 662: -- p_user_id := input fnd user_id

658: -- Purpose
659: -- check for OICM SOD constriants that will be violated
660: -- if the user is assigned the additional responsibility
661: -- Params
662: -- p_user_id := input fnd user_id
663: -- p_responsibility_id := input fnd responsibility_id
664: -- Return
665: -- 'N' := if no SOD violation found.
666: -- 'ConstraintName:Resp_name1;Resp_name2;...' := if SOD violation exists.

Line 1396: -- p_user_id := input fnd user_id

1392: -- get a flat string list of this user's existing role display name, together with those new assigned role(among p_role_names_string)
1393: -- may violate the specified constraint
1394: --
1395: -- Params
1396: -- p_user_id := input fnd user_id
1397: -- p_constraint_rev_id := input constraint_rev_id
1398: -- p_constraint_type_code := input constraint type for p_constraint_rev_id
1399: --
1400: -- Return

Line 1490: -- p_user_id := input fnd user_id

1486: -- get a flat string list of this user's existing responsibility display name, together with those new assigned role(among p_role_names_string)
1487: -- may violate the specified constraint
1488: --
1489: -- Params
1490: -- p_user_id := input fnd user_id
1491: -- p_constraint_rev_id := input constraint_rev_id
1492: -- p_constraint_type_code := input constraint type for p_constraint_rev_id
1493: --
1494: -- Return

Line 1601: -- p_user_id := input fnd user_id

1597: -- together with those new assigned role(among p_role_names_string)
1598: -- may violate the specified constraint
1599: --
1600: -- Params
1601: -- p_user_id := input fnd user_id
1602: -- p_constraint_rev_id := input constraint_rev_id
1603: -- p_constraint_type_code := input constraint type for p_constraint_rev_id
1604: --
1605: -- Return