APPS.IBC_CITEM_WORKFLOW_PVT dependencies on FND_USER

Line 50: FROM fnd_user

46: IS
47: l_result VARCHAR2(80);
48: CURSOR c_user_description(p_user_id NUMBER) IS
49: SELECT description
50: FROM fnd_user
51: WHERE user_id = p_user_id;
52: BEGIN
53: OPEN c_user_description(p_user_id);
54: FETCH c_user_description INTO l_result;

Line 354: FROM FND_USER

350: AND language = p_language;
351:
352: CURSOR c_user_name(p_user_id IN NUMBER) IS
353: SELECT user_name
354: FROM FND_USER
355: WHERE USER_ID = p_user_id;
356:
357: CURSOR c_submitter_name IS
358: SELECT INITCAP(user_name)

Line 359: FROM fnd_user

355: WHERE USER_ID = p_user_id;
356:
357: CURSOR c_submitter_name IS
358: SELECT INITCAP(user_name)
359: FROM fnd_user
360: WHERE USER_ID = FND_GLOBAL.USER_ID;
361:
362: CURSOR c_component_not_status (p_citem_ver_id IN NUMBER,
363: p_status IN VARCHAR2)

Line 581: ELSE -- Owner is a user FND_USER

577: ,p_resource_type => l_owner_resource_type
578: ,px_wf_role_name => l_wf_role_name
579: ,px_wf_role_display_name => l_wf_role_display_name
580: );
581: ELSE -- Owner is a user FND_USER
582: OPEN c_user_name(l_owner_resource_id);
583: FETCH c_user_name INTO l_owner_name;
584: CLOSE c_user_name;
585: Create_Workflow_Role(

Line 1899: FROM FND_USER

1895: AND language = p_language;
1896:
1897: CURSOR c_user_name(p_user_id IN NUMBER) IS
1898: SELECT user_name
1899: FROM FND_USER
1900: WHERE USER_ID = p_user_id;
1901:
1902: CURSOR c_submitter_name IS
1903: SELECT INITCAP(user_name)

Line 1904: FROM fnd_user

1900: WHERE USER_ID = p_user_id;
1901:
1902: CURSOR c_submitter_name IS
1903: SELECT INITCAP(user_name)
1904: FROM fnd_user
1905: WHERE USER_ID = FND_GLOBAL.USER_ID;
1906:
1907: CURSOR c_component_not_status (p_citem_ver_id IN NUMBER,
1908: p_status IN VARCHAR2)

Line 2152: ELSE -- Owner is a user FND_USER

2148: ,p_resource_type => l_owner_resource_type
2149: ,px_wf_role_name => l_wf_role_name
2150: ,px_wf_role_display_name => l_wf_role_display_name
2151: );
2152: ELSE -- Owner is a user FND_USER
2153: OPEN c_user_name(l_owner_resource_id);
2154: FETCH c_user_name INTO l_owner_name;
2155: CLOSE c_user_name;
2156: Create_Workflow_Role(