APPS.CSM_GROUP_DOWNLOAD_PUB SQL Statements

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

Line: 30

      SELECT au.owner_id
      FROM   asg_user au
      WHERE  au.group_id = p_group_id
      AND    au.user_id  = au.owner_id
      AND    au.enabled  = 'Y';

Line: 38

      SELECT au.owner_id
      FROM   asg_user au
      WHERE  au.group_id = p_related_group_id
      AND    au.user_id  = au.owner_id
      AND    au.enabled  = 'Y';

Line: 75

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert records into CSM_GROUPS table

    csm_group_download_pvt.insert_my_group
      ( P_USER_ID          => l_owner_id,
        X_RETURN_STATUS    => l_return_status,
        X_ERROR_MESSAGE    => l_error_message);

Line: 86

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to delete records from CSM_GROUPS table

    csm_group_download_pvt.delete_my_group
      ( P_USER_ID          => l_owner_id,
        X_RETURN_STATUS    => l_return_status,
        X_ERROR_MESSAGE    => l_error_message);

Line: 117

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert Related groups records into CSM_GROUPS table

    csm_group_download_pvt.insert_group_acc
      ( P_USER_ID          => l_rel_user_id,
        P_GROUP_ID         => p_related_group_id,
        P_OWNER_ID         => l_rel_owner_id,
        P_GROUP_TYPE       => l_rel_grp_type,
        X_RETURN_STATUS    => l_rel_return_status,
        X_ERROR_MESSAGE    => l_rel_error_message);

Line: 131

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to insert Related groups records into CSM_GROUPS table

    csm_group_download_pvt.delete_group_acc
      ( P_USER_ID          => l_rel_user_id,
        P_GROUP_ID         => p_related_group_id,
        X_RETURN_STATUS    => l_rel_return_status,
        X_ERROR_MESSAGE    => l_rel_error_message);

Line: 245

      SELECT au.owner_id
      FROM   asg_user au
      WHERE  au.group_id = p_group_id
      AND    au.user_id  = au.owner_id
      AND    au.enabled  = 'Y';

Line: 253

      SELECT au.owner_id
      FROM   asg_user au
      WHERE  au.group_id = p_group_id
      AND    au.user_id  = au.owner_id
      AND    au.enabled  = 'Y';

Line: 290

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert records into CSM_GROUPS table

    csm_group_download_pvt.insert_my_group
      ( P_USER_ID          => l_owner_id,
        X_RETURN_STATUS    => l_return_status,
        X_ERROR_MESSAGE    => l_error_message);

Line: 301

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to delete records from CSM_GROUPS table

    csm_group_download_pvt.delete_my_group
      ( P_USER_ID          => l_owner_id,
        X_RETURN_STATUS    => l_return_status,
        X_ERROR_MESSAGE    => l_error_message);

Line: 327

     l_rel_group_id_tbl.DELETE;

Line: 346

  IF p_operation = 'INSERT'

  THEN

    --calling the package to insert Related groups records into CSM_GROUPS table

    csm_group_download_pvt.insert_group_acc
      ( P_USER_ID          => l_rel_user_id,
        P_GROUP_ID         => l_rel_group_id,
        P_OWNER_ID         => l_rel_owner_id,
        P_GROUP_TYPE       => l_rel_grp_type,
        X_RETURN_STATUS    => l_rel_return_status,
        X_ERROR_MESSAGE    => l_rel_error_message);

Line: 360

  ELSIF p_operation = 'DELETE'

  THEN

    --calling the package to insert Related groups records into CSM_GROUPS table

    csm_group_download_pvt.delete_group_acc
      ( P_USER_ID          => l_rel_user_id,
        P_GROUP_ID         => l_rel_group_id,
        X_RETURN_STATUS    => l_rel_return_status,
        X_ERROR_MESSAGE    => l_rel_error_message);

Line: 472

     SELECT au.owner_id
     FROM   asg_user au
     WHERE  au.group_id = p_group_id
     AND    au.user_id  = au.owner_id
     AND    au.enabled  = 'Y';

Line: 480

     SELECT acc.group_id
     FROM   csm_groups acc
     WHERE  acc.user_id         = p_owner_id
     AND    acc.group_owner_id  <> acc.user_id;

Line: 520

    l_rel_group_id_tbl.DELETE;