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.AMS_FORMULA_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 255


   SELECT activity_metric_id,parent_formula_id
   FROM   ams_act_metric_formulas
   WHERE  formula_id = p_formula_id;

Line: 274


   SELECT *
   FROM   ams_act_metric_form_ent
   WHERE  formula_id = p_formula_id
   ORDER BY formula_entry_id,order_number;

Line: 357


	    l_sql_stmt := 'SELECT '||l_formula_entry_dets.formula_entry_value||'(:p1,:p2,:p3,:p4,:p5) FROM DUAL';

Line: 366


	    l_sql_stmt := 'SELECT '||l_formula_entry_dets.formula_entry_value||' FROM AMS_ACT_METRICS_ALL WHERE ACTIVITY_METRIC_ID = :P1';

Line: 593


     IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN
            NULL;

Line: 642


     IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN

         NULL;

Line: 842


   SELECT COUNT(*)
   FROM   ams_act_metric_formulas
   WHERE  formula_type       = p_formula_rec.formula_type
   AND    activity_metric_id = p_formula_rec.activity_metric_id
   AND    level_depth        = p_formula_rec.level_depth
   AND    formula_id        <> p_formula_rec.formula_id;

Line: 895


   SELECT COUNT(*)
   FROM   ams_act_metric_form_ent
   WHERE  formula_id         =  p_formula_entry_rec.formula_id
   AND    order_number       =  p_formula_entry_rec.order_number
   AND    formula_entry_id   <> p_formula_entry_rec.formula_entry_id;

Line: 1655


   SELECT count(*)
   FROM   ams_act_metric_formulas
   WHERE  formula_id = l_formula_id;

Line: 1660


   SELECT ams_act_metric_formulas_s.NEXTVAL
   FROM   dual;

Line: 1767


      AMS_Utility_PVT.debug_message(l_full_name ||': insert');

Line: 1775


   INSERT INTO AMS_ACT_METRIC_FORMULAS
   ( formula_id
    ,activity_metric_id
    ,level_depth
    ,parent_formula_id
    ,last_update_date
    ,last_updated_by
    ,creation_date
    ,created_by
    ,last_update_login
    ,object_version_number
    ,formula_type
    )
    VALUES
    (l_formula_rec.formula_id
    ,l_formula_rec.activity_metric_id
    ,l_formula_rec.level_depth
    ,l_formula_rec.parent_formula_id
    ,SYSDATE
    ,FND_GLOBAL.User_ID
    ,SYSDATE
    ,FND_GLOBAL.User_ID
    ,FND_GLOBAL.Conc_Login_ID
    ,1--object version number
    ,l_formula_rec.formula_type
    );

Line: 1931


   SELECT count(*)
   FROM   ams_act_metric_form_ent
   WHERE  formula_entry_id = l_formula_entry_id;

Line: 1936


   SELECT ams_act_metric_formula_ent_s.NEXTVAL
   FROM   dual;

Line: 2043


      AMS_Utility_PVT.debug_message(l_full_name ||': insert');

Line: 2051


   INSERT INTO AMS_ACT_METRIC_FORM_ENT
   ( formula_entry_id
    ,formula_id
    ,order_number
    ,formula_entry_type
    ,formula_entry_value
    ,metric_column_value
    ,formula_entry_operator
    ,last_update_date
    ,last_updated_by
    ,creation_date
    ,created_by
    ,last_update_login
    ,object_version_number
   )
   VALUES
   ( l_formula_entry_rec.formula_entry_id
    ,l_formula_entry_rec.formula_id
    ,l_formula_entry_rec.order_number
    ,l_formula_entry_rec.formula_entry_type
    ,l_formula_entry_rec.formula_entry_value
    ,l_formula_entry_rec.metric_column_value
    ,l_formula_entry_rec.formula_entry_operator
    ,SYSDATE
    ,FND_GLOBAL.User_ID
    ,SYSDATE
    ,FND_GLOBAL.User_ID
    ,FND_GLOBAL.User_ID
    ,1--OBJECT_VERSION_NUMBER
   );

Line: 2181


PROCEDURE Update_Formula (
   p_api_version                IN  NUMBER,
   p_init_msg_list              IN  VARCHAR2 := FND_API.G_FALSE,
   p_commit                     IN  VARCHAR2 := FND_API.G_FALSE,
   p_validation_level           IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,

   x_return_status              OUT NOCOPY VARCHAR2,
   x_msg_count                  OUT NOCOPY NUMBER,
   x_msg_data                   OUT NOCOPY VARCHAR2,

   p_formula_rec                IN  ams_formula_rec_type
)
IS
   L_API_VERSION                CONSTANT NUMBER := 1.0;

