DBA Data[Home] [Help]

APPS.CS_WORKFLOW_PUB dependencies on FND_USER

Line 23: -- Procedure : Get_Fnd_User_Role

19: p_emp_first_name IN VARCHAR2 ,
20: p_employee_id_out OUT NOCOPY NUMBER );
21:
22: ------------------------------------------------------------------------------
23: -- Procedure : Get_Fnd_User_Role
24: -- Description : Get the Workflow role of the given FND user
25: -- Parameters :
26: -- IN : p_fnd_user_id IN NUMBER Required
27: -- Corresponds to the column USER_ID in the table

Line 24: -- Description : Get the Workflow role of the given FND user

20: p_employee_id_out OUT NOCOPY NUMBER );
21:
22: ------------------------------------------------------------------------------
23: -- Procedure : Get_Fnd_User_Role
24: -- Description : Get the Workflow role of the given FND user
25: -- Parameters :
26: -- IN : p_fnd_user_id IN NUMBER Required
27: -- Corresponds to the column USER_ID in the table
28: -- FND_USER, and identifies the Oracle Applications user

Line 26: -- IN : p_fnd_user_id IN NUMBER Required

22: ------------------------------------------------------------------------------
23: -- Procedure : Get_Fnd_User_Role
24: -- Description : Get the Workflow role of the given FND user
25: -- Parameters :
26: -- IN : p_fnd_user_id IN NUMBER Required
27: -- Corresponds to the column USER_ID in the table
28: -- FND_USER, and identifies the Oracle Applications user
29: -- OUT : x_role_name OUT VARCHAR2(100)
30: -- Workflow role name of the Applications user

Line 28: -- FND_USER, and identifies the Oracle Applications user

24: -- Description : Get the Workflow role of the given FND user
25: -- Parameters :
26: -- IN : p_fnd_user_id IN NUMBER Required
27: -- Corresponds to the column USER_ID in the table
28: -- FND_USER, and identifies the Oracle Applications user
29: -- OUT : x_role_name OUT VARCHAR2(100)
30: -- Workflow role name of the Applications user
31: -- x_role_display_name OUT VARCHAR2(100)
32: -- Workflow role display name of the Applications user

Line 35: PROCEDURE Get_Fnd_User_Role

31: -- x_role_display_name OUT VARCHAR2(100)
32: -- Workflow role display name of the Applications user
33: ------------------------------------------------------------------------------
34:
35: PROCEDURE Get_Fnd_User_Role
36: ( p_fnd_user_id IN NUMBER,
37: x_role_name OUT NOCOPY VARCHAR2,
38: x_role_display_name OUT NOCOPY VARCHAR2 );
39:

