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 1420: SELECT resource_id FROM jtf_rs_resource_extns emp, fnd_user users WHERE

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

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

1460:
1461:
1462: CURSOR l_get_resource_name_csr IS
1463: SELECT source_last_name,source_first_name
1464: from jtf_rs_resource_extns a, fnd_user b, cs_incidents_all_b c
1465: WHERE c.last_updated_by = b.user_id and
1466: b.employee_id = a.source_id and
1467: c.incident_number = l_request_number;
1468:

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

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

Line 6697: -- Procedure : Get_Fnd_User_Role

6693: END pull_from_list;
6694:
6695:
6696: -- ---------------------------------------------------------------------------
6697: -- Procedure : Get_Fnd_User_Role
6698: -- ---------------------------------------------------------------------------
6699:
6700: PROCEDURE Get_Fnd_User_Role
6701: ( p_fnd_user_id IN NUMBER,

Line 6700: PROCEDURE Get_Fnd_User_Role

6696: -- ---------------------------------------------------------------------------
6697: -- Procedure : Get_Fnd_User_Role
6698: -- ---------------------------------------------------------------------------
6699:
6700: PROCEDURE Get_Fnd_User_Role
6701: ( p_fnd_user_id IN NUMBER,
6702: x_role_name OUT NOCOPY VARCHAR2,
6703: x_role_display_name OUT NOCOPY VARCHAR2 ) IS
6704:

Line 6701: ( p_fnd_user_id IN NUMBER,

6697: -- Procedure : Get_Fnd_User_Role
6698: -- ---------------------------------------------------------------------------
6699:
6700: PROCEDURE Get_Fnd_User_Role
6701: ( p_fnd_user_id IN NUMBER,
6702: x_role_name OUT NOCOPY VARCHAR2,
6703: x_role_display_name OUT NOCOPY VARCHAR2 ) IS
6704:
6705: l_employee_id NUMBER;

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

6704:
6705: l_employee_id NUMBER;
6706:
6707: BEGIN
6708: -- map the FND user to employee ID
6709: SELECT employee_id INTO l_employee_id
6710: FROM fnd_user
6711: WHERE user_id = p_fnd_user_id;
6712:

Line 6710: FROM fnd_user

6706:
6707: BEGIN
6708: -- map the FND user to employee ID
6709: SELECT employee_id INTO l_employee_id
6710: FROM fnd_user
6711: WHERE user_id = p_fnd_user_id;
6712:
6713: IF (l_employee_id IS NOT NULL) THEN
6714: wf_directory.getrolename

Line 6711: WHERE user_id = p_fnd_user_id;

6707: BEGIN
6708: -- map the FND user to employee ID
6709: SELECT employee_id INTO l_employee_id
6710: FROM fnd_user
6711: WHERE user_id = p_fnd_user_id;
6712:
6713: IF (l_employee_id IS NOT NULL) THEN
6714: wf_directory.getrolename
6715: ( p_orig_system => 'PER',

Line 6722: p_orig_system_id => p_fnd_user_id,

6718: p_display_name => x_role_display_name );
6719: ELSE
6720: wf_directory.getrolename
6721: ( p_orig_system => 'FND_USR',
6722: p_orig_system_id => p_fnd_user_id,
6723: p_name => x_role_name,
6724: p_display_name => x_role_display_name );
6725: END IF;
6726: END Get_Fnd_User_Role;

Line 6726: END Get_Fnd_User_Role;

6722: p_orig_system_id => p_fnd_user_id,
6723: p_name => x_role_name,
6724: p_display_name => x_role_display_name );
6725: END IF;
6726: END Get_Fnd_User_Role;
6727:
6728:
6729:
6730: /***********************************************************************