Line: 2195


   L_API_NAME                   CONSTANT VARCHAR2(30) := 'UPDATE_FORMULA';

Line: 2207


   SAVEPOINT Update_Formula_Pvt;

Line: 2248


   	 p_validation_mode      => JTF_PLSQL_API.G_UPDATE,
   	 x_complete_rec         => l_formula_rec,
   	 x_return_status        => l_return_status,
   	 x_msg_count            => x_msg_count,
   	 x_msg_data             => x_msg_data  ) ;

Line: 2271


         p_validation_mode      => JTF_PLSQL_API.g_update,
         x_return_status        => l_return_status
      );

Line: 2304


      AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formulas Table');

Line: 2307


   UPDATE  ams_act_metric_formulas SET
           activity_metric_id      =  l_formula_rec.activity_metric_id,
           level_depth             =  l_formula_rec.level_depth,
           parent_formula_id       =  l_formula_rec.parent_formula_id,
           last_update_date        =  SYSDATE,
           last_updated_by         =  FND_GLOBAL.User_Id,
           last_update_login       =  FND_GLOBAL.Conc_Login_Id,
           object_version_number   =  l_formula_rec.object_version_number + 1,
           formula_type            =  l_formula_rec.formula_type
   WHERE   formula_id              =  l_formula_rec.formula_id;

Line: 2361


      ROLLBACK TO Update_Formula_pvt;

Line: 2369


      ROLLBACK TO Update_Formula_pvt;

Line: 2378


      ROLLBACK TO Update_Formula_pvt;

Line: 2387


END Update_Formula;

Line: 2406


PROCEDURE Update_Formula_Entry (
   p_api_version                IN  NUMBER,
   p_init_msg_list              IN  VARCHAR2 := FND_API.G_FALSE,
   p_commit                     IN  VARCHAR2 := FND_API.G_FALSE,
   p_validation_level           IN  NUMBER := FND_API.G_VALID_LEVEL_FULL,

   x_return_status              OUT NOCOPY VARCHAR2,
   x_msg_count                  OUT NOCOPY NUMBER,
   x_msg_data                   OUT NOCOPY VARCHAR2,

   p_formula_entry_rec          IN  ams_formula_entry_rec_type
)
IS
   L_API_VERSION                CONSTANT NUMBER := 1.0;

Line: 2420


   L_API_NAME                   CONSTANT VARCHAR2(30) := 'UPDATE_FORMULA_ENTRY';

Line: 2432


   SAVEPOINT Update_Formula_Entry_Pvt;

Line: 2473


   	 p_validation_mode      => JTF_PLSQL_API.G_UPDATE,
   	 x_complete_entry_rec   => l_formula_entry_rec,
   	 x_return_status        => l_return_status,
   	 x_msg_count            => x_msg_count,
   	 x_msg_data             => x_msg_data  ) ;

Line: 2496


         p_validation_mode      => JTF_PLSQL_API.g_update,
         x_return_status        => l_return_status
      );

Line: 2528


      AMS_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Formula Entry Table');

Line: 2531


   UPDATE  ams_act_metric_form_ent SET
    formula_id              = l_formula_entry_rec.formula_id
   ,order_number            = l_formula_entry_rec.order_number
   ,formula_entry_type      = l_formula_entry_rec.formula_entry_type
   ,formula_entry_value     = l_formula_entry_rec.formula_entry_value
   ,metric_column_value     = l_formula_entry_rec.metric_column_value
   ,formula_entry_operator  = l_formula_entry_rec.formula_entry_operator
   ,object_version_number   = l_formula_entry_rec.object_version_number + 1
   ,last_update_date        = SYSDATE
   ,last_updated_by         = FND_GLOBAL.User_ID
   ,last_update_login       = FND_GLOBAL.User_ID
   WHERE   formula_entry_id = l_formula_entry_rec.formula_entry_id;

Line: 2588


      ROLLBACK TO Update_Formula_Entry_Pvt;

Line: 2595


      ROLLBACK TO Update_Formula_Entry_Pvt;

Line: 2603


     ROLLBACK TO Update_Formula_Entry_Pvt;

Line: 2612


END Update_Formula_Entry;

Line: 2629


PROCEDURE Delete_Formula (
   p_api_version              IN  NUMBER,
   p_init_msg_list            IN  VARCHAR2 := FND_API.G_FALSE,
   p_commit                   IN  VARCHAR2 := FND_API.G_FALSE,

   x_return_status            OUT NOCOPY VARCHAR2,
   x_msg_count                OUT NOCOPY NUMBER,
   x_msg_data                 OUT NOCOPY VARCHAR2,

   p_formula_id              IN  NUMBER,
   p_object_version_number    IN  NUMBER
)
IS
   L_API_VERSION              CONSTANT NUMBER := 1.0;

