[Home] [Help]
271: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA';
272: l_add_struct_d.extend(1);
273: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA_DDF';
274: l_add_struct_d.extend(1);
275: l_add_struct_d(l_add_struct_d.count) := 'IRC_NOTIFICATION_PREFERENCES';
276: l_add_struct_d.extend(1);
277: l_add_struct_d(l_add_struct_d.count) := 'PER_PEOPLE';
278: l_add_struct_d.extend(1);
279: l_add_struct_d(l_add_struct_d.count) := 'Person Developer DF';
1014: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA';
1015: l_add_struct_d.extend(1);
1016: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA_DDF';
1017: l_add_struct_d.extend(1);
1018: l_add_struct_d(l_add_struct_d.count) := 'IRC_NOTIFICATION_PREFERENCES';
1019: l_add_struct_d.extend(1);
1020: l_add_struct_d(l_add_struct_d.count) := 'PER_PEOPLE';
1021: l_add_struct_d.extend(1);
1022: l_add_struct_d(l_add_struct_d.count) := 'Person Developer DF';
1950: select count(*)
1951: from per_all_assignments_f paaf
1952: , IRC_AGENCY_VACANCIES AGV1
1953: ,per_all_people_f per1
1954: ,irc_notification_preferences prefs
1955: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'
1956: and p_effective_date between PAAF.EFFECTIVE_START_DATE
1957: AND PAAF.EFFECTIVE_END_DATE
1958: and paaf.VACANCY_ID = AGV1.VACANCY_ID
3063: ) IS
3064: --
3065: l_password_check varchar2(1);
3066: l_password_change_check varchar2(1);
3067: l_allow_access irc_notification_preferences.allow_access%type;
3068: l_start_date date;
3069: cursor get_nls_language is
3070: select nls_language
3071: from fnd_languages
3521: l_person_id number;
3522:
3523: cursor has_notification_prefs(p_party_id number) is
3524: select notif.person_id
3525: from irc_notification_preferences notif
3526: where notif.party_id=p_party_id;
3527:
3528: l_notif_person_id number;
3529: l_object_version_number number;
3630: l_menu_name varchar2(30);
3631: l_menu_id number;
3632: l_grant_name varchar2(80);
3633: l_resp_exists boolean;
3634: l_allow_access irc_notification_preferences.allow_access%type;
3635: l_sso_enabled varchar2(30);
3636: l_central_registration_url varchar2(4000);
3637: l_purge_party_id number;
3638: --
3715: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA';
3716: l_add_struct_d.extend(1);
3717: l_add_struct_d(l_add_struct_d.count) := 'IRC_SEARCH_CRITERIA_DDF';
3718: l_add_struct_d.extend(1);
3719: l_add_struct_d(l_add_struct_d.count) := 'IRC_NOTIFICATION_PREFERENCES';
3720: l_add_struct_d.extend(1);
3721: l_add_struct_d(l_add_struct_d.count) := 'PER_PEOPLE';
3722: l_add_struct_d.extend(1);
3723: l_add_struct_d(l_add_struct_d.count) := 'Person Developer DF';
4301: ,p_security_group_id IN number
4302: ,p_allow_access IN varchar2 default null
4303: )is
4304: --
4305: l_allow_access irc_notification_preferences.allow_access%type;
4306: l_start_date date;
4307: --
4308: cursor get_nls_language is
4309: select nls_language
4330: and fu.person_party_id=hzp.party_id(+);
4331: --
4332: cursor get_notif_prefs(p_party_id number) is
4333: select notification_preference_id
4334: from irc_notification_preferences
4335: where party_id=p_party_id;
4336: --
4337: cursor get_bg(p_person_id number) is
4338: select per1.business_group_id,per1.object_version_number,per1.employee_number
4715: and security_group_id = p_security_group_id;
4716: --
4717: cursor get_notif_prefs(p_party_id number) is
4718: select notification_preference_id
4719: from irc_notification_preferences
4720: where party_id=p_party_id;
4721: --
4722: l_proc varchar2(72) := g_package||'irec_profile_exists';
4723: --
5318: --
5319: l_password_check varchar2(1);
5320: l_password_change_check varchar2(1);
5321: l_customer_pwd_check fnd_profile_option_values.profile_option_value%type;
5322: l_allow_access irc_notification_preferences.allow_access%type;
5323: l_start_date date;
5324: cursor get_nls_language is
5325: select nls_language
5326: from fnd_languages