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_TAB_PVT SQL Statements

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

Line: 12


    SELECT OKL_TRNS_ACC_DSTRS_ALL_S.NEXTVAL INTO l_seq FROM DUAL;

Line: 48


    SELECT
            ID,
            CURRENCY_CONVERSION_TYPE,
            SET_OF_BOOKS_ID,
            CR_DR_FLAG,
            CODE_COMBINATION_ID,
            ORG_ID,
            CURRENCY_CODE,
            AE_LINE_TYPE,
            TEMPLATE_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            AMOUNT,
            ACCOUNTED_AMOUNT,
            GL_DATE,
            PERCENTAGE,
            COMMENTS,
            POST_REQUEST_ID,
            CURRENCY_CONVERSION_DATE,
            CURRENCY_CONVERSION_RATE,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            AET_ID,
            POSTED_YN,
            AE_CREATION_ERROR,
            GL_REVERSAL_FLAG,
            REVERSE_EVENT_FLAG,
            DRAFT_YN,
            DRAFT_VERSION,
            ORIGINAL_DIST_ID,
            ACCOUNTING_EVENT_ID,
            POST_TO_GL,
-- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
            ACCOUNTING_TEMPLATE_NAME,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
            UPGRADE_STATUS_FLAG
-- Changes End
      FROM Okl_Trns_Acc_Dstrs
     WHERE okl_trns_acc_dstrs.id = p_id;

Line: 141


              l_tab_rec.PROGRAM_UPDATE_DATE,
              l_tab_rec.ATTRIBUTE_CATEGORY,
              l_tab_rec.ATTRIBUTE1,
              l_tab_rec.ATTRIBUTE2,
              l_tab_rec.ATTRIBUTE3,
              l_tab_rec.ATTRIBUTE4,
              l_tab_rec.ATTRIBUTE5,
              l_tab_rec.ATTRIBUTE6,
              l_tab_rec.ATTRIBUTE7,
              l_tab_rec.ATTRIBUTE8,
              l_tab_rec.ATTRIBUTE9,
              l_tab_rec.ATTRIBUTE10,
              l_tab_rec.ATTRIBUTE11,
              l_tab_rec.ATTRIBUTE12,
              l_tab_rec.ATTRIBUTE13,
              l_tab_rec.ATTRIBUTE14,
              l_tab_rec.ATTRIBUTE15,
              l_tab_rec.CREATED_BY,
              l_tab_rec.CREATION_DATE,
              l_tab_rec.LAST_UPDATED_BY,
              l_tab_rec.LAST_UPDATE_DATE,
              l_tab_rec.LAST_UPDATE_LOGIN,
-- The following two fields have been added by Kanti Jinger on 07/12/2001
              l_tab_rec.AET_ID,
              l_tab_rec.POSTED_YN,
              l_tab_rec.AE_CREATION_ERROR,
              l_tab_rec.GL_REVERSAL_FLAG,
              l_tab_rec.REVERSE_EVENT_FLAG,
              l_tab_rec.DRAFT_YN,
              l_tab_rec.DRAFT_VERSION,
              l_tab_rec.ORIGINAL_DIST_ID,
              l_tab_rec.ACCOUNTING_EVENT_ID,
              l_tab_rec.POST_TO_GL,
-- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
              l_tab_rec.ACCOUNTING_TEMPLATE_NAME,
-- Changes ends
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
              l_tab_rec.UPGRADE_STATUS_FLAG;

Line: 202


    SELECT
            ID,
            CURRENCY_CONVERSION_TYPE,
            SET_OF_BOOKS_ID,
            CR_DR_FLAG,
            CODE_COMBINATION_ID,
            ORG_ID,
            CURRENCY_CODE,
            AE_LINE_TYPE,
            TEMPLATE_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            AMOUNT,
            ACCOUNTED_AMOUNT,
            GL_DATE,
            PERCENTAGE,
            COMMENTS,
            POST_REQUEST_ID,
            CURRENCY_CONVERSION_DATE,
            CURRENCY_CONVERSION_RATE,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            AET_ID,
            POSTED_YN,
            AE_CREATION_ERROR,
            GL_REVERSAL_FLAG,
            REVERSE_EVENT_FLAG,
            DRAFT_YN,
            DRAFT_VERSION,
            ORIGINAL_DIST_ID,
            ACCOUNTING_EVENT_ID,
            POST_TO_GL,
-- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
            ACCOUNTING_TEMPLATE_NAME,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
            UPGRADE_STATUS_FLAG
      FROM OKL_TRNS_ACC_DSTRS
     WHERE OKL_TRNS_ACC_DSTRS.id = p_id;

Line: 293


              l_tabv_rec.PROGRAM_UPDATE_DATE,
              l_tabv_rec.ATTRIBUTE_CATEGORY,
              l_tabv_rec.ATTRIBUTE1,
              l_tabv_rec.ATTRIBUTE2,
              l_tabv_rec.ATTRIBUTE3,
              l_tabv_rec.ATTRIBUTE4,
              l_tabv_rec.ATTRIBUTE5,
              l_tabv_rec.ATTRIBUTE6,
              l_tabv_rec.ATTRIBUTE7,
              l_tabv_rec.ATTRIBUTE8,
              l_tabv_rec.ATTRIBUTE9,
              l_tabv_rec.ATTRIBUTE10,
              l_tabv_rec.ATTRIBUTE11,
              l_tabv_rec.ATTRIBUTE12,
              l_tabv_rec.ATTRIBUTE13,
              l_tabv_rec.ATTRIBUTE14,
              l_tabv_rec.ATTRIBUTE15,
              l_tabv_rec.CREATED_BY,
              l_tabv_rec.CREATION_DATE,
              l_tabv_rec.LAST_UPDATED_BY,
              l_tabv_rec.LAST_UPDATE_DATE,
              l_tabv_rec.LAST_UPDATE_LOGIN,
              l_tabv_rec.AET_ID,
              l_tabv_rec.POSTED_YN,
              l_tabv_rec.AE_CREATION_ERROR,
              l_tabv_rec.GL_REVERSAL_FLAG,
              l_tabv_rec.REVERSE_EVENT_FLAG,
              l_tabv_rec.DRAFT_YN,
              l_tabv_rec.DRAFT_VERSION,
              l_tabv_rec.ORIGINAL_DIST_ID,
              l_tabv_rec.ACCOUNTING_EVENT_ID,
              l_tabv_rec.POST_TO_GL,
-- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
              l_tabv_rec.ACCOUNTING_TEMPLATE_NAME,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
              l_tabv_rec.UPGRADE_STATUS_FLAG;

