[Home] [Help]
416: ,p_effective_date in date
417: ,p_period_of_service_id in number
418: ,p_object_version_number in out nocopy number
419: ,p_actual_termination_date in date
420: ,p_last_standard_process_date in out nocopy date
421: ,p_person_type_id in number default hr_api.g_number
422: ,p_assignment_status_type_id in number default hr_api.g_number
423: ,p_leaving_reason in varchar2 default hr_api.g_varchar2
424: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685: ,p_effective_date => p_effective_date
686: ,p_period_of_service_id => p_period_of_service_id
687: ,p_object_version_number => p_object_version_number
688: ,p_actual_termination_date => p_actual_termination_date
689: ,p_last_standard_process_date => p_last_standard_process_date
690: ,p_person_type_id => p_person_type_id
691: ,p_assignment_status_type_id => p_assignment_status_type_id
692: ,p_leaving_reason => p_leaving_reason
693: -- ,p_rehire_recommendation => p_rehire_recommendation
1055: ,p_assignment_status_type_id in number default hr_api.g_number
1056: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
1057: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
1058: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
1059: ,p_last_standard_process_date in varchar2 default hr_api.g_varchar2
1060: ,p_projected_termination_date in varchar2 default hr_api.g_varchar2
1061: ,p_final_process_date in varchar2 default hr_api.g_varchar2
1062: )
1063:
1177: := 'DATE';
1178:
1179: li_count := li_count + 1;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1181: := 'P_LAST_STANDARD_PROCESS_DATE';
1182: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1183: := p_last_standard_process_date;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1185: := 'DATE';
1179: li_count := li_count + 1;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1181: := 'P_LAST_STANDARD_PROCESS_DATE';
1182: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1183: := p_last_standard_process_date;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1185: := 'DATE';
1186:
1187: li_count := li_count + 1;
1842: per_periods_of_service.object_version_number%TYPE;
1843: ------------------------------------------------------------------------
1844: -- out parameters required by API actual_termination_emp
1845: ------------------------------------------------------------------------
1846: ld_last_standard_process_date
1847: per_periods_of_service.last_standard_process_date%TYPE;
1848: ld_notified_term_date
1849: per_periods_of_service.notified_termination_date%TYPE;
1850:
1843: ------------------------------------------------------------------------
1844: -- out parameters required by API actual_termination_emp
1845: ------------------------------------------------------------------------
1846: ld_last_standard_process_date
1847: per_periods_of_service.last_standard_process_date%TYPE;
1848: ld_notified_term_date
1849: per_periods_of_service.notified_termination_date%TYPE;
1850:
1851: ld_projected_termination_date
1969: ld_actual_term_date := ld_effective_date;
1970: lv_term_reason := lrt_termination.leaving_reason;
1971: ll_term_comments := lrt_termination.comments;
1972:
1973: ld_last_standard_process_date := lrt_termination.last_standard_process_date;
1974:
1975: lv_person_type_id := lrt_termination.person_type_id;
1976: lv_assignment_status_type_id
1977: := lrt_termination.assignment_status_type_id;
2134: p_effective_date => ld_actual_term_date,
2135: p_period_of_service_id => ln_period_of_service_id,
2136: p_object_version_number => ln_object_version_number,
2137: p_actual_termination_date => ld_actual_term_date,
2138: p_last_standard_process_date => ld_last_standard_process_date,
2139: p_leaving_reason => lv_term_reason,
2140: -- p_rehire_recommendation => lv_rehire_recommendation,
2141: -- p_rehire_reason => lv_rehire_reason,
2142: p_person_type_id => lv_person_type_id,
2273: p_transaction_step_id => p_transaction_step_id,
2274: p_name => 'P_NOTIFIED_TERMINATION_DATE'
2275: );
2276:
2277: lrt_termination.last_standard_process_date :=
2278: hr_transaction_api.get_date_value (
2279: p_transaction_step_id => p_transaction_step_id,
2280: p_name => 'P_LAST_STANDARD_PROCESS_DATE'
2281: );
2276:
2277: lrt_termination.last_standard_process_date :=
2278: hr_transaction_api.get_date_value (
2279: p_transaction_step_id => p_transaction_step_id,
2280: p_name => 'P_LAST_STANDARD_PROCESS_DATE'
2281: );
2282:
2283: lrt_termination.projected_termination_date :=
2284: hr_transaction_api.get_date_value (
2442: ,p_assignment_status_type_id out nocopy varchar2
2443: ,p_rehire_recommendation out nocopy varchar2
2444: ,p_rehire_reason out nocopy varchar2
2445: ,p_comments out nocopy varchar2
2446: ,p_last_standard_process_date out nocopy varchar2
2447: ,p_projected_termination_date out nocopy varchar2
2448: ,p_final_process_date out nocopy varchar2
2449: ,p_attribute_category out nocopy varchar2
2450: ,p_attribute1 out nocopy varchar2
2537: (p_transaction_step_id => p_transaction_step_id
2538: ,p_name => 'P_NOTIFIED_TERMINATION_DATE')
2539: ,g_date_format);
2540: --
2541: p_last_standard_process_date := to_char(
2542: hr_transaction_api.get_date_value
2543: (p_transaction_step_id => p_transaction_step_id
2544: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE')
2545: ,g_date_format);
2540: --
2541: p_last_standard_process_date := to_char(
2542: hr_transaction_api.get_date_value
2543: (p_transaction_step_id => p_transaction_step_id
2544: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE')
2545: ,g_date_format);
2546: --
2547: p_projected_termination_date := to_char(
2548: hr_transaction_api.get_date_value