[Home] [Help]
65: ,p_object_version_number in number
66: ,p_person_id in number
67: ,p_login_person_id in number
68: ,p_actual_termination_date in varchar2
69: ,p_last_standard_process_date in varchar2
70: ,p_leaving_reason in varchar2
71: ,p_comments in varchar2 default hr_api.g_varchar2
72: ,p_notified_termination_date in varchar2
73: ,p_review_proc_call in varchar2
238: gtt_transaction_steps(lv_cnt).param_value := p_notified_termination_date;
239: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
240: -- END IF;
241:
242: -- IF p_last_standard_process_date IS NOT NULL THEN
243: lv_cnt := lv_cnt + 1;
244: gtt_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
245: gtt_transaction_steps(lv_cnt).param_value := p_last_standard_process_date;
246: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
240: -- END IF;
241:
242: -- IF p_last_standard_process_date IS NOT NULL THEN
243: lv_cnt := lv_cnt + 1;
244: gtt_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
245: gtt_transaction_steps(lv_cnt).param_value := p_last_standard_process_date;
246: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
247: -- END IF;
248:
241:
242: -- IF p_last_standard_process_date IS NOT NULL THEN
243: lv_cnt := lv_cnt + 1;
244: gtt_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
245: gtt_transaction_steps(lv_cnt).param_value := p_last_standard_process_date;
246: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
247: -- END IF;
248:
249: lv_cnt := lv_cnt + 1;
686: ,p_object_version_number in number
687: ,p_person_type_id in number default hr_api.g_number
688: ,p_actual_termination_date in varchar2 default to_char(hr_api.g_date)
689: ,p_final_process_date in varchar2
690: ,p_last_standard_process_date in varchar2
691: ,p_termination_reason in varchar2 default hr_api.g_varchar2
692: ,p_projected_termination_date in varchar2 default to_char(hr_api.g_date)
693: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
694: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
776:
777: -- In out params for terminate_placement
778: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
779: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
780: l_last_standard_process_date
781: per_periods_of_placement.last_standard_process_date%TYPE;
782:
783: l_person_type varchar2(50);
784: l_actual_termination_date date;
777: -- In out params for terminate_placement
778: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
779: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
780: l_last_standard_process_date
781: per_periods_of_placement.last_standard_process_date%TYPE;
782:
783: l_person_type varchar2(50);
784: l_actual_termination_date date;
785: l_fut_actns_exist_warning boolean;
876: gtt_transaction_steps(lv_cnt).param_value := p_final_process_date;
877: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
878: END IF;
879:
880: IF p_last_standard_process_date IS NOT NULL THEN
881: lv_cnt := lv_cnt + 1;
882: gtt_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
883: gtt_transaction_steps(lv_cnt).param_value := p_last_standard_process_date;
884: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
878: END IF;
879:
880: IF p_last_standard_process_date IS NOT NULL THEN
881: lv_cnt := lv_cnt + 1;
882: gtt_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
883: gtt_transaction_steps(lv_cnt).param_value := p_last_standard_process_date;
884: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
885: END IF;
886:
879:
880: IF p_last_standard_process_date IS NOT NULL THEN
881: lv_cnt := lv_cnt + 1;
882: gtt_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
883: gtt_transaction_steps(lv_cnt).param_value := p_last_standard_process_date;
884: gtt_transaction_steps(lv_cnt).param_data_type := 'DATE';
885: END IF;
886:
887: lv_cnt := lv_cnt + 1;
1501: ,p_object_version_number out nocopy number
1502: ,p_person_type_id out nocopy number
1503: ,p_actual_termination_date out nocopy Date
1504: ,p_final_process_date out nocopy Date
1505: ,p_last_standard_process_date out nocopy Date
1506: ,p_termination_reason out nocopy varchar2
1507: ,p_rehire_recommendation out nocopy varchar2
1508: ,p_rehire_reason out nocopy varchar2
1509: ,p_projected_termination_date out nocopy Date
1607: hr_transaction_api.get_date_value
1608: (p_transaction_step_id => p_transaction_step_id
1609: ,p_name => 'P_FINAL_PROCESS_DATE');
1610: --
1611: p_last_standard_process_date :=
1612: hr_transaction_api.get_date_value
1613: (p_transaction_step_id => p_transaction_step_id
1614: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1615: --
1610: --
1611: p_last_standard_process_date :=
1612: hr_transaction_api.get_date_value
1613: (p_transaction_step_id => p_transaction_step_id
1614: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1615: --
1616: p_termination_reason :=
1617: hr_transaction_api.get_varchar2_value
1618: (p_transaction_step_id => p_transaction_step_id
1961: ,p_actual_termination_date out nocopy Date
1962: ,p_leaving_reason out nocopy varchar2
1963: ,p_notified_termination_date out nocopy Date
1964: ,p_comments out nocopy varchar2
1965: ,p_last_standard_process_date out nocopy Date
1966: ,p_projected_termination_date out nocopy Date
1967: ,p_final_process_date out nocopy Date
1968: ,p_rehire_recommendation out nocopy varchar2
1969: ,p_attribute_category out nocopy varchar2
2055: (p_transaction_step_id => p_transaction_step_id
2056: ,p_name => 'P_FINAL_PROCESS_DATE');
2057:
2058: --
2059: p_last_standard_process_date :=
2060: hr_transaction_api.get_date_value
2061: (p_transaction_step_id => p_transaction_step_id
2062: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2063: --
2058: --
2059: p_last_standard_process_date :=
2060: hr_transaction_api.get_date_value
2061: (p_transaction_step_id => p_transaction_step_id
2062: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2063: --
2064: p_notified_termination_date :=
2065: hr_transaction_api.get_date_value
2066: (p_transaction_step_id => p_transaction_step_id