eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CWK_TERMINATION_SWI dependencies on STANDARD

Line 19: ,p_last_standard_process_date in out nocopy date

15: ,p_person_id in number
16: ,p_date_start in date
17: ,p_object_version_number in out nocopy number
18: ,p_actual_termination_date in date
19: ,p_last_standard_process_date in out nocopy date
20: ,p_person_type_id in number default hr_api.g_number
21: ,p_assignment_status_type_id in number default hr_api.g_number
22: ,p_termination_reason in varchar2 default hr_api.g_varchar2
23: ,p_entries_changed_warning out nocopy varchar2

Line 40: l_last_standard_process_date date;

36: l_dod_warning boolean;
37: --
38: -- Variables for IN/OUT parameters
39: l_object_version_number number;
40: l_last_standard_process_date date;
41: --
42: -- Other variables
43: l_proc varchar2(72) := g_package ||'actual_termination_placement';
44: Begin

Line 58: l_last_standard_process_date := p_last_standard_process_date;

54: --
55: -- Remember IN OUT parameter IN values
56: --
57: l_object_version_number := p_object_version_number;
58: l_last_standard_process_date := p_last_standard_process_date;
59: --
60: -- Convert constant values to their corresponding boolean value
61: --
62:

Line 76: ,p_last_standard_process_date => p_last_standard_process_date

72: ,p_person_id => p_person_id
73: ,p_date_start => p_date_start
74: ,p_object_version_number => p_object_version_number
75: ,p_actual_termination_date => p_actual_termination_date
76: ,p_last_standard_process_date => p_last_standard_process_date
77: ,p_person_type_id => p_person_type_id
78: ,p_assignment_status_type_id => p_assignment_status_type_id
79: ,p_termination_reason => p_termination_reason
80: ,p_supervisor_warning => l_supervisor_warning

Line 168: p_last_standard_process_date := l_last_standard_process_date;

164: --
165: -- Reset IN OUT parameters and set OUT parameters
166: --
167: p_object_version_number := l_object_version_number;
168: p_last_standard_process_date := l_last_standard_process_date;
169: p_return_status := hr_multi_message.get_return_status_disable;
170: hr_utility.set_location(' Leaving:' || l_proc, 30);
171: when others then
172: --

Line 188: p_last_standard_process_date := l_last_standard_process_date;

184: --
185: -- Reset IN OUT and set OUT parameters
186: --
187: p_object_version_number := l_object_version_number;
188: p_last_standard_process_date := l_last_standard_process_date;
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc,50);
191: end actual_termination_placement;
192: -- ----------------------------------------------------------------------------

Line 533: ,p_last_standard_process_date in out nocopy date

529: ,p_person_type_id in number default hr_api.g_number
530: ,p_assignment_status_type_id in number default hr_api.g_number
531: ,p_actual_termination_date in date default hr_api.g_date
532: ,p_final_process_date in out nocopy date
533: ,p_last_standard_process_date in out nocopy date
534: ,p_termination_reason in varchar2 default hr_api.g_varchar2
535: ,p_projected_termination_date in date default hr_api.g_date
536: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
537: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 620: l_last_standard_process_date date;

616: --
617: -- Variables for IN/OUT parameters
618: l_object_version_number number;
619: l_final_process_date date;
620: l_last_standard_process_date date;
621: --
622: -- Other variables
623: l_proc varchar2(72) := g_package ||'terminate_placement';
624: Begin

Line 639: l_last_standard_process_date := p_last_standard_process_date;

635: -- Remember IN OUT parameter IN values
636: --
637: l_object_version_number := p_object_version_number;
638: l_final_process_date := p_final_process_date;
639: l_last_standard_process_date := p_last_standard_process_date;
640: --
641: -- Convert constant values to their corresponding boolean value
642: --
643:

Line 660: ,p_last_standard_process_date => p_last_standard_process_date

