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

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

Line: 94


    SELECT
            DC_LINE_ID,
            CI_ID,
            PROJECT_ID,
            TASK_ID,
            EXPENDITURE_TYPE,
            RESOURCE_LIST_MEMBER_ID,
            UNIT_OF_MEASURE,
            CURRENCY_CODE,
            QUANTITY,
            PLANNING_RESOURCE_RATE,
            RAW_COST,
            BURDENED_COST,
            RAW_COST_RATE,
            BURDEN_COST_RATE,
            RESOURCE_ASSIGNMENT_ID,
            EFFECTIVE_FROM,
            EFFECTIVE_TO,
            CHANGE_REASON_CODE,
            CHANGE_DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATE_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Pa_Ci_Direct_Cost_Details
     WHERE pa_ci_direct_cost_details.dc_line_id = p_dc_line_id;

Line: 150


              l_pa_ci_direct_cost8.last_update_by,
              l_pa_ci_direct_cost8.last_update_date,
              l_pa_ci_direct_cost8.last_update_login;

Line: 259


    IF (l_pa_ci_direct_cost8.last_update_by = PA_API.G_MISS_NUM ) THEN
      l_pa_ci_direct_cost8.last_update_by := NULL;

Line: 262


    IF (l_pa_ci_direct_cost8.last_update_date = PA_API.G_MISS_DATE ) THEN
      l_pa_ci_direct_cost8.last_update_date := NULL;

Line: 265


    IF (l_pa_ci_direct_cost8.last_update_login = PA_API.G_MISS_NUM ) THEN
      l_pa_ci_direct_cost8.last_update_login := NULL;

Line: 435


  PROCEDURE validate_last_update_by(
    x_return_status                OUT NOCOPY VARCHAR2,
    p_last_update_by               IN NUMBER) IS
  BEGIN
    x_return_status := PA_API.G_RET_STS_SUCCESS;

Line: 440


    IF (p_last_update_by = PA_API.G_MISS_NUM OR
        p_last_update_by IS NULL)
    THEN
      PA_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'last_update_by');

Line: 458


  END validate_last_update_by;

Line: 531


    validate_last_update_by(x_return_status, p_pa_ci_direct_cost1.last_update_by);

Line: 605


    p_to.last_update_by := p_from.last_update_by;

Line: 606


    p_to.last_update_date := p_from.last_update_date;

Line: 607


    p_to.last_update_login := p_from.last_update_login;

Line: 877


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pa_ci_direct_cost1           IN PaCiDirectCostDetailsRecType,
    XPaCiDirectCostDetailsRec      OUT NOCOPY PaCiDirectCostDetailsRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 887


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

Line: 923


    INSERT INTO PA_CI_DIRECT_COST_DETAILS(
      dc_line_id,
      ci_id,
      project_id,
      task_id,
      expenditure_type,
      resource_list_member_id,
      unit_of_measure,
      currency_code,
      quantity,
      planning_resource_rate,
      raw_cost,
      burdened_cost,
      raw_cost_rate,
      burden_cost_rate,
      resource_assignment_id,
      effective_from,
      effective_to,
      change_reason_code,
      change_description,
      created_by,
      creation_date,
      last_update_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_pa_ci_direct_cost8.dc_line_id,
      l_pa_ci_direct_cost8.ci_id,
      l_pa_ci_direct_cost8.project_id,
      l_pa_ci_direct_cost8.task_id,
      l_pa_ci_direct_cost8.expenditure_type,
      l_pa_ci_direct_cost8.resource_list_member_id,
      l_pa_ci_direct_cost8.unit_of_measure,
      l_pa_ci_direct_cost8.currency_code,
      l_pa_ci_direct_cost8.quantity,
      l_pa_ci_direct_cost8.planning_resource_rate,
      l_pa_ci_direct_cost8.raw_cost,
      l_pa_ci_direct_cost8.burdened_cost,
      l_pa_ci_direct_cost8.raw_cost_rate,
      l_pa_ci_direct_cost8.burden_cost_rate,
      l_pa_ci_direct_cost8.resource_assignment_id,
      l_pa_ci_direct_cost8.effective_from,
      l_pa_ci_direct_cost8.effective_to,
      l_pa_ci_direct_cost8.change_reason_code,
      l_pa_ci_direct_cost8.change_description,
      l_pa_ci_direct_cost8.created_by,
      l_pa_ci_direct_cost8.creation_date,
      l_pa_ci_direct_cost8.last_update_by,
      l_pa_ci_direct_cost8.last_update_date,
      l_pa_ci_direct_cost8.last_update_login);

