[Home] [Help]
1014: IF p_tab_rec_data.COUNT > 0 THEN
1015: FOR i in p_tab_rec_data.FIRST .. p_tab_rec_data.LAST
1016: LOOP
1017:
1018: INSERT INTO pay_simulation_information
1019: (
1020: ACTION_INFORMATION_ID,
1021: ACTION_CONTEXT_ID,
1022: ACTION_CONTEXT_TYPE,
1060: ASSIGNMENT_ID
1061: )
1062: VALUES
1063: (
1064: pay_simulation_information_s.NEXTVAL,
1065: p_action_context_id,
1066: p_action_context_type,
1067: p_tax_unit_id,
1068: p_tab_rec_data(i).jurisdiction_code,
1127: pragma AUTONOMOUS_TRANSACTION;
1128: lv_procedure_name VARCHAR2(100) := '.insert_error_message';
1129: BEGIN
1130: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1131: INSERT INTO pay_simulation_information
1132: (
1133: ACTION_INFORMATION_ID,
1134: ACTION_CONTEXT_ID,
1135: ACTION_CONTEXT_TYPE,
1139: ASSIGNMENT_ID
1140: )
1141: VALUES
1142: (
1143: pay_simulation_information_s.NEXTVAL,
1144: p_action_context_id,
1145: p_action_context_type,
1146: 'SIMULATION_ERROR',
1147: p_err_msg,
1188: IF lv_retain_simulation_data = 'NO' THEN
1189:
1190: hr_utility.trace('Cleaning Archive Data for Assignment ID : '||p_assignment_id);
1191:
1192: DELETE FROM pay_simulation_information
1193: WHERE assignment_id = p_assignment_id
1194: ;
1195:
1196: END IF;
1210: BEGIN
1211: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1212:
1213: INSERT
1214: INTO pay_simulation_information
1215: (action_information_id
1216: ,action_context_id
1217: ,action_context_type
1218: ,action_information_category
1248: ,action_information28
1249: ,action_information29
1250: ,action_information30
1251: )
1252: SELECT pay_simulation_information_s.nextval
1253: ,p_source_id
1254: ,'USER_INPUTS'
1255: ,information_type
1256: ,p_effective_date