656: ,p_person_type_id => p_person_type_id
657: ,p_assignment_status_type_id => p_assignment_status_type_id
658: ,p_actual_termination_date => p_actual_termination_date
659: ,p_final_process_date => p_final_process_date
660: ,p_last_standard_process_date => p_last_standard_process_date
661: ,p_termination_reason => p_termination_reason
662: ,p_projected_termination_date => p_projected_termination_date
663: -- ,p_rehire_recommendation => p_rehire_recommendation
664: -- ,p_rehire_reason => p_rehire_reason

Line 887: p_last_standard_process_date := l_last_standard_process_date;

883: -- Reset IN OUT parameters and set OUT parameters
884: --
885: p_object_version_number := l_object_version_number;
886: p_final_process_date := l_final_process_date;
887: p_last_standard_process_date := l_last_standard_process_date;
888: p_return_status := hr_multi_message.get_return_status_disable;
889: hr_utility.set_location(' Leaving:' || l_proc, 30);
890: when others then
891: --

Line 908: p_last_standard_process_date := l_last_standard_process_date;

904: -- Reset IN OUT and set OUT parameters
905: --
906: p_object_version_number := l_object_version_number;
907: p_final_process_date := l_final_process_date;
908: p_last_standard_process_date := l_last_standard_process_date;
909: p_return_status := hr_multi_message.get_return_status_disable;
910: hr_utility.set_location(' Leaving:' || l_proc,50);
911: end terminate_placement;
912:

Line 925: ,p_last_standard_process_date in date

921: ,p_object_version_number in number
922: ,p_person_type_id in number default hr_api.g_number
923: ,p_actual_termination_date in date default hr_api.g_date
924: ,p_final_process_date in date
925: ,p_last_standard_process_date in date
926: ,p_termination_reason in varchar2 default hr_api.g_varchar2
927: ,p_projected_termination_date in date default hr_api.g_date
928: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
929: ,p_rehire_reason in varchar2 default hr_api.g_varchar2

Line 1014: l_last_standard_process_date

1010:
1011: -- In out params for terminate_placement
1012: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
1013: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
1014: l_last_standard_process_date
1015: per_periods_of_placement.last_standard_process_date%TYPE;
1016:
1017: validate_exception EXCEPTION;
1018:

Line 1015: per_periods_of_placement.last_standard_process_date%TYPE;

1011: -- In out params for terminate_placement
1012: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
1013: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
1014: l_last_standard_process_date
1015: per_periods_of_placement.last_standard_process_date%TYPE;
1016:
1017: validate_exception EXCEPTION;
1018:
1019: BEGIN

Line 1033: ,p_last_standard_process_date => l_last_standard_process_date

1029: ,p_object_version_number => l_object_version_number
1030: ,p_person_type_id => p_person_type_id
1031: ,p_actual_termination_date => p_actual_termination_date
1032: ,p_final_process_date => l_final_process_date
1033: ,p_last_standard_process_date => l_last_standard_process_date
1034: ,p_termination_reason => p_termination_reason
1035: ,p_projected_termination_date => p_projected_termination_date
1036: ,p_attribute_category => p_attribute_category
1037: ,p_attribute1 => p_attribute1

Line 1145: IF p_last_standard_process_date IS NOT NULL THEN

1141: lv_transaction_steps(lv_cnt).param_value := to_char(p_final_process_date, hr_transaction_ss.g_date_format);
1142: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1143: END IF;
1144:
1145: IF p_last_standard_process_date IS NOT NULL THEN
1146: lv_cnt := lv_cnt + 1;
1147: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1148: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1149: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';

Line 1147: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';

1143: END IF;
1144:
1145: IF p_last_standard_process_date IS NOT NULL THEN
1146: lv_cnt := lv_cnt + 1;
1147: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1148: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1149: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1150: END IF;
1151:

Line 1148: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);

1144:
1145: IF p_last_standard_process_date IS NOT NULL THEN
1146: lv_cnt := lv_cnt + 1;
1147: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1148: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1149: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1150: END IF;
1151:
1152: lv_cnt := lv_cnt + 1;

Line 1615: ,p_last_standard_process_date out nocopy date

