APPS.IRC_PARTY_API dependencies on IRC_NOTIFICATION_PREFERENCES

Line 265: l_add_struct_d(l_add_struct_d.count) := 'IRC_NOTIFICATION_PREFERENCES';

261: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA';
262: l_add_struct_d.extend(1);
263: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA_DDF';
264: l_add_struct_d.extend(1);
265: l_add_struct_d(l_add_struct_d.count) := 'IRC_NOTIFICATION_PREFERENCES';
266: l_add_struct_d.extend(1);
267: l_add_struct_d(l_add_struct_d.count) := 'PER_PEOPLE';
268: l_add_struct_d.extend(1);
269: l_add_struct_d(l_add_struct_d.count) := 'Person Developer DF';

Line 991: l_add_struct_d(l_add_struct_d.count) := 'IRC_NOTIFICATION_PREFERENCES';

987: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA';
988: l_add_struct_d.extend(1);
989: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA_DDF';
990: l_add_struct_d.extend(1);
991: l_add_struct_d(l_add_struct_d.count) := 'IRC_NOTIFICATION_PREFERENCES';
992: l_add_struct_d.extend(1);
993: l_add_struct_d(l_add_struct_d.count) := 'PER_PEOPLE';
994: l_add_struct_d.extend(1);
995: l_add_struct_d(l_add_struct_d.count) := 'Person Developer DF';

Line 1929: ,irc_notification_preferences prefs

1925: select count(*)
1926: from per_all_assignments_f paaf
1927: , IRC_AGENCY_VACANCIES AGV1
1928: ,per_all_people_f per1
1929: ,irc_notification_preferences prefs
1930: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'
1931: and p_effective_date between PAAF.EFFECTIVE_START_DATE
1932: AND PAAF.EFFECTIVE_END_DATE
1933: and paaf.VACANCY_ID = AGV1.VACANCY_ID

Line 2950: l_allow_access irc_notification_preferences.allow_access%type;

2946: ) IS
2947: --
2948: l_password_check varchar2(1);
2949: l_password_change_check varchar2(1);
2950: l_allow_access irc_notification_preferences.allow_access%type;
2951: l_start_date date;
2952: cursor get_nls_language is
2953: select nls_language
2954: from fnd_languages

Line 3400: from irc_notification_preferences notif

3396: l_person_id number;
3397:
3398: cursor has_notification_prefs(p_party_id number) is
3399: select notif.person_id
3400: from irc_notification_preferences notif
3401: where notif.party_id=p_party_id;
3402:
3403: l_notif_person_id number;
3404: l_object_version_number number;

Line 3500: l_allow_access irc_notification_preferences.allow_access%type;

3496: l_menu_name varchar2(30);
3497: l_menu_id number;
3498: l_grant_name varchar2(80);
3499: l_resp_exists boolean;
3500: l_allow_access irc_notification_preferences.allow_access%type;
3501: --
3502: cursor get_nls_language is
3503: select nls_language
3504: from fnd_languages

Line 4077: l_allow_access irc_notification_preferences.allow_access%type;

4073: ,p_security_group_id IN number
4074: ,p_allow_access IN varchar2 default null
4075: )is
4076: --
4077: l_allow_access irc_notification_preferences.allow_access%type;
4078: l_start_date date;
4079: --
4080: cursor get_nls_language is
4081: select nls_language

Line 4106: from irc_notification_preferences

4102: and fu.person_party_id=hzp.party_id(+);
4103: --
4104: cursor get_notif_prefs(p_party_id number) is
4105: select notification_preference_id
4106: from irc_notification_preferences
4107: where party_id=p_party_id;
4108: --
4109: cursor get_bg(p_person_id number) is
4110: select per1.business_group_id,per1.object_version_number,per1.employee_number

Line 4489: from irc_notification_preferences

4485: and security_group_id = p_security_group_id;
4486: --
4487: cursor get_notif_prefs(p_party_id number) is
4488: select notification_preference_id
4489: from irc_notification_preferences
4490: where party_id=p_party_id;
4491: --
4492: l_proc varchar2(72) := g_package||'irec_profile_exists';
4493: --

Line 5088: l_allow_access irc_notification_preferences.allow_access%type;

5084: ) IS
5085: --
5086: l_password_check varchar2(1);
5087: l_password_change_check varchar2(1);
5088: l_allow_access irc_notification_preferences.allow_access%type;
5089: l_start_date date;
5090: cursor get_nls_language is
5091: select nls_language
5092: from fnd_languages