1: PACKAGE BODY hr_termination_ss AS
2: /* $Header: hrtrmwrs.pkb 120.7.12020000.5 2013/03/11 12:51:04 sudedas 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
528: hr_utility.set_location('Entering: ' || l_proc,5);
529:
530: -- Bug 2098595 Fix Begins: 12/03/2001
531: -- Need to switch the order of calling the api. We need to call
532: -- hr_termination_ss.update_pds_details first to set the flex segments
533: -- before calling hr_ex_employee_api.actual_termination_emp.
534: -- Otherwise, when there is a mandatory segment, we'll get an error
535: -- as follows:
536: -- The mandatory column Attribute??(also known as xxxx) has not been
561: --
562: -- N.B. Local variable l_pds_information10 declared at
563: -- top of procedure
564: -- Also l_pds_information10 used in call to
565: -- hr_termination_ss.update_pds_details below
566: --------------------------------------------------------------
567: l_pds_information10 := p_pds_information10;
568: l_pds_information_category := p_pds_information_category;
569:
587: end if;
588: end if;
589: --
590:
591: hr_utility.trace('Calling hr_termination_ss.update_pds_details ' || l_proc);
592: hr_termination_ss.update_pds_details
593: (p_validate => 0
594: ,p_effective_date => p_effective_date
595: ,p_period_of_service_id => p_period_of_service_id
588: end if;
589: --
590:
591: hr_utility.trace('Calling hr_termination_ss.update_pds_details ' || l_proc);
592: hr_termination_ss.update_pds_details
593: (p_validate => 0
594: ,p_effective_date => p_effective_date
595: ,p_period_of_service_id => p_period_of_service_id
596: ,p_termination_accepted_person => p_termination_accepted_person
661:
662: -- Core HR API will not support update of field Rehire Recommendation
663: -- and Rehire Reason. Hence we make following call to Person API
664: -- to update the Fields.
665: hr_utility.trace('Calling hr_termination_ss.update_per_details ' || l_proc);
666: -- moved cursor definitions to new procedure , which can be called from
667: -- proces_api also.
668:
669: update_per_details(
759: -- message.
760: -- For example:
761: -- "Error: java.sql.SQLExcpetion: ORA-01400: cannot insert NULL into
762: -- ("HR"."PER_PERSON_LIST_CHANGES"."SECURITY_PROFILE_ID"). ORA-06512:
763: -- at "APPS.HR_TERMINATION_SS", line xxx ORA-06512: at line 1.
764: -- With the call to hr_java_conv_util_ss, the error message text will
765: -- become:
766: -- "Error: ORA-01400: cannot insert NULL into
767: -- ("HR"."PER_PERSON_LIST_CHANGES"."SECURITY_PROFILE_ID").
1096: -- Save data to transaction table.
1097: ----------------------------------------------------------------------
1098:
1099: li_count := 1;
1100: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1101: := 'P_ACTUAL_TERMINATION_DATE';
1102: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1103: := p_actual_termination_date;
1104: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1098:
1099: li_count := 1;
1100: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1101: := 'P_ACTUAL_TERMINATION_DATE';
1102: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1103: := p_actual_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_ACTUAL_TERMINATION_DATE';
1102: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1103: := p_actual_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_PERIOD_OF_SERVICE_ID';
1110: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1111: := p_period_of_service_id;
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_PERIOD_OF_SERVICE_ID';
1110: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1111: := p_period_of_service_id;
1112: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1113: := 'NUMBER';
1114:
1108: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1109: := 'P_PERIOD_OF_SERVICE_ID';
1110: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1111: := p_period_of_service_id;
1112: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1113: := 'NUMBER';
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: := 'NUMBER';
1114:
1115: li_count := li_count + 1;
1116: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1117: := 'P_PERSON_ID';
1118: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1119: := p_person_id;
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_PERSON_ID';
1118: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1119: := p_person_id;
1120: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1121: := 'NUMBER';
1122:
1116: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1117: := 'P_PERSON_ID';
1118: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1119: := p_person_id;
1120: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1121: := 'NUMBER';
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: := 'NUMBER';
1122:
1123: li_count := li_count + 1;
1124: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1125: := 'P_OBJECT_VERSION_NUMBER';
1126: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1127: := p_object_version_number;
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_OBJECT_VERSION_NUMBER';
1126: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1127: := p_object_version_number;
1128: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1129: := 'NUMBER';
1130:
1124: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1125: := 'P_OBJECT_VERSION_NUMBER';
1126: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1127: := p_object_version_number;
1128: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1129: := 'NUMBER';
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: := 'NUMBER';
1130:
1131: li_count := li_count + 1;
1132: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1133: := 'P_LEAVING_REASON';
1134: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1135: := p_leaving_reason;
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_LEAVING_REASON';
1134: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1135: := p_leaving_reason;
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_LEAVING_REASON';
1134: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1135: := p_leaving_reason;
1136: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1137: := 'VARCHAR2';
1138:
1139: li_count := li_count + 1;
1140: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1136: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1137: := 'VARCHAR2';
1138:
1139: li_count := li_count + 1;
1140: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1141: := 'P_PERSON_TYPE_ID';
1142: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1143: := p_person_type_id;
1144: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1138:
1139: li_count := li_count + 1;
1140: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1141: := 'P_PERSON_TYPE_ID';
1142: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1143: := p_person_type_id;
1144: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1145: := 'NUMBER';
1146:
1140: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1141: := 'P_PERSON_TYPE_ID';
1142: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1143: := p_person_type_id;
1144: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1145: := 'NUMBER';
1146:
1147: li_count := li_count + 1;
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1144: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1145: := 'NUMBER';
1146:
1147: li_count := li_count + 1;
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1149: := 'P_ASSIGNMENT_STATUS_TYPE_ID';
1150: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1151: := p_assignment_status_type_id;
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1146:
1147: li_count := li_count + 1;
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1149: := 'P_ASSIGNMENT_STATUS_TYPE_ID';
1150: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1151: := p_assignment_status_type_id;
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1153: := 'NUMBER';
1154:
1148: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1149: := 'P_ASSIGNMENT_STATUS_TYPE_ID';
1150: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1151: := p_assignment_status_type_id;
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1153: := 'NUMBER';
1154:
1155: li_count := li_count + 1;
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1152: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1153: := 'NUMBER';
1154:
1155: li_count := li_count + 1;
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1157: := 'P_REHIRE_RECOMMENDATION';
1158: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1159: := p_rehire_recommendation;
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1154:
1155: li_count := li_count + 1;
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1157: := 'P_REHIRE_RECOMMENDATION';
1158: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1159: := p_rehire_recommendation;
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1161: := 'VARCHAR2';
1162:
1156: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1157: := 'P_REHIRE_RECOMMENDATION';
1158: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1159: := p_rehire_recommendation;
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1161: := 'VARCHAR2';
1162:
1163: li_count := li_count + 1;
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1160: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1161: := 'VARCHAR2';
1162:
1163: li_count := li_count + 1;
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1165: := 'P_REHIRE_REASON';
1166: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1167: := p_rehire_reason;
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1162:
1163: li_count := li_count + 1;
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1165: := 'P_REHIRE_REASON';
1166: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1167: := p_rehire_reason;
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1169: := 'VARCHAR2';
1170:
1164: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1165: := 'P_REHIRE_REASON';
1166: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1167: := p_rehire_reason;
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1169: := 'VARCHAR2';
1170:
1171: li_count := li_count + 1;
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1168: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1169: := 'VARCHAR2';
1170:
1171: li_count := li_count + 1;
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1173: := 'P_NOTIFIED_TERMINATION_DATE';
1174: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1175: := p_notified_termination_date;
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1170:
1171: li_count := li_count + 1;
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1173: := 'P_NOTIFIED_TERMINATION_DATE';
1174: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1175: := p_notified_termination_date;
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1177: := 'DATE';
1178:
1172: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1173: := 'P_NOTIFIED_TERMINATION_DATE';
1174: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1175: := p_notified_termination_date;
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1177: := 'DATE';
1178:
1179: li_count := li_count + 1;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1176: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1177: := 'DATE';
1178:
1179: li_count := li_count + 1;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1181: := 'P_LAST_STANDARD_PROCESS_DATE';
1182: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1183: := p_last_standard_process_date;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1178:
1179: li_count := li_count + 1;
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1181: := 'P_LAST_STANDARD_PROCESS_DATE';
1182: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1183: := p_last_standard_process_date;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1185: := 'DATE';
1186:
1180: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1181: := 'P_LAST_STANDARD_PROCESS_DATE';
1182: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1183: := p_last_standard_process_date;
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1185: := 'DATE';
1186:
1187: li_count := li_count + 1;
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1184: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1185: := 'DATE';
1186:
1187: li_count := li_count + 1;
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1189: := 'P_PROJECTED_TERMINATION_DATE';
1190: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1191: := p_projected_termination_date;
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1186:
1187: li_count := li_count + 1;
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1189: := 'P_PROJECTED_TERMINATION_DATE';
1190: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1191: := p_projected_termination_date;
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1193: := 'DATE';
1194:
1188: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1189: := 'P_PROJECTED_TERMINATION_DATE';
1190: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1191: := p_projected_termination_date;
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1193: := 'DATE';
1194:
1195: li_count := li_count + 1;
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1192: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1193: := 'DATE';
1194:
1195: li_count := li_count + 1;
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1197: := 'P_FINAL_PROCESS_DATE';
1198: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1199: := p_final_process_date;
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1194:
1195: li_count := li_count + 1;
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1197: := 'P_FINAL_PROCESS_DATE';
1198: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1199: := p_final_process_date;
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1201: := 'DATE';
1202:
1196: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1197: := 'P_FINAL_PROCESS_DATE';
1198: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1199: := p_final_process_date;
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1201: := 'DATE';
1202:
1203: li_count := li_count + 1;
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1200: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1201: := 'DATE';
1202:
1203: li_count := li_count + 1;
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1205: := 'P_COMMENTS';
1206: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1207: := p_comments;
1208: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1202:
1203: li_count := li_count + 1;
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1205: := 'P_COMMENTS';
1206: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1207: := p_comments;
1208: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1209: := 'VARCHAR2';
1210:
1204: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1205: := 'P_COMMENTS';
1206: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1207: := p_comments;
1208: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1209: := 'VARCHAR2';
1210:
1211: ----------------------------------------------------------------------
1212: -- DDF repeat 20 times
1212: -- DDF repeat 20 times
1213: ----------------------------------------------------------------------
1214:
1215: li_count := li_count + 1;
1216: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1217: := 'P_ATTRIBUTE_CATEGORY';
1218: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1219: := p_attribute_category;
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_ATTRIBUTE_CATEGORY';
1218: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1219: := p_attribute_category;
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_ATTRIBUTE_CATEGORY';
1218: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1219: := p_attribute_category;
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_ATTRIBUTE1';
1226: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1227: := p_attribute1;
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_ATTRIBUTE1';
1226: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1227: := p_attribute1;
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_ATTRIBUTE1';
1226: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1227: := p_attribute1;
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_ATTRIBUTE2';
1234: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1235: := p_attribute2;
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_ATTRIBUTE2';
1234: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1235: := p_attribute2;
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_ATTRIBUTE2';
1234: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1235: := p_attribute2;
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_ATTRIBUTE3';
1242: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1243: := p_attribute3;
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_ATTRIBUTE3';
1242: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1243: := p_attribute3;
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_ATTRIBUTE3';
1242: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1243: := p_attribute3;
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_ATTRIBUTE4';
1250: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1251: := p_attribute4;
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_ATTRIBUTE4';
1250: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1251: := p_attribute4;
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_ATTRIBUTE4';
1250: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1251: := p_attribute4;
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_ATTRIBUTE5';
1258: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1259: := p_attribute5;
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_ATTRIBUTE5';
1258: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1259: := p_attribute5;
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_ATTRIBUTE5';
1258: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1259: := p_attribute5;
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_ATTRIBUTE6';
1266: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1267: := p_attribute6;
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_ATTRIBUTE6';
1266: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1267: := p_attribute6;
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_ATTRIBUTE6';
1266: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1267: := p_attribute6;
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_ATTRIBUTE7';
1274: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1275: := p_attribute7;
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_ATTRIBUTE7';
1274: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1275: := p_attribute7;
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_ATTRIBUTE7';
1274: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1275: := p_attribute7;
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_ATTRIBUTE8';
1282: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1283: := p_attribute8;
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_ATTRIBUTE8';
1282: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1283: := p_attribute8;
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_ATTRIBUTE8';
1282: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1283: := p_attribute8;
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_ATTRIBUTE9';
1290: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1291: := p_attribute9;
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_ATTRIBUTE9';
1290: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1291: := p_attribute9;
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_ATTRIBUTE9';
1290: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1291: := p_attribute9;
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_ATTRIBUTE10';
1298: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1299: := p_attribute10;
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_ATTRIBUTE10';
1298: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1299: := p_attribute10;
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_ATTRIBUTE10';
1298: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1299: := p_attribute10;
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_ATTRIBUTE11';
1306: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1307: := p_attribute11;
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_ATTRIBUTE11';
1306: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1307: := p_attribute11;
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_ATTRIBUTE11';
1306: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1307: := p_attribute11;
1308: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1309: := 'VARCHAR2';
1310:
1311: li_count := li_count + 1;
1312: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1308: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1309: := 'VARCHAR2';
1310:
1311: li_count := li_count + 1;
1312: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1313: := 'P_ATTRIBUTE12';
1314: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1315: := p_attribute12;
1316: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1310:
1311: li_count := li_count + 1;
1312: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1313: := 'P_ATTRIBUTE12';
1314: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1315: := p_attribute12;
1316: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1317: := 'VARCHAR2';
1318:
1312: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1313: := 'P_ATTRIBUTE12';
1314: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1315: := p_attribute12;
1316: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1317: := 'VARCHAR2';
1318:
1319: li_count := li_count + 1;
1320: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1316: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1317: := 'VARCHAR2';
1318:
1319: li_count := li_count + 1;
1320: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1321: := 'P_ATTRIBUTE13';
1322: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1323: := p_attribute13;
1324: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1318:
1319: li_count := li_count + 1;
1320: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1321: := 'P_ATTRIBUTE13';
1322: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1323: := p_attribute13;
1324: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1325: := 'VARCHAR2';
1326:
1320: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1321: := 'P_ATTRIBUTE13';
1322: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1323: := p_attribute13;
1324: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1325: := 'VARCHAR2';
1326:
1327: li_count := li_count + 1;
1328: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1324: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1325: := 'VARCHAR2';
1326:
1327: li_count := li_count + 1;
1328: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1329: := 'P_ATTRIBUTE14';
1330: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1331: := p_attribute14;
1332: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1326:
1327: li_count := li_count + 1;
1328: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1329: := 'P_ATTRIBUTE14';
1330: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1331: := p_attribute14;
1332: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1333: := 'VARCHAR2';
1334:
1328: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1329: := 'P_ATTRIBUTE14';
1330: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1331: := p_attribute14;
1332: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1333: := 'VARCHAR2';
1334:
1335: li_count := li_count + 1;
1336: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1332: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1333: := 'VARCHAR2';
1334:
1335: li_count := li_count + 1;
1336: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1337: := 'P_ATTRIBUTE15';
1338: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1339: := p_attribute15;
1340: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1334:
1335: li_count := li_count + 1;
1336: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1337: := 'P_ATTRIBUTE15';
1338: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1339: := p_attribute15;
1340: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1341: := 'VARCHAR2';
1342:
1336: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1337: := 'P_ATTRIBUTE15';
1338: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1339: := p_attribute15;
1340: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1341: := 'VARCHAR2';
1342:
1343: li_count := li_count + 1;
1344: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1340: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1341: := 'VARCHAR2';
1342:
1343: li_count := li_count + 1;
1344: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1345: := 'P_ATTRIBUTE16';
1346: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1347: := p_attribute16;
1348: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1342:
1343: li_count := li_count + 1;
1344: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1345: := 'P_ATTRIBUTE16';
1346: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1347: := p_attribute16;
1348: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1349: := 'VARCHAR2';
1350:
1344: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1345: := 'P_ATTRIBUTE16';
1346: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1347: := p_attribute16;
1348: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1349: := 'VARCHAR2';
1350:
1351: li_count := li_count + 1;
1352: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1348: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1349: := 'VARCHAR2';
1350:
1351: li_count := li_count + 1;
1352: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1353: := 'P_ATTRIBUTE17';
1354: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1355: := p_attribute17;
1356: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1350:
1351: li_count := li_count + 1;
1352: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1353: := 'P_ATTRIBUTE17';
1354: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1355: := p_attribute17;
1356: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1357: := 'VARCHAR2';
1358:
1352: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1353: := 'P_ATTRIBUTE17';
1354: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1355: := p_attribute17;
1356: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1357: := 'VARCHAR2';
1358:
1359: li_count := li_count + 1;
1360: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1356: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1357: := 'VARCHAR2';
1358:
1359: li_count := li_count + 1;
1360: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1361: := 'P_ATTRIBUTE18';
1362: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1363: := p_attribute18;
1364: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1358:
1359: li_count := li_count + 1;
1360: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1361: := 'P_ATTRIBUTE18';
1362: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1363: := p_attribute18;
1364: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1365: := 'VARCHAR2';
1366:
1360: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1361: := 'P_ATTRIBUTE18';
1362: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1363: := p_attribute18;
1364: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1365: := 'VARCHAR2';
1366:
1367: li_count := li_count + 1;
1368: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1364: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1365: := 'VARCHAR2';
1366:
1367: li_count := li_count + 1;
1368: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1369: := 'P_ATTRIBUTE19';
1370: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1371: := p_attribute19;
1372: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1366:
1367: li_count := li_count + 1;
1368: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1369: := 'P_ATTRIBUTE19';
1370: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1371: := p_attribute19;
1372: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1373: := 'VARCHAR2';
1374:
1368: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1369: := 'P_ATTRIBUTE19';
1370: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1371: := p_attribute19;
1372: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1373: := 'VARCHAR2';
1374:
1375: li_count := li_count + 1;
1376: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1372: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1373: := 'VARCHAR2';
1374:
1375: li_count := li_count + 1;
1376: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1377: := 'P_ATTRIBUTE20';
1378: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1379: := p_attribute20;
1380: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1374:
1375: li_count := li_count + 1;
1376: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1377: := 'P_ATTRIBUTE20';
1378: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1379: := p_attribute20;
1380: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1381: := 'VARCHAR2';
1382:
1376: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1377: := 'P_ATTRIBUTE20';
1378: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1379: := p_attribute20;
1380: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1381: := 'VARCHAR2';
1382:
1383: ----------------------------------------------------------------------
1384: -- Store the activity internal name for this particular
1383: ----------------------------------------------------------------------
1384: -- Store the activity internal name for this particular
1385: -- activity with other information.
1386: ----------------------------------------------------------------------
1387: lv_activity_name := hr_termination_ss.gv_TERMINATION_ACTIVITY_NAME;
1388: li_count := li_count + 1;
1389: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1390: := 'P_ACTIVITY_NAME';
1391: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1385: -- activity with other information.
1386: ----------------------------------------------------------------------
1387: lv_activity_name := hr_termination_ss.gv_TERMINATION_ACTIVITY_NAME;
1388: li_count := li_count + 1;
1389: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1390: := 'P_ACTIVITY_NAME';
1391: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1392: := lv_activity_name;
1393: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1387: lv_activity_name := hr_termination_ss.gv_TERMINATION_ACTIVITY_NAME;
1388: li_count := li_count + 1;
1389: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1390: := 'P_ACTIVITY_NAME';
1391: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1392: := lv_activity_name;
1393: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1394: := 'VARCHAR2';
1395:
1389: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1390: := 'P_ACTIVITY_NAME';
1391: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1392: := lv_activity_name;
1393: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1394: := 'VARCHAR2';
1395:
1396: ----------------------------------------------------------------------
1397: -- Store the the Review Procedure Call and
1397: -- Store the the Review Procedure Call and
1398: -- activity id with other information.
1399: ----------------------------------------------------------------------
1400: li_count := li_count + 1;
1401: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1402: := 'P_REVIEW_PROC_CALL';
1403: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1404: := p_review_proc_call;
1405: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1399: ----------------------------------------------------------------------
1400: li_count := li_count + 1;
1401: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1402: := 'P_REVIEW_PROC_CALL';
1403: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1404: := p_review_proc_call;
1405: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1406: := 'VARCHAR2';
1407:
1401: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1402: := 'P_REVIEW_PROC_CALL';
1403: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1404: := p_review_proc_call;
1405: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1406: := 'VARCHAR2';
1407:
1408: li_count := li_count + 1;
1409: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1405: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1406: := 'VARCHAR2';
1407:
1408: li_count := li_count + 1;
1409: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1410: := 'P_REVIEW_ACTID';
1411: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1412: := p_actid;
1413: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1407:
1408: li_count := li_count + 1;
1409: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1410: := 'P_REVIEW_ACTID';
1411: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1412: := p_actid;
1413: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1414: := 'VARCHAR2';
1415:
1409: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1410: := 'P_REVIEW_ACTID';
1411: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1412: := p_actid;
1413: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1414: := 'VARCHAR2';
1415:
1416: ---------------------------------------------------------------------
1417: -- DDF Enhancement
1418: -- Store DDF Segments
1419: ---------------------------------------------------------------------
1420:
1421: li_count := li_count + 1;
1422: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1423: := 'P_PDS_INFORMATION_CATEGORY';
1424: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1425: := p_pds_information_category;
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_INFORMATION_CATEGORY';
1424: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1425: := p_pds_information_category;
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_INFORMATION_CATEGORY';
1424: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1425: := p_pds_information_category;
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_INFORMATION1';
1432: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1433: := p_pds_information1;
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_INFORMATION1';
1432: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1433: := p_pds_information1;
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_INFORMATION1';
1432: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1433: := p_pds_information1;
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_INFORMATION2';
1440: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1441: := p_pds_information2;
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_INFORMATION2';
1440: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1441: := p_pds_information2;
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_INFORMATION2';
1440: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1441: := p_pds_information2;
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_INFORMATION3';
1448: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1449: := p_pds_information3;
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_INFORMATION3';
1448: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1449: := p_pds_information3;
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_INFORMATION3';
1448: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1449: := p_pds_information3;
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_INFORMATION4';
1456: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1457: := p_pds_information4;
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_INFORMATION4';
1456: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1457: := p_pds_information4;
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_INFORMATION4';
1456: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1457: := p_pds_information4;
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_INFORMATION5';
1464: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1465: := p_pds_information5;
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_INFORMATION5';
1464: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1465: := p_pds_information5;
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_INFORMATION5';
1464: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1465: := p_pds_information5;
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_INFORMATION6';
1472: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1473: := p_pds_information6;
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_INFORMATION6';
1472: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1473: := p_pds_information6;
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_INFORMATION6';
1472: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1473: := p_pds_information6;
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_INFORMATION7';
1480: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1481: := p_pds_information7;
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_INFORMATION7';
1480: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1481: := p_pds_information7;
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_INFORMATION7';
1480: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1481: := p_pds_information7;
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_INFORMATION8';
1488: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1489: := p_pds_information8;
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_INFORMATION8';
1488: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1489: := p_pds_information8;
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_INFORMATION8';
1488: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1489: := p_pds_information8;
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_INFORMATION9';
1496: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1497: := p_pds_information9;
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_INFORMATION9';
1496: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1497: := p_pds_information9;
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_INFORMATION9';
1496: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1497: := p_pds_information9;
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_INFORMATION10';
1504: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1505: := p_pds_information10;
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_INFORMATION10';
1504: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1505: := p_pds_information10;
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_INFORMATION10';
1504: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1505: := p_pds_information10;
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_INFORMATION11';
1512: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1513: := p_pds_information11;
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_INFORMATION11';
1512: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1513: := p_pds_information11;
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_INFORMATION11';
1512: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1513: := p_pds_information11;
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_INFORMATION12';
1520: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1521: := p_pds_information12;
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_INFORMATION12';
1520: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1521: := p_pds_information12;
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_INFORMATION12';
1520: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1521: := p_pds_information12;
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_INFORMATION13';
1528: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1529: := p_pds_information13;
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_INFORMATION13';
1528: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1529: := p_pds_information13;
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_INFORMATION13';
1528: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1529: := p_pds_information13;
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_INFORMATION14';
1536: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1537: := p_pds_information14;
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_INFORMATION14';
1536: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1537: := p_pds_information14;
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_INFORMATION14';
1536: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1537: := p_pds_information14;
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_INFORMATION15';
1544: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1545: := p_pds_information15;
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_INFORMATION15';
1544: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1545: := p_pds_information15;
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_INFORMATION15';
1544: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1545: := p_pds_information15;
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_INFORMATION16';
1552: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1553: := p_pds_information16;
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_INFORMATION16';
1552: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1553: := p_pds_information16;
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_INFORMATION16';
1552: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1553: := p_pds_information16;
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_INFORMATION17';
1560: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1561: := p_pds_information17;
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_INFORMATION17';
1560: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1561: := p_pds_information17;
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_INFORMATION17';
1560: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1561: := p_pds_information17;
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_INFORMATION18';
1568: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1569: := p_pds_information18;
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_INFORMATION18';
1568: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1569: := p_pds_information18;
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_INFORMATION18';
1568: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1569: := p_pds_information18;
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_INFORMATION19';
1576: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1577: := p_pds_information19;
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_INFORMATION19';
1576: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1577: := p_pds_information19;
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_INFORMATION19';
1576: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1577: := p_pds_information19;
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_INFORMATION20';
1584: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1585: := p_pds_information20;
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_INFORMATION20';
1584: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1585: := p_pds_information20;
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_INFORMATION20';
1584: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1585: := p_pds_information20;
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_INFORMATION21';
1592: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1593: := p_pds_information21;
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_INFORMATION21';
1592: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1593: := p_pds_information21;
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_INFORMATION21';
1592: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1593: := p_pds_information21;
1594: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1595: := 'VARCHAR2';
1596:
1597: li_count := li_count + 1;
1598: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1594: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1595: := 'VARCHAR2';
1596:
1597: li_count := li_count + 1;
1598: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1599: := 'P_PDS_INFORMATION22';
1600: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1601: := p_pds_information22;
1602: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1596:
1597: li_count := li_count + 1;
1598: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1599: := 'P_PDS_INFORMATION22';
1600: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1601: := p_pds_information22;
1602: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1603: := 'VARCHAR2';
1604:
1598: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1599: := 'P_PDS_INFORMATION22';
1600: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1601: := p_pds_information22;
1602: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1603: := 'VARCHAR2';
1604:
1605: li_count := li_count + 1;
1606: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1602: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1603: := 'VARCHAR2';
1604:
1605: li_count := li_count + 1;
1606: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1607: := 'P_PDS_INFORMATION23';
1608: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1609: := p_pds_information23;
1610: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1604:
1605: li_count := li_count + 1;
1606: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1607: := 'P_PDS_INFORMATION23';
1608: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1609: := p_pds_information23;
1610: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1611: := 'VARCHAR2';
1612:
1606: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1607: := 'P_PDS_INFORMATION23';
1608: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1609: := p_pds_information23;
1610: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1611: := 'VARCHAR2';
1612:
1613: li_count := li_count + 1;
1614: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1610: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1611: := 'VARCHAR2';
1612:
1613: li_count := li_count + 1;
1614: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1615: := 'P_PDS_INFORMATION24';
1616: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1617: := p_pds_information24;
1618: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1612:
1613: li_count := li_count + 1;
1614: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1615: := 'P_PDS_INFORMATION24';
1616: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1617: := p_pds_information24;
1618: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1619: := 'VARCHAR2';
1620:
1614: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1615: := 'P_PDS_INFORMATION24';
1616: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1617: := p_pds_information24;
1618: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1619: := 'VARCHAR2';
1620:
1621: li_count := li_count + 1;
1622: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1618: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1619: := 'VARCHAR2';
1620:
1621: li_count := li_count + 1;
1622: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1623: := 'P_PDS_INFORMATION25';
1624: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1625: := p_pds_information25;
1626: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1620:
1621: li_count := li_count + 1;
1622: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1623: := 'P_PDS_INFORMATION25';
1624: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1625: := p_pds_information25;
1626: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1627: := 'VARCHAR2';
1628:
1622: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1623: := 'P_PDS_INFORMATION25';
1624: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1625: := p_pds_information25;
1626: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1627: := 'VARCHAR2';
1628:
1629: li_count := li_count + 1;
1630: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1626: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1627: := 'VARCHAR2';
1628:
1629: li_count := li_count + 1;
1630: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1631: := 'P_PDS_INFORMATION26';
1632: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1633: := p_pds_information26;
1634: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1628:
1629: li_count := li_count + 1;
1630: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1631: := 'P_PDS_INFORMATION26';
1632: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1633: := p_pds_information26;
1634: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1635: := 'VARCHAR2';
1636:
1630: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1631: := 'P_PDS_INFORMATION26';
1632: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1633: := p_pds_information26;
1634: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1635: := 'VARCHAR2';
1636:
1637: li_count := li_count + 1;
1638: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1634: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1635: := 'VARCHAR2';
1636:
1637: li_count := li_count + 1;
1638: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1639: := 'P_PDS_INFORMATION27';
1640: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1641: := p_pds_information27;
1642: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1636:
1637: li_count := li_count + 1;
1638: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1639: := 'P_PDS_INFORMATION27';
1640: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1641: := p_pds_information27;
1642: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1643: := 'VARCHAR2';
1644:
1638: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1639: := 'P_PDS_INFORMATION27';
1640: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1641: := p_pds_information27;
1642: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1643: := 'VARCHAR2';
1644:
1645: li_count := li_count + 1;
1646: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1642: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1643: := 'VARCHAR2';
1644:
1645: li_count := li_count + 1;
1646: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1647: := 'P_PDS_INFORMATION28';
1648: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1649: := p_pds_information28;
1650: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1644:
1645: li_count := li_count + 1;
1646: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1647: := 'P_PDS_INFORMATION28';
1648: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1649: := p_pds_information28;
1650: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1651: := 'VARCHAR2';
1652:
1646: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1647: := 'P_PDS_INFORMATION28';
1648: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1649: := p_pds_information28;
1650: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1651: := 'VARCHAR2';
1652:
1653: li_count := li_count + 1;
1654: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1650: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1651: := 'VARCHAR2';
1652:
1653: li_count := li_count + 1;
1654: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1655: := 'P_PDS_INFORMATION29';
1656: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1657: := p_pds_information29;
1658: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1652:
1653: li_count := li_count + 1;
1654: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1655: := 'P_PDS_INFORMATION29';
1656: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1657: := p_pds_information29;
1658: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1659: := 'VARCHAR2';
1660:
1654: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1655: := 'P_PDS_INFORMATION29';
1656: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1657: := p_pds_information29;
1658: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1659: := 'VARCHAR2';
1660:
1661: li_count := li_count + 1;
1662: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1658: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1659: := 'VARCHAR2';
1660:
1661: li_count := li_count + 1;
1662: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1663: := 'P_PDS_INFORMATION30';
1664: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1665: := p_pds_information30;
1666: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1660:
1661: li_count := li_count + 1;
1662: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1663: := 'P_PDS_INFORMATION30';
1664: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1665: := p_pds_information30;
1666: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1667: := 'VARCHAR2';
1668: ---------------------------------------------------------------------
1662: hr_termination_ss.gtt_transaction_steps(li_count).param_name
1663: := 'P_PDS_INFORMATION30';
1664: hr_termination_ss.gtt_transaction_steps(li_count).param_value
1665: := p_pds_information30;
1666: hr_termination_ss.gtt_transaction_steps(li_count).param_data_type
1667: := 'VARCHAR2';
1668: ---------------------------------------------------------------------
1669: -- Check if there is already a transaction for this process?
1670: ---------------------------------------------------------------------
1747: p_item_Key => p_item_key,
1748: p_actid => TO_NUMBER(p_actid),
1749: p_login_person_id => p_login_person_id,
1750: p_transaction_step_id => ln_transaction_step_id,
1751: p_api_name => 'hr_termination_ss.process_save',
1752: p_transaction_data => hr_termination_ss.gtt_transaction_steps
1753: );
1754:
1755: -- 07/16/2001 Bug 1853417 Fix:
1748: p_actid => TO_NUMBER(p_actid),
1749: p_login_person_id => p_login_person_id,
1750: p_transaction_step_id => ln_transaction_step_id,
1751: p_api_name => 'hr_termination_ss.process_save',
1752: p_transaction_data => hr_termination_ss.gtt_transaction_steps
1753: );
1754:
1755: -- 07/16/2001 Bug 1853417 Fix:
1756: -- The code to check for existence of subordinates for the
1829: p_transaction_step_id IN NUMBER DEFAULT NULL,
1830: p_effective_date IN VARCHAR2 DEFAULT NULL
1831: )
1832: IS
1833: lrt_termination hr_termination_ss.rt_termination;
1834: ld_actual_term_date
1835: per_periods_of_service.actual_termination_date%TYPE;
1836: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1837: ll_term_comments per_periods_of_service.comments%TYPE;
1863: lb_pay_proposal_warning BOOLEAN;
1864: lb_dod_warning BOOLEAN;
1865:
1866: --DFF
1867: lt_term_flex hr_termination_ss.t_flex_table;
1868: lv_attribute_category VARCHAR2(100);
1869:
1870: --DDF Enhancement
1871: lv_pds_information_category VARCHAR2(100);
2032: end;
2033:
2034: -- Bug 2098595 Fix Begins: 11/12/2001
2035: -- Need to switch the order of calling the api. We need to call
2036: -- hr_termination_ss.update_pds_details first to set the flex segments
2037: -- before calling hr_ex_employee_api.actual_termination_emp.
2038: -- Otherwise, when there is a mandatory segment, we'll get an error
2039: -- as follows:
2040: -- The mandatory column Attribute??(also known as xxxx) has not been
2261: FUNCTION get_termination_details (
2262: p_transaction_step_id IN
2263: hr_api_transaction_steps.transaction_step_id%type
2264: )
2265: RETURN hr_termination_ss.rt_termination
2266: IS
2267: lrt_termination hr_termination_ss.rt_termination;
2268: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2269: BEGIN
2263: hr_api_transaction_steps.transaction_step_id%type
2264: )
2265: RETURN hr_termination_ss.rt_termination
2266: IS
2267: lrt_termination hr_termination_ss.rt_termination;
2268: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2269: BEGIN
2270: hr_utility.set_location('Entering: '|| l_proc,5);
2271: lrt_termination.notified_termination_date :=
2363: FUNCTION get_term_flex_detail (
2364: p_transaction_step_id IN
2365: hr_api_transaction_steps.transaction_step_id%type
2366: )
2367: RETURN hr_termination_ss.t_flex_table
2368: IS
2369: lt_term_flex hr_termination_ss.t_flex_table;
2370: l_proc constant varchar2(100) := g_package || 'get_term_flex_detail ';
2371: BEGIN
2365: hr_api_transaction_steps.transaction_step_id%type
2366: )
2367: RETURN hr_termination_ss.t_flex_table
2368: IS
2369: lt_term_flex hr_termination_ss.t_flex_table;
2370: l_proc constant varchar2(100) := g_package || 'get_term_flex_detail ';
2371: BEGIN
2372: ---- First 20 DFF Data
2373: ---- Next 30, DDF Data
3300: lv_param_13 := fnd_number.number_to_canonical(p_old_sup_person_id);
3301: lv_param_14 := fnd_number.number_to_canonical(cur_get_direct_reports.person_id);
3302: lv_param_15 := fnd_number.number_to_canonical(supDirId);
3303:
3304: l_tmp_new_asg_id := hr_termination_ss.get_sup_asg_byprfl(
3305: p_param_1 => lv_param_1
3306: ,p_param_2 => lv_param_2
3307: ,p_param_3 => lv_param_3
3308: ,p_param_4 => lv_param_4
3370: raise;
3371: end moveAllDirectReports;
3372:
3373:
3374: END hr_termination_ss;