[Home] [Help]
449: end merge_table;
450:
451:
452: /* Added for bug 3787120
453: -> This procedure is called before inserting into the table BOM_RES_INSTANCE_CHANGES
454: -> Check for the date/time range overlap with the existing record in BOM_RES_INSTANCE_CHANGES
455: -> If overlapping occurs then TRUE is returned. And if there is need for updating the record
456: then parameter p_out_to_update is updated to true.
457: -> If no overlapping, then FALSE is returned.
450:
451:
452: /* Added for bug 3787120
453: -> This procedure is called before inserting into the table BOM_RES_INSTANCE_CHANGES
454: -> Check for the date/time range overlap with the existing record in BOM_RES_INSTANCE_CHANGES
455: -> If overlapping occurs then TRUE is returned. And if there is need for updating the record
456: then parameter p_out_to_update is updated to true.
457: -> If no overlapping, then FALSE is returned.
458: */
491:
492: --Check if new record's date/time range clashes with that of the old record
493: select from_date, from_time, to_date, to_time
494: into p_out_from_date_old, p_out_from_time_old, p_out_to_date_old, p_out_to_time_old
495: from bom_res_instance_changes
496: where department_id = p_downtime_row.department_id
497: and resource_id = p_downtime_row.resource_id
498: and shift_num = p_shift_num
499: and simulation_set = p_simulation_set
577: /*
578: * Added the following procedure as a part of bug#3577299
579: * Given a from date/time and a to date/time, this procedure breaks
580: * up the interval into start and end times based on shifts for the
581: * resource/department and inserts into bom_res_instance_changes
582: */
583: procedure break_and_insert (p_from_date IN DATE,
584: p_from_time IN NUMBER,
585: p_to_date IN DATE,
749: fnd_file.put_line(fnd_file.log,'Inserting from '||l_from_date||to_char(to_date(l_from_time,'SSSSS'),' HH24:MI:SS')||
750: ' to '||l_to_date||to_char(to_date(l_to_time,'SSSSS'),' HH24:MI:SS'));
751: end if;
752:
753: insert into bom_res_instance_changes(
754: department_id,
755: resource_id,
756: shift_num,
757: simulation_set,
831: if G_DEBUG = 'Y' THEN
832: fnd_file.put_line(fnd_file.log,'Updating...');
833: end if;
834:
835: update bom_res_instance_changes
836: set from_date = l_out_from_date,
837: from_time = l_out_from_time,
838: to_date = l_out_to_date,
839: to_time = l_out_to_time
935: l_from_date := trunc(l_from_date);
936: l_to_date := trunc(l_to_date);
937: if is_overlap(l_from_date,l_from_time, l_to_date, l_to_time, p_calendar_code, a_shift.shift_num)
938: then
939: /* Moved the insert stmt on bom_res_instance_changes
940: * to procedure break_and_insert as part of fix for
941: * bug#3577299
942: */
943: break_and_insert(l_from_date,l_from_time,l_to_date,l_to_time,
1086: x_return_status := FND_API.g_ret_sts_success;
1087:
1088: --API Body
1089: --Delete BRIC rows
1090: delete from bom_res_instance_changes
1091: where
1092: downtime_group_id is not null
1093: and simulation_set=p_simulation_set
1094: and ((p_department_id is not null and department_id=p_department_id)
1239: sysdate,
1240: ACTION_TYPE,
1241: g_reason_code,
1242: p_downtime_group_id
1243: from bom_res_instance_changes
1244: where
1245: downtime_group_id=p_downtime_group_id
1246: group by DEPARTMENT_ID,
1247: RESOURCE_ID,
1321: x_return_status := FND_API.g_ret_sts_success;
1322:
1323: --API Body
1324: --Delete all previous equipment downtime rows in BRIC and BRC
1325: delete from bom_res_instance_changes
1326: where
1327: downtime_group_id is not null
1328: and simulation_set=p_simulation_set
1329: and department_id in