Line: 1008


  END insert_row;

Line: 1016


    PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    PPaCiDirectCostDetailsTbl      IN PaCiDirectCostDetailsTblType,
    XPaCiDirectCostDetailsTbl      OUT NOCOPY PaCiDirectCostDetailsTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1026


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

Line: 1042


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => PA_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_pa_ci_direct_cost1           => PPaCiDirectCostDetailsTbl(i),
          XPaCiDirectCostDetailsRec      => XPaCiDirectCostDetailsTbl(i));

Line: 1093


  END insert_row;

Line: 1111


    SELECT *
      FROM PA_CI_DIRECT_COST_DETAILS
     WHERE DC_LINE_ID = p_pa_ci_direct_cost1.dc_line_id
    FOR UPDATE NOWAIT;

Line: 1147


      PA_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1456


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pa_ci_direct_cost1           IN PaCiDirectCostDetailsRecType,
    XPaCiDirectCostDetailsRec      OUT NOCOPY PaCiDirectCostDetailsRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1465


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

Line: 1569


        IF (XPaCiDirectCostDetailsRec.last_update_by = PA_API.G_MISS_NUM)
        THEN
          XPaCiDirectCostDetailsRec.last_update_by := l_pa_ci_direct_cost8.last_update_by;

Line: 1573


        IF (XPaCiDirectCostDetailsRec.last_update_date = PA_API.G_MISS_DATE)
        THEN
          XPaCiDirectCostDetailsRec.last_update_date := l_pa_ci_direct_cost8.last_update_date;

Line: 1577


        IF (XPaCiDirectCostDetailsRec.last_update_login = PA_API.G_MISS_NUM)
        THEN
          XPaCiDirectCostDetailsRec.last_update_login := l_pa_ci_direct_cost8.last_update_login;

Line: 1624


    UPDATE PA_CI_DIRECT_COST_DETAILS
    SET CI_ID = LDefPaCiDirectCostDetailsRec.ci_id,
        PROJECT_ID = LDefPaCiDirectCostDetailsRec.project_id,
        TASK_ID = LDefPaCiDirectCostDetailsRec.task_id,
        EXPENDITURE_TYPE = LDefPaCiDirectCostDetailsRec.expenditure_type,
        RESOURCE_LIST_MEMBER_ID = LDefPaCiDirectCostDetailsRec.resource_list_member_id,
        UNIT_OF_MEASURE = LDefPaCiDirectCostDetailsRec.unit_of_measure,
        CURRENCY_CODE = LDefPaCiDirectCostDetailsRec.currency_code,
        QUANTITY = LDefPaCiDirectCostDetailsRec.quantity,
        PLANNING_RESOURCE_RATE = LDefPaCiDirectCostDetailsRec.planning_resource_rate,
        RAW_COST = LDefPaCiDirectCostDetailsRec.raw_cost,
        BURDENED_COST = LDefPaCiDirectCostDetailsRec.burdened_cost,
        RAW_COST_RATE = LDefPaCiDirectCostDetailsRec.raw_cost_rate,
        BURDEN_COST_RATE = LDefPaCiDirectCostDetailsRec.burden_cost_rate,
        RESOURCE_ASSIGNMENT_ID = LDefPaCiDirectCostDetailsRec.resource_assignment_id,
        EFFECTIVE_FROM = LDefPaCiDirectCostDetailsRec.effective_from,
        EFFECTIVE_TO = LDefPaCiDirectCostDetailsRec.effective_to,
        CHANGE_REASON_CODE = LDefPaCiDirectCostDetailsRec.change_reason_code,
        CHANGE_DESCRIPTION = LDefPaCiDirectCostDetailsRec.change_description,
        CREATED_BY = LDefPaCiDirectCostDetailsRec.created_by,
        CREATION_DATE = LDefPaCiDirectCostDetailsRec.creation_date,
        LAST_UPDATE_BY = LDefPaCiDirectCostDetailsRec.last_update_by,
        LAST_UPDATE_DATE = LDefPaCiDirectCostDetailsRec.last_update_date,
        LAST_UPDATE_LOGIN = LDefPaCiDirectCostDetailsRec.last_update_login
    WHERE DC_LINE_ID = LDefPaCiDirectCostDetailsRec.dc_line_id;

