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

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

Line: 45


   SELECT inventory_item_id
   FROM   mtl_system_items_b
   WHERE  decode(nvl(l_RQL_rec.SEGMENT1, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT1) = nvl(SEGMENT1, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT2, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT2) = nvl(SEGMENT2, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT3, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT3) = nvl(SEGMENT3, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT4, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT4) = nvl(SEGMENT4, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT5, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT5) = nvl(SEGMENT5, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT6, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT6) = nvl(SEGMENT6, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT7, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT7) = nvl(SEGMENT7, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT8, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT8) = nvl(SEGMENT8, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT9, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT9) = nvl(SEGMENT9, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT10, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT10) = nvl(SEGMENT10, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT11, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT11) = nvl(SEGMENT11, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT12, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT12) = nvl(SEGMENT12, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT13, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT13) = nvl(SEGMENT13, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT14, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT14) = nvl(SEGMENT14, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT15, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT15) = nvl(SEGMENT15, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT16, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT16) = nvl(SEGMENT16, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT17, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT17) = nvl(SEGMENT17, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT18, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT18) = nvl(SEGMENT18, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT19, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT19) = nvl(SEGMENT19, '####')
   AND decode(nvl(l_RQL_rec.SEGMENT20, FND_API.G_MISS_CHAR), FND_API.G_MISS_CHAR, '####', l_RQL_rec.SEGMENT20) = nvl(SEGMENT20, '####')
   AND organization_id = cs_std.get_item_valdn_orgzn_id;

Line: 116


    x_pvt_RQL_Tbl(I).LAST_UPDATED_BY := p_RQL_Tbl(I).LAST_UPDATED_BY;

Line: 117


    x_pvt_RQL_Tbl(I).LAST_UPDATE_DATE := p_RQL_Tbl(I).LAST_UPDATE_DATE;

Line: 118


    x_pvt_RQL_Tbl(I).LAST_UPDATE_LOGIN := p_RQL_Tbl(I).LAST_UPDATE_LOGIN;

Line: 170


        SELECT count(requirement_header_id)
        INTO l_count
        FROM csp_requirement_headers
        WHERE requirement_header_id = l_pvt_RQL_Tbl(I).requirement_header_id;

Line: 188


        SELECT count(inventory_item_id)
        INTO l_count
        FROM mtl_system_items_b
        WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id;

Line: 205


        SELECT count(organization_id)
        INTO l_count
        FROM mtl_parameters
        WHERE organization_id = l_pvt_RQL_Tbl(I).source_organization_id;

Line: 223


        SELECT count(uom_code)
        INTO l_count
        FROM mtl_item_uoms_view
        WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id
        AND organization_id =
              decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
        AND uom_code = l_pvt_RQL_Tbl(I).uom_code;

Line: 243


        SELECT count(revision)
        INTO l_count
        FROM mtl_item_revisions
        WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id
        AND organization_id =
            decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
        AND revision = l_pvt_RQL_Tbl(I).revision;

Line: 350


        x_requirement_line_tbl(I).LAST_UPDATED_BY := l_pvt_Rql_tbl(I).LAST_UPDATED_BY;

Line: 351


        x_requirement_line_tbl(I).LAST_UPDATE_DATE := l_pvt_Rql_tbl(I).LAST_UPDATE_DATE;

Line: 352


        x_requirement_line_tbl(I).LAST_UPDATE_LOGIN := l_pvt_Rql_tbl(I).LAST_UPDATE_LOGIN;

Line: 441


PROCEDURE Update_REQUIREMENT_LINES(
    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_RQL_Tbl                    IN   RQL_Tbl_Type := G_MISS_RQL_TBL,
    X_Return_Status              OUT NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT NOCOPY  NUMBER,
    X_Msg_Data                   OUT NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_REQUIREMENT_LINES';

Line: 458


      SAVEPOINT UPDATE_Packlist_Headers_PUB;

Line: 500


    CSP_REQUIREMENT_LINES_PVT.Update_REQUIREMENT_LINES(
        P_Api_Version_Number         => 1.0,
        P_Init_Msg_List              => FND_API.G_FALSE,
        P_Commit                     => p_commit,
        P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
        P_Requirement_Line_Tbl       =>  l_pvt_RQL_Tbl ,
        X_Return_Status              => x_return_status,
        X_Msg_Count                  => x_msg_count,
        X_Msg_Data                   => x_msg_data);

Line: 570


End Update_REQUIREMENT_LINES;

Line: 575


PROCEDURE Delete_REQUIREMENT_LINES(
    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_RQL_Tbl                    IN   RQL_Tbl_Type,
    X_Return_Status              OUT  NOCOPY  VARCHAR2,
    X_Msg_Count                  OUT  NOCOPY  NUMBER,
    X_Msg_Data                   OUT  NOCOPY  VARCHAR2
    )

 IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_REQUIREMENT_LINES';

Line: 594


      SAVEPOINT DELETE_REQUIREMENT_LINES_PUB;

Line: 636


        SELECT count(requirement_line_id)
        INTO l_count
        FROM csp_Req_line_details
        where requirement_line_id = P_RQL_Tbl(I).requirement_line_id;

Line: 642


          FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');

Line: 653


    CSP_REQUIREMENT_LINES_PVT.Delete_REQUIREMENT_LINES(
    P_Api_Version_Number         => 1.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => FND_API.G_VALID_LEVEL_FULL,
    P_Requirement_Line_Tbl       => l_pvt_RQL_Tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 723


End Delete_REQUIREMENT_LINES;