eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_GEN_003 dependencies on FND_USER

Line 175: ---- Get the FND User Information for the Person ID passed.

171: || ssawhney 18-AUG-2005 Bug#: 4378028 added end date logic in insert/update.
172: */
173:
174: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
175: ---- Get the FND User Information for the Person ID passed.
176: CURSOR get_user_id_cur(cp_person_id fnd_user.person_party_id%type) IS
177: SELECT user_id
178: FROM fnd_user
179: WHERE person_party_id = cp_person_id;

Line 176: CURSOR get_user_id_cur(cp_person_id fnd_user.person_party_id%type) IS

172: */
173:
174: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
175: ---- Get the FND User Information for the Person ID passed.
176: CURSOR get_user_id_cur(cp_person_id fnd_user.person_party_id%type) IS
177: SELECT user_id
178: FROM fnd_user
179: WHERE person_party_id = cp_person_id;
180:

Line 178: FROM fnd_user

174: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
175: ---- Get the FND User Information for the Person ID passed.
176: CURSOR get_user_id_cur(cp_person_id fnd_user.person_party_id%type) IS
177: SELECT user_id
178: FROM fnd_user
179: WHERE person_party_id = cp_person_id;
180:
181: -- Exclusively for Insert.
182: ---- Get the responsibilities associated with the System Person Type, which are not associated with the person already. INSERT CASE

Line 183: CURSOR get_resp_info_cur(cp_system_person_typ igs_pe_typ_rsp_dflt.s_person_type%type, cp_user_id fnd_user.user_id%type) IS

179: WHERE person_party_id = cp_person_id;
180:
181: -- Exclusively for Insert.
182: ---- Get the responsibilities associated with the System Person Type, which are not associated with the person already. INSERT CASE
183: CURSOR get_resp_info_cur(cp_system_person_typ igs_pe_typ_rsp_dflt.s_person_type%type, cp_user_id fnd_user.user_id%type) IS
184: SELECT default_resp.responsibility_key, oss.application_short_name, default_resp.responsibility_id, default_resp.application_id, default_resp.description
185: FROM igs_pe_typ_rsp_dflt oss , fnd_responsibility_vl default_resp
186: WHERE oss.s_person_type= cp_system_person_typ
187: AND oss.responsibility_key = default_resp.responsibility_key

Line 190: FROM fnd_user_resp_groups_direct resp_group

186: WHERE oss.s_person_type= cp_system_person_typ
187: AND oss.responsibility_key = default_resp.responsibility_key
188: AND NOT EXISTS
189: (SELECT 1
190: FROM fnd_user_resp_groups_direct resp_group
191: WHERE user_id = cp_user_id AND
192: resp_group.responsibility_id = default_resp.responsibility_id AND
193: resp_group.responsibility_application_id = default_resp.application_id
194: );

Line 199: CURSOR get_inactive_resp_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS

195:
196:
197: -- Get the Default responsibilities mapping with the System Person Type ,
198: -- that are present with the user. Update the end date. Both INSERT/UPDATE case
199: CURSOR get_inactive_resp_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS
200: SELECT resp.responsibility_key, resp.responsibility_id, resp.application_id, resp_group.start_date, Resp_group.end_date, fnd.application_short_name
201: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp , igs_pe_typ_rsp_dflt oss, fnd_application fnd
202: WHERE user_id = cp_user_id AND
203: Resp.responsibility_id = resp_group.Responsibility_id AND

Line 201: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp , igs_pe_typ_rsp_dflt oss, fnd_application fnd

197: -- Get the Default responsibilities mapping with the System Person Type ,
198: -- that are present with the user. Update the end date. Both INSERT/UPDATE case
199: CURSOR get_inactive_resp_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS
200: SELECT resp.responsibility_key, resp.responsibility_id, resp.application_id, resp_group.start_date, Resp_group.end_date, fnd.application_short_name
201: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp , igs_pe_typ_rsp_dflt oss, fnd_application fnd
202: WHERE user_id = cp_user_id AND
203: Resp.responsibility_id = resp_group.Responsibility_id AND
204: Resp.application_id = resp_group.responsibility_application_id AND
205: oss.s_person_type = cp_system_person_type AND

Line 225: CURSOR get_resp_sys_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS

221:
222:
223:
224: ---- Get all those responsibilities associated with the System Person Type of OTHER. DELETE CASE
225: CURSOR get_resp_sys_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS
226: SELECT resp.application_id, resp.responsibility_id , resp.responsibility_key, resp_group.start_date, Resp_group.end_date
227: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp
228: WHERE user_id = cp_user_id AND
229: Resp.responsibility_id = resp_group.Responsibility_id AND

Line 227: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp

223:
224: ---- Get all those responsibilities associated with the System Person Type of OTHER. DELETE CASE
225: CURSOR get_resp_sys_cur(cp_user_id fnd_user.user_id%type, cp_system_person_type igs_pe_typ_rsp_dflt.s_person_type%type) IS
226: SELECT resp.application_id, resp.responsibility_id , resp.responsibility_key, resp_group.start_date, Resp_group.end_date
227: FROM fnd_user_resp_groups_direct resp_group, fnd_responsibility resp
228: WHERE user_id = cp_user_id AND
229: Resp.responsibility_id = resp_group.Responsibility_id AND
230: Resp.application_id = resp_group.responsibility_application_id
231: --AND Resp_group.end_date IS NOT NULL

Line 243: l_user_id fnd_user.user_id%type;

239: l_parameter_list_t wf_parameter_list_t := wf_parameter_list_t();
240: l_person_id NUMBER(15);
241: l_system_person_type VARCHAR2(30);
242: l_action VARCHAR2(10);
243: l_user_id fnd_user.user_id%type;
244: l_result VARCHAR2(100);
245: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_gen_003.resp_assignment';
246: l_label VARCHAR2(500);
247: l_debug_str VARCHAR2(3200);

Line 315: fnd_user_resp_groups_api.update_assignment (

311: END IF;
312:
313: --Call update
314: IF l_update_resp THEN
315: fnd_user_resp_groups_api.update_assignment (
316: user_id => l_user_id,
317: responsibility_id => inactive_resp_rec.responsibility_id,
318: responsibility_application_id => inactive_resp_rec.application_id,
319: security_group_id => 0,

Line 333: Fnd_User_Resp_Groups_api.insert_assignment (

329: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.'||l_action;
330: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || ' End Date ' ||'/' ||l_end_date;
331: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
332: END IF;
333: Fnd_User_Resp_Groups_api.insert_assignment (
334: user_id => l_user_id,
335: responsibility_id => resp_info_rec.responsibility_id,
336: responsibility_application_id => resp_info_rec.application_id,
337: security_group_id => 0,

Line 357: fnd_user_resp_groups_api.update_assignment (

353:
354: -- Delete event will only be called for Others person type. And will always be for sysdate.
355: -- if the resp is already end date with a past end date. Then dont touch it.
356: IF ( NVL(resp_sys_rec.end_date, sysdate) >= sysdate) THEN
357: fnd_user_resp_groups_api.update_assignment (
358: user_id => l_user_id,
359: responsibility_id => resp_sys_rec.responsibility_id,
360: responsibility_application_id => resp_sys_rec.application_id,
361: security_group_id => 0,