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

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

Line: 43


    SELECT
            accounting_event_id,
            ORG_ID,
            EVENT_TYPE_CODE,
            ACCOUNTING_DATE,
            EVENT_NUMBER,
            EVENT_STATUS_CODE,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            PROGRAM_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Accounting_Events
     WHERE okl_accounting_events.accounting_event_id = p_accounting_event_id;

Line: 82


              l_aet_rec.PROGRAM_UPDATE_DATE,
              l_aet_rec.REQUEST_ID,
              l_aet_rec.CREATED_BY,
              l_aet_rec.CREATION_DATE,
              l_aet_rec.LAST_UPDATED_BY,
              l_aet_rec.LAST_UPDATE_DATE,
              l_aet_rec.LAST_UPDATE_LOGIN;

Line: 109


    SELECT
            accounting_event_id,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            EVENT_TYPE_CODE,
            ACCOUNTING_DATE,
            EVENT_NUMBER,
            EVENT_STATUS_CODE,
            SOURCE_ID,
            SOURCE_TABLE,
            PROGRAM_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM OKL_ACCOUNTING_EVENTS
     WHERE OKL_ACCOUNTING_EVENTS.accounting_event_id = p_accounting_event_id;

Line: 148


              l_aetv_rec.PROGRAM_UPDATE_DATE,
              l_aetv_rec.REQUEST_ID,
              l_aetv_rec.CREATED_BY,
              l_aetv_rec.CREATION_DATE,
              l_aetv_rec.LAST_UPDATED_BY,
              l_aetv_rec.LAST_UPDATE_DATE,
              l_aetv_rec.LAST_UPDATE_LOGIN;

Line: 206


    IF (l_aetv_rec.program_update_date = Okc_Api.G_MISS_DATE) THEN
      l_aetv_rec.program_update_date := NULL;

