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 534: ,p_last_standard_process_date in out nocopy date

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

Line 621: l_last_standard_process_date date;

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

Line 640: l_last_standard_process_date := p_last_standard_process_date;

636: -- Remember IN OUT parameter IN values
637: --
638: l_object_version_number := p_object_version_number;
639: l_final_process_date := p_final_process_date;
640: l_last_standard_process_date := p_last_standard_process_date;
641: --
642: --
643: -- Core HR API will not support update of field Rehire Recommendation
644: -- and Rehire Reason. Hence we make following call to Person API

Line 710: ,p_last_standard_process_date => p_last_standard_process_date

706: ,p_person_type_id => p_person_type_id
707: ,p_assignment_status_type_id => p_assignment_status_type_id
708: ,p_actual_termination_date => p_actual_termination_date
709: ,p_final_process_date => p_final_process_date
710: ,p_last_standard_process_date => p_last_standard_process_date
711: ,p_termination_reason => p_termination_reason
712: ,p_projected_termination_date => p_projected_termination_date
713: -- ,p_rehire_recommendation => p_rehire_recommendation
714: -- ,p_rehire_reason => p_rehire_reason

Line 884: p_last_standard_process_date := l_last_standard_process_date;

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

Line 905: p_last_standard_process_date := l_last_standard_process_date;

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

Line 922: ,p_last_standard_process_date in date

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

Line 1011: l_last_standard_process_date

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

Line 1012: per_periods_of_placement.last_standard_process_date%TYPE;

1008: -- In out params for terminate_placement
1009: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
1010: l_final_process_date per_periods_of_placement.final_process_Date%TYPE;
1011: l_last_standard_process_date
1012: per_periods_of_placement.last_standard_process_date%TYPE;
1013:
1014: validate_exception EXCEPTION;
1015:
1016: ItemType varchar2(200);

Line 1044: ,p_last_standard_process_date => l_last_standard_process_date

1040: ,p_object_version_number => l_object_version_number
1041: ,p_person_type_id => p_person_type_id
1042: ,p_actual_termination_date => p_actual_termination_date
1043: ,p_final_process_date => l_final_process_date
1044: ,p_last_standard_process_date => l_last_standard_process_date
1045: ,p_termination_reason => p_termination_reason
1046: ,p_projected_termination_date => p_projected_termination_date
1047: ,p_attribute_category => p_attribute_category
1048: ,p_attribute1 => p_attribute1

Line 1156: IF p_last_standard_process_date IS NOT NULL THEN

1152: lv_transaction_steps(lv_cnt).param_value := to_char(p_final_process_date, hr_transaction_ss.g_date_format);
1153: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1154: END IF;
1155:
1156: IF p_last_standard_process_date IS NOT NULL THEN
1157: lv_cnt := lv_cnt + 1;
1158: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1159: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1160: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';

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

1154: END IF;
1155:
1156: IF p_last_standard_process_date IS NOT NULL THEN
1157: lv_cnt := lv_cnt + 1;
1158: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1159: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1160: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1161: END IF;
1162:

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

1155:
1156: IF p_last_standard_process_date IS NOT NULL THEN
1157: lv_cnt := lv_cnt + 1;
1158: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1159: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1160: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1161: END IF;
1162:
1163: lv_cnt := lv_cnt + 1;

Line 1682: ,p_last_standard_process_date out nocopy date

1678: ,p_object_version_number out nocopy number
1679: ,p_person_type_id out nocopy number
1680: ,p_actual_termination_date out nocopy date
1681: ,p_final_process_date out nocopy date
1682: ,p_last_standard_process_date out nocopy date
1683: ,p_termination_reason out nocopy varchar2
1684: ,p_rehire_recommendation out nocopy varchar2
1685: ,p_rehire_reason out nocopy varchar2
1686: ,p_projected_termination_date out nocopy date

Line 1792: p_last_standard_process_date :=

1788: hr_transaction_api.get_date_value
1789: (p_transaction_step_id => p_transaction_step_id
1790: ,p_name => 'P_FINAL_PROCESS_DATE');
1791: --
1792: p_last_standard_process_date :=
1793: hr_transaction_api.get_date_value
1794: (p_transaction_step_id => p_transaction_step_id
1795: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1796: --

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

1791: --
1792: p_last_standard_process_date :=
1793: hr_transaction_api.get_date_value
1794: (p_transaction_step_id => p_transaction_step_id
1795: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
1796: --
1797: p_termination_reason :=
1798: hr_transaction_api.get_varchar2_value
1799: (p_transaction_step_id => p_transaction_step_id

Line 2144: l_last_standard_process_date VARCHAR2(100);*/

2140: l_object_version_number VARCHAR2(100);
2141: l_person_type_id VARCHAR2(100);
2142: l_actual_termination_date VARCHAR2(100);
2143: l_final_process_date VARCHAR2(100);
2144: l_last_standard_process_date VARCHAR2(100);*/
2145: /*l_projected_termination_date VARCHAR2(100);*/
2146:
2147: l_attribute_category per_periods_of_placement.attribute_category%TYPE;
2148: l_attribute1 per_periods_of_placement.attribute1%TYPE;

Line 2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;

2216: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2217: l_person_type_id per_all_people_f.person_type_id%TYPE;
2218: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2219: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2220: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2221: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2222: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2223: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2224: l_rehire_reason per_all_people_f.rehire_reason%TYPE;

Line 2255: ,p_last_standard_process_date => l_last_standard_process_date

2251: ,p_object_version_number => l_object_version_number
2252: ,p_person_type_id => l_person_type_id
2253: ,p_actual_termination_date => l_actual_termination_date
2254: ,p_final_process_date => l_final_process_date
2255: ,p_last_standard_process_date => l_last_standard_process_date
2256: ,p_termination_reason => l_termination_reason
2257: ,p_rehire_recommendation => l_rehire_recommendation
2258: ,p_rehire_reason => l_rehire_reason
2259: ,p_projected_termination_date => l_projected_termination_date

Line 2339: last_standard_process_date :=

2335: final_process_date :=
2336: hr_transaction_api.get_date_value
2337: (p_transaction_step_id => p_transaction_step_id
2338: ,p_name => 'P_FINAL_PROCESS_DATE');
2339: last_standard_process_date :=
2340: hr_transaction_api.get_date_value
2341: (p_transaction_step_id => p_transaction_step_id
2342: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2343: projected_termination_date :=

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

2338: ,p_name => 'P_FINAL_PROCESS_DATE');
2339: last_standard_process_date :=
2340: hr_transaction_api.get_date_value
2341: (p_transaction_step_id => p_transaction_step_id
2342: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE');
2343: projected_termination_date :=
2344: hr_transaction_api.get_date_value
2345: (p_transaction_step_id => p_transaction_step_id
2346: ,p_name => 'P_PROJECTED_TERMINATION_DATE');

Line 2363: ,p_last_standard_process_date => l_last_standard_process_date

2359: ,p_object_version_number => l_object_version_number
2360: ,p_person_type_id => l_person_type_id
2361: ,p_actual_termination_date => l_actual_termination_date
2362: ,p_final_process_date => l_final_process_date
2363: ,p_last_standard_process_date => l_last_standard_process_date
2364: ,p_termination_reason => l_termination_reason
2365: ,p_projected_termination_date => l_projected_termination_date
2366: ,p_rehire_recommendation => l_rehire_recommendation
2367: ,p_rehire_reason => l_rehire_reason