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_UNIT_EFFECTIVITIES_PKG

Line 496: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(

492: OPEN ahl_unit_effectivity_csr (dependent_rec.unit_effectivity_id);
493: FETCH ahl_unit_effectivity_csr INTO l_ue_rec;
494: IF (ahl_unit_effectivity_csr%FOUND) THEN
495:
496: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(
497: X_UNIT_EFFECTIVITY_ID => l_ue_rec.unit_effectivity_id,
498: X_CSI_ITEM_INSTANCE_ID => l_ue_rec.csi_item_instance_id,
499: X_MR_INTERVAL_ID => l_ue_rec.mr_interval_id,
500: X_MR_EFFECTIVITY_ID => l_ue_rec.mr_effectivity_id,

Line 751: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(

747: -- update unit effectivity.
748: exception_rec.message_code := l_exception_code;
749: exception_rec.status_code := 'EXCEPTION';
750:
751: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(
752: X_UNIT_EFFECTIVITY_ID => exception_rec.unit_effectivity_id,
753: X_CSI_ITEM_INSTANCE_ID => exception_rec.csi_item_instance_id,
754: X_MR_INTERVAL_ID => exception_rec.mr_interval_id,
755: X_MR_EFFECTIVITY_ID => exception_rec.mr_effectivity_id,

Line 819: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(

815:
816: OPEN ahl_unit_effectivity_csr (ue_reln_rec.related_ue_id);
817: FETCH ahl_unit_effectivity_csr INTO l_ue_rec;
818: IF (ahl_unit_effectivity_csr%FOUND) THEN
819: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(
820: X_UNIT_EFFECTIVITY_ID => l_ue_rec.unit_effectivity_id,
821: X_CSI_ITEM_INSTANCE_ID => l_ue_rec.csi_item_instance_id,
822: X_MR_INTERVAL_ID => l_ue_rec.mr_interval_id,
823: X_MR_EFFECTIVITY_ID => l_ue_rec.mr_effectivity_id,

Line 903: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(ue_reln_rec.related_ue_id);

899:
900: -- delete relationship.
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:

Line 933: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(exception_rec.unit_effectivity_id);

929:
930: END IF; -- exception_rec.status_code
931:
932: -- delete ue.
933: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(exception_rec.unit_effectivity_id);
934: END IF;
935:
936: END LOOP; /* for exception rec */
937: END LOOP; /* for node */

Line 965: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

961: END IF;
962:
963: -- Default object type and application usage values.
964:
965: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
966: X_ROWID => l_rowid,
967: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
968: X_CSI_ITEM_INSTANCE_ID => p_x_temp_mr_rec.csi_item_instance_id,
969: X_MR_INTERVAL_ID => p_x_temp_mr_rec.mr_interval_id,

Line 1058: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

1054: AHL_DEBUG_PUB.Debug('Start Update Record-' || p_mr_rec.unit_effectivity_id);
1055: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);
1056: END IF;
1057:
1058: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
1059: X_UNIT_EFFECTIVITY_ID => p_mr_rec.unit_effectivity_id,
1060: X_CSI_ITEM_INSTANCE_ID => p_mr_rec.csi_item_instance_id,
1061: X_MR_INTERVAL_ID => p_temp_mr_rec.mr_interval_id,
1062: X_MR_EFFECTIVITY_ID => p_temp_mr_rec.mr_effectivity_id,

Line 1940: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

1936: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
1937: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || unit_sr_def_rec.MR_header_id);
1938: END IF;
1939:
1940: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
1941: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_rec.unit_effectivity_id,
1942: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
1943: X_MR_INTERVAL_ID => l_unit_effectivity_rec.mr_interval_id,
1944: X_MR_EFFECTIVITY_ID => l_unit_effectivity_rec.mr_effectivity_id,

Line 2031: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

2027: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
2028: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2029: END IF;
2030:
2031: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
2032: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_rec.unit_effectivity_id,
2033: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
2034: X_MR_INTERVAL_ID => l_unit_effectivity_rec.mr_interval_id,
2035: X_MR_EFFECTIVITY_ID => l_unit_effectivity_rec.mr_effectivity_id,

Line 2129: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

2125: AHL_DEBUG_PUB.Debug('Insert Record-');
2126: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2127: END IF;
2128:
2129: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2130: X_ROWID => l_rowid,
2131: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
2132: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
2133: X_MR_INTERVAL_ID => null,

Line 2218: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

2214: unit_sr_def_rec.unit_effectivity_id)
2215: LOOP
2216: -- Initialize.
2217:
2218: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2219: X_ROWID => l_rowid,
2220: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
2221: X_CSI_ITEM_INSTANCE_ID => ahl_temp_rec.csi_item_instance_id,
2222: X_MR_INTERVAL_ID => null,

Line 2361: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

2357: FND_MSG_PUB.ADD;
2358: CLOSE ahl_unit_effectivity_csr;
2359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2360: ELSE
2361: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2362: X_ROWID => l_rowid,
2363: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
2364: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
2365: X_MR_INTERVAL_ID => l_unit_effectivity_rec.MR_INTERVAL_ID,

Line 2509: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.related_ue_id);

2505: -- delete ahl_ue_relationships
2506: FOR l_ue_rec IN ahl_ue_csr(l_delete_ue_id_tbl(i)) LOOP
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:

Line 2519: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_delete_ue_id_tbl(i));

2515: DELETE FROM ahl_ue_relationships
2516: WHERE originator_ue_id = l_delete_ue_id_tbl(i);
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: