DBA Data[Home] [Help]

APPS.JTF_RS_WF_EVENTS_PUB dependencies on JTF_RS_ROLES_B

Line 500: l_role_id jtf_rs_roles_b.role_id%type := p_role_id;

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;

Line 501: l_role_type_code jtf_rs_roles_b.role_type_code%type := p_role_type_code;

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;

Line 502: l_role_code jtf_rs_roles_b.role_code%type := p_role_code;

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;

Line 505: l_active_flag jtf_rs_roles_b.active_flag%type := p_active_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;

Line 506: l_member_flag jtf_rs_roles_b.member_flag%type := p_member_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:

Line 507: l_admin_flag jtf_rs_roles_b.admin_flag%type := p_admin_flag;

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

Line 508: l_lead_flag jtf_rs_roles_b.lead_flag%type := p_lead_flag;

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:

Line 509: l_manager_flag jtf_rs_roles_b.manager_flag%type := p_manager_flag;

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;

Line 578: l_role_id jtf_rs_roles_b.role_id%type := p_resource_role_rec.role_id;

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;

Line 579: l_new_role_type_code jtf_rs_roles_b.role_type_code%type := p_resource_role_rec.role_type_code;

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;

Line 580: l_new_role_code jtf_rs_roles_b.role_code%type := p_resource_role_rec.role_code;

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;

Line 583: l_new_active_flag jtf_rs_roles_b.active_flag%type := p_resource_role_rec.active_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;

Line 584: l_new_member_flag jtf_rs_roles_b.member_flag%type := p_resource_role_rec.member_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:

Line 585: l_new_admin_flag jtf_rs_roles_b.admin_flag%type := p_resource_role_rec.admin_flag;

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

Line 586: l_new_lead_flag jtf_rs_roles_b.lead_flag%type := p_resource_role_rec.lead_flag;

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

Line 587: l_new_manager_flag jtf_rs_roles_b.manager_flag%type := p_resource_role_rec.manager_flag;

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,

Line 703: l_role_id jtf_rs_roles_b.role_id%type := p_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;