DBA Data[Home] [Help]

APPS.CS_KB_WF_PKG dependencies on FND_USER

Line 211: -- h_user_id = the fnd_user user id

207: -- This one DOES have profile checking.
208: --
209: -- VARIABLES
210: -- h_Step = Step to check
211: -- h_user_id = the fnd_user user id
212: -- h_set_id
213: /*******************************************************************/
214: --FUNCTION hasPermission(
215: -- h_flow_details_id IN NUMBER,

Line 239: -- h_user_id = the fnd_user user id

235: -- to a specific Step.
236: --
237: -- VARIABLES
238: -- h_Step = Step to check
239: -- h_user_id = the fnd_user user id
240: --
241: /*******************************************************************/
242: FUNCTION inCategory(
243: c_user_id IN NUMBER,

Line 282: -- c_set_id = the fnd_user user id

278: -- product as solution.
279: --
280: -- VARIABLES
281: -- c_user_id = Step to check
282: -- c_set_id = the fnd_user user id
283: --
284: /*******************************************************************/
285: FUNCTION inProduct(
286: c_user_id IN NUMBER,

Line 328: -- user_id = the fnd_user user id

324: --
325: -- INTERNAL USE MAINLY
326: --
327: -- VARIABLES
328: -- user_id = the fnd_user user id
329: -- group_id =
330: --
331: /*******************************************************************/
332: FUNCTION isMember(

Line 342: min(fnd_user.user_id)

338: m_temp NUMBER;
339: return_value NUMBER;
340: BEGIN
341: SELECT
342: min(fnd_user.user_id)
343: INTO
344: m_temp
345: FROM
346: fnd_user,

Line 346: fnd_user,

342: min(fnd_user.user_id)
343: INTO
344: m_temp
345: FROM
346: fnd_user,
347: jtf_rs_resource_extns,
348: jtf_rs_group_members
349: WHERE
350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id

Line 352: fnd_user.user_id=m_user_id

348: jtf_rs_group_members
349: WHERE
350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
351: AND
352: fnd_user.user_id=m_user_id
353: AND
354: jtf_rs_group_members.group_id=m_group_id
355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'
356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate

Line 359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id

355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'
356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
358: AND (
359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id

Line 363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id

359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
364: AND
365: jtf_rs_resource_extns.category ='PARTY'));
366:
367:

Line 1517: x_original_author_id FND_USER.USER_ID%TYPE;

1513: p_locked_by NUMBER;
1514: current_id NUMBER;
1515: user_id NUMBER := fnd_global.user_id;
1516: set_id NUMBER := p_set_id;
1517: x_original_author_id FND_USER.USER_ID%TYPE;
1518: x_author FND_USER.USER_NAME%TYPE;
1519: x_new_step number;
1520:
1521: BEGIN

Line 1518: x_author FND_USER.USER_NAME%TYPE;

1514: current_id NUMBER;
1515: user_id NUMBER := fnd_global.user_id;
1516: set_id NUMBER := p_set_id;
1517: x_original_author_id FND_USER.USER_ID%TYPE;
1518: x_author FND_USER.USER_NAME%TYPE;
1519: x_new_step number;
1520:
1521: BEGIN
1522:

Line 1615: from fnd_user

1611: p_group_id, solution_title );
1612: ELSE
1613: /*select user_name
1614: into x_author
1615: from fnd_user
1616: where user_id = x_original_author_id;*/
1617: FOR get_user IN --Bugfix7117561 - get the users to whom we need to send notifications
1618: (
1619: SELECT DISTINCT user_id, user_name

Line 1623: FROM cs_kb_sets_b a, fnd_user b

1619: SELECT DISTINCT user_id, user_name
1620: FROM
1621: (
1622: SELECT user_id, user_name
1623: FROM cs_kb_sets_b a, fnd_user b
1624: WHERE set_id IN (
1625: SELECT MIN(set_id)
1626: FROM cs_kb_sets_b
1627: WHERE set_number = p_set_number

Line 1632: FROM cs_kb_sets_b a, fnd_user b

1628: )
1629: AND a.created_by = b.user_id
1630: UNION
1631: SELECT user_id, user_name
1632: FROM cs_kb_sets_b a, fnd_user b
1633: WHERE set_id IN (
1634: SELECT MAX(set_id) --Bug fix:7159784 - made it max(set_id) to get the last updater
1635: FROM cs_kb_sets_b
1636: WHERE set_number = p_set_number AND

Line 1723: fnd_user.user_name,

1719:
1720:
1721: CURSOR Get_Group_Members (v_group_id IN NUMBER) IS
1722: SELECT DISTINCT
1723: fnd_user.user_name,
1724: fnd_user.user_id
1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members

Line 1724: fnd_user.user_id

1720:
1721: CURSOR Get_Group_Members (v_group_id IN NUMBER) IS
1722: SELECT DISTINCT
1723: fnd_user.user_name,
1724: fnd_user.user_id
1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id

Line 1725: FROM fnd_user,

1721: CURSOR Get_Group_Members (v_group_id IN NUMBER) IS
1722: SELECT DISTINCT
1723: fnd_user.user_name,
1724: fnd_user.user_id
1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id

Line 1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id

1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );

Line 1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id

1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
1738:
1739: BEGIN