Line: 1684


  END update_row;

Line: 1689


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pa_ci_direct_cost1           IN PaCiDirectCostDetailsRecType,
    XPaCiDirectCostDetailsRec      OUT NOCOPY PaCiDirectCostDetailsRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1699


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

Line: 1715


      l_pa_ci_direct_cost8.LAST_UPDATE_DATE := SYSDATE;

Line: 1716


      l_pa_ci_direct_cost8.LAST_UPDATE_BY := FND_GLOBAL.USER_ID;

Line: 1717


      l_pa_ci_direct_cost8.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1820


        IF (XPaCiDirectCostDetailsRec.last_update_by = PA_API.G_MISS_NUM)
        THEN
          XPaCiDirectCostDetailsRec.last_update_by := l_db_pa_ci_direct_cos106.last_update_by;

Line: 1824


        IF (XPaCiDirectCostDetailsRec.last_update_date = PA_API.G_MISS_DATE)
        THEN
          XPaCiDirectCostDetailsRec.last_update_date := l_db_pa_ci_direct_cos106.last_update_date;

Line: 1828


        IF (XPaCiDirectCostDetailsRec.last_update_login = PA_API.G_MISS_NUM)
        THEN
          XPaCiDirectCostDetailsRec.last_update_login := l_db_pa_ci_direct_cos106.last_update_login;

Line: 1919


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pa_ci_direct_cost8,
      LxPaCiDirectCostDetailsRec
    );

Line: 1967


  END update_row;

Line: 1971


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    PPaCiDirectCostDetailsTbl      IN PaCiDirectCostDetailsTblType,
    XPaCiDirectCostDetailsTbl      OUT NOCOPY PaCiDirectCostDetailsTblType,
    px_error_tbl                   IN OUT NOCOPY PA_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1982


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

Line: 1996


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => PA_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_pa_ci_direct_cost1           => PPaCiDirectCostDetailsTbl(i),
            XPaCiDirectCostDetailsRec      => XPaCiDirectCostDetailsTbl(i));

Line: 2064


  END update_row;

Line: 2069


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    PPaCiDirectCostDetailsTbl      IN PaCiDirectCostDetailsTblType,
    XPaCiDirectCostDetailsTbl      OUT NOCOPY PaCiDirectCostDetailsTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2079


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

Line: 2086


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => PA_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        PPaCiDirectCostDetailsTbl      => PPaCiDirectCostDetailsTbl,
        XPaCiDirectCostDetailsTbl      => XPaCiDirectCostDetailsTbl,
        px_error_tbl                   => l_error_tbl);

Line: 2128


  END update_row;

Line: 2136


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pa_ci_direct_cost1           IN PaCiDirectCostDetailsRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2144


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

Line: 2159


    DELETE FROM PA_CI_DIRECT_COST_DETAILS
     WHERE DC_LINE_ID = p_pa_ci_direct_cost1.dc_line_id;

Line: 2195


  END delete_row;

Line: 2199


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pa_ci_direct_cost1           IN PaCiDirectCostDetailsRecType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2208


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

Line: 2231


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pa_ci_direct_cost8
    );

Line: 2276


  END delete_row;

Line: 2280


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    PPaCiDirectCostDetailsTbl      IN PaCiDirectCostDetailsTblType,
    px_error_tbl                   IN OUT NOCOPY PA_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2290


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

Line: 2304


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => PA_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_pa_ci_direct_cost1           => PPaCiDirectCostDetailsTbl(i));

Line: 2371


  END delete_row;

Line: 2376


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT PA_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    PPaCiDirectCostDetailsTbl      IN PaCiDirectCostDetailsTblType) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2385


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

Line: 2392


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => PA_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        PPaCiDirectCostDetailsTbl      => PPaCiDirectCostDetailsTbl,
        px_error_tbl                   => l_error_tbl);

Line: 2433


  END delete_row;