DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on STANDARD

Line 361: ,p_data_group_name in fnd_data_groups_standard_view.data_group_name%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
364: ,p_request_group_name in fnd_request_groups.request_group_name%type
365: default null

Line 406: FROM fnd_data_groups_standard_view

402: AND application_id = p_resp_app_id);
403: --
404: CURSOR lc_get_data_group_id IS
405: SELECT data_group_id
406: FROM fnd_data_groups_standard_view
407: WHERE data_group_name = p_data_group_name;
408: --
409: CURSOR lc_get_menu_id IS
410: SELECT menu_id

Line 501: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');

497: IF lc_get_data_group_id%NOTFOUND
498: THEN
499: CLOSE lc_get_data_group_id;
500: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
501: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
502: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
503: fnd_message.set_token('VALUE', p_data_group_name);
504: hr_utility.raise_error;
505: ELSE

Line 568: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');

564: IF lc_get_data_group_id%NOTFOUND
565: THEN
566: CLOSE lc_get_data_group_id;
567: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
568: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
569: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
570: fnd_message.set_token('VALUE', p_data_group_name);
571: hr_utility.raise_error;
572: ELSE