Line: 477


    IF (l_tabv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
      l_tabv_rec.program_update_date := NULL;

Line: 486


    IF (l_tabv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_tabv_rec.last_updated_by := NULL;

Line: 489


    IF (l_tabv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_tabv_rec.last_update_date := NULL;

Line: 492


    IF (l_tabv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_tabv_rec.last_update_login := NULL;

Line: 1037


	  SELECT '1'
	  FROM OKL_AE_TEMPLATES
	  WHERE id = v_template_id;

Line: 1162


  SELECT '1'
  FROM OKL_ACCOUNTING_EVENTS
  WHERE accounting_event_id  = v_id;

Line: 1792


    p_to.program_update_date := p_from.program_update_date;

Line: 1811


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1812


    p_to.last_update_date := p_from.last_update_date;

Line: 1813


    p_to.last_update_login := p_from.last_update_login;

Line: 1859


    p_to.program_update_date := p_from.program_update_date;

Line: 1878


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1879


    p_to.last_update_date := p_from.last_update_date;

Line: 1880


    p_to.last_update_login := p_from.last_update_login;

Line: 2059


  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_tab_rec                      IN tab_rec_type,
    x_tab_rec                      OUT NOCOPY tab_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2068


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

Line: 2104


    INSERT INTO OKL_TRNS_ACC_DSTRS(
        id,
        currency_conversion_type,
        set_of_books_id,
        cr_dr_flag,
        code_combination_id,
        org_id,
        currency_code,
        ae_line_type,
        template_id,
        source_id,
        source_table,
        object_version_number,
        amount,
        accounted_amount,
        gl_date,
        percentage,
        comments,
        post_request_id,
        currency_conversion_date,
        currency_conversion_rate,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
-- The following two fields have been added by Kanti Jinger on 07/12/2001
        aet_id,
        posted_yn,
        ae_creation_error,
        gl_reversal_flag,
        reverse_Event_flag,
        draft_yn,
        draft_version,
        original_dist_id,
        accounting_event_id,
        post_to_gl,
-- Changes ends
-- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
        accounting_template_name,
-- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
        UPGRADE_STATUS_FLAG)

      VALUES (
        l_tab_rec.id,
        l_tab_rec.currency_conversion_type,
        l_tab_rec.set_of_books_id,
        l_tab_rec.cr_dr_flag,
        l_tab_rec.code_combination_id,
        l_tab_rec.org_id,
        l_tab_rec.currency_code,
        l_tab_rec.ae_line_type,
        l_tab_rec.template_id,
        l_tab_rec.source_id,
        l_tab_rec.source_table,
        l_tab_rec.object_version_number,
        l_tab_rec.amount,
        l_tab_rec.accounted_amount,
        l_tab_rec.gl_date,
        l_tab_rec.percentage,
        l_tab_rec.comments,
        l_tab_rec.post_request_id,
        l_tab_rec.currency_conversion_date,
        l_tab_rec.currency_conversion_rate,
        l_tab_rec.request_id,
        l_tab_rec.program_application_id,
        l_tab_rec.program_id,
        l_tab_rec.program_update_date,
        l_tab_rec.attribute_category,
        l_tab_rec.attribute1,
        l_tab_rec.attribute2,
        l_tab_rec.attribute3,
        l_tab_rec.attribute4,
        l_tab_rec.attribute5,
        l_tab_rec.attribute6,
        l_tab_rec.attribute7,
        l_tab_rec.attribute8,
        l_tab_rec.attribute9,
        l_tab_rec.attribute10,
        l_tab_rec.attribute11,
        l_tab_rec.attribute12,
        l_tab_rec.attribute13,
        l_tab_rec.attribute14,
        l_tab_rec.attribute15,
        l_tab_rec.created_by,
        l_tab_rec.creation_date,
        l_tab_rec.last_updated_by,
        l_tab_rec.last_update_date,
        l_tab_rec.last_update_login,
-- The following two fields have been added by Kanti Jinger on 07/12/2001
        l_tab_rec.aet_id,
        l_tab_rec.posted_yn,
        l_tab_rec.ae_creation_error,
        l_tab_rec.gl_reversal_flag,
        l_tab_rec.reverse_Event_flag,
        l_tab_rec.draft_yn,
        l_tab_rec.draft_version,
        l_tab_rec.original_dist_id,
        l_tab_rec.accounting_event_id,
        l_tab_rec.post_to_gl,
-- Changes ends
-- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
	l_tab_rec.accounting_template_name,
-- Added by nikshah for SLA project (Bug 5707866) 13-Apr-2007
        l_tab_rec.UPGRADE_STATUS_FLAG);

Line: 2264


  END insert_row;

Line: 2268


  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_tabv_rec                     IN tabv_rec_type,
    x_tabv_rec                     OUT NOCOPY tabv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2278


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

Line: 2294


      l_tabv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2295


      l_tabv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2296


      l_tabv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2323


      SELECT DECODE(l_request_id, -1, NULL, l_request_id),
      DECODE(l_prog_app_id, -1, NULL, l_prog_app_id),
      DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
      DECODE(l_request_id, -1, NULL, SYSDATE)
     INTO  x_tabv_rec.REQUEST_ID
          ,x_tabv_rec.PROGRAM_APPLICATION_ID
          ,x_tabv_rec.PROGRAM_ID
          ,x_tabv_rec.PROGRAM_UPDATE_DATE
     FROM DUAL;

Line: 2402


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tab_rec,
      lx_tab_rec
    );

Line: 2450


  END insert_row;

Line: 2454


  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_tabv_tbl                     IN tabv_tbl_type,
    x_tabv_tbl                     OUT NOCOPY tabv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2464


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

Line: 2474


        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_tabv_rec                     => p_tabv_tbl(i),
          x_tabv_rec                     => x_tabv_tbl(i));

Line: 2525


  END insert_row;

Line: 2543


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRNS_ACC_DSTRS
     WHERE ID = p_tab_rec.id
       AND OBJECT_VERSION_NUMBER = p_tab_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2550


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRNS_ACC_DSTRS
    WHERE ID = p_tab_rec.id;

Line: 2591


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2600


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2794


  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_tab_rec                      IN tab_rec_type,
    x_tab_rec                      OUT NOCOPY tab_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2803


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

Line: 2920


      IF (x_tab_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_tab_rec.program_update_date := l_tab_rec.program_update_date;

Line: 2999


      IF (x_tab_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_tab_rec.last_updated_by := l_tab_rec.last_updated_by;

Line: 3003


      IF (x_tab_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_tab_rec.last_update_date := l_tab_rec.last_update_date;

Line: 3007


      IF (x_tab_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_tab_rec.last_update_login := l_tab_rec.last_update_login;

Line: 3103


    UPDATE  OKL_TRNS_ACC_DSTRS
    SET CURRENCY_CONVERSION_TYPE = l_def_tab_rec.currency_conversion_type,
        SET_OF_BOOKS_ID = l_def_tab_rec.set_of_books_id,
        CR_DR_FLAG = l_def_tab_rec.cr_dr_flag,
        CODE_COMBINATION_ID = l_def_tab_rec.code_combination_id,
        ORG_ID = l_def_tab_rec.org_id,
        CURRENCY_CODE = l_def_tab_rec.currency_code,
        AE_LINE_TYPE = l_def_tab_rec.ae_line_type,
        TEMPLATE_ID = l_def_tab_rec.template_id,
        SOURCE_ID = l_def_tab_rec.source_id,
        SOURCE_TABLE = l_def_tab_rec.source_table,
        OBJECT_VERSION_NUMBER = l_def_tab_rec.object_version_number,
        AMOUNT = l_def_tab_rec.amount,
        ACCOUNTED_AMOUNT = l_def_tab_rec.accounted_amount,
        GL_DATE = l_def_tab_rec.gl_date,
        PERCENTAGE = l_def_tab_rec.percentage,
        COMMENTS = l_def_tab_rec.comments,
        POST_REQUEST_ID = l_def_tab_rec.post_request_id,
        CURRENCY_CONVERSION_DATE = l_def_tab_rec.currency_conversion_date,
        CURRENCY_CONVERSION_RATE = l_def_tab_rec.currency_conversion_rate,
        REQUEST_ID = l_def_tab_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_tab_rec.program_application_id,
        PROGRAM_ID = l_def_tab_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_tab_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_tab_rec.attribute_category,
        ATTRIBUTE1 = l_def_tab_rec.attribute1,
        ATTRIBUTE2 = l_def_tab_rec.attribute2,
        ATTRIBUTE3 = l_def_tab_rec.attribute3,
        ATTRIBUTE4 = l_def_tab_rec.attribute4,
        ATTRIBUTE5 = l_def_tab_rec.attribute5,
        ATTRIBUTE6 = l_def_tab_rec.attribute6,
        ATTRIBUTE7 = l_def_tab_rec.attribute7,
        ATTRIBUTE8 = l_def_tab_rec.attribute8,
        ATTRIBUTE9 = l_def_tab_rec.attribute9,
        ATTRIBUTE10 = l_def_tab_rec.attribute10,
        ATTRIBUTE11 = l_def_tab_rec.attribute11,
        ATTRIBUTE12 = l_def_tab_rec.attribute12,
        ATTRIBUTE13 = l_def_tab_rec.attribute13,
        ATTRIBUTE14 = l_def_tab_rec.attribute14,
        ATTRIBUTE15 = l_def_tab_rec.attribute15,
        CREATED_BY = l_def_tab_rec.created_by,
        CREATION_DATE = l_def_tab_rec.creation_date,
        LAST_UPDATED_BY = l_def_tab_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tab_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tab_rec.last_update_login,
-- The following two fields have been added by Kanti Jinger on 07/12/2001
        aet_id = l_def_tab_rec.aet_id ,
        POSTED_YN = l_def_tab_rec.posted_yn,
        AE_CREATION_ERROR = l_def_tab_rec.AE_CREATION_ERROR,
        GL_REVERSAL_FLAG = l_def_tab_rec.GL_REVERSAL_FLAG,
        Reverse_event_flag = l_def_tab_rec.Reverse_event_flag,
        draft_yn = l_def_tab_rec.draft_yn,
        draft_version = l_def_tab_rec.draft_version,
        original_dist_id = l_def_tab_rec.original_dist_id,
        accounting_event_id = l_def_tab_rec.accounting_event_id,
        POST_TO_GL = l_def_tab_rec.POST_TO_GL,
-- Changes ends
-- Added by zrehman for SLA project (Bug 5707866) 9-Feb-2007
        ACCOUNTING_TEMPLATE_NAME = l_def_tab_rec.ACCOUNTING_TEMPLATE_NAME,
-- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
        UPGRADE_STATUS_FLAG = l_def_tab_rec.UPGRADE_STATUS_FLAG
    WHERE ID = l_def_tab_rec.id;

Line: 3199


  END update_row;

Line: 3203


  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_tabv_rec                     IN tabv_rec_type,
    x_tabv_rec                     OUT NOCOPY tabv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3213


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

Line: 3227


      l_tabv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3228


      l_tabv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3229


      l_tabv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3411


      IF (x_tabv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_tabv_rec.program_update_date := l_tabv_rec.program_update_date;

Line: 3423


      IF (x_tabv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_tabv_rec.last_updated_by := l_tabv_rec.last_updated_by;

Line: 3427


      IF (x_tabv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_tabv_rec.last_update_date := l_tabv_rec.last_update_date;

Line: 3431


      IF (x_tabv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_tabv_rec.last_update_login := l_tabv_rec.last_update_login;

Line: 3509


	 SELECT  NVL(DECODE(l_request_id, -1, NULL, l_request_id) ,p_tabv_rec.REQUEST_ID)
    ,NVL(DECODE(l_prog_app_id, -1, NULL, l_prog_app_id) ,p_tabv_rec.PROGRAM_APPLICATION_ID)
    ,NVL(DECODE(l_program_id, -1, NULL, l_program_id)  ,p_tabv_rec.PROGRAM_ID)
    ,DECODE(DECODE(l_request_id, -1, NULL, SYSDATE) ,NULL, p_tabv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
  	INTO x_tabv_rec.REQUEST_ID
    ,x_tabv_rec.PROGRAM_APPLICATION_ID
    ,x_tabv_rec.PROGRAM_ID
    ,x_tabv_rec.PROGRAM_UPDATE_DATE
    FROM DUAL;

Line: 3575


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_tab_rec,
      lx_tab_rec
    );

Line: 3622


  END update_row;

Line: 3626


  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_tabv_tbl                     IN tabv_tbl_type,
    x_tabv_tbl                     OUT NOCOPY tabv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3636


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

Line: 3646


        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_tabv_rec                     => p_tabv_tbl(i),
          x_tabv_rec                     => x_tabv_tbl(i));

Line: 3698


  END update_row;

Line: 3706


  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_tab_rec                      IN tab_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3714


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

Line: 3728


    DELETE FROM OKL_TRNS_ACC_DSTRS
     WHERE ID = l_tab_rec.id;

Line: 3763


  END delete_row;

Line: 3767


  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_tabv_rec                     IN tabv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3776


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

Line: 3800


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

Line: 3844


  END delete_row;

Line: 3848


  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_tabv_tbl                     IN tabv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3857


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

Line: 3867


        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_tabv_rec                     => p_tabv_tbl(i));

Line: 3915


  END delete_row;