DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_DATA_GROUPS

Line 3275: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type

3271: ,p_responsibility_id in fnd_responsibility.responsibility_id%type
3272: ,p_responsibility_name in fnd_responsibility_tl.responsibility_name%type
3273: ,p_owner in varchar2
3274: ,p_data_group_app_short_name in fnd_application.application_short_name%type
3275: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
3276: ,p_menu_name in fnd_menus.menu_name%type
3277: ,p_start_date in varchar2
3278: ,p_end_date in varchar2
3279: ,p_description in varchar2

Line 3421: l_new_data_group_name fnd_data_groups_standard_view.data_group_name%type;

3417: l_new_responsibility_id fnd_responsibility.responsibility_id%type;
3418: l_new_responsibility_name fnd_responsibility_tl.responsibility_name%type;
3419: l_new_owner varchar2(120);
3420: l_new_data_group_app_name fnd_application.application_short_name%type;
3421: l_new_data_group_name fnd_data_groups_standard_view.data_group_name%type;
3422: l_new_data_group_id fnd_data_groups_standard_view.data_group_name%type;
3423: l_new_menu_name fnd_menus.menu_name%type;
3424: l_new_start_date varchar2(240); -- must be varchar
3425: l_new_end_date varchar2(240); -- must be varchar

Line 3422: l_new_data_group_id fnd_data_groups_standard_view.data_group_name%type;

3418: l_new_responsibility_name fnd_responsibility_tl.responsibility_name%type;
3419: l_new_owner varchar2(120);
3420: l_new_data_group_app_name fnd_application.application_short_name%type;
3421: l_new_data_group_name fnd_data_groups_standard_view.data_group_name%type;
3422: l_new_data_group_id fnd_data_groups_standard_view.data_group_name%type;
3423: l_new_menu_name fnd_menus.menu_name%type;
3424: l_new_start_date varchar2(240); -- must be varchar
3425: l_new_end_date varchar2(240); -- must be varchar
3426: l_new_description varchar2(240);

Line 3468: fnd_data_groups dg,

3464: cursor csr_data_groups(cp_new_data_group_id in number,
3465: cp_new_app_short_name in varchar2) IS
3466: select dg.data_group_name, a.application_short_name
3467: from fnd_data_group_units dgu,
3468: fnd_data_groups dg,
3469: fnd_application a
3470: where dgu.data_group_id = dg.data_group_id
3471: and dg.data_group_id = cp_new_data_group_id
3472: and dgu.application_id = a.application_id