Line 36: ( p_fnd_user_id IN NUMBER,

32: -- Workflow role display name of the Applications user
33: ------------------------------------------------------------------------------
34:
35: PROCEDURE Get_Fnd_User_Role
36: ( p_fnd_user_id IN NUMBER,
37: x_role_name OUT NOCOPY VARCHAR2,
38: x_role_display_name OUT NOCOPY VARCHAR2 );
39:
40: /****************************************************************************

Line 290: get_fnd_user_role

286: --dbms_output.put_line('item-key ' || l_itemkey);
287:
288: -- Get the process initiator's workflow role name
289: IF (p_initiator_user_id IS NOT NULL) THEN
290: get_fnd_user_role
291: ( p_fnd_user_id => p_initiator_user_id,
292: x_role_name => l_initiator_role,
293: x_role_display_name => l_dummy );
294: END IF;

Line 291: ( p_fnd_user_id => p_initiator_user_id,

287:
288: -- Get the process initiator's workflow role name
289: IF (p_initiator_user_id IS NOT NULL) THEN
290: get_fnd_user_role
291: ( p_fnd_user_id => p_initiator_user_id,
292: x_role_name => l_initiator_role,
293: x_role_display_name => l_dummy );
294: END IF;
295:

Line 775: -- If we can't get that information, just use the FND username

771: END IF;
772:
773: --
774: -- Get the employee name of the user who is aborting the process
775: -- If we can't get that information, just use the FND username
776: --
777: SELECT fnd.user_name, emp.full_name
778: INTO l_user_name, l_emp_name
779: FROM fnd_user fnd, per_people_x emp

Line 777: SELECT fnd.user_name, emp.full_name

773: --
774: -- Get the employee name of the user who is aborting the process
775: -- If we can't get that information, just use the FND username
776: --
777: SELECT fnd.user_name, emp.full_name
778: INTO l_user_name, l_emp_name
779: FROM fnd_user fnd, per_people_x emp
780: WHERE fnd.user_id = p_user_id
781: AND fnd.employee_id = emp.person_id (+);

Line 779: FROM fnd_user fnd, per_people_x emp

775: -- If we can't get that information, just use the FND username
776: --
777: SELECT fnd.user_name, emp.full_name
778: INTO l_user_name, l_emp_name
779: FROM fnd_user fnd, per_people_x emp
780: WHERE fnd.user_id = p_user_id
781: AND fnd.employee_id = emp.person_id (+);
782:
783: IF (l_emp_name IS NOT NULL) THEN

Line 780: WHERE fnd.user_id = p_user_id

776: --
777: SELECT fnd.user_name, emp.full_name
778: INTO l_user_name, l_emp_name
779: FROM fnd_user fnd, per_people_x emp
780: WHERE fnd.user_id = p_user_id
781: AND fnd.employee_id = emp.person_id (+);
782:
783: IF (l_emp_name IS NOT NULL) THEN
784: l_aborted_by := l_emp_name;

Line 1279: -- Get_Emp_Fnd_User_ID

1275: END Get_Emp_Supervisor;
1276:
1277:
1278: -- -----------------------------------------------------------------------
1279: -- Get_Emp_Fnd_User_ID
1280: -- -----------------------------------------------------------------------
1281:
1282: PROCEDURE Get_Emp_Fnd_User_ID(
1283: p_api_version IN NUMBER,

Line 1282: PROCEDURE Get_Emp_Fnd_User_ID(

1278: -- -----------------------------------------------------------------------
1279: -- Get_Emp_Fnd_User_ID
1280: -- -----------------------------------------------------------------------
1281:
1282: PROCEDURE Get_Emp_Fnd_User_ID(
1283: p_api_version IN NUMBER,
1284: p_init_msg_list IN VARCHAR2 ,
1285: p_return_status OUT NOCOPY VARCHAR2,
1286: p_msg_count OUT NOCOPY NUMBER,

Line 1291: p_fnd_user_id OUT NOCOPY NUMBER ) IS

1287: p_msg_data OUT NOCOPY VARCHAR2,
1288: p_employee_id IN NUMBER ,
1289: p_emp_last_name IN VARCHAR2 ,
1290: p_emp_first_name IN VARCHAR2 ,
1291: p_fnd_user_id OUT NOCOPY NUMBER ) IS
1292:
1293: l_api_name CONSTANT VARCHAR2(30) := 'Get_Emp_Fnd_User_ID';
1294: l_api_version CONSTANT NUMBER := 1.0;
1295: l_msg_count NUMBER;

Line 1293: l_api_name CONSTANT VARCHAR2(30) := 'Get_Emp_Fnd_User_ID';

1289: p_emp_last_name IN VARCHAR2 ,
1290: p_emp_first_name IN VARCHAR2 ,
1291: p_fnd_user_id OUT NOCOPY NUMBER ) IS
1292:
1293: l_api_name CONSTANT VARCHAR2(30) := 'Get_Emp_Fnd_User_ID';
1294: l_api_version CONSTANT NUMBER := 1.0;
1295: l_msg_count NUMBER;
1296: l_msg_data VARCHAR2(2000);
1297: l_return_status VARCHAR2(1);

Line 1302: FROM fnd_user

1298: l_employee_id NUMBER;
1299:
1300: CURSOR l_emp_csr IS
1301: SELECT user_id
1302: FROM fnd_user
1303: WHERE employee_id = l_employee_id;
1304:
1305: BEGIN
1306:

Line 1345: FETCH l_emp_csr INTO p_fnd_user_id;

1341: -- Bug 654417: TOO_MANY_ROWS exception when SELECT INTO statement
1342: -- returns more than one row
1343: -- The FETCH statement raises neither NO_DATA_FOUND nor TOO_MANY_ROWS
1344: OPEN l_emp_csr;
1345: FETCH l_emp_csr INTO p_fnd_user_id;
1346: CLOSE l_emp_csr;
1347:
1348: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1349: p_data => p_msg_data );

Line 1371: END Get_Emp_Fnd_User_ID;

1367: END IF;
1368: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1369: p_data => p_msg_data );
1370:
1371: END Get_Emp_Fnd_User_ID;
1372:
1373:
1374: ----------------------------------------------------------------------
1375: -- Launch_Action_Workflow

Line 1533: get_fnd_user_role

1529: l_itemkey := p_request_id || '-' || p_action_number || '-' || l_wf_process_id;
1530:
1531: -- Get the process initiator's workflow role name
1532: IF (p_initiator_user_id IS NOT NULL) THEN
1533: get_fnd_user_role
1534: ( p_fnd_user_id => p_initiator_user_id,
1535: x_role_name => l_initiator_role,
1536: x_role_display_name => l_dummy );
1537: END IF;

Line 1534: ( p_fnd_user_id => p_initiator_user_id,

1530:
1531: -- Get the process initiator's workflow role name
1532: IF (p_initiator_user_id IS NOT NULL) THEN
1533: get_fnd_user_role
1534: ( p_fnd_user_id => p_initiator_user_id,
1535: x_role_name => l_initiator_role,
1536: x_role_display_name => l_dummy );
1537: END IF;
1538:

Line 1849: -- If we can't get that information, just use the FND username

1845: END IF;
1846:
1847: --
1848: -- Get the employee name of the user who is aborting the process
1849: -- If we can't get that information, just use the FND username
1850: --
1851: SELECT fnd.user_name, emp.full_name
1852: INTO l_user_name, l_emp_name
1853: FROM fnd_user fnd, per_people_x emp

Line 1851: SELECT fnd.user_name, emp.full_name

1847: --
1848: -- Get the employee name of the user who is aborting the process
1849: -- If we can't get that information, just use the FND username
1850: --
1851: SELECT fnd.user_name, emp.full_name
1852: INTO l_user_name, l_emp_name
1853: FROM fnd_user fnd, per_people_x emp
1854: WHERE fnd.user_id = p_abort_user_id
1855: AND fnd.employee_id = emp.person_id (+);

Line 1853: FROM fnd_user fnd, per_people_x emp

1849: -- If we can't get that information, just use the FND username
1850: --
1851: SELECT fnd.user_name, emp.full_name
1852: INTO l_user_name, l_emp_name
1853: FROM fnd_user fnd, per_people_x emp
1854: WHERE fnd.user_id = p_abort_user_id
1855: AND fnd.employee_id = emp.person_id (+);
1856:
1857: IF (l_emp_name IS NOT NULL) THEN

Line 1854: WHERE fnd.user_id = p_abort_user_id

1850: --
1851: SELECT fnd.user_name, emp.full_name
1852: INTO l_user_name, l_emp_name
1853: FROM fnd_user fnd, per_people_x emp
1854: WHERE fnd.user_id = p_abort_user_id
1855: AND fnd.employee_id = emp.person_id (+);
1856:
1857: IF (l_emp_name IS NOT NULL) THEN
1858: l_aborted_by := l_emp_name;

Line 2249: -- Procedure : Get_Fnd_User_Role

2245:
2246: END Get_Employee_ID;
2247:
2248: ------------------------------------------------------------------------------
2249: -- Procedure : Get_Fnd_User_Role
2250: ------------------------------------------------------------------------------
2251:
2252: PROCEDURE Get_Fnd_User_Role
2253: ( p_fnd_user_id IN NUMBER,

Line 2252: PROCEDURE Get_Fnd_User_Role

2248: ------------------------------------------------------------------------------
2249: -- Procedure : Get_Fnd_User_Role
2250: ------------------------------------------------------------------------------
2251:
2252: PROCEDURE Get_Fnd_User_Role
2253: ( p_fnd_user_id IN NUMBER,
2254: x_role_name OUT NOCOPY VARCHAR2,
2255: x_role_display_name OUT NOCOPY VARCHAR2 )
2256: IS

Line 2253: ( p_fnd_user_id IN NUMBER,

2249: -- Procedure : Get_Fnd_User_Role
2250: ------------------------------------------------------------------------------
2251:
2252: PROCEDURE Get_Fnd_User_Role
2253: ( p_fnd_user_id IN NUMBER,
2254: x_role_name OUT NOCOPY VARCHAR2,
2255: x_role_display_name OUT NOCOPY VARCHAR2 )
2256: IS
2257: l_employee_id NUMBER;

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

2255: x_role_display_name OUT NOCOPY VARCHAR2 )
2256: IS
2257: l_employee_id NUMBER;
2258: BEGIN
2259: -- map the FND user to employee ID
2260: SELECT employee_id INTO l_employee_id
2261: FROM fnd_user
2262: WHERE user_id = p_fnd_user_id;
2263:

Line 2261: FROM fnd_user

2257: l_employee_id NUMBER;
2258: BEGIN
2259: -- map the FND user to employee ID
2260: SELECT employee_id INTO l_employee_id
2261: FROM fnd_user
2262: WHERE user_id = p_fnd_user_id;
2263:
2264: IF (l_employee_id IS NOT NULL) THEN
2265: wf_directory.getrolename

Line 2262: WHERE user_id = p_fnd_user_id;

2258: BEGIN
2259: -- map the FND user to employee ID
2260: SELECT employee_id INTO l_employee_id
2261: FROM fnd_user
2262: WHERE user_id = p_fnd_user_id;
2263:
2264: IF (l_employee_id IS NOT NULL) THEN
2265: wf_directory.getrolename
2266: ( p_orig_system => 'PER',

Line 2273: p_orig_system_id => p_fnd_user_id,

2269: p_display_name => x_role_display_name );
2270: ELSE
2271: wf_directory.getrolename
2272: ( p_orig_system => 'FND_USR',
2273: p_orig_system_id => p_fnd_user_id,
2274: p_name => x_role_name,
2275: p_display_name => x_role_display_name );
2276: END IF;
2277: END Get_Fnd_User_Role;

Line 2277: END Get_Fnd_User_Role;

2273: p_orig_system_id => p_fnd_user_id,
2274: p_name => x_role_name,
2275: p_display_name => x_role_display_name );
2276: END IF;
2277: END Get_Fnd_User_Role;
2278:
2279: END CS_Workflow_PUB;