DBA Data[Home] [Help]

APPS.AHL_UMP_SR_PVT dependencies on FND_GLOBAL

Line 498: X_CREATED_BY => fnd_global.user_id,

494: X_DEFER_FROM_UE_ID => null,
495: X_ORIG_DEFERRAL_UE_ID => null,
496: X_REMARKS => null,
497: X_CREATION_DATE => sysdate,
498: X_CREATED_BY => fnd_global.user_id,
499: X_LAST_UPDATE_DATE => sysdate,
500: X_LAST_UPDATED_BY => fnd_global.user_id,
501: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
502:

Line 500: X_LAST_UPDATED_BY => fnd_global.user_id,

496: X_REMARKS => null,
497: X_CREATION_DATE => sysdate,
498: X_CREATED_BY => fnd_global.user_id,
499: X_LAST_UPDATE_DATE => sysdate,
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' );

Line 501: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

497: X_CREATION_DATE => sysdate,
498: X_CREATED_BY => fnd_global.user_id,
499: X_LAST_UPDATE_DATE => sysdate,
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);

Line 1798: X_CREATED_BY => fnd_global.user_id,

1794: X_DEFER_FROM_UE_ID => null,
1795: X_ORIG_DEFERRAL_UE_ID => null,
1796: X_REMARKS => null,
1797: X_CREATION_DATE => sysdate,
1798: X_CREATED_BY => fnd_global.user_id,
1799: X_LAST_UPDATE_DATE => sysdate,
1800: X_LAST_UPDATED_BY => fnd_global.user_id,
1801: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
1802:

Line 1800: X_LAST_UPDATED_BY => fnd_global.user_id,

1796: X_REMARKS => null,
1797: X_CREATION_DATE => sysdate,
1798: X_CREATED_BY => fnd_global.user_id,
1799: X_LAST_UPDATE_DATE => sysdate,
1800: X_LAST_UPDATED_BY => fnd_global.user_id,
1801: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
1802:
1803: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1804: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Created New UE with Id ' || x_ue_id);

Line 1801: X_LAST_UPDATE_LOGIN => fnd_global.login_id );

1797: X_CREATION_DATE => sysdate,
1798: X_CREATED_BY => fnd_global.user_id,
1799: X_LAST_UPDATE_DATE => sysdate,
1800: X_LAST_UPDATED_BY => fnd_global.user_id,
1801: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
1802:
1803: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1804: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Created New UE with Id ' || x_ue_id);
1805: END IF;

Line 2198: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated

2194: X_DEFER_FROM_UE_ID => l_curr_ue_rec.DEFER_FROM_UE_ID,
2195: X_ORIG_DEFERRAL_UE_ID => l_curr_ue_rec.ORIG_DEFERRAL_UE_ID,
2196: X_REMARKS => l_curr_ue_rec.REMARKS,
2197: X_LAST_UPDATE_DATE => SYSDATE, -- Updated
2198: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
2199: X_LAST_UPDATE_LOGIN => fnd_global.login_id -- Updated
2200: );
2201: l_temp_count := l_temp_count + 1;
2202: END LOOP;

Line 2199: X_LAST_UPDATE_LOGIN => fnd_global.login_id -- Updated

2195: X_ORIG_DEFERRAL_UE_ID => l_curr_ue_rec.ORIG_DEFERRAL_UE_ID,
2196: X_REMARKS => l_curr_ue_rec.REMARKS,
2197: X_LAST_UPDATE_DATE => SYSDATE, -- Updated
2198: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
2199: X_LAST_UPDATE_LOGIN => fnd_global.login_id -- Updated
2200: );
2201: l_temp_count := l_temp_count + 1;
2202: END LOOP;
2203: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2378: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated

2374: X_DEFER_FROM_UE_ID => l_curr_ue_rec.DEFER_FROM_UE_ID,
2375: X_ORIG_DEFERRAL_UE_ID => l_curr_ue_rec.ORIG_DEFERRAL_UE_ID,
2376: X_REMARKS => l_curr_ue_rec.REMARKS,
2377: X_LAST_UPDATE_DATE => SYSDATE, -- Updated
2378: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
2379: X_LAST_UPDATE_LOGIN => fnd_global.login_id -- Updated
2380: );
2381: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2382: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Unit Effectivity ' || p_sr_ue_id || ' has been updated.');

Line 2379: X_LAST_UPDATE_LOGIN => fnd_global.login_id -- Updated

2375: X_ORIG_DEFERRAL_UE_ID => l_curr_ue_rec.ORIG_DEFERRAL_UE_ID,
2376: X_REMARKS => l_curr_ue_rec.REMARKS,
2377: X_LAST_UPDATE_DATE => SYSDATE, -- Updated
2378: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
2379: X_LAST_UPDATE_LOGIN => fnd_global.login_id -- Updated
2380: );
2381: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2382: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Unit Effectivity ' || p_sr_ue_id || ' has been updated.');
2383: END IF;