DBA Data[Home] [Help]

APPS.HR_TERMINATION_SS dependencies on FND_NUMBER

Line 3290: lv_param_7 := fnd_number.number_to_canonical(cur_get_direct_reports.business_group_id);

3286: lv_param_6 := 'Y';
3287: lv_param_7 := '1';
3288: else
3289: lv_param_6 := 'N';
3290: lv_param_7 := fnd_number.number_to_canonical(cur_get_direct_reports.business_group_id);
3291: end if;
3292:
3293: supDirId := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3294:

Line 3293: supDirId := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);

3289: lv_param_6 := 'N';
3290: lv_param_7 := fnd_number.number_to_canonical(cur_get_direct_reports.business_group_id);
3291: end if;
3292:
3293: supDirId := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3294:
3295: if ( supDirId is null ) then
3296: supDirId := fnd_number.number_to_canonical(p_login_person_id);
3297: end if;

Line 3296: supDirId := fnd_number.number_to_canonical(p_login_person_id);

3292:
3293: supDirId := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3294:
3295: if ( supDirId is null ) then
3296: supDirId := fnd_number.number_to_canonical(p_login_person_id);
3297: end if;
3298:
3299: lv_param_12 := fnd_number.number_to_canonical(cur_get_direct_reports.assignment_id);
3300: lv_param_13 := fnd_number.number_to_canonical(p_old_sup_person_id);

Line 3299: lv_param_12 := fnd_number.number_to_canonical(cur_get_direct_reports.assignment_id);

3295: if ( supDirId is null ) then
3296: supDirId := fnd_number.number_to_canonical(p_login_person_id);
3297: end if;
3298:
3299: lv_param_12 := fnd_number.number_to_canonical(cur_get_direct_reports.assignment_id);
3300: lv_param_13 := fnd_number.number_to_canonical(p_old_sup_person_id);
3301: lv_param_14 := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3302: lv_param_15 := fnd_number.number_to_canonical(supDirId);
3303:

Line 3300: lv_param_13 := fnd_number.number_to_canonical(p_old_sup_person_id);

3296: supDirId := fnd_number.number_to_canonical(p_login_person_id);
3297: end if;
3298:
3299: lv_param_12 := fnd_number.number_to_canonical(cur_get_direct_reports.assignment_id);
3300: lv_param_13 := fnd_number.number_to_canonical(p_old_sup_person_id);
3301: lv_param_14 := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3302: lv_param_15 := fnd_number.number_to_canonical(supDirId);
3303:
3304: l_tmp_new_asg_id := hr_termination_ss.get_sup_asg_byprfl(

Line 3301: lv_param_14 := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);

3297: end if;
3298:
3299: lv_param_12 := fnd_number.number_to_canonical(cur_get_direct_reports.assignment_id);
3300: lv_param_13 := fnd_number.number_to_canonical(p_old_sup_person_id);
3301: lv_param_14 := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3302: lv_param_15 := fnd_number.number_to_canonical(supDirId);
3303:
3304: l_tmp_new_asg_id := hr_termination_ss.get_sup_asg_byprfl(
3305: p_param_1 => lv_param_1

Line 3302: lv_param_15 := fnd_number.number_to_canonical(supDirId);

3298:
3299: lv_param_12 := fnd_number.number_to_canonical(cur_get_direct_reports.assignment_id);
3300: lv_param_13 := fnd_number.number_to_canonical(p_old_sup_person_id);
3301: lv_param_14 := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3302: lv_param_15 := fnd_number.number_to_canonical(supDirId);
3303:
3304: l_tmp_new_asg_id := hr_termination_ss.get_sup_asg_byprfl(
3305: p_param_1 => lv_param_1
3306: ,p_param_2 => lv_param_2