DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on FND_RESPONSIBILITY_S

Line 359: ,p_start_date in fnd_responsibility.start_date%type

355: ,p_resp_name in fnd_responsibility_tl.responsibility_name%type
356: ,p_resp_app_id in fnd_responsibility.application_id%type
357: ,p_resp_description in fnd_responsibility_tl.description%type
358: default null
359: ,p_start_date in fnd_responsibility.start_date%type
360: ,p_end_date in fnd_responsibility.end_date%type default null
361: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%type
362: ,p_data_group_app_id in fnd_responsibility.data_group_application_id%type
363: ,p_menu_name in fnd_menus.menu_name%type

Line 421: SELECT fnd_responsibility_s.nextval

417: WHERE request_group_name = p_request_group_name
418: AND application_id = p_request_group_app_id;
419: --
420: CURSOR lc_generate_resp_id IS
421: SELECT fnd_responsibility_s.nextval
422: FROM sys.dual;
423:
424:
425: l_proc varchar2(72) := g_package||'create_fnd_responsibility';

Line 639: fnd_message.set_token('SEQUENCE', 'FND_RESPONSIBILITY_S');

635: IF lc_generate_resp_id%NOTFOUND
636: THEN
637: CLOSE lc_generate_resp_id;
638: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
639: fnd_message.set_token('SEQUENCE', 'FND_RESPONSIBILITY_S');
640: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
641: fnd_message.set_token('VALUE', 'NULL');
642: hr_utility.raise_error;
643: ELSE