Line: 218


    IF (l_aetv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
      l_aetv_rec.last_updated_by := NULL;

Line: 221


    IF (l_aetv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
      l_aetv_rec.last_update_date := NULL;

Line: 224


    IF (l_aetv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
      l_aetv_rec.last_update_login := NULL;

Line: 889


    p_to.program_update_date := p_from.program_update_date;

Line: 893


    p_to.last_updated_by := p_from.last_updated_by;

Line: 894


    p_to.last_update_date := p_from.last_update_date;

Line: 895


    p_to.last_update_login := p_from.last_update_login;

Line: 913


    p_to.program_update_date := p_from.program_update_date;

Line: 917


    p_to.last_updated_by := p_from.last_updated_by;

Line: 918


    p_to.last_update_date := p_from.last_update_date;

Line: 919


    p_to.last_update_login := p_from.last_update_login;

Line: 1080


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aet_rec                      IN aet_rec_type,
    x_aet_rec                      OUT NOCOPY aet_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1089


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

Line: 1126


    INSERT INTO OKL_ACCOUNTING_EVENTS(
        accounting_event_id,
        org_id,
        event_type_code,
        accounting_date,
        event_number,
        event_status_code,
        source_id,
        source_table,
        object_version_number,
        program_id,
        program_application_id,
        program_update_date,
        request_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_aet_rec.accounting_event_id,
        l_aet_rec.org_id,
        l_aet_rec.event_type_code,
        l_aet_rec.accounting_date,
        l_aet_rec.event_number,
        l_aet_rec.event_status_code,
        l_aet_rec.source_id,
        l_aet_rec.source_table,
        l_aet_rec.object_version_number,
        l_aet_rec.program_id,
        l_aet_rec.program_application_id,
        l_aet_rec.program_update_date,
        l_aet_rec.request_id,
        l_aet_rec.created_by,
        l_aet_rec.creation_date,
        l_aet_rec.last_updated_by,
        l_aet_rec.last_update_date,
        l_aet_rec.last_update_login);

Line: 1198


  END insert_row;

Line: 1202


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aetv_rec                     IN aetv_rec_type,
    x_aetv_rec                     OUT NOCOPY aetv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1212


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

Line: 1228


      l_aetv_rec.LAST_UPDATE_DATE := l_aetv_rec.CREATION_DATE ;

Line: 1229


      l_aetv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1230


      l_aetv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1247


	  SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
	  		 DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
			 DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
			 DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
	    INTO  x_aetv_rec.REQUEST_ID
	  	     ,x_aetv_rec.PROGRAM_APPLICATION_ID
		     ,x_aetv_rec.PROGRAM_ID
		     ,x_aetv_rec.PROGRAM_UPDATE_DATE
		   FROM DUAL;

Line: 1307


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aet_rec,
      lx_aet_rec
    );

Line: 1356


  END insert_row;

Line: 1360


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aetv_tbl                     IN aetv_tbl_type,
    x_aetv_tbl                     OUT NOCOPY aetv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1370


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

Line: 1381


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_aetv_rec                     => p_aetv_tbl(i),
          x_aetv_rec                     => x_aetv_tbl(i));

Line: 1434


  END insert_row;

Line: 1452


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ACCOUNTING_EVENTS
     WHERE accounting_event_id = p_aet_rec.accounting_event_id
       AND OBJECT_VERSION_NUMBER = p_aet_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1459


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ACCOUNTING_EVENTS
    WHERE accounting_event_id = p_aet_rec.accounting_event_id;

Line: 1500


      Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1509


      Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1706


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aet_rec                      IN aet_rec_type,
    x_aet_rec                      OUT NOCOPY aet_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1715


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

Line: 1781


      IF (x_aet_rec.program_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_aet_rec.program_update_date := l_aet_rec.program_update_date;

Line: 1797


      IF (x_aet_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_aet_rec.last_updated_by := l_aet_rec.last_updated_by;

Line: 1801


      IF (x_aet_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_aet_rec.last_update_date := l_aet_rec.last_update_date;

Line: 1805


      IF (x_aet_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_aet_rec.last_update_login := l_aet_rec.last_update_login;

Line: 1849


    UPDATE  OKL_ACCOUNTING_EVENTS
    SET ORG_ID = l_def_aet_rec.org_id,
        EVENT_TYPE_CODE = l_def_aet_rec.event_type_code,
        ACCOUNTING_DATE = l_def_aet_rec.accounting_date,
        EVENT_NUMBER = l_def_aet_rec.event_number,
        EVENT_STATUS_CODE = l_def_aet_rec.event_status_code,
        SOURCE_ID = l_def_aet_rec.source_id,
        SOURCE_TABLE = l_def_aet_rec.source_table,
        OBJECT_VERSION_NUMBER = l_def_aet_rec.object_version_number,
        PROGRAM_ID = l_def_aet_rec.program_id,
        PROGRAM_APPLICATION_ID = l_def_aet_rec.program_application_id,
        PROGRAM_UPDATE_DATE = l_def_aet_rec.program_update_date,
        REQUEST_ID = l_def_aet_rec.request_id,
        CREATED_BY = l_def_aet_rec.created_by,
        CREATION_DATE = l_def_aet_rec.creation_date,
        LAST_UPDATED_BY = l_def_aet_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_aet_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_aet_rec.last_update_login
    WHERE accounting_event_id = l_def_aet_rec.accounting_event_id;

Line: 1902


  END update_row;

Line: 1906


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aetv_rec                     IN aetv_rec_type,
    x_aetv_rec                     OUT NOCOPY aetv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1916


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

Line: 1930


      l_aetv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1931


      l_aetv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;

Line: 1932


      l_aetv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1996


      IF (x_aetv_rec.program_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_aetv_rec.program_update_date := l_aetv_rec.program_update_date;

Line: 2012


      IF (x_aetv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_aetv_rec.last_updated_by := l_aetv_rec.last_updated_by;

Line: 2016


      IF (x_aetv_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_aetv_rec.last_update_date := l_aetv_rec.last_update_date;

Line: 2020


      IF (x_aetv_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_aetv_rec.last_update_login := l_aetv_rec.last_update_login;

Line: 2037


	  SELECT  NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID)
	  			 ,p_aetv_rec.REQUEST_ID)
			 ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
	  			 ,p_aetv_rec.PROGRAM_APPLICATION_ID)
			 ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)
	  		 	 ,p_aetv_rec.PROGRAM_ID)
			 ,DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
	  		 	 ,NULL,p_aetv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
		INTO x_aetv_rec.REQUEST_ID
			 ,x_aetv_rec.PROGRAM_APPLICATION_ID
			 ,x_aetv_rec.PROGRAM_ID
			 ,x_aetv_rec.PROGRAM_UPDATE_DATE
		  FROM DUAL;

Line: 2105


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aet_rec,
      lx_aet_rec
    );

Line: 2152


  END update_row;

Line: 2156


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aetv_tbl                     IN aetv_tbl_type,
    x_aetv_tbl                     OUT NOCOPY aetv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2166


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

Line: 2177


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_aetv_rec                     => p_aetv_tbl(i),
          x_aetv_rec                     => x_aetv_tbl(i));

Line: 2228


  END update_row;

Line: 2236


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aet_rec                      IN aet_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2244


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

Line: 2258


    DELETE FROM OKL_ACCOUNTING_EVENTS
     WHERE accounting_event_id = l_aet_rec.accounting_event_id;

Line: 2293


  END delete_row;

Line: 2297


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aetv_rec                     IN aetv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2306


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

Line: 2330


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_aet_rec
    );

Line: 2374


  END delete_row;

Line: 2378


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_aetv_tbl                     IN aetv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2387


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

Line: 2398


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_aetv_rec                     => p_aetv_tbl(i));

Line: 2449


  END delete_row;