DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on FND_GLOBAL

Line 55: l_user_id := FND_GLOBAL.USER_ID;

51: or object_id_to1 = p_structure_version_id)
52: and relationship_type = 'L';
53:
54: BEGIN
55: l_user_id := FND_GLOBAL.USER_ID;
56:
57: --get the current user's person_id
58: open get_person_id(l_user_id);
59: fetch get_person_id into l_person_id;

Line 499: FND_GLOBAL.USER_ID, l_struc_ver_id)) THEN

495: LOOP
496: FETCH get_other_unpub_ver into l_struc_ver_id;
497: EXIT WHEN get_other_unpub_ver%NOTFOUND;
498: IF ('O' = PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(
499: FND_GLOBAL.USER_ID, l_struc_ver_id)) THEN
500: CLOSE get_other_unpub_ver;
501: return 'N';
502: END IF;
503: END LOOP;

Line 3185: IF (IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,

3181: CLOSE c2;
3182:
3183: IF (l_dummy = 1) THEN
3184: --found; check if locked by another user
3185: IF (IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,
3186: p_structure_version_id) = 'O') THEN
3187: --added for bug 3071008
3188: IF (PA_SECURITY_PVT.check_user_privilege('PA_UNLOCK_ANY_STRUCTURE'
3189: ,NULL

Line 3222: IF (IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,

3218: FETCH c2 into l_dummy;
3219: CLOSE c2;
3220: IF (l_dummy = 1) THEN
3221: --found; check if locked by another user
3222: IF (IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,
3223: p_structure_version_id) = 'O') THEN
3224: --added for bug 3071008
3225: IF (PA_SECURITY_PVT.check_user_privilege('PA_UNLOCK_ANY_STRUCTURE'
3226: ,NULL