DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_REQUEST_GROUPS

Line 3281: ,p_request_group_name in fnd_request_groups.request_group_name%type

3277: ,p_start_date in varchar2
3278: ,p_end_date in varchar2
3279: ,p_description in varchar2
3280: ,p_group_app_short_name in fnd_application.application_short_name%type
3281: ,p_request_group_name in fnd_request_groups.request_group_name%type
3282: ,p_version in varchar2
3283: ,p_web_host_name in fnd_responsibility.web_host_name%type
3284: ,p_web_agent_name in fnd_responsibility.web_agent_name%type) IS
3285:

Line 3428: l_new_request_group_name fnd_request_groups.request_group_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);
3427: l_new_group_app_short_name fnd_application.application_short_name%type;
3428: l_new_request_group_name fnd_request_groups.request_group_name%type;
3429: l_new_request_group_id fnd_request_groups.request_group_name%type;
3430: l_new_version fnd_responsibility.version%type;
3431: l_new_web_host_name fnd_responsibility.web_host_name%type;
3432: l_new_web_agent_name fnd_responsibility.web_agent_name%type;

Line 3429: l_new_request_group_id fnd_request_groups.request_group_name%type;

3425: l_new_end_date varchar2(240); -- must be varchar
3426: l_new_description varchar2(240);
3427: l_new_group_app_short_name fnd_application.application_short_name%type;
3428: l_new_request_group_name fnd_request_groups.request_group_name%type;
3429: l_new_request_group_id fnd_request_groups.request_group_name%type;
3430: l_new_version fnd_responsibility.version%type;
3431: l_new_web_host_name fnd_responsibility.web_host_name%type;
3432: l_new_web_agent_name fnd_responsibility.web_agent_name%type;
3433: l_legilsation_code per_business_groups.legislation_code%type;

Line 3459: from fnd_request_groups req,

3455: and resp.responsibility_key = cp_new_responsibility_key;
3456:
3457: cursor csr_requests_groups(cp_new_request_group_id in number) IS
3458: select request_group_name, apps.application_short_name
3459: from fnd_request_groups req,
3460: fnd_application apps
3461: where request_group_id = cp_new_request_group_id
3462: and req.application_id = apps.application_id;
3463: