APPS.IGF_AP_ISIR_GEN_PKG dependencies on FND_USER

Line 59: p_user_id IN fnd_user.user_id%TYPE

55: END attach_isir;
56:
57: FUNCTION can_unlock_isir(
58: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
59: p_user_id IN fnd_user.user_id%TYPE
60: )
61: RETURN VARCHAR2 IS
62: /*
63: || Created By : ugummall

Line 75: cp_user_id fnd_user.user_id%TYPE

71: */
72:
73: -- Cursor to check wether the user locked the specified ISIR or not.
74: CURSOR cur_is_user_locked_isir( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
75: cp_user_id fnd_user.user_id%TYPE
76: ) IS
77: SELECT 'X'
78: FROM IGF_AP_FA_BASE_REC_ALL fabase
79: WHERE fabase.base_id = cp_base_id

Line 83: CURSOR cur_is_user_sysadmin( cp_user_id fnd_user.user_id%TYPE ) IS

79: WHERE fabase.base_id = cp_base_id
80: AND (fabase.isir_locked_by IS NULL OR fabase.isir_locked_by = cp_user_id);
81:
82: -- Cursor to check wether the user is system administrator or not.
83: CURSOR cur_is_user_sysadmin( cp_user_id fnd_user.user_id%TYPE ) IS
84: SELECT 'X'
85: FROM FND_USER_RESP_GROUPS userresp,
86: FND_RESPONSIBILITY resp
87: WHERE resp.responsibility_id = userresp.responsibility_id

Line 85: FROM FND_USER_RESP_GROUPS userresp,

81:
82: -- Cursor to check wether the user is system administrator or not.
83: CURSOR cur_is_user_sysadmin( cp_user_id fnd_user.user_id%TYPE ) IS
84: SELECT 'X'
85: FROM FND_USER_RESP_GROUPS userresp,
86: FND_RESPONSIBILITY resp
87: WHERE resp.responsibility_id = userresp.responsibility_id
88: AND resp.responsibility_key = 'SYSTEM_ADMINISTRATOR'
89: AND userresp.user_id = cp_user_id;

Line 152: p_user_id IN fnd_user.user_id%TYPE

148:
149:
150: FUNCTION update_lock_status (
151: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
152: p_user_id IN fnd_user.user_id%TYPE
153: )
154: RETURN VARCHAR2 IS
155: /*
156: || Created By : ugummall