577:
578: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
579: END IF;
580:
581: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Insert_Row)
582: AMS_DM_scoreS_B_PKG.Insert_Row(
583: p_score_id => l_score_rec.score_ID,
584: p_last_update_date => SYSDATE,
585: p_last_updated_by => FND_GLOBAL.USER_ID,
578: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
579: END IF;
580:
581: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Insert_Row)
582: AMS_DM_scoreS_B_PKG.Insert_Row(
583: p_score_id => l_score_rec.score_ID,
584: p_last_update_date => SYSDATE,
585: p_last_updated_by => FND_GLOBAL.USER_ID,
586: p_creation_date => SYSDATE,
1231: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler',FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1232: END IF;
1233:
1234: BEGIN
1235: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Update_Row)
1236: AMS_DM_scoreS_B_PKG.Update_Row(
1237: p_score_ID => l_tar_score_rec.score_id,
1238: p_LAST_UPDATE_DATE => SYSDATE,
1239: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1232: END IF;
1233:
1234: BEGIN
1235: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Update_Row)
1236: AMS_DM_scoreS_B_PKG.Update_Row(
1237: p_score_ID => l_tar_score_rec.score_id,
1238: p_LAST_UPDATE_DATE => SYSDATE,
1239: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1240: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
1458: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1459:
1460: END IF;
1461: -- Debug Message
1462: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Delete_Row)
1463: AMS_DM_scoreS_B_PKG.Delete_Row(
1464: p_score_ID => p_score_id);
1465: --
1466: -- End of API body
1459:
1460: END IF;
1461: -- Debug Message
1462: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Delete_Row)
1463: AMS_DM_scoreS_B_PKG.Delete_Row(
1464: p_score_ID => p_score_id);
1465: --
1466: -- End of API body
1467: --