Line: 2643


   L_API_NAME                 CONSTANT VARCHAR2(30) := 'DELETE_FORMULA';

Line: 2652


   SAVEPOINT Delete_Formula_pvt;

Line: 2690


   	     AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');

Line: 2697


         DELETE
	 FROM  ams_act_metric_formulas
         WHERE formula_id = p_formula_id
	 AND   object_version_number = p_object_version_number;

Line: 2712


         DELETE
	 FROM  ams_act_metric_form_ent
         WHERE formula_id = p_formula_id;

Line: 2744


      ROLLBACK TO Delete_Formula_pvt;

Line: 2751


      ROLLBACK TO Delete_Formula_pvt;

Line: 2758


      ROLLBACK TO Delete_Formula_pvt;

Line: 2767


END Delete_Formula;

Line: 2784


PROCEDURE Delete_Formula_Entry (
   p_api_version              IN  NUMBER,
   p_init_msg_list            IN  VARCHAR2 := FND_API.G_FALSE,
   p_commit                   IN  VARCHAR2 := FND_API.G_FALSE,

   x_return_status            OUT NOCOPY VARCHAR2,
   x_msg_count                OUT NOCOPY NUMBER,
   x_msg_data                 OUT NOCOPY VARCHAR2,

   p_formula_entry_id         IN  NUMBER,
   p_object_version_number    IN  NUMBER
)
IS
   L_API_VERSION              CONSTANT NUMBER := 1.0;

Line: 2798


   L_API_NAME                 CONSTANT VARCHAR2(30) := 'DELETE_FORMULA_ENTRY';

Line: 2807


   SAVEPOINT Delete_Formula_Entry_Pvt;

Line: 2845


   	     AMS_Utility_PVT.debug_message(l_full_name ||': delete with Validation');

Line: 2852


         DELETE
	 FROM  ams_act_metric_form_ent
         WHERE formula_entry_id = p_formula_entry_id
	 AND   object_version_number = p_object_version_number;

Line: 2895


      ROLLBACK TO Delete_Formula_Entry_Pvt;

Line: 2902


      ROLLBACK TO Delete_Formula_Entry_Pvt;

Line: 2909


      ROLLBACK TO Delete_Formula_Entry_Pvt;

Line: 2918


END Delete_Formula_Entry;

Line: 2954


   SELECT formula_id
   FROM   ams_act_metric_formulas
   WHERE  formula_id         = p_formula_id
   AND object_version_number = p_object_version_number
   FOR UPDATE OF formula_id NOWAIT;

Line: 3104


   SELECT formula_entry_id
   FROM   ams_act_metric_form_ent
   WHERE  formula_entry_id   = p_formula_entry_id
   AND object_version_number = p_object_version_number
   FOR UPDATE OF formula_entry_id NOWAIT;

Line: 3240


   SELECT *
   FROM  ams_act_metric_formulas
   WHERE formula_id = p_formula_rec.formula_id;

Line: 3281


   IF p_formula_rec.last_update_date  = FND_API.G_MISS_DATE THEN
      x_complete_formula_rec.last_update_date  := l_formula_rec.last_update_date;

Line: 3285


   IF p_formula_rec.last_updated_by   = FND_API.G_MISS_NUM THEN
      x_complete_formula_rec.last_updated_by   := l_formula_rec.last_updated_by ;

Line: 3294


      x_complete_formula_rec.last_updated_by   := l_formula_rec.last_updated_by ;

Line: 3297


   IF p_formula_rec.last_update_login  = FND_API.G_MISS_NUM THEN
      x_complete_formula_rec.last_updated_by   := l_formula_rec.last_updated_by ;

Line: 3328


   SELECT *
   FROM  ams_act_metric_form_ent
   WHERE formula_entry_id = p_formula_entry_rec.formula_entry_id;

Line: 3384


   IF p_formula_entry_rec.last_update_date  = FND_API.G_MISS_DATE THEN
      x_complete_formula_entry_rec.last_update_date  := l_formula_entry_rec.last_update_date;

Line: 3388


   IF p_formula_entry_rec.last_updated_by  = FND_API.G_MISS_NUM THEN
      x_complete_formula_entry_rec.last_updated_by  := l_formula_entry_rec.last_updated_by;

Line: 3400


   IF p_formula_entry_rec.last_update_login  = FND_API.G_MISS_NUM THEN
      x_complete_formula_entry_rec.last_update_login  := l_formula_entry_rec.last_update_login;