APPS.EGO_LIFECYCLE_ADMIN_PUB SQL Statements

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

Line: 13

 PROCEDURE Check_Delete_Lifecycle_OK
(
     p_api_version             IN      NUMBER
   , p_lifecycle_id            IN      PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
   , p_init_msg_list           IN      VARCHAR2   := fnd_api.g_FALSE
   , x_delete_ok               OUT     NOCOPY VARCHAR2
   , x_return_status           OUT     NOCOPY VARCHAR2
   , x_errorcode               OUT     NOCOPY NUMBER
   , x_msg_count               OUT     NOCOPY NUMBER
   , x_msg_data                OUT     NOCOPY VARCHAR2
)
IS
  l_count  NUMBER;

Line: 26

  l_api_name        CONSTANT VARCHAR2(30)     := 'Check_Delete_Lifecycle_OK';

Line: 34

   x_delete_ok := FND_API.G_TRUE;

Line: 37

    SELECT 1
    INTO l_count
    FROM DUAL
    WHERE EXISTS
      (SELECT 'X'
       FROM  MTL_SYSTEM_ITEMS_B
       WHERE LIFECYCLE_ID = p_lifecycle_id);

Line: 44

    x_delete_ok := FND_API.G_FALSE;

Line: 55

      SELECT 1
      INTO l_count
      FROM DUAL
      WHERE EXISTS
        (SELECT 'X'
        FROM  MTL_ITEM_REVISIONS_B
        WHERE LIFECYCLE_ID = p_lifecycle_id);

Line: 62

      x_delete_ok := FND_API.G_FALSE;

Line: 74

      SELECT 1
      INTO l_count
      FROM DUAL
      WHERE EXISTS
        (SELECT 'X'
         FROM  MTL_PENDING_ITEM_STATUS
         WHERE LIFECYCLE_ID = p_lifecycle_id);

Line: 81

      x_delete_ok := FND_API.G_FALSE;

Line: 100

     x_delete_ok := FND_API.G_FALSE;

Line: 109

END Check_Delete_Lifecycle_OK;

Line: 111

PROCEDURE Check_Delete_Phase_OK
(
    p_api_version             IN      NUMBER
  , p_phase_id                IN      PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
  , p_init_msg_list           IN      VARCHAR2   := FND_API.G_FALSE
  , x_delete_ok               OUT     NOCOPY VARCHAR2
  , x_return_status           OUT     NOCOPY VARCHAR2
  , x_errorcode               OUT     NOCOPY NUMBER
  , x_msg_count               OUT     NOCOPY NUMBER
  , x_msg_data                OUT     NOCOPY VARCHAR2
)
IS
    l_count           NUMBER;

Line: 125

    l_api_name        CONSTANT VARCHAR2(30)     := 'Check_Delete_Phase_OK';

Line: 131

   x_delete_ok := FND_API.G_TRUE;

Line: 134

    SELECT 1
    INTO l_count
    FROM DUAL
    WHERE EXISTS
      (SELECT 'X'
       FROM  MTL_SYSTEM_ITEMS_B
       WHERE CURRENT_PHASE_ID = p_phase_id);

Line: 141

    x_delete_ok := FND_API.G_FALSE;

Line: 152

      SELECT 1
      INTO l_count
      FROM DUAL
      WHERE EXISTS
        (SELECT 'X'
         FROM  MTL_ITEM_REVISIONS_B
         WHERE CURRENT_PHASE_ID = p_phase_id);

Line: 159

      x_delete_ok := FND_API.G_FALSE;

Line: 171

      SELECT 1
      INTO l_count
      FROM DUAL
      WHERE EXISTS
        (SELECT 'X'
         FROM  MTL_PENDING_ITEM_STATUS
         WHERE PHASE_ID = p_phase_id);

Line: 178

      x_delete_ok := FND_API.G_FALSE;

Line: 198

     x_delete_ok := FND_API.G_FALSE;

Line: 207

END Check_Delete_Phase_OK;

Line: 210

PROCEDURE Process_Phase_Delete
(
    p_api_version             IN  NUMBER
  , p_phase_id                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_errorcode               OUT  NOCOPY NUMBER
  , x_msg_count               OUT  NOCOPY NUMBER
  , x_msg_data                OUT  NOCOPY VARCHAR2
)
IS
  l_api_name        CONSTANT VARCHAR2(30)     := 'Process_Phase_Delete';

Line: 226

    SAVEPOINT Process_Phase_Delete_PUB;

Line: 241

 DELETE
 FROM
   EGO_LCPHASE_POLICY
 WHERE
   PHASE_ID = p_phase_id;

Line: 256

       ROLLBACK TO Process_Phase_Delete_PUB;

Line: 266

END Process_Phase_Delete;

Line: 268

PROCEDURE Process_Phase_Code_Delete
(
     p_api_version             IN   NUMBER
   , p_phase_code              IN   VARCHAR2
   , 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_errorcode               OUT  NOCOPY NUMBER
   , x_msg_count               OUT  NOCOPY NUMBER
   , x_msg_data                OUT  NOCOPY VARCHAR2
)
IS
  l_api_name        CONSTANT VARCHAR2(30)     := 'Process_Phase_Code_Delete';

Line: 284

   SAVEPOINT Process_Phase_Code_Delete_PUB;

Line: 299

  DELETE
  FROM
    EGO_LCPHASE_ITEM_STATUS
  WHERE
    PHASE_CODE = p_phase_code;

Line: 314

       ROLLBACK TO Process_Phase_Code_Delete_PUB;

Line: 324

END Process_Phase_Code_Delete;

Line: 326

PROCEDURE Delete_Stale_Data_For_Lc
(
    p_api_version             IN  NUMBER
  , p_lifecycle_id            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_errorcode               OUT  NOCOPY NUMBER
  , x_msg_count               OUT  NOCOPY NUMBER
  , x_msg_data                OUT  NOCOPY VARCHAR2
)
IS
  l_api_name        CONSTANT VARCHAR2(30)     := 'Delete_Stale_Data_For_Lc';

Line: 342

    SAVEPOINT Delete_Stale_Data_Lc_PUB;

Line: 356

 DELETE
 FROM
   EGO_OBJ_TYPE_LIFECYCLES
 WHERE
   LIFECYCLE_ID = p_lifecycle_id;

Line: 382

       ROLLBACK TO Delete_Stale_Data_Lc_PUB;

Line: 392

END Delete_Stale_Data_For_Lc;