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_SR_PVT dependencies on AHL_UNIT_EFFECTIVITIES_PKG

Line 432: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling TABLE HANDLER AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row' );

428: END IF;
429: END IF;
430:
431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
432: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' BEFORE Calling TABLE HANDLER AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row' );
433: END IF;
434:
435:
436: --******************************

Line 439: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

435:
436: --******************************
437: -- Call Table Handler.
438: --******************************
439: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
440: X_ROWID => l_rowid,
441: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
442: X_MANUALLY_PLANNED_FLAG => 'Y',
443: X_LOG_SERIES_CODE => null,

Line 504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' AFTER Calling TABLE HANDLER AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row' );

500: X_LAST_UPDATED_BY => fnd_global.user_id,
501: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
502:
503: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
504: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' AFTER Calling TABLE HANDLER AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row' );
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Unit Effectivity ID:' || l_unit_effectivity_id);
506: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Return Status:' || x_return_status);
507: END IF;
508:

Line 1367: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => l_rel_dtls_rec.RELATED_UE_ID);

1363:
1364: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Unit Effectivity with UNIT_EFFECTIVITY_ID = ' || l_rel_dtls_rec.RELATED_UE_ID || ' for a Group MR');
1366: END IF;
1367: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => l_rel_dtls_rec.RELATED_UE_ID);
1368: END LOOP;
1369: -- Delete the MR Relationship and UE
1370: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Relationship with RELATIONSHIP_ID = ' || l_relationship_id);

Line 1378: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => p_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);

1374:
1375: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1376: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to Delete Unit Effectivity with UNIT_EFFECTIVITY_ID = ' || p_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1377: END IF;
1378: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => p_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1379:
1380: END IF; -- Disassociation Record
1381: END LOOP; -- All Association/Disassociation Records
1382:

Line 1739: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

1735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
1737: END IF;
1738:
1739: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
1740: X_ROWID => l_temp_row_id,
1741: X_UNIT_EFFECTIVITY_ID => x_ue_id,
1742: X_MANUALLY_PLANNED_FLAG => 'Y',
1743: X_LOG_SERIES_CODE => null,

Line 2140: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW(

2136: ELSE
2137: l_temp_tolerance_flag := l_curr_ue_rec.TOLERANCE_FLAG;
2138: END IF;
2139: -- Update the unit effectivity
2140: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW(
2141: X_UNIT_EFFECTIVITY_ID => l_curr_ue_rec.UNIT_EFFECTIVITY_ID,
2142: X_MANUALLY_PLANNED_FLAG => l_curr_ue_rec.MANUALLY_PLANNED_FLAG,
2143: X_LOG_SERIES_CODE => l_curr_ue_rec.LOG_SERIES_CODE,
2144: X_LOG_SERIES_NUMBER => l_curr_ue_rec.LOG_SERIES_NUMBER,

Line 2320: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW(

2316: l_temp_tolerance_flag := l_curr_ue_rec.TOLERANCE_FLAG;
2317: END IF;
2318:
2319: -- Update the unit effectivity
2320: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW(
2321: X_UNIT_EFFECTIVITY_ID => l_curr_ue_rec.UNIT_EFFECTIVITY_ID,
2322: X_MANUALLY_PLANNED_FLAG => l_curr_ue_rec.MANUALLY_PLANNED_FLAG,
2323: X_LOG_SERIES_CODE => l_curr_ue_rec.LOG_SERIES_CODE,
2324: X_LOG_SERIES_NUMBER => l_curr_ue_rec.LOG_SERIES_NUMBER,

Line 2542: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => rel_and_ue_id_rec.RELATED_UE_ID);

2538: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleted Relationship with UE_RELATIONSHIP_ID = ' || rel_and_ue_id_rec.UE_RELATIONSHIP_ID);
2540: END IF;
2541: -- Next delete the unit effectivity
2542: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => rel_and_ue_id_rec.RELATED_UE_ID);
2543: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2544: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleted Unit Effectivity with UNIT_EFFECTIVITY_ID = ' || rel_and_ue_id_rec.RELATED_UE_ID);
2545: END IF;
2546: END LOOP;

Line 2549: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => p_sr_ue_id);

2545: END IF;
2546: END LOOP;
2547:
2548: -- Delete the SR's Unit Effectivity
2549: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW(X_UNIT_EFFECTIVITY_ID => p_sr_ue_id);
2550: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Deleted Unit Effectivity with UNIT_EFFECTIVITY_ID = ' || p_sr_ue_id);
2552: END IF;
2553: END IF; -- Planned or Not