[Home] [Help]
260: --
261: l_resp_count := hr_user_acct_utility.g_fnd_resp_tbl.count;
262: --
263: IF l_resp_count < 1
264: -- No fnd_user_resp_groups, per_sec_profile_assignments,
265: -- function exclusions or profile option values to insert
266: THEN
267: goto after_process_hook;
268: END IF;
553: -- into fnd_user_resp_groups only if view-all security profile of the
554: -- employee's business group is to be used. This will be applicable
555: -- to Employee Self Service responsibility. If a restricted security
556: -- profile is to be used, then we must call hrasprhi.pkb which will
557: -- insert one row into per_sec_profile_assignments as well as to
558: -- fnd_user_resp_groups.
559:
560: IF l_fnd_resp_rec.sec_group_id IS NULL OR
561: l_fnd_resp_rec.sec_profile_id IS NULL
594: ' after create_fnd_user_resp_groups', 54);
595: --
596: ELSE
597: -- sec_group_id and sec_profile_id are filled in
598: -- call peasprhi.pkb to insert into per_sec_profile_assignments
599: -- as well as fnd_user_resp_groups.
600:
601: hr_utility.set_location (l_proc ||
602: ' before create_sec_profile_asg', 56);
600:
601: hr_utility.set_location (l_proc ||
602: ' before create_sec_profile_asg', 56);
603:
604: -- Insert this row into per_sec_profile_assignments
605: hr_user_acct_internal.create_sec_profile_asg
606: (p_user_id => l_user_id
607: ,p_sec_group_id => l_fnd_resp_rec.sec_group_id
608: ,p_sec_profile_id => l_fnd_resp_rec.sec_profile_id
994: -- | |
995: -- | USAGE: |
996: -- | ----- |
997: -- | This wrapper module is used to update fnd_user and |
998: -- | fnd_user_resp_groups, or per_sec_profile_assignments records specifically|
999: -- | for expiring a user account. |
1000: -- | User accounts for terminated employees will not be deleted because |
1001: -- | some HR history forms have sql statements join to the fnd_user table |
1002: -- | derive the who columns. |
1044: ,responsibility_id
1045: ,responsibility_application_id
1046: ,object_version_number
1047: ,start_date
1048: FROM per_sec_profile_assignments
1049: WHERE user_id = c_user_id
1050: AND nvl(end_date, l_date + 1) > l_date;
1051: --
1052: -- Cursor to select all records which belongs to the terminated employee's
1151: (p_user_id => get_user_ids.user_id
1152: ,p_end_date => l_date
1153: );
1154: --
1155: -- Need to end date all rows in per_sec_profile_assignments associated
1156: -- the user id.
1157: -- The per_asp_upd(peasprhi.pkb) api will transparently end date the
1158: -- fnd_user_resp_groups records as well.
1159: