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 777: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(

773: OPEN ahl_unit_effectivity_csr (dependent_rec.unit_effectivity_id);
774: FETCH ahl_unit_effectivity_csr INTO l_ue_rec;
775: IF (ahl_unit_effectivity_csr%FOUND) THEN
776:
777: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(
778: X_UNIT_EFFECTIVITY_ID => l_ue_rec.unit_effectivity_id,
779: X_CSI_ITEM_INSTANCE_ID => l_ue_rec.csi_item_instance_id,
780: X_MR_INTERVAL_ID => l_ue_rec.mr_interval_id,
781: X_MR_EFFECTIVITY_ID => l_ue_rec.mr_effectivity_id,

Line 1122: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(

1118: exception_rec.message_code := l_exception_code;
1119: exception_rec.status_code := 'EXCEPTION';
1120: END IF;
1121:
1122: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(
1123: X_UNIT_EFFECTIVITY_ID => exception_rec.unit_effectivity_id,
1124: X_CSI_ITEM_INSTANCE_ID => exception_rec.csi_item_instance_id,
1125: X_MR_INTERVAL_ID => exception_rec.mr_interval_id,
1126: X_MR_EFFECTIVITY_ID => exception_rec.mr_effectivity_id,

Line 1190: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(

1186:
1187: OPEN ahl_unit_effectivity_csr (ue_reln_rec.related_ue_id);
1188: FETCH ahl_unit_effectivity_csr INTO l_ue_rec;
1189: IF (ahl_unit_effectivity_csr%FOUND) THEN
1190: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row(
1191: X_UNIT_EFFECTIVITY_ID => l_ue_rec.unit_effectivity_id,
1192: X_CSI_ITEM_INSTANCE_ID => l_ue_rec.csi_item_instance_id,
1193: X_MR_INTERVAL_ID => l_ue_rec.mr_interval_id,
1194: X_MR_EFFECTIVITY_ID => l_ue_rec.mr_effectivity_id,

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

1270:
1271: -- delete relationship.
1272: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);
1273: -- delete unit effectivity record.
1274: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(ue_reln_rec.related_ue_id);
1275:
1276: -- Delete the corresponding rows in ahl_schedule materials for this ue.
1277: Delete_Sch_Materials(ue_reln_rec.related_ue_id);
1278:

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

1300:
1301: END IF; -- exception_rec.status_code
1302:
1303: -- delete ue.
1304: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(exception_rec.unit_effectivity_id);
1305: END IF;
1306:
1307: END LOOP; /* for exception rec */
1308: END LOOP; /* for node */

Line 1343: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

1339: END IF;
1340:
1341: -- Default object type and application usage values.
1342:
1343: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
1344: X_ROWID => l_rowid,
1345: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
1346: X_CSI_ITEM_INSTANCE_ID => p_x_temp_mr_rec.csi_item_instance_id,
1347: X_MR_INTERVAL_ID => p_x_temp_mr_rec.mr_interval_id,

Line 1445: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

1441: AHL_DEBUG_PUB.Debug('Start Update Record-' || p_mr_rec.unit_effectivity_id);
1442: AHL_DEBUG_PUB.Debug('CSI:MR:' || p_mr_rec.csi_item_instance_id || ',' || p_mr_rec.MR_header_id);
1443: END IF;
1444:
1445: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
1446: X_UNIT_EFFECTIVITY_ID => p_mr_rec.unit_effectivity_id,
1447: X_CSI_ITEM_INSTANCE_ID => p_mr_rec.csi_item_instance_id,
1448: X_MR_INTERVAL_ID => p_temp_mr_rec.mr_interval_id,
1449: X_MR_EFFECTIVITY_ID => p_temp_mr_rec.mr_effectivity_id,

Line 2357: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

2353: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
2354: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || unit_sr_def_rec.MR_header_id);
2355: END IF;
2356:
2357: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
2358: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_rec.unit_effectivity_id,
2359: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
2360: X_MR_INTERVAL_ID => l_unit_effectivity_rec.mr_interval_id,
2361: X_MR_EFFECTIVITY_ID => l_unit_effectivity_rec.mr_effectivity_id,

Line 2450: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (

2446: AHL_DEBUG_PUB.Debug('Update Record-' || l_unit_effectivity_rec.unit_effectivity_id);
2447: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2448: END IF;
2449:
2450: AHL_UNIT_EFFECTIVITIES_PKG.Update_Row (
2451: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_rec.unit_effectivity_id,
2452: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
2453: X_MR_INTERVAL_ID => l_unit_effectivity_rec.mr_interval_id,
2454: X_MR_EFFECTIVITY_ID => l_unit_effectivity_rec.mr_effectivity_id,

Line 2548: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

2544: AHL_DEBUG_PUB.Debug('Insert Record-');
2545: AHL_DEBUG_PUB.Debug('CSI:MR:' || l_unit_effectivity_rec.csi_item_instance_id || ',' || l_unit_effectivity_rec.MR_header_id);
2546: END IF;
2547:
2548: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2549: X_ROWID => l_rowid,
2550: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
2551: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
2552: X_MR_INTERVAL_ID => null,

Line 2646: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

2642: unit_sr_def_rec.unit_effectivity_id)
2643: LOOP
2644: -- Initialize.
2645:
2646: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2647: X_ROWID => l_rowid,
2648: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
2649: X_CSI_ITEM_INSTANCE_ID => ahl_temp_rec.csi_item_instance_id,
2650: X_MR_INTERVAL_ID => null,

Line 2788: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

2784: FND_MSG_PUB.ADD;
2785: CLOSE ahl_unit_effectivity_csr;
2786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2787: ELSE
2788: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
2789: X_ROWID => l_rowid,
2790: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
2791: X_CSI_ITEM_INSTANCE_ID => l_unit_effectivity_rec.csi_item_instance_id,
2792: X_MR_INTERVAL_ID => l_unit_effectivity_rec.MR_INTERVAL_ID,

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

2932: -- delete ahl_ue_relationships
2933: FOR l_ue_rec IN ahl_ue_csr(l_delete_ue_id_tbl(i)) LOOP
2934:
2935: -- delete unit effectivity record.
2936: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.related_ue_id);
2937:
2938: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2939: Delete_Sch_Materials(l_ue_rec.related_ue_id);
2940:

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

2942: DELETE FROM ahl_ue_relationships
2943: WHERE originator_ue_id = l_delete_ue_id_tbl(i);
2944:
2945: -- delete top UE
2946: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_delete_ue_id_tbl(i));
2947:
2948: -- Delete the corresponding rows in ahl_schedule materials for this ue.
2949: Delete_Sch_Materials(l_delete_ue_id_tbl(i));
2950: