DBA Data[Home] [Help]

APPS.FEM_FEMAPPR_ITEM_TYPE dependencies on FND_USER

Line 62: t_user_id FND_USER.user_id%TYPE;

58: t_item_key WF_ITEMS.item_key%TYPE;
59:
60: -- Oracle Applications
61: t_org_id number;
62: t_user_id FND_USER.user_id%TYPE;
63: t_user_name FND_USER.user_name%TYPE;
64: t_responsibility_id FND_RESPONSIBILITY.responsibility_id%TYPE;
65: t_application_id FND_APPLICATION.application_id%TYPE;
66:

Line 63: t_user_name FND_USER.user_name%TYPE;

59:
60: -- Oracle Applications
61: t_org_id number;
62: t_user_id FND_USER.user_id%TYPE;
63: t_user_name FND_USER.user_name%TYPE;
64: t_responsibility_id FND_RESPONSIBILITY.responsibility_id%TYPE;
65: t_application_id FND_APPLICATION.application_id%TYPE;
66:
67: -- Oracle Approval Management (AME)

Line 196: -- p_user_id - FND User ID

192: --
193: -- IN
194: -- p_event_name - Business Event Name
195: -- p_request_id - Workflow Request Id (FEM_WF_REQUEST_ID_SEQ)
196: -- p_user_id - FND User ID
197: -- p_user_name - FND User Name
198: -- p_responsibility_id - FND Responsibility ID
199: -- p_application_id - FND Application ID
200: -- p_org_id - FND Organization ID

Line 197: -- p_user_name - FND User Name

193: -- IN
194: -- p_event_name - Business Event Name
195: -- p_request_id - Workflow Request Id (FEM_WF_REQUEST_ID_SEQ)
196: -- p_user_id - FND User ID
197: -- p_user_name - FND User Name
198: -- p_responsibility_id - FND Responsibility ID
199: -- p_application_id - FND Application ID
200: -- p_org_id - FND Organization ID
201: --

Line 1910: -- Gets the FND user id.

1906: -- FUNCTION
1907: -- GetUserId
1908: --
1909: -- DESCRIPTION
1910: -- Gets the FND user id.
1911: --
1912: -- IN
1913: -- p_user_name - FND User Name
1914: --

Line 1913: -- p_user_name - FND User Name

1909: -- DESCRIPTION
1910: -- Gets the FND user id.
1911: --
1912: -- IN
1913: -- p_user_name - FND User Name
1914: --
1915: -- RETURNS
1916: -- user_id - FND User Id
1917: --

Line 1916: -- user_id - FND User Id

1912: -- IN
1913: -- p_user_name - FND User Name
1914: --
1915: -- RETURNS
1916: -- user_id - FND User Id
1917: --
1918: --------------------------------------------------------------------------------
1919: FUNCTION GetUserId (
1920: p_user_name in varchar2

Line 1926: l_user_id fnd_user.user_id%TYPE := -1;

1922: RETURN t_id%TYPE
1923: --------------------------------------------------------------------------------
1924: IS
1925:
1926: l_user_id fnd_user.user_id%TYPE := -1;
1927:
1928: BEGIN
1929:
1930: select user_id

Line 1932: from fnd_user

1928: BEGIN
1929:
1930: select user_id
1931: into l_user_id
1932: from fnd_user
1933: where user_name = p_user_name;
1934:
1935: return l_user_id;
1936: