APPS.CSL_CS_COUNTER_VALS_ACC_PKG SQL Statements

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

Line: 30

    SELECT COUNTER_ID
    FROM CS_COUNTER_VALUES
    WHERE COUNTER_VALUE_ID = b_counter_value_id;

Line: 55

    SELECT COUNTER_VALUE_ID
    FROM CS_COUNTER_PROP_VALUES
    WHERE COUNTER_PROP_VALUE_ID = b_counter_prop_val_id;

Line: 76

PROCEDURE INSERT_CTR_PROP_VAL_ACC_RECORD ( p_counter_prop_value_id IN NUMBER,
                              p_resource_id      IN NUMBER
                            )
IS
BEGIN
-- add debug info later.
  JTM_HOOK_UTIL_PKG.Insert_Acc
  ( P_PUBLICATION_ITEM_NAMES => g_ctr_prop_vals_pubi_name
   ,P_ACC_TABLE_NAME         => g_ctr_prop_vals_acc_table_name
   ,P_PK1_NAME               => g_ctr_prop_vals_pk1_name
   ,P_PK1_NUM_VALUE          => p_counter_prop_value_id
   ,P_RESOURCE_ID            => p_resource_id
  );

Line: 89

END INSERT_CTR_PROP_VAL_ACC_RECORD;

Line: 91

PROCEDURE DELETE_CTR_PROP_VAL_ACC_RECORD ( p_counter_prop_value_id IN NUMBER,
                              p_resource_id      IN NUMBER
                            )
IS
BEGIN
-- add debug info later.
  JTM_HOOK_UTIL_PKG.Delete_Acc
  ( P_PUBLICATION_ITEM_NAMES => g_ctr_prop_vals_pubi_name
   ,P_ACC_TABLE_NAME         => g_ctr_prop_vals_acc_table_name
   ,P_PK1_NAME               => g_ctr_prop_vals_pk1_name
   ,P_PK1_NUM_VALUE          => p_counter_prop_value_id
   ,P_RESOURCE_ID            => p_resource_id
  );

Line: 104

END DELETE_CTR_PROP_VAL_ACC_RECORD;

Line: 106

PROCEDURE UPDATE_CTR_PROP_VAL_ACC_RECORD
  ( p_resource_id        IN NUMBER
   ,p_acc_id             IN NUMBER
  )
IS
BEGIN
  JTM_HOOK_UTIL_PKG.UPDATE_Acc
  ( P_PUBLICATION_ITEM_NAMES => g_ctr_prop_vals_pubi_name
   ,P_ACC_TABLE_NAME         => g_ctr_prop_vals_acc_table_name
   ,P_RESOURCE_ID            => p_resource_id
   ,P_ACCESS_ID              => p_acc_id
  );

Line: 118

END UPDATE_CTR_PROP_VAL_ACC_RECORD;

Line: 125

PROCEDURE INSERT_CTR_VALUE_ACC_Record
  ( p_counter_value_id   IN NUMBER
   ,p_resource_id        IN NUMBER
  )
IS
  CURSOR c_counter_prop_value (b_counter_value_id NUMBER) IS
    SELECT COUNTER_PROP_VALUE_ID
    FROM  CS_COUNTER_PROP_VALUES
    WHERE COUNTER_VALUE_ID = b_counter_value_id;

Line: 135

  JTM_HOOK_UTIL_PKG.Insert_Acc
  ( P_PUBLICATION_ITEM_NAMES => g_ctr_vals_pubi_name
   ,P_ACC_TABLE_NAME         => g_ctr_vals_acc_table_name
   ,P_PK1_NAME               => g_ctr_vals_pk1_name
   ,P_PK1_NUM_VALUE          => p_counter_value_id
   ,P_RESOURCE_ID            => p_resource_id
  );

Line: 144

    INSERT_CTR_PROP_VAL_ACC_RECORD( r_counter_prop_value_id.COUNTER_PROP_VALUE_ID, p_resource_id );

Line: 146

END INSERT_CTR_VALUE_ACC_Record;

Line: 148

PROCEDURE Update_CTR_VALUE_ACC_Record
  ( p_resource_id        IN NUMBER
   ,p_acc_id             IN NUMBER
  )
IS
BEGIN
  JTM_HOOK_UTIL_PKG.UPDATE_Acc
  ( P_PUBLICATION_ITEM_NAMES => g_ctr_vals_pubi_name
   ,P_ACC_TABLE_NAME         => g_ctr_vals_acc_table_name
   ,P_RESOURCE_ID            => p_resource_id
   ,P_ACCESS_ID              => p_acc_id
  );

Line: 160

END Update_CTR_VALUE_ACC_Record;

Line: 162

PROCEDURE DELETE_CTR_VALUE_ACC_Record
  ( p_counter_value_id   IN NUMBER
   ,p_resource_id        IN NUMBER
  )
IS
  CURSOR c_counter_prop_value (b_counter_value_id NUMBER) IS
    SELECT COUNTER_PROP_VALUE_ID
    FROM  CS_COUNTER_PROP_VALUES
    WHERE COUNTER_VALUE_ID = b_counter_value_id;

Line: 172

  JTM_HOOK_UTIL_PKG.Delete_Acc
  ( P_PUBLICATION_ITEM_NAMES => g_ctr_vals_pubi_name
   ,P_ACC_TABLE_NAME         => g_ctr_vals_acc_table_name
   ,P_PK1_NAME               => g_ctr_vals_pk1_name
   ,P_PK1_NUM_VALUE          => p_counter_value_id
   ,P_RESOURCE_ID            => p_resource_id
  );

Line: 181

    DELETE_CTR_PROP_VAL_ACC_RECORD( r_counter_prop_value_id.COUNTER_PROP_VALUE_ID, p_resource_id );

Line: 183

END DELETE_CTR_VALUE_ACC_Record;

Line: 189

FUNCTION POST_INSERT_PARENT
  ( p_counter_id IN NUMBER
   ,p_resource_id        IN NUMBER
  )
RETURN BOOLEAN
IS
  CURSOR c_counter_values (b_counter_id NUMBER) IS
    SELECT COUNTER_VALUE_ID
    FROM CS_COUNTER_VALUES
    WHERE COUNTER_ID = b_counter_id;

Line: 202

    INSERT_CTR_VALUE_ACC_RECORD(r_counter_value_id.COUNTER_VALUE_ID, p_resource_id);

Line: 208

END Post_Insert_Parent;

Line: 211

FUNCTION PRE_DELETE_PARENT
  ( p_counter_id IN NUMBER
   ,p_resource_id        IN NUMBER
  )
RETURN BOOLEAN
IS
  CURSOR c_counter_values (b_counter_id NUMBER) IS
    SELECT COUNTER_VALUE_ID
    FROM CS_COUNTER_VALUES
    WHERE COUNTER_ID = b_counter_id;

Line: 224

    DELETE_CTR_VALUE_ACC_RECORD(r_counter_value_id.COUNTER_VALUE_ID, p_resource_id);

Line: 230

END PRE_DELETE_PARENT;

Line: 246

    SELECT *
    FROM CS_COUNTER_VALUES
    WHERE COUNTER_VALUE_ID = b_counter_value_id;

Line: 250

    SELECT *
    FROM JTM_CS_COUNTERS_ACC
    WHERE COUNTER_ID = b_counter_id;

Line: 294

/* Called before counter value Insert.
   DO NOTHING
 */
PROCEDURE PRE_INSERT_COUNTER_VALUE
  ( x_return_status OUT NOCOPY varchar2
  )
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 303

END PRE_INSERT_COUNTER_VALUE ;

Line: 305

/* Called after counter value Insert.
   Check if counter is mobilized. If so, do the insert.
 */
PROCEDURE POST_INSERT_COUNTER_VALUE ( P_Api_Version_Number IN  NUMBER
                                    , P_Init_Msg_List      IN  VARCHAR2
                                    , P_Commit             IN  VARCHAR2
                                    , p_validation_level   IN  NUMBER
                                    , p_COUNTER_GRP_LOG_ID IN  NUMBER
                                    , X_Return_Status      OUT NOCOPY VARCHAR2
                                    , X_Msg_Count          OUT NOCOPY NUMBER
                                    , X_Msg_Data           OUT NOCOPY VARCHAR2 )
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 322

  SELECT *
  FROM CS_COUNTER_VALUES
  WHERE COUNTER_GRP_LOG_ID = b_grp_log_id;

Line: 346

        INSERT_CTR_VALUE_ACC_RECORD
        (r_ctr_vals.counter_value_id
        ,l_tab_resource_id(i)
        );

Line: 354

END POST_INSERT_COUNTER_VALUE ;

Line: 356

/* Called before counter value Update
 * DO NOTHING
 */
PROCEDURE PRE_UPDATE_COUNTER_VALUE ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 363

END PRE_UPDATE_COUNTER_VALUE ;

Line: 365

/* Called after counter value Update
 * Mark dirty
 */
PROCEDURE POST_UPDATE_COUNTER_VALUE ( P_Api_Version_Number    IN  NUMBER
                                    , P_Init_Msg_List         IN  VARCHAR2
                                    , P_Commit                IN  VARCHAR2
                                    , p_validation_level      IN  NUMBER
                                    , p_COUNTER_GRP_LOG_ID    IN  NUMBER
                                    , p_object_version_number IN  NUMBER
                                    , X_Return_Status         OUT NOCOPY VARCHAR2
                                    , X_Msg_Count             OUT NOCOPY NUMBER
                                    , X_Msg_Data              OUT NOCOPY VARCHAR2 )
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 381

  SELECT *
  FROM CS_COUNTER_VALUES
  WHERE COUNTER_GRP_LOG_ID = b_grp_log_id;

Line: 400

        UPDATE_CTR_VALUE_ACC_RECORD
        (l_tab_resource_id(i)
         ,l_tab_access_id(i)
        );

Line: 407

END POST_UPDATE_COUNTER_VALUE;

Line: 409

/* Called before counter value Update
 * DO NOTHING
 */
PROCEDURE PRE_DELETE_COUNTER_VALUE ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 416

END PRE_DELETE_COUNTER_VALUE ;

Line: 418

/* Called after counter value Update
 * Mark dirty
 */
PROCEDURE POST_DELETE_COUNTER_VALUE (
   p_counter_value_id in NUMBER
   ,x_return_status OUT NOCOPY varchar2)
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 441

      DELETE_CTR_VALUE_ACC_RECORD
      (p_counter_value_id
      ,l_tab_resource_id(i)
      );

Line: 447

END POST_DELETE_COUNTER_VALUE;

Line: 454

/* Called before counter prop value Insert.
   DO NOTHING
 */
PROCEDURE PRE_INSERT_COUNTER_PROP_VAL
  ( x_return_status OUT NOCOPY varchar2
  )
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 463

END PRE_INSERT_COUNTER_PROP_VAL ;

Line: 465

/* Called after counter Prop value Insert.
   Check if counter is mobilized. If so, do the insert.
 */
PROCEDURE POST_INSERT_COUNTER_PROP_VAL ( P_Api_Version_Number IN  NUMBER
                                       , P_Init_Msg_List      IN  VARCHAR2
                                       , P_Commit             IN  VARCHAR2
                                       , p_validation_level   IN  NUMBER
                                       , p_COUNTER_GRP_LOG_ID IN  NUMBER
                                       , X_Return_Status      OUT NOCOPY VARCHAR2
                                       , X_Msg_Count          OUT NOCOPY NUMBER
                                       , X_Msg_Data           OUT NOCOPY VARCHAR2 )
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 481

   SELECT CPV.COUNTER_PROP_VALUE_ID
   ,      CPV.COUNTER_VALUE_ID
   FROM CS_COUNTER_PROP_VALUES CPV
   ,    CS_COUNTER_VALUES CCS
   WHERE CCS.COUNTER_VALUE_ID = CPV.COUNTER_VALUE_ID
   AND   CCS.COUNTER_GRP_LOG_ID = b_ctr_grp_log_id;

Line: 501

        INSERT_CTR_PROP_VAL_ACC_RECORD
        (r_ctr_prop_vals.COUNTER_PROP_VALUE_ID
        ,l_tab_resource_id(i)
        );

Line: 508

END POST_INSERT_COUNTER_PROP_VAL ;

Line: 510

/* Called before counter prop value Update
 * DO NOTHING
 */
PROCEDURE PRE_UPDATE_COUNTER_PROP_VAL ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 517

END PRE_UPDATE_COUNTER_PROP_VAL ;

Line: 519

/* Called after counter value Update
 * Mark dirty
 */
PROCEDURE POST_UPDATE_COUNTER_PROP_VAL ( P_Api_Version_Number    IN  NUMBER
                                       , P_Init_Msg_List         IN  VARCHAR2
                                       , P_Commit                IN  VARCHAR2
                                       , p_validation_level      IN  NUMBER
                                       , p_COUNTER_GRP_LOG_ID    IN  NUMBER
                                       , p_object_version_number IN  NUMBER
                                       , X_Return_Status         OUT NOCOPY VARCHAR2
                                       , X_Msg_Count             OUT NOCOPY NUMBER
                                       , X_Msg_Data              OUT NOCOPY VARCHAR2 )
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 536

   SELECT CPV.COUNTER_PROP_VALUE_ID
   ,      CPV.COUNTER_VALUE_ID
   FROM CS_COUNTER_PROP_VALUES CPV
   ,    CS_COUNTER_VALUES CCS
   WHERE CCS.COUNTER_VALUE_ID = CPV.COUNTER_VALUE_ID
   AND   CCS.COUNTER_GRP_LOG_ID = b_ctr_grp_log_id;

Line: 558

        UPDATE_CTR_PROP_VAL_ACC_RECORD
        (l_tab_resource_id(i)
         ,l_tab_access_id(i)
        );

Line: 565

END POST_UPDATE_COUNTER_PROP_VAL;

Line: 567

/* Called before counter value Update
 * DO NOTHING
 */
PROCEDURE PRE_DELETE_COUNTER_PROP_VAL ( x_return_status OUT NOCOPY varchar2)
IS
BEGIN
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 574

END PRE_DELETE_COUNTER_PROP_VAL ;

Line: 576

/* Called after counter prop value delete
 * Mark dirty
 */
PROCEDURE POST_DELETE_COUNTER_PROP_VAL (
   p_counter_prop_val_id in NUMBER
   ,x_return_status OUT NOCOPY varchar2)
IS
  l_tab_resource_id    dbms_sql.Number_Table;

Line: 598

      DELETE_CTR_VALUE_ACC_RECORD
      (p_counter_prop_val_id
      ,l_tab_resource_id(i)
      );

Line: 604

END POST_DELETE_COUNTER_PROP_VAL;