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

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

Line: 47


      SELECT OZF_ACCTNG_EVENTS_ALL_s.NEXTVAL
      FROM dual;

Line: 51


      SELECT count(accounting_event_id) FROM OZF_ACCTNG_EVENTS_ALL
      WHERE ACCOUNTING_EVENT_ID = l_id;

Line: 139


      OZF_ACCTNG_EVENTS_PKG.Insert_Row(
          px_accounting_event_id  => l_accounting_event_id,
          px_object_version_number  => l_object_version_number,
          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_acctng_event_rec.request_id,
          p_program_application_id  => p_acctng_event_rec.program_application_id,
          p_program_update_date  => p_acctng_event_rec.program_update_date,
          p_program_id  => p_acctng_event_rec.program_id,
          p_accounting_date  => p_acctng_event_rec.accounting_date,
          p_event_number  => p_acctng_event_rec.event_number,
          p_event_status_code  => p_acctng_event_rec.event_status_code,
          p_event_type_code  => p_acctng_event_rec.event_type_code,
          px_org_id  => l_org_id,
          p_source_id  => p_acctng_event_rec.source_id,
          p_source_table  => p_acctng_event_rec.source_table,
          p_attribute_category  => p_acctng_event_rec.attribute_category,
          p_attribute1  => p_acctng_event_rec.attribute1,
          p_attribute2  => p_acctng_event_rec.attribute2,
          p_attribute3  => p_acctng_event_rec.attribute3,
          p_attribute4  => p_acctng_event_rec.attribute4,
          p_attribute5  => p_acctng_event_rec.attribute5,
          p_attribute6  => p_acctng_event_rec.attribute6,
          p_attribute7  => p_acctng_event_rec.attribute7,
          p_attribute8  => p_acctng_event_rec.attribute8,
          p_attribute9  => p_acctng_event_rec.attribute9,
          p_attribute10  => p_acctng_event_rec.attribute10,
          p_attribute11  => p_acctng_event_rec.attribute11,
          p_attribute12  => p_acctng_event_rec.attribute12,
          p_attribute13  => p_acctng_event_rec.attribute13,
          p_attribute14  => p_acctng_event_rec.attribute14,
          p_attribute15  => p_acctng_event_rec.attribute15);

Line: 235


PROCEDURE Update_Acctng_Events(
    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_acctng_event_rec               IN    acctng_event_rec_type,
    x_object_version_number      OUT NOCOPY  NUMBER
    )

 IS

CURSOR c_get_acctng_events(p_accounting_event_id NUMBER) IS
    SELECT *
    FROM   OZF_ACCTNG_EVENTS_ALL
    WHERE  accounting_event_id  = p_accounting_event_id;

Line: 256


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

Line: 267


      SAVEPOINT UPDATE_Acctng_Events_PVT;

Line: 295


         OZF_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 350


         OZF_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

Line: 354


      OZF_ACCTNG_EVENTS_PKG.Update_Row(
          p_accounting_event_id  => p_acctng_event_rec.accounting_event_id,
          p_object_version_number  => p_acctng_event_rec.object_version_number,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.CONC_LOGIN_ID,
          p_request_id  => p_acctng_event_rec.request_id,
          p_program_application_id  => p_acctng_event_rec.program_application_id,
          p_program_update_date  => p_acctng_event_rec.program_update_date,
          p_program_id  => p_acctng_event_rec.program_id,
          p_accounting_date  => p_acctng_event_rec.accounting_date,
          p_event_number  => p_acctng_event_rec.event_number,
          p_event_status_code  => p_acctng_event_rec.event_status_code,
          p_event_type_code  => p_acctng_event_rec.event_type_code,
          p_org_id  => p_acctng_event_rec.org_id,
          p_source_id  => p_acctng_event_rec.source_id,
          p_source_table  => p_acctng_event_rec.source_table,
          p_attribute_category  => p_acctng_event_rec.attribute_category,
          p_attribute1  => p_acctng_event_rec.attribute1,
          p_attribute2  => p_acctng_event_rec.attribute2,
          p_attribute3  => p_acctng_event_rec.attribute3,
          p_attribute4  => p_acctng_event_rec.attribute4,
          p_attribute5  => p_acctng_event_rec.attribute5,
          p_attribute6  => p_acctng_event_rec.attribute6,
          p_attribute7  => p_acctng_event_rec.attribute7,
          p_attribute8  => p_acctng_event_rec.attribute8,
          p_attribute9  => p_acctng_event_rec.attribute9,
          p_attribute10  => p_acctng_event_rec.attribute10,
          p_attribute11  => p_acctng_event_rec.attribute11,
          p_attribute12  => p_acctng_event_rec.attribute12,
          p_attribute13  => p_acctng_event_rec.attribute13,
          p_attribute14  => p_acctng_event_rec.attribute14,
          p_attribute15  => p_acctng_event_rec.attribute15);

