APPS.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on FND_USER

Line 690: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE

686: SELECT incident_owner_id FROM cs_incidents_all_b WHERE
687: incident_id = l_request_id;
688:
689: CURSOR sel_resource_id IS
690: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE
691: emp.source_id = users.employee_id and
692: users.user_id = l_user_id;
693:
694: CURSOR sel_prev_owner_id IS

Line 1416: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE

1412: l_resource_id NUMBER;
1413: l_user_id NUMBER;
1414:
1415: CURSOR sel_resource_id IS
1416: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE
1417: emp.source_id = users.employee_id and
1418: users.user_id = l_user_id;
1419:
1420: /* Roopa - begin

Line 1460: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c

1456:
1457:
1458: CURSOR l_get_resource_name_csr IS
1459: SELECT source_last_name,source_first_name
1460: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1461: WHERE c.last_updated_by = b.user_id and
1462: b.employee_id = a.source_id and
1463: c.incident_number = l_request_number;
1464:

Line 1469: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c

1465: l_get_resource_name_rec l_get_resource_name_csr%ROWTYPE;
1466:
1467: CURSOR l_get_create_rsrc_csr IS
1468: SELECT source_last_name,source_first_name
1469: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1470: WHERE c.created_by = b.user_id and
1471: b.employee_id = a.source_id and
1472: c.incident_number = l_request_number;
1473:

Line 6633: -- Procedure : Get_Fnd_User_Role

6629: END pull_from_list;
6630:
6631:
6632: -- ---------------------------------------------------------------------------
6633: -- Procedure : Get_Fnd_User_Role
6634: -- ---------------------------------------------------------------------------
6635:
6636: PROCEDURE Get_Fnd_User_Role
6637: ( p_fnd_user_id IN NUMBER,

Line 6636: PROCEDURE Get_Fnd_User_Role

6632: -- ---------------------------------------------------------------------------
6633: -- Procedure : Get_Fnd_User_Role
6634: -- ---------------------------------------------------------------------------
6635:
6636: PROCEDURE Get_Fnd_User_Role
6637: ( p_fnd_user_id IN NUMBER,
6638: x_role_name OUT NOCOPY VARCHAR2,
6639: x_role_display_name OUT NOCOPY VARCHAR2 ) IS
6640:

Line 6637: ( p_fnd_user_id IN NUMBER,

6633: -- Procedure : Get_Fnd_User_Role
6634: -- ---------------------------------------------------------------------------
6635:
6636: PROCEDURE Get_Fnd_User_Role
6637: ( p_fnd_user_id IN NUMBER,
6638: x_role_name OUT NOCOPY VARCHAR2,
6639: x_role_display_name OUT NOCOPY VARCHAR2 ) IS
6640:
6641: l_employee_id NUMBER;

Line 6644: -- map the FND user to employee ID

6640:
6641: l_employee_id NUMBER;
6642:
6643: BEGIN
6644: -- map the FND user to employee ID
6645: SELECT employee_id INTO l_employee_id
6646: FROM fnd_user
6647: WHERE user_id = p_fnd_user_id;
6648:

Line 6646: FROM fnd_user

6642:
6643: BEGIN
6644: -- map the FND user to employee ID
6645: SELECT employee_id INTO l_employee_id
6646: FROM fnd_user
6647: WHERE user_id = p_fnd_user_id;
6648:
6649: IF (l_employee_id IS NOT NULL) THEN
6650: wf_directory.getrolename

Line 6647: WHERE user_id = p_fnd_user_id;

6643: BEGIN
6644: -- map the FND user to employee ID
6645: SELECT employee_id INTO l_employee_id
6646: FROM fnd_user
6647: WHERE user_id = p_fnd_user_id;
6648:
6649: IF (l_employee_id IS NOT NULL) THEN
6650: wf_directory.getrolename
6651: ( p_orig_system => 'PER',

Line 6658: p_orig_system_id => p_fnd_user_id,

6654: p_display_name => x_role_display_name );
6655: ELSE
6656: wf_directory.getrolename
6657: ( p_orig_system => 'FND_USR',
6658: p_orig_system_id => p_fnd_user_id,
6659: p_name => x_role_name,
6660: p_display_name => x_role_display_name );
6661: END IF;
6662: END Get_Fnd_User_Role;

Line 6662: END Get_Fnd_User_Role;

6658: p_orig_system_id => p_fnd_user_id,
6659: p_name => x_role_name,
6660: p_display_name => x_role_display_name );
6661: END IF;
6662: END Get_Fnd_User_Role;
6663:
6664:
6665:
6666: /***********************************************************************