1: PACKAGE BODY hr_termination_ss AS
2: /* $Header: hrtrmwrs.pkb 120.2.12010000.2 2008/08/06 08:49:40 ubhat ship $ */
3:
4: -- Package scope global variables.
5: -- The canonical date format has to use hyphens instead of slashes, ie.
7: -- dateValue() is expecting the date string in "rrrr-mm-dd" format.
8: -- All date fields are converted to canonical date formats and return to
9: -- the java caller.
10: g_date_format constant varchar2(10):='RRRR-MM-DD';
11: g_package constant varchar2(30) := 'HR_TERMINATION_SS';
12:
13:
14: /*
15: ||===========================================================================
159: FUNCTION get_termination_details (
160: p_transaction_step_id IN
161: hr_api_transaction_steps.transaction_step_id%type
162: )
163: RETURN hr_termination_ss.rt_termination;
164:
165: /*
166: ||=======================================================================
167: || FUNCTION: get_term_flex_detail - Private
172: FUNCTION get_term_flex_detail (
173: p_transaction_step_id IN
174: hr_api_transaction_steps.transaction_step_id%type
175: )
176: RETURN hr_termination_ss.t_flex_table;
177:
178: /*
179: ||===========================================================================
180: || FUNCTION: branch_on_subordinate_presence
480: hr_utility.set_location('Entering: ' || l_proc,5);
481:
482: -- Bug 2098595 Fix Begins: 12/03/2001
483: -- Need to switch the order of calling the api. We need to call
484: -- hr_termination_ss.update_pds_details first to set the flex segments
485: -- before calling hr_ex_employee_api.actual_termination_emp.
486: -- Otherwise, when there is a mandatory segment, we'll get an error
487: -- as follows:
488: -- The mandatory column Attribute??(also known as xxxx) has not been
513: --
514: -- N.B. Local variable l_pds_information10 declared at
515: -- top of procedure
516: -- Also l_pds_information10 used in call to
517: -- hr_termination_ss.update_pds_details below
518: --------------------------------------------------------------
519: l_pds_information10 := p_pds_information10;
520: l_pds_information_category := p_pds_information_category;
521:
539: end if;
540: end if;
541: --
542:
543: hr_utility.trace('Calling hr_termination_ss.update_pds_details ' || l_proc);
544: hr_termination_ss.update_pds_details
545: (p_validate => 0
546: ,p_effective_date => p_effective_date
547: ,p_period_of_service_id => p_period_of_service_id
540: end if;
541: --
542:
543: hr_utility.trace('Calling hr_termination_ss.update_pds_details ' || l_proc);
544: hr_termination_ss.update_pds_details
545: (p_validate => 0
546: ,p_effective_date => p_effective_date
547: ,p_period_of_service_id => p_period_of_service_id
548: ,p_termination_accepted_person => p_termination_accepted_person
654: --
655: -- Core HR API will not support update of field Rehire Recommendation
656: -- and Rehire Reason. Hence we make following call to Person API
657: -- to update the Fields.
658: hr_utility.trace('Calling hr_termination_ss.update_per_details ' || l_proc);
659: -- moved cursor definitions to new procedure , which can be called from
660: -- proces_api also.
661: update_per_details(
662: p_validate => 0, -- false
702: -- message.
703: -- For example:
704: -- "Error: java.sql.SQLExcpetion: ORA-01400: cannot insert NULL into
705: -- ("HR"."PER_PERSON_LIST_CHANGES"."SECURITY_PROFILE_ID"). ORA-06512:
706: -- at "APPS.HR_TERMINATION_SS", line xxx ORA-06512: at line 1.
707: -- With the call to hr_java_conv_util_ss, the error message text will
708: -- become:
709: -- "Error: ORA-01400: cannot insert NULL into
710: -- ("HR"."PER_PERSON_LIST_CHANGES"."SECURITY_PROFILE_ID").
1024: -- Save data to transaction table.
1025: ----------------------------------------------------------------------
1026:
1027: li_count := 1;
1028: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1029: := 'P_ACTUAL_TERMINATION_DATE';
1030: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1031: := p_actual_termination_date;
1032: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1026:
1027: li_count := 1;
1028: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1029: := 'P_ACTUAL_TERMINATION_DATE';
1030: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1031: := p_actual_termination_date;
1032: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1033: := 'DATE';
1034:
1028: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1029: := 'P_ACTUAL_TERMINATION_DATE';
1030: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1031: := p_actual_termination_date;
1032: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1033: := 'DATE';
1034:
1035: li_count := li_count + 1;
1036: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1032: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1033: := 'DATE';
1034:
1035: li_count := li_count + 1;
1036: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1037: := 'P_PERIOD_OF_SERVICE_ID';
1038: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1039: := p_period_of_service_id;
1040: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1034:
1035: li_count := li_count + 1;
1036: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1037: := 'P_PERIOD_OF_SERVICE_ID';
1038: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1039: := p_period_of_service_id;
1040: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1041: := 'NUMBER';
1042:
1036: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1037: := 'P_PERIOD_OF_SERVICE_ID';
1038: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1039: := p_period_of_service_id;
1040: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1041: := 'NUMBER';
1042:
1043: li_count := li_count + 1;
1044: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1040: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1041: := 'NUMBER';
1042:
1043: li_count := li_count + 1;
1044: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1045: := 'P_PERSON_ID';
1046: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1047: := p_person_id;
1048: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1042:
1043: li_count := li_count + 1;
1044: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1045: := 'P_PERSON_ID';
1046: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1047: := p_person_id;
1048: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1049: := 'NUMBER';
1050:
1044: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1045: := 'P_PERSON_ID';
1046: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1047: := p_person_id;
1048: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1049: := 'NUMBER';
1050:
1051: li_count := li_count + 1;
1052: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1048: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1049: := 'NUMBER';
1050:
1051: li_count := li_count + 1;
1052: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1053: := 'P_OBJECT_VERSION_NUMBER';
1054: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1055: := p_object_version_number;
1056: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1050:
1051: li_count := li_count + 1;
1052: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1053: := 'P_OBJECT_VERSION_NUMBER';
1054: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1055: := p_object_version_number;
1056: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1057: := 'NUMBER';
1058:
1052: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1053: := 'P_OBJECT_VERSION_NUMBER';
1054: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1055: := p_object_version_number;
1056: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1057: := 'NUMBER';
1058:
1059: li_count := li_count + 1;
1060: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1056: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1057: := 'NUMBER';
1058:
1059: li_count := li_count + 1;
1060: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1061: := 'P_LEAVING_REASON';
1062: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1063: := p_leaving_reason;
1064: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1058:
1059: li_count := li_count + 1;
1060: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1061: := 'P_LEAVING_REASON';
1062: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1063: := p_leaving_reason;
1064: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1065: := 'VARCHAR2';
1066:
1060: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1061: := 'P_LEAVING_REASON';
1062: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1063: := p_leaving_reason;
1064: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1065: := 'VARCHAR2';
1066:
1067: li_count := li_count + 1;
1068: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1064: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1065: := 'VARCHAR2';
1066:
1067: li_count := li_count + 1;
1068: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1069: := 'P_PERSON_TYPE_ID';
1070: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1071: := p_person_type_id;
1072: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1066:
1067: li_count := li_count + 1;
1068: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1069: := 'P_PERSON_TYPE_ID';
1070: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1071: := p_person_type_id;
1072: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1073: := 'NUMBER';
1074:
1068: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1069: := 'P_PERSON_TYPE_ID';
1070: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1071: := p_person_type_id;
1072: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1073: := 'NUMBER';
1074:
1075: li_count := li_count + 1;
1076: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1072: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1073: := 'NUMBER';
1074:
1075: li_count := li_count + 1;
1076: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1077: := 'P_ASSIGNMENT_STATUS_TYPE_ID';
1078: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1079: := p_assignment_status_type_id;
1080: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1074:
1075: li_count := li_count + 1;
1076: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1077: := 'P_ASSIGNMENT_STATUS_TYPE_ID';
1078: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1079: := p_assignment_status_type_id;
1080: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1081: := 'NUMBER';
1082:
1076: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1077: := 'P_ASSIGNMENT_STATUS_TYPE_ID';
1078: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1079: := p_assignment_status_type_id;
1080: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1081: := 'NUMBER';
1082:
1083: li_count := li_count + 1;
1084: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1080: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1081: := 'NUMBER';
1082:
1083: li_count := li_count + 1;
1084: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1085: := 'P_REHIRE_RECOMMENDATION';
1086: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1087: := p_rehire_recommendation;
1088: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1082:
1083: li_count := li_count + 1;
1084: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1085: := 'P_REHIRE_RECOMMENDATION';
1086: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1087: := p_rehire_recommendation;
1088: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1089: := 'VARCHAR2';
1090:
1084: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1085: := 'P_REHIRE_RECOMMENDATION';
1086: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1087: := p_rehire_recommendation;
1088: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1089: := 'VARCHAR2';
1090:
1091: li_count := li_count + 1;
1092: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1088: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1089: := 'VARCHAR2';
1090:
1091: li_count := li_count + 1;
1092: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1093: := 'P_REHIRE_REASON';
1094: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1095: := p_rehire_reason;
1096: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1090:
1091: li_count := li_count + 1;
1092: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1093: := 'P_REHIRE_REASON';
1094: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1095: := p_rehire_reason;
1096: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1097: := 'VARCHAR2';
1098:
1092: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1093: := 'P_REHIRE_REASON';
1094: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1095: := p_rehire_reason;
1096: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1097: := 'VARCHAR2';
1098:
1099: li_count := li_count + 1;
1100: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1096: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1097: := 'VARCHAR2';
1098:
1099: li_count := li_count + 1;
1100: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1101: := 'P_NOTIFIED_TERMINATION_DATE';
1102: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1103: := p_notified_termination_date;
1104: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1098:
1099: li_count := li_count + 1;
1100: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1101: := 'P_NOTIFIED_TERMINATION_DATE';
1102: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1103: := p_notified_termination_date;
1104: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1105: := 'DATE';
1106:
1100: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1101: := 'P_NOTIFIED_TERMINATION_DATE';
1102: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1103: := p_notified_termination_date;
1104: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1105: := 'DATE';
1106:
1107: li_count := li_count + 1;
1108: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1104: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1105: := 'DATE';
1106:
1107: li_count := li_count + 1;
1108: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1109: := 'P_LAST_STANDARD_PROCESS_DATE';
1110: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1111: := p_last_standard_process_date;
1112: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1106:
1107: li_count := li_count + 1;
1108: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1109: := 'P_LAST_STANDARD_PROCESS_DATE';
1110: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1111: := p_last_standard_process_date;
1112: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1113: := 'DATE';
1114:
1108: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1109: := 'P_LAST_STANDARD_PROCESS_DATE';
1110: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1111: := p_last_standard_process_date;
1112: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1113: := 'DATE';
1114:
1115: li_count := li_count + 1;
1116: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1112: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1113: := 'DATE';
1114:
1115: li_count := li_count + 1;
1116: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1117: := 'P_PROJECTED_TERMINATION_DATE';
1118: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1119: := p_projected_termination_date;
1120: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1114:
1115: li_count := li_count + 1;
1116: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1117: := 'P_PROJECTED_TERMINATION_DATE';
1118: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1119: := p_projected_termination_date;
1120: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1121: := 'DATE';
1122:
1116: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1117: := 'P_PROJECTED_TERMINATION_DATE';
1118: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1119: := p_projected_termination_date;
1120: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1121: := 'DATE';
1122:
1123: li_count := li_count + 1;
1124: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1120: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1121: := 'DATE';
1122:
1123: li_count := li_count + 1;
1124: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1125: := 'P_FINAL_PROCESS_DATE';
1126: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1127: := p_final_process_date;
1128: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1122:
1123: li_count := li_count + 1;
1124: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1125: := 'P_FINAL_PROCESS_DATE';
1126: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1127: := p_final_process_date;
1128: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1129: := 'DATE';
1130:
1124: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1125: := 'P_FINAL_PROCESS_DATE';
1126: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1127: := p_final_process_date;
1128: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1129: := 'DATE';
1130:
1131: li_count := li_count + 1;
1132: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1128: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1129: := 'DATE';
1130:
1131: li_count := li_count + 1;
1132: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1133: := 'P_COMMENTS';
1134: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1135: := p_comments;
1136: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1130:
1131: li_count := li_count + 1;
1132: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1133: := 'P_COMMENTS';
1134: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1135: := p_comments;
1136: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1137: := 'VARCHAR2';
1138:
1132: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1133: := 'P_COMMENTS';
1134: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1135: := p_comments;
1136: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1137: := 'VARCHAR2';
1138:
1139: ----------------------------------------------------------------------
1140: -- DDF repeat 20 times
1140: -- DDF repeat 20 times
1141: ----------------------------------------------------------------------
1142:
1143: li_count := li_count + 1;
1144: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1145: := 'P_ATTRIBUTE_CATEGORY';
1146: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1147: := p_attribute_category;
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1142:
1143: li_count := li_count + 1;
1144: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1145: := 'P_ATTRIBUTE_CATEGORY';
1146: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1147: := p_attribute_category;
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1149: := 'VARCHAR2';
1150:
1144: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1145: := 'P_ATTRIBUTE_CATEGORY';
1146: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1147: := p_attribute_category;
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1149: := 'VARCHAR2';
1150:
1151: li_count := li_count + 1;
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1149: := 'VARCHAR2';
1150:
1151: li_count := li_count + 1;
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1153: := 'P_ATTRIBUTE1';
1154: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1155: := p_attribute1;
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1150:
1151: li_count := li_count + 1;
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1153: := 'P_ATTRIBUTE1';
1154: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1155: := p_attribute1;
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1157: := 'VARCHAR2';
1158:
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1153: := 'P_ATTRIBUTE1';
1154: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1155: := p_attribute1;
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1157: := 'VARCHAR2';
1158:
1159: li_count := li_count + 1;
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1157: := 'VARCHAR2';
1158:
1159: li_count := li_count + 1;
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1161: := 'P_ATTRIBUTE2';
1162: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1163: := p_attribute2;
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1158:
1159: li_count := li_count + 1;
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1161: := 'P_ATTRIBUTE2';
1162: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1163: := p_attribute2;
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1165: := 'VARCHAR2';
1166:
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1161: := 'P_ATTRIBUTE2';
1162: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1163: := p_attribute2;
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1165: := 'VARCHAR2';
1166:
1167: li_count := li_count + 1;
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1165: := 'VARCHAR2';
1166:
1167: li_count := li_count + 1;
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1169: := 'P_ATTRIBUTE3';
1170: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1171: := p_attribute3;
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1166:
1167: li_count := li_count + 1;
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1169: := 'P_ATTRIBUTE3';
1170: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1171: := p_attribute3;
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1173: := 'VARCHAR2';
1174:
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1169: := 'P_ATTRIBUTE3';
1170: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1171: := p_attribute3;
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1173: := 'VARCHAR2';
1174:
1175: li_count := li_count + 1;
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1173: := 'VARCHAR2';
1174:
1175: li_count := li_count + 1;
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1177: := 'P_ATTRIBUTE4';
1178: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1179: := p_attribute4;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1174:
1175: li_count := li_count + 1;
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1177: := 'P_ATTRIBUTE4';
1178: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1179: := p_attribute4;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1181: := 'VARCHAR2';
1182:
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1177: := 'P_ATTRIBUTE4';
1178: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1179: := p_attribute4;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1181: := 'VARCHAR2';
1182:
1183: li_count := li_count + 1;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1181: := 'VARCHAR2';
1182:
1183: li_count := li_count + 1;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1185: := 'P_ATTRIBUTE5';
1186: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1187: := p_attribute5;
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1182:
1183: li_count := li_count + 1;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1185: := 'P_ATTRIBUTE5';
1186: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1187: := p_attribute5;
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1189: := 'VARCHAR2';
1190:
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1185: := 'P_ATTRIBUTE5';
1186: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1187: := p_attribute5;
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1189: := 'VARCHAR2';
1190:
1191: li_count := li_count + 1;
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1189: := 'VARCHAR2';
1190:
1191: li_count := li_count + 1;
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1193: := 'P_ATTRIBUTE6';
1194: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1195: := p_attribute6;
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1190:
1191: li_count := li_count + 1;
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1193: := 'P_ATTRIBUTE6';
1194: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1195: := p_attribute6;
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1197: := 'VARCHAR2';
1198:
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1193: := 'P_ATTRIBUTE6';
1194: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1195: := p_attribute6;
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1197: := 'VARCHAR2';
1198:
1199: li_count := li_count + 1;
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1197: := 'VARCHAR2';
1198:
1199: li_count := li_count + 1;
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1201: := 'P_ATTRIBUTE7';
1202: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1203: := p_attribute7;
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1198:
1199: li_count := li_count + 1;
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1201: := 'P_ATTRIBUTE7';
1202: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1203: := p_attribute7;
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1205: := 'VARCHAR2';
1206:
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1201: := 'P_ATTRIBUTE7';
1202: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1203: := p_attribute7;
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1205: := 'VARCHAR2';
1206:
1207: li_count := li_count + 1;
1208: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1205: := 'VARCHAR2';
1206:
1207: li_count := li_count + 1;
1208: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1209: := 'P_ATTRIBUTE8';
1210: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1211: := p_attribute8;
1212: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1206:
1207: li_count := li_count + 1;
1208: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1209: := 'P_ATTRIBUTE8';
1210: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1211: := p_attribute8;
1212: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1213: := 'VARCHAR2';
1214:
1208: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1209: := 'P_ATTRIBUTE8';
1210: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1211: := p_attribute8;
1212: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1213: := 'VARCHAR2';
1214:
1215: li_count := li_count + 1;
1216: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1212: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1213: := 'VARCHAR2';
1214:
1215: li_count := li_count + 1;
1216: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1217: := 'P_ATTRIBUTE9';
1218: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1219: := p_attribute9;
1220: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1214:
1215: li_count := li_count + 1;
1216: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1217: := 'P_ATTRIBUTE9';
1218: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1219: := p_attribute9;
1220: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1221: := 'VARCHAR2';
1222:
1216: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1217: := 'P_ATTRIBUTE9';
1218: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1219: := p_attribute9;
1220: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1221: := 'VARCHAR2';
1222:
1223: li_count := li_count + 1;
1224: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1220: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1221: := 'VARCHAR2';
1222:
1223: li_count := li_count + 1;
1224: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1225: := 'P_ATTRIBUTE10';
1226: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1227: := p_attribute10;
1228: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1222:
1223: li_count := li_count + 1;
1224: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1225: := 'P_ATTRIBUTE10';
1226: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1227: := p_attribute10;
1228: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1229: := 'VARCHAR2';
1230:
1224: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1225: := 'P_ATTRIBUTE10';
1226: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1227: := p_attribute10;
1228: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1229: := 'VARCHAR2';
1230:
1231: li_count := li_count + 1;
1232: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1228: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1229: := 'VARCHAR2';
1230:
1231: li_count := li_count + 1;
1232: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1233: := 'P_ATTRIBUTE11';
1234: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1235: := p_attribute11;
1236: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1230:
1231: li_count := li_count + 1;
1232: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1233: := 'P_ATTRIBUTE11';
1234: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1235: := p_attribute11;
1236: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1237: := 'VARCHAR2';
1238:
1232: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1233: := 'P_ATTRIBUTE11';
1234: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1235: := p_attribute11;
1236: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1237: := 'VARCHAR2';
1238:
1239: li_count := li_count + 1;
1240: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1236: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1237: := 'VARCHAR2';
1238:
1239: li_count := li_count + 1;
1240: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1241: := 'P_ATTRIBUTE12';
1242: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1243: := p_attribute12;
1244: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1238:
1239: li_count := li_count + 1;
1240: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1241: := 'P_ATTRIBUTE12';
1242: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1243: := p_attribute12;
1244: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1245: := 'VARCHAR2';
1246:
1240: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1241: := 'P_ATTRIBUTE12';
1242: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1243: := p_attribute12;
1244: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1245: := 'VARCHAR2';
1246:
1247: li_count := li_count + 1;
1248: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1244: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1245: := 'VARCHAR2';
1246:
1247: li_count := li_count + 1;
1248: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1249: := 'P_ATTRIBUTE13';
1250: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1251: := p_attribute13;
1252: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1246:
1247: li_count := li_count + 1;
1248: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1249: := 'P_ATTRIBUTE13';
1250: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1251: := p_attribute13;
1252: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1253: := 'VARCHAR2';
1254:
1248: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1249: := 'P_ATTRIBUTE13';
1250: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1251: := p_attribute13;
1252: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1253: := 'VARCHAR2';
1254:
1255: li_count := li_count + 1;
1256: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1252: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1253: := 'VARCHAR2';
1254:
1255: li_count := li_count + 1;
1256: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1257: := 'P_ATTRIBUTE14';
1258: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1259: := p_attribute14;
1260: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1254:
1255: li_count := li_count + 1;
1256: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1257: := 'P_ATTRIBUTE14';
1258: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1259: := p_attribute14;
1260: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1261: := 'VARCHAR2';
1262:
1256: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1257: := 'P_ATTRIBUTE14';
1258: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1259: := p_attribute14;
1260: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1261: := 'VARCHAR2';
1262:
1263: li_count := li_count + 1;
1264: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1260: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1261: := 'VARCHAR2';
1262:
1263: li_count := li_count + 1;
1264: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1265: := 'P_ATTRIBUTE15';
1266: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1267: := p_attribute15;
1268: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1262:
1263: li_count := li_count + 1;
1264: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1265: := 'P_ATTRIBUTE15';
1266: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1267: := p_attribute15;
1268: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1269: := 'VARCHAR2';
1270:
1264: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1265: := 'P_ATTRIBUTE15';
1266: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1267: := p_attribute15;
1268: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1269: := 'VARCHAR2';
1270:
1271: li_count := li_count + 1;
1272: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1268: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1269: := 'VARCHAR2';
1270:
1271: li_count := li_count + 1;
1272: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1273: := 'P_ATTRIBUTE16';
1274: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1275: := p_attribute16;
1276: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1270:
1271: li_count := li_count + 1;
1272: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1273: := 'P_ATTRIBUTE16';
1274: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1275: := p_attribute16;
1276: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1277: := 'VARCHAR2';
1278:
1272: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1273: := 'P_ATTRIBUTE16';
1274: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1275: := p_attribute16;
1276: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1277: := 'VARCHAR2';
1278:
1279: li_count := li_count + 1;
1280: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1276: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1277: := 'VARCHAR2';
1278:
1279: li_count := li_count + 1;
1280: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1281: := 'P_ATTRIBUTE17';
1282: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1283: := p_attribute17;
1284: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1278:
1279: li_count := li_count + 1;
1280: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1281: := 'P_ATTRIBUTE17';
1282: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1283: := p_attribute17;
1284: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1285: := 'VARCHAR2';
1286:
1280: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1281: := 'P_ATTRIBUTE17';
1282: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1283: := p_attribute17;
1284: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1285: := 'VARCHAR2';
1286:
1287: li_count := li_count + 1;
1288: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1284: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1285: := 'VARCHAR2';
1286:
1287: li_count := li_count + 1;
1288: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1289: := 'P_ATTRIBUTE18';
1290: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1291: := p_attribute18;
1292: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1286:
1287: li_count := li_count + 1;
1288: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1289: := 'P_ATTRIBUTE18';
1290: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1291: := p_attribute18;
1292: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1293: := 'VARCHAR2';
1294:
1288: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1289: := 'P_ATTRIBUTE18';
1290: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1291: := p_attribute18;
1292: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1293: := 'VARCHAR2';
1294:
1295: li_count := li_count + 1;
1296: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1292: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1293: := 'VARCHAR2';
1294:
1295: li_count := li_count + 1;
1296: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1297: := 'P_ATTRIBUTE19';
1298: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1299: := p_attribute19;
1300: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1294:
1295: li_count := li_count + 1;
1296: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1297: := 'P_ATTRIBUTE19';
1298: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1299: := p_attribute19;
1300: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1301: := 'VARCHAR2';
1302:
1296: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1297: := 'P_ATTRIBUTE19';
1298: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1299: := p_attribute19;
1300: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1301: := 'VARCHAR2';
1302:
1303: li_count := li_count + 1;
1304: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1300: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1301: := 'VARCHAR2';
1302:
1303: li_count := li_count + 1;
1304: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1305: := 'P_ATTRIBUTE20';
1306: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1307: := p_attribute20;
1308: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1302:
1303: li_count := li_count + 1;
1304: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1305: := 'P_ATTRIBUTE20';
1306: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1307: := p_attribute20;
1308: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1309: := 'VARCHAR2';
1310:
1304: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1305: := 'P_ATTRIBUTE20';
1306: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1307: := p_attribute20;
1308: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1309: := 'VARCHAR2';
1310:
1311: ----------------------------------------------------------------------
1312: -- Store the activity internal name for this particular
1311: ----------------------------------------------------------------------
1312: -- Store the activity internal name for this particular
1313: -- activity with other information.
1314: ----------------------------------------------------------------------
1315: lv_activity_name := hr_termination_ss.gv_TERMINATION_ACTIVITY_NAME;
1316: li_count := li_count + 1;
1317: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1318: := 'P_ACTIVITY_NAME';
1319: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1313: -- activity with other information.
1314: ----------------------------------------------------------------------
1315: lv_activity_name := hr_termination_ss.gv_TERMINATION_ACTIVITY_NAME;
1316: li_count := li_count + 1;
1317: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1318: := 'P_ACTIVITY_NAME';
1319: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1320: := lv_activity_name;
1321: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1315: lv_activity_name := hr_termination_ss.gv_TERMINATION_ACTIVITY_NAME;
1316: li_count := li_count + 1;
1317: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1318: := 'P_ACTIVITY_NAME';
1319: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1320: := lv_activity_name;
1321: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1322: := 'VARCHAR2';
1323:
1317: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1318: := 'P_ACTIVITY_NAME';
1319: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1320: := lv_activity_name;
1321: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1322: := 'VARCHAR2';
1323:
1324: ----------------------------------------------------------------------
1325: -- Store the the Review Procedure Call and
1325: -- Store the the Review Procedure Call and
1326: -- activity id with other information.
1327: ----------------------------------------------------------------------
1328: li_count := li_count + 1;
1329: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1330: := 'P_REVIEW_PROC_CALL';
1331: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1332: := p_review_proc_call;
1333: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1327: ----------------------------------------------------------------------
1328: li_count := li_count + 1;
1329: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1330: := 'P_REVIEW_PROC_CALL';
1331: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1332: := p_review_proc_call;
1333: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1334: := 'VARCHAR2';
1335:
1329: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1330: := 'P_REVIEW_PROC_CALL';
1331: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1332: := p_review_proc_call;
1333: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1334: := 'VARCHAR2';
1335:
1336: li_count := li_count + 1;
1337: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1333: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1334: := 'VARCHAR2';
1335:
1336: li_count := li_count + 1;
1337: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1338: := 'P_REVIEW_ACTID';
1339: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1340: := p_actid;
1341: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1335:
1336: li_count := li_count + 1;
1337: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1338: := 'P_REVIEW_ACTID';
1339: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1340: := p_actid;
1341: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1342: := 'VARCHAR2';
1343:
1337: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1338: := 'P_REVIEW_ACTID';
1339: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1340: := p_actid;
1341: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1342: := 'VARCHAR2';
1343:
1344: ---------------------------------------------------------------------
1345: -- DDF Enhancement
1346: -- Store DDF Segments
1347: ---------------------------------------------------------------------
1348:
1349: li_count := li_count + 1;
1350: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1351: := 'P_PDS_INFORMATION_CATEGORY';
1352: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1353: := p_pds_information_category;
1354: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1348:
1349: li_count := li_count + 1;
1350: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1351: := 'P_PDS_INFORMATION_CATEGORY';
1352: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1353: := p_pds_information_category;
1354: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1355: := 'VARCHAR2';
1356:
1350: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1351: := 'P_PDS_INFORMATION_CATEGORY';
1352: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1353: := p_pds_information_category;
1354: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1355: := 'VARCHAR2';
1356:
1357: li_count := li_count + 1;
1358: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1354: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1355: := 'VARCHAR2';
1356:
1357: li_count := li_count + 1;
1358: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1359: := 'P_PDS_INFORMATION1';
1360: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1361: := p_pds_information1;
1362: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1356:
1357: li_count := li_count + 1;
1358: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1359: := 'P_PDS_INFORMATION1';
1360: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1361: := p_pds_information1;
1362: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1363: := 'VARCHAR2';
1364:
1358: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1359: := 'P_PDS_INFORMATION1';
1360: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1361: := p_pds_information1;
1362: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1363: := 'VARCHAR2';
1364:
1365: li_count := li_count + 1;
1366: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1362: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1363: := 'VARCHAR2';
1364:
1365: li_count := li_count + 1;
1366: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1367: := 'P_PDS_INFORMATION2';
1368: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1369: := p_pds_information2;
1370: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1364:
1365: li_count := li_count + 1;
1366: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1367: := 'P_PDS_INFORMATION2';
1368: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1369: := p_pds_information2;
1370: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1371: := 'VARCHAR2';
1372:
1366: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1367: := 'P_PDS_INFORMATION2';
1368: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1369: := p_pds_information2;
1370: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1371: := 'VARCHAR2';
1372:
1373: li_count := li_count + 1;
1374: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1370: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1371: := 'VARCHAR2';
1372:
1373: li_count := li_count + 1;
1374: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1375: := 'P_PDS_INFORMATION3';
1376: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1377: := p_pds_information3;
1378: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1372:
1373: li_count := li_count + 1;
1374: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1375: := 'P_PDS_INFORMATION3';
1376: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1377: := p_pds_information3;
1378: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1379: := 'VARCHAR2';
1380:
1374: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1375: := 'P_PDS_INFORMATION3';
1376: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1377: := p_pds_information3;
1378: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1379: := 'VARCHAR2';
1380:
1381: li_count := li_count + 1;
1382: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1378: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1379: := 'VARCHAR2';
1380:
1381: li_count := li_count + 1;
1382: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1383: := 'P_PDS_INFORMATION4';
1384: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1385: := p_pds_information4;
1386: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1380:
1381: li_count := li_count + 1;
1382: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1383: := 'P_PDS_INFORMATION4';
1384: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1385: := p_pds_information4;
1386: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1387: := 'VARCHAR2';
1388:
1382: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1383: := 'P_PDS_INFORMATION4';
1384: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1385: := p_pds_information4;
1386: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1387: := 'VARCHAR2';
1388:
1389: li_count := li_count + 1;
1390: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1386: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1387: := 'VARCHAR2';
1388:
1389: li_count := li_count + 1;
1390: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1391: := 'P_PDS_INFORMATION5';
1392: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1393: := p_pds_information5;
1394: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1388:
1389: li_count := li_count + 1;
1390: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1391: := 'P_PDS_INFORMATION5';
1392: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1393: := p_pds_information5;
1394: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1395: := 'VARCHAR2';
1396:
1390: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1391: := 'P_PDS_INFORMATION5';
1392: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1393: := p_pds_information5;
1394: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1395: := 'VARCHAR2';
1396:
1397: li_count := li_count + 1;
1398: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1394: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1395: := 'VARCHAR2';
1396:
1397: li_count := li_count + 1;
1398: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1399: := 'P_PDS_INFORMATION6';
1400: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1401: := p_pds_information6;
1402: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1396:
1397: li_count := li_count + 1;
1398: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1399: := 'P_PDS_INFORMATION6';
1400: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1401: := p_pds_information6;
1402: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1403: := 'VARCHAR2';
1404:
1398: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1399: := 'P_PDS_INFORMATION6';
1400: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1401: := p_pds_information6;
1402: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1403: := 'VARCHAR2';
1404:
1405: li_count := li_count + 1;
1406: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1402: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1403: := 'VARCHAR2';
1404:
1405: li_count := li_count + 1;
1406: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1407: := 'P_PDS_INFORMATION7';
1408: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1409: := p_pds_information7;
1410: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1404:
1405: li_count := li_count + 1;
1406: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1407: := 'P_PDS_INFORMATION7';
1408: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1409: := p_pds_information7;
1410: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1411: := 'VARCHAR2';
1412:
1406: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1407: := 'P_PDS_INFORMATION7';
1408: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1409: := p_pds_information7;
1410: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1411: := 'VARCHAR2';
1412:
1413: li_count := li_count + 1;
1414: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1410: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1411: := 'VARCHAR2';
1412:
1413: li_count := li_count + 1;
1414: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1415: := 'P_PDS_INFORMATION8';
1416: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1417: := p_pds_information8;
1418: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1412:
1413: li_count := li_count + 1;
1414: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1415: := 'P_PDS_INFORMATION8';
1416: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1417: := p_pds_information8;
1418: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1419: := 'VARCHAR2';
1420:
1414: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1415: := 'P_PDS_INFORMATION8';
1416: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1417: := p_pds_information8;
1418: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1419: := 'VARCHAR2';
1420:
1421: li_count := li_count + 1;
1422: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1418: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1419: := 'VARCHAR2';
1420:
1421: li_count := li_count + 1;
1422: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1423: := 'P_PDS_INFORMATION9';
1424: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1425: := p_pds_information9;
1426: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1420:
1421: li_count := li_count + 1;
1422: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1423: := 'P_PDS_INFORMATION9';
1424: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1425: := p_pds_information9;
1426: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1427: := 'VARCHAR2';
1428:
1422: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1423: := 'P_PDS_INFORMATION9';
1424: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1425: := p_pds_information9;
1426: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1427: := 'VARCHAR2';
1428:
1429: li_count := li_count + 1;
1430: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1426: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1427: := 'VARCHAR2';
1428:
1429: li_count := li_count + 1;
1430: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1431: := 'P_PDS_INFORMATION10';
1432: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1433: := p_pds_information10;
1434: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1428:
1429: li_count := li_count + 1;
1430: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1431: := 'P_PDS_INFORMATION10';
1432: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1433: := p_pds_information10;
1434: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1435: := 'VARCHAR2';
1436:
1430: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1431: := 'P_PDS_INFORMATION10';
1432: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1433: := p_pds_information10;
1434: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1435: := 'VARCHAR2';
1436:
1437: li_count := li_count + 1;
1438: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1434: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1435: := 'VARCHAR2';
1436:
1437: li_count := li_count + 1;
1438: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1439: := 'P_PDS_INFORMATION11';
1440: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1441: := p_pds_information11;
1442: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1436:
1437: li_count := li_count + 1;
1438: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1439: := 'P_PDS_INFORMATION11';
1440: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1441: := p_pds_information11;
1442: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1443: := 'VARCHAR2';
1444:
1438: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1439: := 'P_PDS_INFORMATION11';
1440: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1441: := p_pds_information11;
1442: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1443: := 'VARCHAR2';
1444:
1445: li_count := li_count + 1;
1446: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1442: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1443: := 'VARCHAR2';
1444:
1445: li_count := li_count + 1;
1446: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1447: := 'P_PDS_INFORMATION12';
1448: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1449: := p_pds_information12;
1450: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1444:
1445: li_count := li_count + 1;
1446: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1447: := 'P_PDS_INFORMATION12';
1448: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1449: := p_pds_information12;
1450: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1451: := 'VARCHAR2';
1452:
1446: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1447: := 'P_PDS_INFORMATION12';
1448: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1449: := p_pds_information12;
1450: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1451: := 'VARCHAR2';
1452:
1453: li_count := li_count + 1;
1454: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1450: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1451: := 'VARCHAR2';
1452:
1453: li_count := li_count + 1;
1454: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1455: := 'P_PDS_INFORMATION13';
1456: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1457: := p_pds_information13;
1458: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1452:
1453: li_count := li_count + 1;
1454: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1455: := 'P_PDS_INFORMATION13';
1456: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1457: := p_pds_information13;
1458: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1459: := 'VARCHAR2';
1460:
1454: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1455: := 'P_PDS_INFORMATION13';
1456: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1457: := p_pds_information13;
1458: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1459: := 'VARCHAR2';
1460:
1461: li_count := li_count + 1;
1462: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1458: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1459: := 'VARCHAR2';
1460:
1461: li_count := li_count + 1;
1462: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1463: := 'P_PDS_INFORMATION14';
1464: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1465: := p_pds_information14;
1466: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1460:
1461: li_count := li_count + 1;
1462: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1463: := 'P_PDS_INFORMATION14';
1464: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1465: := p_pds_information14;
1466: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1467: := 'VARCHAR2';
1468:
1462: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1463: := 'P_PDS_INFORMATION14';
1464: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1465: := p_pds_information14;
1466: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1467: := 'VARCHAR2';
1468:
1469: li_count := li_count + 1;
1470: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1466: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1467: := 'VARCHAR2';
1468:
1469: li_count := li_count + 1;
1470: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1471: := 'P_PDS_INFORMATION15';
1472: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1473: := p_pds_information15;
1474: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1468:
1469: li_count := li_count + 1;
1470: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1471: := 'P_PDS_INFORMATION15';
1472: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1473: := p_pds_information15;
1474: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1475: := 'VARCHAR2';
1476:
1470: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1471: := 'P_PDS_INFORMATION15';
1472: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1473: := p_pds_information15;
1474: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1475: := 'VARCHAR2';
1476:
1477: li_count := li_count + 1;
1478: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1474: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1475: := 'VARCHAR2';
1476:
1477: li_count := li_count + 1;
1478: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1479: := 'P_PDS_INFORMATION16';
1480: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1481: := p_pds_information16;
1482: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1476:
1477: li_count := li_count + 1;
1478: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1479: := 'P_PDS_INFORMATION16';
1480: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1481: := p_pds_information16;
1482: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1483: := 'VARCHAR2';
1484:
1478: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1479: := 'P_PDS_INFORMATION16';
1480: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1481: := p_pds_information16;
1482: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1483: := 'VARCHAR2';
1484:
1485: li_count := li_count + 1;
1486: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1482: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1483: := 'VARCHAR2';
1484:
1485: li_count := li_count + 1;
1486: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1487: := 'P_PDS_INFORMATION17';
1488: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1489: := p_pds_information17;
1490: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1484:
1485: li_count := li_count + 1;
1486: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1487: := 'P_PDS_INFORMATION17';
1488: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1489: := p_pds_information17;
1490: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1491: := 'VARCHAR2';
1492:
1486: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1487: := 'P_PDS_INFORMATION17';
1488: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1489: := p_pds_information17;
1490: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1491: := 'VARCHAR2';
1492:
1493: li_count := li_count + 1;
1494: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1490: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1491: := 'VARCHAR2';
1492:
1493: li_count := li_count + 1;
1494: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1495: := 'P_PDS_INFORMATION18';
1496: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1497: := p_pds_information18;
1498: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1492:
1493: li_count := li_count + 1;
1494: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1495: := 'P_PDS_INFORMATION18';
1496: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1497: := p_pds_information18;
1498: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1499: := 'VARCHAR2';
1500:
1494: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1495: := 'P_PDS_INFORMATION18';
1496: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1497: := p_pds_information18;
1498: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1499: := 'VARCHAR2';
1500:
1501: li_count := li_count + 1;
1502: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1498: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1499: := 'VARCHAR2';
1500:
1501: li_count := li_count + 1;
1502: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1503: := 'P_PDS_INFORMATION19';
1504: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1505: := p_pds_information19;
1506: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1500:
1501: li_count := li_count + 1;
1502: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1503: := 'P_PDS_INFORMATION19';
1504: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1505: := p_pds_information19;
1506: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1507: := 'VARCHAR2';
1508:
1502: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1503: := 'P_PDS_INFORMATION19';
1504: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1505: := p_pds_information19;
1506: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1507: := 'VARCHAR2';
1508:
1509: li_count := li_count + 1;
1510: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1506: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1507: := 'VARCHAR2';
1508:
1509: li_count := li_count + 1;
1510: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1511: := 'P_PDS_INFORMATION20';
1512: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1513: := p_pds_information20;
1514: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1508:
1509: li_count := li_count + 1;
1510: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1511: := 'P_PDS_INFORMATION20';
1512: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1513: := p_pds_information20;
1514: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1515: := 'VARCHAR2';
1516:
1510: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1511: := 'P_PDS_INFORMATION20';
1512: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1513: := p_pds_information20;
1514: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1515: := 'VARCHAR2';
1516:
1517: li_count := li_count + 1;
1518: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1514: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1515: := 'VARCHAR2';
1516:
1517: li_count := li_count + 1;
1518: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1519: := 'P_PDS_INFORMATION21';
1520: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1521: := p_pds_information21;
1522: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1516:
1517: li_count := li_count + 1;
1518: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1519: := 'P_PDS_INFORMATION21';
1520: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1521: := p_pds_information21;
1522: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1523: := 'VARCHAR2';
1524:
1518: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1519: := 'P_PDS_INFORMATION21';
1520: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1521: := p_pds_information21;
1522: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1523: := 'VARCHAR2';
1524:
1525: li_count := li_count + 1;
1526: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1522: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1523: := 'VARCHAR2';
1524:
1525: li_count := li_count + 1;
1526: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1527: := 'P_PDS_INFORMATION22';
1528: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1529: := p_pds_information22;
1530: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1524:
1525: li_count := li_count + 1;
1526: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1527: := 'P_PDS_INFORMATION22';
1528: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1529: := p_pds_information22;
1530: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1531: := 'VARCHAR2';
1532:
1526: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1527: := 'P_PDS_INFORMATION22';
1528: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1529: := p_pds_information22;
1530: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1531: := 'VARCHAR2';
1532:
1533: li_count := li_count + 1;
1534: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1530: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1531: := 'VARCHAR2';
1532:
1533: li_count := li_count + 1;
1534: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1535: := 'P_PDS_INFORMATION23';
1536: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1537: := p_pds_information23;
1538: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1532:
1533: li_count := li_count + 1;
1534: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1535: := 'P_PDS_INFORMATION23';
1536: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1537: := p_pds_information23;
1538: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1539: := 'VARCHAR2';
1540:
1534: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1535: := 'P_PDS_INFORMATION23';
1536: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1537: := p_pds_information23;
1538: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1539: := 'VARCHAR2';
1540:
1541: li_count := li_count + 1;
1542: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1538: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1539: := 'VARCHAR2';
1540:
1541: li_count := li_count + 1;
1542: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1543: := 'P_PDS_INFORMATION24';
1544: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1545: := p_pds_information24;
1546: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1540:
1541: li_count := li_count + 1;
1542: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1543: := 'P_PDS_INFORMATION24';
1544: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1545: := p_pds_information24;
1546: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1547: := 'VARCHAR2';
1548:
1542: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1543: := 'P_PDS_INFORMATION24';
1544: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1545: := p_pds_information24;
1546: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1547: := 'VARCHAR2';
1548:
1549: li_count := li_count + 1;
1550: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1546: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1547: := 'VARCHAR2';
1548:
1549: li_count := li_count + 1;
1550: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1551: := 'P_PDS_INFORMATION25';
1552: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1553: := p_pds_information25;
1554: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1548:
1549: li_count := li_count + 1;
1550: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1551: := 'P_PDS_INFORMATION25';
1552: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1553: := p_pds_information25;
1554: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1555: := 'VARCHAR2';
1556:
1550: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1551: := 'P_PDS_INFORMATION25';
1552: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1553: := p_pds_information25;
1554: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1555: := 'VARCHAR2';
1556:
1557: li_count := li_count + 1;
1558: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1554: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1555: := 'VARCHAR2';
1556:
1557: li_count := li_count + 1;
1558: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1559: := 'P_PDS_INFORMATION26';
1560: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1561: := p_pds_information26;
1562: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1556:
1557: li_count := li_count + 1;
1558: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1559: := 'P_PDS_INFORMATION26';
1560: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1561: := p_pds_information26;
1562: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1563: := 'VARCHAR2';
1564:
1558: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1559: := 'P_PDS_INFORMATION26';
1560: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1561: := p_pds_information26;
1562: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1563: := 'VARCHAR2';
1564:
1565: li_count := li_count + 1;
1566: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1562: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1563: := 'VARCHAR2';
1564:
1565: li_count := li_count + 1;
1566: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1567: := 'P_PDS_INFORMATION27';
1568: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1569: := p_pds_information27;
1570: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1564:
1565: li_count := li_count + 1;
1566: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1567: := 'P_PDS_INFORMATION27';
1568: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1569: := p_pds_information27;
1570: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1571: := 'VARCHAR2';
1572:
1566: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1567: := 'P_PDS_INFORMATION27';
1568: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1569: := p_pds_information27;
1570: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1571: := 'VARCHAR2';
1572:
1573: li_count := li_count + 1;
1574: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1570: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1571: := 'VARCHAR2';
1572:
1573: li_count := li_count + 1;
1574: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1575: := 'P_PDS_INFORMATION28';
1576: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1577: := p_pds_information28;
1578: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1572:
1573: li_count := li_count + 1;
1574: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1575: := 'P_PDS_INFORMATION28';
1576: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1577: := p_pds_information28;
1578: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1579: := 'VARCHAR2';
1580:
1574: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1575: := 'P_PDS_INFORMATION28';
1576: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1577: := p_pds_information28;
1578: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1579: := 'VARCHAR2';
1580:
1581: li_count := li_count + 1;
1582: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1578: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1579: := 'VARCHAR2';
1580:
1581: li_count := li_count + 1;
1582: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1583: := 'P_PDS_INFORMATION29';
1584: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1585: := p_pds_information29;
1586: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1580:
1581: li_count := li_count + 1;
1582: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1583: := 'P_PDS_INFORMATION29';
1584: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1585: := p_pds_information29;
1586: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1587: := 'VARCHAR2';
1588:
1582: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1583: := 'P_PDS_INFORMATION29';
1584: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1585: := p_pds_information29;
1586: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1587: := 'VARCHAR2';
1588:
1589: li_count := li_count + 1;
1590: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1586: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1587: := 'VARCHAR2';
1588:
1589: li_count := li_count + 1;
1590: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1591: := 'P_PDS_INFORMATION30';
1592: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1593: := p_pds_information30;
1594: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1588:
1589: li_count := li_count + 1;
1590: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1591: := 'P_PDS_INFORMATION30';
1592: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1593: := p_pds_information30;
1594: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1595: := 'VARCHAR2';
1596: ---------------------------------------------------------------------
1590: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1591: := 'P_PDS_INFORMATION30';
1592: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1593: := p_pds_information30;
1594: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1595: := 'VARCHAR2';
1596: ---------------------------------------------------------------------
1597: -- Check if there is already a transaction for this process?
1598: ---------------------------------------------------------------------
1675: p_item_Key => p_item_key,
1676: p_actid => TO_NUMBER(p_actid),
1677: p_login_person_id => p_login_person_id,
1678: p_transaction_step_id => ln_transaction_step_id,
1679: p_api_name => 'hr_termination_ss.process_save',
1680: p_transaction_data => hr_termination_ss.gtt_transaction_steps
1681: );
1682:
1683: -- 07/16/2001 Bug 1853417 Fix:
1676: p_actid => TO_NUMBER(p_actid),
1677: p_login_person_id => p_login_person_id,
1678: p_transaction_step_id => ln_transaction_step_id,
1679: p_api_name => 'hr_termination_ss.process_save',
1680: p_transaction_data => hr_termination_ss.gtt_transaction_steps
1681: );
1682:
1683: -- 07/16/2001 Bug 1853417 Fix:
1684: -- The code to check for existence of subordinates for the
1705: p_transaction_step_id IN NUMBER DEFAULT NULL,
1706: p_effective_date IN VARCHAR2 DEFAULT NULL
1707: )
1708: IS
1709: lrt_termination hr_termination_ss.rt_termination;
1710: ld_actual_term_date
1711: per_periods_of_service.actual_termination_date%TYPE;
1712: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1713: ll_term_comments per_periods_of_service.comments%TYPE;
1739: lb_pay_proposal_warning BOOLEAN;
1740: lb_dod_warning BOOLEAN;
1741:
1742: --DFF
1743: lt_term_flex hr_termination_ss.t_flex_table;
1744: lv_attribute_category VARCHAR2(100);
1745:
1746: --DDF Enhancement
1747: lv_pds_information_category VARCHAR2(100);
1891: end;
1892:
1893: -- Bug 2098595 Fix Begins: 11/12/2001
1894: -- Need to switch the order of calling the api. We need to call
1895: -- hr_termination_ss.update_pds_details first to set the flex segments
1896: -- before calling hr_ex_employee_api.actual_termination_emp.
1897: -- Otherwise, when there is a mandatory segment, we'll get an error
1898: -- as follows:
1899: -- The mandatory column Attribute??(also known as xxxx) has not been
2048: FUNCTION get_termination_details (
2049: p_transaction_step_id IN
2050: hr_api_transaction_steps.transaction_step_id%type
2051: )
2052: RETURN hr_termination_ss.rt_termination
2053: IS
2054: lrt_termination hr_termination_ss.rt_termination;
2055: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2056: BEGIN
2050: hr_api_transaction_steps.transaction_step_id%type
2051: )
2052: RETURN hr_termination_ss.rt_termination
2053: IS
2054: lrt_termination hr_termination_ss.rt_termination;
2055: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2056: BEGIN
2057: hr_utility.set_location('Entering: '|| l_proc,5);
2058: lrt_termination.notified_termination_date :=
2150: FUNCTION get_term_flex_detail (
2151: p_transaction_step_id IN
2152: hr_api_transaction_steps.transaction_step_id%type
2153: )
2154: RETURN hr_termination_ss.t_flex_table
2155: IS
2156: lt_term_flex hr_termination_ss.t_flex_table;
2157: l_proc constant varchar2(100) := g_package || 'get_term_flex_detail ';
2158: BEGIN
2152: hr_api_transaction_steps.transaction_step_id%type
2153: )
2154: RETURN hr_termination_ss.t_flex_table
2155: IS
2156: lt_term_flex hr_termination_ss.t_flex_table;
2157: l_proc constant varchar2(100) := g_package || 'get_term_flex_detail ';
2158: BEGIN
2159: ---- First 20 DFF Data
2160: ---- Next 30, DDF Data
2715: RAISE; -- Raise error here relevant to the new tech stack.
2716:
2717: END get_term_transaction;
2718:
2719: END hr_termination_ss;