DBA Data[Home] [Help]

APPS.HR_EX_EMPLOYEE_INTERNAL dependencies on STANDARD

Line 23: ,p_last_standard_process_date in out nocopy date

19: ,p_termination_accepted_person in number default hr_api.g_number
20: ,p_accepted_termination_date in date default hr_api.g_date
21: ,p_actual_termination_date in date default hr_api.g_date
22: ,p_final_process_date in out nocopy date
23: ,p_last_standard_process_date in out nocopy date
24: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
25: ,p_comments in varchar2 default hr_api.g_varchar2
26: ,p_notified_termination_date in date default hr_api.g_date
27: ,p_projected_termination_date in date default hr_api.g_date

Line 108: ,p_last_standard_process_date => p_last_standard_process_date

104: ,p_termination_accepted_person => p_termination_accepted_person
105: ,p_accepted_termination_date => p_accepted_termination_date
106: ,p_actual_termination_date => p_actual_termination_date
107: ,p_final_process_date => p_final_process_date
108: ,p_last_standard_process_date => p_last_standard_process_date
109: ,p_leaving_reason => p_leaving_reason
110: ,p_comments => p_comments
111: ,p_notified_termination_date => p_notified_termination_date
112: ,p_projected_termination_date => p_projected_termination_date

Line 197: ,p_last_standard_process_date in out nocopy date

193: ,p_termination_accepted_person in number default hr_api.g_number
194: ,p_accepted_termination_date in date default hr_api.g_date
195: ,p_actual_termination_date in date default hr_api.g_date
196: ,p_final_process_date in out nocopy date
197: ,p_last_standard_process_date in out nocopy date
198: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
199: ,p_comments in varchar2 default hr_api.g_varchar2
200: ,p_notified_termination_date in date default hr_api.g_date
201: ,p_projected_termination_date in date default hr_api.g_date

Line 413: hr_utility.set_location('LSPD '||to_char(p_last_standard_process_date,

409: fetch csr_get_pds_details
410: into l_cur_pds;
411: close csr_get_pds_details;
412:
413: hr_utility.set_location('LSPD '||to_char(p_last_standard_process_date,
414: 'dd-mon-yyyy'),20);
415: begin
416: /*
417: ** Set global variable so that the ATD is available to

Line 434: ,p_last_standard_process_date => p_last_standard_process_date

430: --
431: -- 120.2 (START)
432: --
433: ,p_actual_termination_date => p_actual_termination_date
434: ,p_last_standard_process_date => p_last_standard_process_date
435: ,p_final_process_date => p_final_process_date
436: --
437: -- 120.2 (END)
438: --

Line 784: ( l_pds_rec.last_standard_process_date is null

780: */
781: if ( l_pds_rec.actual_termination_date is null
782: and p_actual_termination_date is not null)
783: OR
784: ( l_pds_rec.last_standard_process_date is null
785: and p_last_standard_process_date is not null)
786: then
787: l_last_std_process_date_in := p_last_standard_process_date;
788: --

Line 785: and p_last_standard_process_date is not null)

781: if ( l_pds_rec.actual_termination_date is null
782: and p_actual_termination_date is not null)
783: OR
784: ( l_pds_rec.last_standard_process_date is null
785: and p_last_standard_process_date is not null)
786: then
787: l_last_std_process_date_in := p_last_standard_process_date;
788: --
789: -- 120.2 (START)

Line 787: l_last_std_process_date_in := p_last_standard_process_date;

783: OR
784: ( l_pds_rec.last_standard_process_date is null
785: and p_last_standard_process_date is not null)
786: then
787: l_last_std_process_date_in := p_last_standard_process_date;
788: --
789: -- 120.2 (START)
790: --
791: if l_pds_rec.actual_termination_date is null then

Line 796: if l_pds_rec.last_standard_process_date is null then

792: l_atd_new := 1;
793: else
794: l_atd_new := 0;
795: end if;
796: if l_pds_rec.last_standard_process_date is null then
797: l_lspd_new := 1;
798: else
799: l_lspd_new := 0;
800: end if;

Line 818: ,p_last_standard_process_date => l_last_std_process_date_in

814: (p_effective_date => p_effective_date
815: ,p_period_of_service_id => p_period_of_service_id
816: ,p_object_version_number => p_object_version_number
817: ,p_actual_termination_date => p_actual_termination_date
818: ,p_last_standard_process_date => l_last_std_process_date_in
819: ,p_person_type_id => p_person_type_id
820: ,p_assignment_status_type_id => p_assignment_status_type_id
821: ,p_leaving_reason => p_leaving_reason
822: --

Line 901: p_last_standard_process_date := l_last_std_process_date_out;

897: -- 120.2 (END)
898: --
899: );
900:
901: p_last_standard_process_date := l_last_std_process_date_out;
902: --
903: -- 120.2 (START)
904: --
905: p_alu_change_warning := l_alu_change_warning;