APPS.CSP_REQUIREMENT_HEADERS_PUB SQL Statements

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

Line: 41

          SELECT task_id
          FROM   jtf_Tasks_b
          WHERE  task_number = x_Task_Number;

Line: 78

    x_pvt_RQH_rec.LAST_UPDATED_BY := P_RQH_Rec.LAST_UPDATED_BY;

Line: 79

    x_pvt_RQH_rec.LAST_UPDATE_DATE := P_RQH_Rec.LAST_UPDATE_DATE;

Line: 80

    x_pvt_RQH_rec.LAST_UPDATE_LOGIN := P_RQH_Rec.LAST_UPDATE_LOGIN;

Line: 134

      SELECT count(location_id)
      INTO l_count
      FROM hr_locations
      WHERE location_id = l_pvt_RQH_Rec.ship_to_location_id;

Line: 151

      SELECT count(task_id)
      INTO l_count
      FROM jtf_Tasks_b
      WHERE task_id = l_pvt_RQH_Rec.task_id;

Line: 169

      SELECT count(task_assignment_id)
      INTO l_count
      FROM jtf_Task_assignments
      WHERE task_assignment_id = l_pvt_RQH_Rec.task_assignment_id;

Line: 187

      SELECT count(jov.object_code)
      INTO l_count
      FROM   jtf_objects_vl jov,
             jtf_object_usages jou
      WHERE trunc(sysdate) between trunc(nvl(jov.start_date_active,sysdate))
               and trunc(nvl(jov.end_date_active,sysdate))
      AND  jou.object_code = jov.object_code
      AND  jou.object_user_code = 'RESOURCES'
      AND  jov.object_code = l_pvt_RQH_rec.resource_type;

Line: 209

      SELECT count(resource_id)
      INTO l_count
      FROM jtf_rs_resource_extns
      WHERE resource_id = l_pvt_RQH_rec.resource_id
      AND ( end_date_active is null OR
		    trunc(end_date_active) >= trunc(sysdate));

Line: 229

      SELECT count(organization_id)
      INTO l_count
      FROM mtl_parameters
      WHERE organization_id = l_pvt_RQH_rec.destination_organization_id;

Line: 247

      SELECT count(secondary_inventory_name)
      INTO l_count
      FROM mtl_secondary_inventories
      WHERE organization_id = nvl(l_pvt_RQH_rec.destination_organization_id, organization_id)
      AND secondary_inventory_name = l_pvt_RQH_rec.destination_subinventory;

Line: 410

PROCEDURE Update_requirement_headers(
    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_RQH_Rec                    IN   RQH_Rec_Type := G_MISS_RQH_REC,
    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_headers';

Line: 426

      SAVEPOINT UPDATE_Packlist_Headers_PUB;

Line: 460

    CSP_requirement_headers_PVT.Update_requirement_headers(
        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_Header_Rec     =>  l_pvt_RQH_Rec ,
        X_Return_Status              => x_return_status,
        X_Msg_Count                  => x_msg_count,
        X_Msg_Data                   => x_msg_data);

Line: 530

End Update_requirement_headers;

Line: 535

PROCEDURE Delete_requirement_headers(
    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_RQH_Rec                    IN   RQH_Rec_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_headers';

Line: 551

  SELECT REQUIREMENT_LINE_ID
 /*        CREATED_BY,
         CREATION_DATE,
         LAST_UPDATED_BY,
         LAST_UPDATE_DATE,
         LAST_UPDATE_LOGIN,
         REQUIREMENT_HEADER_ID,
         INVENTORY_ITEM_ID,
         UOM_CODE,
         REQUIRED_QUANTITY,
         SHIP_COMPLETE_FLAG,
         LIKELIHOOD,
         REVISION,
         SOURCE_ORGANIZATION_ID,
         SOURCE_SUBINVENTORY,
         ORDERED_QUANTITY,
         ORDER_LINE_ID,
         RESERVATION_ID,
         LOCAL_RESERVATION_ID,
         ORDER_BY_DATE ,
         ARRIVAL_DATE,
         ITEM_SCRATCHPAD,
         SHIPPING_METHOD_CODE,
         ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15,
         SECURITY_GROUP_ID,
         SOURCED_FROM
 */
     FROM csp_requirement_lines
     WHERE requirement_header_id = p_rqmt_header_id;

Line: 599

      SAVEPOINT DELETE_Requirement_Headers_PUB;

Line: 651

      CSP_requirement_lines_pub.Delete_requirement_lines(
        P_Api_Version_Number         => 1.0,
        P_Init_Msg_List              => FND_API.G_FALSE,
        P_Commit                     => p_commit,
        P_RQL_TBL                    => l_RQL_TBL,
        X_Return_Status              => x_return_status,
        X_Msg_Count                  => x_msg_count,
        X_Msg_Data                   => x_msg_data);

Line: 668

    CSP_requirement_headers_PVT.Delete_requirement_headers(
    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_Header_Rec     => l_pvt_RQH_Rec,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 734

End Delete_requirement_headers;