496: l_key varchar2(240);
497: l_exist varchar2(30);
498: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.role.create';
499:
500: l_role_id jtf_rs_roles_b.role_id%type := p_role_id;
501: l_role_type_code jtf_rs_roles_b.role_type_code%type := p_role_type_code;
502: l_role_code jtf_rs_roles_b.role_code%type := p_role_code;
503: l_role_name jtf_rs_roles_tl.role_name%type := p_role_name;
504: l_role_desc jtf_rs_roles_tl.role_desc%type := p_role_desc;
497: l_exist varchar2(30);
498: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.role.create';
499:
500: l_role_id jtf_rs_roles_b.role_id%type := p_role_id;
501: l_role_type_code jtf_rs_roles_b.role_type_code%type := p_role_type_code;
502: l_role_code jtf_rs_roles_b.role_code%type := p_role_code;
503: l_role_name jtf_rs_roles_tl.role_name%type := p_role_name;
504: l_role_desc jtf_rs_roles_tl.role_desc%type := p_role_desc;
505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_flag;
498: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.role.create';
499:
500: l_role_id jtf_rs_roles_b.role_id%type := p_role_id;
501: l_role_type_code jtf_rs_roles_b.role_type_code%type := p_role_type_code;
502: l_role_code jtf_rs_roles_b.role_code%type := p_role_code;
503: l_role_name jtf_rs_roles_tl.role_name%type := p_role_name;
504: l_role_desc jtf_rs_roles_tl.role_desc%type := p_role_desc;
505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_flag;
506: l_member_flag jtf_rs_roles_b.member_flag%type := p_member_flag;
501: l_role_type_code jtf_rs_roles_b.role_type_code%type := p_role_type_code;
502: l_role_code jtf_rs_roles_b.role_code%type := p_role_code;
503: l_role_name jtf_rs_roles_tl.role_name%type := p_role_name;
504: l_role_desc jtf_rs_roles_tl.role_desc%type := p_role_desc;
505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_flag;
506: l_member_flag jtf_rs_roles_b.member_flag%type := p_member_flag;
507: l_admin_flag jtf_rs_roles_b.admin_flag%type := p_admin_flag;
508: l_lead_flag jtf_rs_roles_b.lead_flag%type := p_lead_flag;
509: l_manager_flag jtf_rs_roles_b.manager_flag%type := p_manager_flag;
502: l_role_code jtf_rs_roles_b.role_code%type := p_role_code;
503: l_role_name jtf_rs_roles_tl.role_name%type := p_role_name;
504: l_role_desc jtf_rs_roles_tl.role_desc%type := p_role_desc;
505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_flag;
506: l_member_flag jtf_rs_roles_b.member_flag%type := p_member_flag;
507: l_admin_flag jtf_rs_roles_b.admin_flag%type := p_admin_flag;
508: l_lead_flag jtf_rs_roles_b.lead_flag%type := p_lead_flag;
509: l_manager_flag jtf_rs_roles_b.manager_flag%type := p_manager_flag;
510:
503: l_role_name jtf_rs_roles_tl.role_name%type := p_role_name;
504: l_role_desc jtf_rs_roles_tl.role_desc%type := p_role_desc;
505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_flag;
506: l_member_flag jtf_rs_roles_b.member_flag%type := p_member_flag;
507: l_admin_flag jtf_rs_roles_b.admin_flag%type := p_admin_flag;
508: l_lead_flag jtf_rs_roles_b.lead_flag%type := p_lead_flag;
509: l_manager_flag jtf_rs_roles_b.manager_flag%type := p_manager_flag;
510:
511: BEGIN
504: l_role_desc jtf_rs_roles_tl.role_desc%type := p_role_desc;
505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_flag;
506: l_member_flag jtf_rs_roles_b.member_flag%type := p_member_flag;
507: l_admin_flag jtf_rs_roles_b.admin_flag%type := p_admin_flag;
508: l_lead_flag jtf_rs_roles_b.lead_flag%type := p_lead_flag;
509: l_manager_flag jtf_rs_roles_b.manager_flag%type := p_manager_flag;
510:
511: BEGIN
512:
505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_flag;
506: l_member_flag jtf_rs_roles_b.member_flag%type := p_member_flag;
507: l_admin_flag jtf_rs_roles_b.admin_flag%type := p_admin_flag;
508: l_lead_flag jtf_rs_roles_b.lead_flag%type := p_lead_flag;
509: l_manager_flag jtf_rs_roles_b.manager_flag%type := p_manager_flag;
510:
511: BEGIN
512:
513: x_return_status := fnd_api.g_ret_sts_success;
574: l_key varchar2(240);
575: l_exist varchar2(30);
576: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.role.update';
577:
578: l_role_id jtf_rs_roles_b.role_id%type := p_resource_role_rec.role_id;
579: l_new_role_type_code jtf_rs_roles_b.role_type_code%type := p_resource_role_rec.role_type_code;
580: l_new_role_code jtf_rs_roles_b.role_code%type := p_resource_role_rec.role_code;
581: l_new_role_name jtf_rs_roles_tl.role_name%type := p_resource_role_rec.role_name;
582: l_new_role_desc jtf_rs_roles_tl.role_desc%type := p_resource_role_rec.role_desc;
575: l_exist varchar2(30);
576: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.role.update';
577:
578: l_role_id jtf_rs_roles_b.role_id%type := p_resource_role_rec.role_id;
579: l_new_role_type_code jtf_rs_roles_b.role_type_code%type := p_resource_role_rec.role_type_code;
580: l_new_role_code jtf_rs_roles_b.role_code%type := p_resource_role_rec.role_code;
581: l_new_role_name jtf_rs_roles_tl.role_name%type := p_resource_role_rec.role_name;
582: l_new_role_desc jtf_rs_roles_tl.role_desc%type := p_resource_role_rec.role_desc;
583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_flag;
576: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.role.update';
577:
578: l_role_id jtf_rs_roles_b.role_id%type := p_resource_role_rec.role_id;
579: l_new_role_type_code jtf_rs_roles_b.role_type_code%type := p_resource_role_rec.role_type_code;
580: l_new_role_code jtf_rs_roles_b.role_code%type := p_resource_role_rec.role_code;
581: l_new_role_name jtf_rs_roles_tl.role_name%type := p_resource_role_rec.role_name;
582: l_new_role_desc jtf_rs_roles_tl.role_desc%type := p_resource_role_rec.role_desc;
583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_flag;
584: l_new_member_flag jtf_rs_roles_b.member_flag%type := p_resource_role_rec.member_flag;
579: l_new_role_type_code jtf_rs_roles_b.role_type_code%type := p_resource_role_rec.role_type_code;
580: l_new_role_code jtf_rs_roles_b.role_code%type := p_resource_role_rec.role_code;
581: l_new_role_name jtf_rs_roles_tl.role_name%type := p_resource_role_rec.role_name;
582: l_new_role_desc jtf_rs_roles_tl.role_desc%type := p_resource_role_rec.role_desc;
583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_flag;
584: l_new_member_flag jtf_rs_roles_b.member_flag%type := p_resource_role_rec.member_flag;
585: l_new_admin_flag jtf_rs_roles_b.admin_flag%type := p_resource_role_rec.admin_flag;
586: l_new_lead_flag jtf_rs_roles_b.lead_flag%type := p_resource_role_rec.lead_flag;
587: l_new_manager_flag jtf_rs_roles_b.manager_flag%type := p_resource_role_rec.manager_flag;
580: l_new_role_code jtf_rs_roles_b.role_code%type := p_resource_role_rec.role_code;
581: l_new_role_name jtf_rs_roles_tl.role_name%type := p_resource_role_rec.role_name;
582: l_new_role_desc jtf_rs_roles_tl.role_desc%type := p_resource_role_rec.role_desc;
583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_flag;
584: l_new_member_flag jtf_rs_roles_b.member_flag%type := p_resource_role_rec.member_flag;
585: l_new_admin_flag jtf_rs_roles_b.admin_flag%type := p_resource_role_rec.admin_flag;
586: l_new_lead_flag jtf_rs_roles_b.lead_flag%type := p_resource_role_rec.lead_flag;
587: l_new_manager_flag jtf_rs_roles_b.manager_flag%type := p_resource_role_rec.manager_flag;
588:
581: l_new_role_name jtf_rs_roles_tl.role_name%type := p_resource_role_rec.role_name;
582: l_new_role_desc jtf_rs_roles_tl.role_desc%type := p_resource_role_rec.role_desc;
583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_flag;
584: l_new_member_flag jtf_rs_roles_b.member_flag%type := p_resource_role_rec.member_flag;
585: l_new_admin_flag jtf_rs_roles_b.admin_flag%type := p_resource_role_rec.admin_flag;
586: l_new_lead_flag jtf_rs_roles_b.lead_flag%type := p_resource_role_rec.lead_flag;
587: l_new_manager_flag jtf_rs_roles_b.manager_flag%type := p_resource_role_rec.manager_flag;
588:
589: cursor res_role_cur IS
582: l_new_role_desc jtf_rs_roles_tl.role_desc%type := p_resource_role_rec.role_desc;
583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_flag;
584: l_new_member_flag jtf_rs_roles_b.member_flag%type := p_resource_role_rec.member_flag;
585: l_new_admin_flag jtf_rs_roles_b.admin_flag%type := p_resource_role_rec.admin_flag;
586: l_new_lead_flag jtf_rs_roles_b.lead_flag%type := p_resource_role_rec.lead_flag;
587: l_new_manager_flag jtf_rs_roles_b.manager_flag%type := p_resource_role_rec.manager_flag;
588:
589: cursor res_role_cur IS
590: select
583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_flag;
584: l_new_member_flag jtf_rs_roles_b.member_flag%type := p_resource_role_rec.member_flag;
585: l_new_admin_flag jtf_rs_roles_b.admin_flag%type := p_resource_role_rec.admin_flag;
586: l_new_lead_flag jtf_rs_roles_b.lead_flag%type := p_resource_role_rec.lead_flag;
587: l_new_manager_flag jtf_rs_roles_b.manager_flag%type := p_resource_role_rec.manager_flag;
588:
589: cursor res_role_cur IS
590: select
591: role_id,
699: l_key varchar2(240);
700: l_exist varchar2(30);
701: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.role.delete';
702:
703: l_role_id jtf_rs_roles_b.role_id%type := p_role_id;
704:
705: BEGIN
706:
707: x_return_status := fnd_api.g_ret_sts_success;