Line: 415


     ROLLBACK TO UPDATE_Acctng_Events_PVT;

Line: 425


     ROLLBACK TO UPDATE_Acctng_Events_PVT;

Line: 435


     ROLLBACK TO UPDATE_Acctng_Events_PVT;

Line: 447


End Update_Acctng_Events;

Line: 450


PROCEDURE Delete_Acctng_Events(
    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_accounting_event_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Acctng_Events';

Line: 469


      SAVEPOINT DELETE_Acctng_Events_PVT;

Line: 500


         OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 504


      OZF_ACCTNG_EVENTS_PKG.Delete_Row(
          p_ACCOUNTING_EVENT_ID  => p_ACCOUNTING_EVENT_ID);

Line: 534


     ROLLBACK TO DELETE_Acctng_Events_PVT;

Line: 544


     ROLLBACK TO DELETE_Acctng_Events_PVT;

Line: 554


     ROLLBACK TO DELETE_Acctng_Events_PVT;

Line: 566


End Delete_Acctng_Events;

Line: 590


   SELECT ACCOUNTING_EVENT_ID
   FROM OZF_ACCTNG_EVENTS_ALL
   WHERE ACCOUNTING_EVENT_ID = p_ACCOUNTING_EVENT_ID
   AND object_version_number = p_object_version
   FOR UPDATE NOWAIT;

Line: 749


      IF p_acctng_event_rec.last_update_date = FND_API.g_miss_date OR p_acctng_event_rec.last_update_date IS NULL THEN
          OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 756


      IF p_acctng_event_rec.last_updated_by = FND_API.g_miss_num OR p_acctng_event_rec.last_updated_by IS NULL THEN
         OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 827


      IF p_acctng_event_rec.last_update_date IS NULL THEN
         OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_DATE' );

Line: 834


      IF p_acctng_event_rec.last_updated_by IS NULL THEN
         OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATED_BY' );

Line: 969


      SELECT *
      FROM ozf_acctng_events_all
      WHERE accounting_event_id = p_acctng_event_rec.accounting_event_id;

Line: 998


   IF p_acctng_event_rec.last_update_date = FND_API.g_miss_date THEN
      x_complete_rec.last_update_date := NULL;

Line: 1001


   IF p_acctng_event_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_acctng_event_rec.last_update_date;

Line: 1006


   IF p_acctng_event_rec.last_updated_by = FND_API.g_miss_num THEN
      x_complete_rec.last_updated_by := NULL;

Line: 1009


   IF p_acctng_event_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_acctng_event_rec.last_updated_by;

Line: 1030


   IF p_acctng_event_rec.last_update_login = FND_API.g_miss_num THEN
      x_complete_rec.last_update_login := NULL;

Line: 1033


   IF p_acctng_event_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_acctng_event_rec.last_update_login;

Line: 1054


   IF p_acctng_event_rec.program_update_date = FND_API.g_miss_date THEN
      x_complete_rec.program_update_date := NULL;

Line: 1057


   IF p_acctng_event_rec.program_update_date IS NULL THEN
      x_complete_rec.program_update_date := l_acctng_event_rec.program_update_date;

Line: 1292


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