DBA Data[Home] [Help]

APPS.AMS_REL_ITEM_PVT SQL Statements

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

Line: 52

    Select rowid,
           INVENTORY_ITEM_ID,
           ORGANIZATION_ID,
           RELATED_ITEM_ID,
           RELATIONSHIP_TYPE_ID,
           RECIPROCAL_FLAG,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE
    From  MTL_RELATED_ITEMS
    WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
	 AND organization_id   = P_REL_ITEM_Rec.organization_id
	 AND related_item_id   = P_REL_ITEM_Rec.related_item_id
	 AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;
Line: 76

    SELECT item_owner_id
    FROM ams_item_attributes
    WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
    AND organization_id = P_REL_ITEM_rec.organization_id;
Line: 191

      AMS_RELATED_ITEMS_PKG.Insert_Row(
          p_INVENTORY_ITEM_ID  => p_REL_ITEM_rec.INVENTORY_ITEM_ID,
          p_ORGANIZATION_ID  => p_REL_ITEM_rec.ORGANIZATION_ID,
          p_RELATED_ITEM_ID  => p_REL_ITEM_rec.RELATED_ITEM_ID,
          p_RELATIONSHIP_TYPE_ID  => p_REL_ITEM_rec.RELATIONSHIP_TYPE_ID,
          p_RECIPROCAL_FLAG  => p_REL_ITEM_rec.RECIPROCAL_FLAG,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_REQUEST_ID  => p_REL_ITEM_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_REL_ITEM_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => p_REL_ITEM_rec.PROGRAM_UPDATE_DATE);
Line: 299

PROCEDURE Update_rel_item(
    P_Api_Version_Number         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_REL_ITEM_Rec     IN    REL_ITEM_Rec_Type
    )

 IS

Cursor C_Get_rel_item  IS
    Select rowid,
           INVENTORY_ITEM_ID,
           ORGANIZATION_ID,
           RELATED_ITEM_ID,
           RELATIONSHIP_TYPE_ID,
           RECIPROCAL_FLAG,
           LAST_UPDATE_DATE,
           LAST_UPDATED_BY,
           CREATION_DATE,
           CREATED_BY,
           LAST_UPDATE_LOGIN,
           REQUEST_ID,
           PROGRAM_APPLICATION_ID,
           PROGRAM_ID,
           PROGRAM_UPDATE_DATE
    From  MTL_RELATED_ITEMS
    WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
	 AND organization_id   = P_REL_ITEM_Rec.organization_id
	 AND related_item_id   = P_REL_ITEM_Rec.related_item_id
	 AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;
Line: 337

l_api_name                CONSTANT VARCHAR2(30) := 'Update_rel_item';
Line: 348

      SAVEPOINT UPDATE_REL_ITEM_PVT;
Line: 378

      AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
Line: 391

               l_ref_REL_ITEM_rec.LAST_UPDATE_DATE,
               l_ref_REL_ITEM_rec.LAST_UPDATED_BY,
               l_ref_REL_ITEM_rec.CREATION_DATE,
               l_ref_REL_ITEM_rec.CREATED_BY,
               l_ref_REL_ITEM_rec.LAST_UPDATE_LOGIN,
               l_ref_REL_ITEM_rec.REQUEST_ID,
               l_ref_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
               l_ref_REL_ITEM_rec.PROGRAM_ID,
               l_ref_REL_ITEM_rec.PROGRAM_UPDATE_DATE;
Line: 404

               FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
Line: 444

      AMS_RELATED_ITEMS_PKG.Update_Row(
          p_INVENTORY_ITEM_ID  => p_REL_ITEM_rec.INVENTORY_ITEM_ID,
          p_ORGANIZATION_ID  => p_REL_ITEM_rec.ORGANIZATION_ID,
          p_RELATED_ITEM_ID  => p_REL_ITEM_rec.RELATED_ITEM_ID,
          p_RELATIONSHIP_TYPE_ID  => p_REL_ITEM_rec.RELATIONSHIP_TYPE_ID,
          p_RECIPROCAL_FLAG  => p_REL_ITEM_rec.RECIPROCAL_FLAG,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_REQUEST_ID  => p_REL_ITEM_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_REL_ITEM_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => p_REL_ITEM_rec.PROGRAM_UPDATE_DATE);
Line: 483

    ROLLBACK TO UPDATE_REL_ITEM_PVT;
Line: 492

    ROLLBACK TO UPDATE_REL_ITEM_PVT;
Line: 501

    ROLLBACK TO UPDATE_REL_ITEM_PVT;
Line: 513

End Update_rel_item;
Line: 516

PROCEDURE Delete_rel_item(
    P_Api_Version_Number         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_REL_ITEM_Rec     IN    REL_ITEM_Rec_Type
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_rel_item';
Line: 536

   SELECT 1
   FROM mtl_related_items
   WHERE organization_id = P_REL_ITEM_Rec.organization_id
   AND inventory_item_id = p_REL_ITEM_Rec.inventory_item_id;
Line: 546

    SELECT item_owner_id
    FROM ams_item_attributes
    WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
    AND organization_id = P_REL_ITEM_rec.organization_id;
Line: 553

      SAVEPOINT DELETE_REL_ITEM_PVT;
Line: 586

      AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
Line: 591

      AMS_RELATED_ITEMS_PKG.Delete_Row(
          p_INVENTORY_ITEM_ID  => p_REL_ITEM_rec.INVENTORY_ITEM_ID,
          p_ORGANIZATION_ID  => p_REL_ITEM_rec.ORGANIZATION_ID,
          p_RELATED_ITEM_ID  => p_REL_ITEM_rec.RELATED_ITEM_ID,
          p_RELATIONSHIP_TYPE_ID  => p_REL_ITEM_rec.RELATIONSHIP_TYPE_ID,
          p_RECIPROCAL_FLAG  => p_REL_ITEM_rec.RECIPROCAL_FLAG,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_CREATION_DATE  => SYSDATE,
          p_CREATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_REQUEST_ID  => p_REL_ITEM_rec.REQUEST_ID,
          p_PROGRAM_APPLICATION_ID  => p_REL_ITEM_rec.PROGRAM_APPLICATION_ID,
          p_PROGRAM_ID  => p_REL_ITEM_rec.PROGRAM_ID,
          p_PROGRAM_UPDATE_DATE  => p_REL_ITEM_rec.PROGRAM_UPDATE_DATE);
Line: 683

    ROLLBACK TO DELETE_REL_ITEM_PVT;
Line: 692

    ROLLBACK TO DELETE_REL_ITEM_PVT;
Line: 701

    ROLLBACK TO DELETE_REL_ITEM_PVT;
Line: 713

End Delete_rel_item;
Line: 739

   SELECT *
     FROM mtl_related_items
    WHERE inventory_item_id = P_REL_ITEM_Rec.inventory_item_id
	AND organization_id   = P_REL_ITEM_Rec.organization_id
	AND related_item_id   = P_REL_ITEM_Rec.related_item_id
	AND relationship_type_id = P_REL_ITEM_Rec.relationship_type_id;
Line: 803

   IF P_REL_ITEM_Rec.program_update_date = FND_API.g_miss_date THEN
	    x_complete_rec.program_update_date := l_rel_item_rec.program_update_date;
Line: 845

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