1611: ,p_object_version_number out nocopy number
1612: ,p_person_type_id out nocopy number
1613: ,p_actual_termination_date out nocopy date
1614: ,p_final_process_date out nocopy date
1615: ,p_last_standard_process_date out nocopy date
1616: ,p_termination_reason out nocopy varchar2
1617: ,p_rehire_recommendation out nocopy varchar2
1618: ,p_rehire_reason out nocopy varchar2
1619: ,p_projected_termination_date out nocopy date

Line 1725: p_last_standard_process_date :=

1721: hr_transaction_api.get_date_value
1722: (p_transaction_step_id => p_transaction_step_id
1723: ,p_name => 'P_FINAL_PROCESS_DATE');
1724: --
1725: p_last_standard_process_date :=
1726: hr_transaction_api.get_date_value
1727: (p_transaction_step_id => p_transaction_step_id
1728: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1729: --

Line 1728: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');

1724: --
1725: p_last_standard_process_date :=
1726: hr_transaction_api.get_date_value
1727: (p_transaction_step_id => p_transaction_step_id
1728: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1729: --
1730: p_termination_reason :=
1731: hr_transaction_api.get_varchar2_value
1732: (p_transaction_step_id => p_transaction_step_id

Line 2077: l_last_standard_process_date VARCHAR2(100);*/

2073: l_object_version_number VARCHAR2(100);
2074: l_person_type_id VARCHAR2(100);
2075: l_actual_termination_date VARCHAR2(100);
2076: l_final_process_date VARCHAR2(100);
2077: l_last_standard_process_date VARCHAR2(100);*/
2078: /*l_projected_termination_date VARCHAR2(100);*/
2079:
2080: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2081: l_attribute1 per_periods_of_placement.attribute1%TYPE;

Line 2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;

2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2157: l_rehire_reason per_all_people_f.rehire_reason%TYPE;

Line 2174: ,p_last_standard_process_date => l_last_standard_process_date

2170: ,p_object_version_number => l_object_version_number
2171: ,p_person_type_id => l_person_type_id
2172: ,p_actual_termination_date => l_actual_termination_date
2173: ,p_final_process_date => l_final_process_date
2174: ,p_last_standard_process_date => l_last_standard_process_date
2175: ,p_termination_reason => l_termination_reason
2176: ,p_rehire_recommendation => l_rehire_recommendation
2177: ,p_rehire_reason => l_rehire_reason
2178: ,p_projected_termination_date => l_projected_termination_date

Line 2258: last_standard_process_date :=

2254: final_process_date :=
2255: hr_transaction_api.get_date_value
2256: (p_transaction_step_id => p_transaction_step_id
2257: ,p_name => 'P_FINAL_PROCESS_DATE');
2258: last_standard_process_date :=
2259: hr_transaction_api.get_date_value
2260: (p_transaction_step_id => p_transaction_step_id
2261: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2262: projected_termination_date :=

Line 2261: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');

2257: ,p_name => 'P_FINAL_PROCESS_DATE');
2258: last_standard_process_date :=
2259: hr_transaction_api.get_date_value
2260: (p_transaction_step_id => p_transaction_step_id
2261: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2262: projected_termination_date :=
2263: hr_transaction_api.get_date_value
2264: (p_transaction_step_id => p_transaction_step_id
2265: ,p_name => 'P_PROJECTED_TERMINATION_DATE');

Line 2282: ,p_last_standard_process_date => l_last_standard_process_date

2278: ,p_object_version_number => l_object_version_number
2279: ,p_person_type_id => l_person_type_id
2280: ,p_actual_termination_date => l_actual_termination_date
2281: ,p_final_process_date => l_final_process_date
2282: ,p_last_standard_process_date => l_last_standard_process_date
2283: ,p_termination_reason => l_termination_reason
2284: ,p_projected_termination_date => l_projected_termination_date
2285: ,p_rehire_recommendation => l_rehire_recommendation
2286: ,p_rehire_reason => l_rehire_reason