eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_SCHEDULE_MATERIALS

Line 32: -- Procedure to delete rows from ahl_schedule_materials.

28: -- Added for 11.5.10.
29: PROCEDURE Flush_Unit_SR_Deferrals;
30:
31:
32: -- Procedure to delete rows from ahl_schedule_materials.
33: PROCEDURE Delete_Sch_Materials(p_unit_effectivity_id IN NUMBER);
34:
35:
36: ------------------------------

Line 810: -- Delete the corresponding rows in ahl_schedule materials for this ue.

806: X_LAST_UPDATE_DATE => sysdate,
807: X_LAST_UPDATED_BY => fnd_global.user_id,
808: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
809:
810: -- Delete the corresponding rows in ahl_schedule materials for this ue.
811: Delete_Sch_Materials(exception_rec.unit_effectivity_id);
812:
813: -- update all group element's status too.
814: FOR ue_reln_rec IN decendent_csr(exception_rec.unit_effectivity_id) LOOP

Line 878: -- Delete the corresponding rows in ahl_schedule materials for this ue.

874: X_LAST_UPDATE_DATE => sysdate,
875: X_LAST_UPDATED_BY => fnd_global.user_id,
876: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
877:
878: -- Delete the corresponding rows in ahl_schedule materials for this ue.
879: Delete_Sch_Materials(l_ue_rec.unit_effectivity_id);
880:
881: ELSE
882: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UE_NOTFOUND');

Line 905: -- Delete the corresponding rows in ahl_schedule materials for this ue.

901: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);
902: -- delete unit effectivity record.
903: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(ue_reln_rec.related_ue_id);
904:
905: -- Delete the corresponding rows in ahl_schedule materials for this ue.
906: Delete_Sch_Materials(ue_reln_rec.related_ue_id);
907:
908:
909: END LOOP;

Line 911: -- Delete the corresponding rows in ahl_schedule materials for this ue.

907:
908:
909: END LOOP;
910:
911: -- Delete the corresponding rows in ahl_schedule materials for this ue.
912: Delete_Sch_Materials(exception_rec.unit_effectivity_id);
913:
914: IF (exception_rec.status_code = 'INIT-DUE' OR
915: exception_rec.message_code = 'INIT-DUE') THEN

Line 1118: -- Delete the corresponding rows in ahl_schedule materials for this ue.

1114: X_LAST_UPDATED_BY => fnd_global.user_id,
1115: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
1116:
1117: IF (p_temp_mr_rec.due_date IS NULL AND p_mr_rec.object_type = 'MR') THEN
1118: -- Delete the corresponding rows in ahl_schedule materials for this ue.
1119: Delete_Sch_Materials(p_mr_rec.unit_effectivity_id);
1120: END IF;
1121:
1122: IF G_DEBUG = 'Y' THEN

Line 2002: -- Delete the corresponding rows in ahl_schedule materials for this ue.

1998: CLOSE ahl_unit_effectivity_csr;
1999:
2000: IF (l_unit_effectivity_rec.due_date IS NULL
2001: AND l_unit_effectivity_rec.object_type = 'MR') THEN
2002: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2003: Delete_Sch_Materials(l_unit_effectivity_rec.unit_effectivity_id);
2004: END IF;
2005:
2006: -- Update all group children.

Line 2091: -- Delete the corresponding rows in ahl_schedule materials for this ue.

2087: X_LAST_UPDATED_BY => fnd_global.user_id,
2088: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
2089:
2090:
2091: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2092: IF (l_unit_effectivity_rec.due_date IS NULL
2093: AND l_unit_effectivity_rec.object_type = 'MR') THEN
2094: Delete_Sch_Materials(l_unit_effectivity_rec.unit_effectivity_id);
2095: END IF;

Line 2475: -- Delete the corresponding rows in ahl_schedule materials for this ue.

2471: -- only if visit is in planning status we must mark an exception.
2472: -- if visit is already on the floor, we do nothing.
2473: IF (l_visit_status = 'PLANNING') THEN
2474: FOR l_ue_rec IN ahl_ue_csr(l_delete_ue_id_tbl(i)) LOOP
2475: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2476: Delete_Sch_Materials(l_ue_rec.related_ue_id);
2477: END LOOP;
2478:
2479: -- update unit effectivity record to exception.

Line 2511: -- Delete the corresponding rows in ahl_schedule materials for this ue.

2507:
2508: -- delete unit effectivity record.
2509: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.related_ue_id);
2510:
2511: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2512: Delete_Sch_Materials(l_ue_rec.related_ue_id);
2513:
2514: END LOOP;
2515: DELETE FROM ahl_ue_relationships

Line 2521: -- Delete the corresponding rows in ahl_schedule materials for this ue.

2517:
2518: -- delete top UE
2519: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_delete_ue_id_tbl(i));
2520:
2521: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2522: Delete_Sch_Materials(l_delete_ue_id_tbl(i));
2523:
2524: END IF; -- l_visit_status
2525: END LOOP;

Line 2535: -- Procedure to delete rows from ahl_schedule_materials.

2531:
2532: END Flush_Unit_SR_Deferrals;
2533:
2534:
2535: -- Procedure to delete rows from ahl_schedule_materials.
2536: PROCEDURE Delete_Sch_Materials(p_unit_effectivity_id IN NUMBER) IS
2537:
2538: CURSOR ahl_sch_material_csr (p_unit_effectivity_id IN NUMBER) IS
2539: SELECT scheduled_material_id

Line 2540: FROM ahl_schedule_materials

2536: PROCEDURE Delete_Sch_Materials(p_unit_effectivity_id IN NUMBER) IS
2537:
2538: CURSOR ahl_sch_material_csr (p_unit_effectivity_id IN NUMBER) IS
2539: SELECT scheduled_material_id
2540: FROM ahl_schedule_materials
2541: WHERE material_request_type = 'FORECAST'
2542: AND unit_effectivity_id = p_unit_effectivity_id
2543: FOR UPDATE NOWAIT;
2544:

Line 2552: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => sch_material_rec.scheduled_material_id);

2548: AHL_DEBUG_PUB.Debug('Start Delete_Sch_Materials for UE:' || p_unit_effectivity_id,'UMP-ProcessUnit');
2549: END IF;
2550:
2551: FOR sch_material_rec IN ahl_sch_material_csr(p_unit_effectivity_id) LOOP
2552: AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => sch_material_rec.scheduled_material_id);
2553:
2554: END LOOP;
2555:
2556: IF G_DEBUG = 'Y' THEN