APPS.EAM_CONSTRUCTION_EST_PUB SQL Statements

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

Line: 39

PROCEDURE INSERT_PARENT_WO_LINE(
  p_api_version                 IN  NUMBER        := 1.0
  , p_init_msg_list               IN  VARCHAR2      := FND_API.G_FALSE
  , p_commit                 IN VARCHAR2
  , p_estimate_id            IN NUMBER
  , p_parent_wo_line_rec     IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_PARENT_WO_REC
  , x_return_status          OUT NOCOPY VARCHAR2
  , x_msg_count              OUT NOCOPY NUMBER
  , x_msg_data               OUT NOCOPY VARCHAR2
)
IS
BEGIN
  EAM_CONSTRUCTION_EST_PVT.INSERT_PARENT_WO_LINE(
      p_api_version          =>     p_api_version
    , p_init_msg_list        =>     p_init_msg_list
    , p_commit               =>     p_commit
    , p_estimate_id          =>     p_estimate_id
    , p_parent_wo_line_rec   =>     p_parent_wo_line_rec
    , x_return_status        =>     x_return_status
    , x_msg_count            =>     x_msg_count
    , x_msg_data             =>     x_msg_data  );

Line: 63

END INSERT_PARENT_WO_LINE;

Line: 65

PROCEDURE DELETE_WO_LINE(
    p_api_version                 IN  NUMBER        := 1.0
  , p_init_msg_list               IN  VARCHAR2      := FND_API.G_FALSE
  , p_commit                        IN VARCHAR2
  , p_work_order_line_id            IN NUMBER
  , x_return_status                 OUT NOCOPY VARCHAR2
  , x_msg_count              OUT NOCOPY NUMBER
  , x_msg_data               OUT NOCOPY VARCHAR2
)
IS
BEGIN
  EAM_CONSTRUCTION_EST_PVT.DELETE_WO_LINE(
      p_api_version          =>  p_api_version
    , p_init_msg_list      =>  p_init_msg_list
    , p_commit             =>  p_commit
    , p_work_order_line_id =>  p_work_order_line_id
    , x_return_status      =>  x_return_status
    , x_msg_count          =>  x_msg_count
    , x_msg_data           =>  x_msg_data );

Line: 87

END DELETE_WO_LINE;

Line: 103

    SELECT WIP_ENTITY_NAME
      FROM WIP_ENTITIES
      WHERE WIP_ENTITY_ID = p_wip_entityid;

Line: 108

  SELECT DISTINCT ESTIMATE_WORK_ORDER_ID
   FROM EAM_CE_WORK_ORDER_LINES
    WHERE ESTIMATE_ID = p_estimate_id
    AND ORGANIZATION_ID = p_organization_id;

Line: 148

          UPDATE EAM_CE_WORK_ORDER_LINES SET WORK_ORDER_NUMBER = l_wip_name_rec.WIP_ENTITY_NAME
             WHERE ESTIMATE_ID = p_estimate_id
             AND ORGANIZATION_ID = p_organization_id
             AND ESTIMATE_WORK_ORDER_ID = l_est_wo_rec.ESTIMATE_WORK_ORDER_ID;

Line: 168

PROCEDURE INSERT_ALL_WO_LINES(
   p_api_version                 IN  NUMBER        := 1.0
  , p_init_msg_list               IN  VARCHAR2      := FND_API.G_FALSE
  , p_commit                 IN VARCHAR2
  , p_estimate_id            IN NUMBER
  , p_eam_ce_wo_lines_tbl    IN EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WORK_ORDER_LINES_TBL
  , x_return_status          OUT NOCOPY VARCHAR2
  , x_msg_count              OUT NOCOPY NUMBER
  , x_msg_data               OUT NOCOPY VARCHAR2)
IS
BEGIN
  EAM_CONSTRUCTION_EST_PVT.INSERT_ALL_WO_LINES(
      p_api_version            =>  p_api_version
    , p_init_msg_list        =>  p_init_msg_list
    , p_commit               =>  p_commit
    , p_estimate_id          =>  p_estimate_id
    , p_eam_ce_wo_lines_tbl  =>  p_eam_ce_wo_lines_tbl
    , x_return_status        =>  x_return_status
    , x_msg_count            =>  x_msg_count
    , x_msg_data             =>  x_msg_data);

Line: 191

END INSERT_ALL_WO_LINES;

Line: 272

PROCEDURE UPDATE_ESTIMATE(
          p_api_version       IN  NUMBER,
          p_commit            IN  VARCHAR2,
          p_init_msg_list     IN  VARCHAR2,
          p_validation_level  IN  NUMBER,
          p_estimate_rec      IN  EAM_EST_DATASTRUCTURES_PUB.EAM_CONSTRUCTION_ESTIMATE_REC,
          x_return_status     OUT NOCOPY VARCHAR2,
          x_msg_count         OUT NOCOPY NUMBER,
          x_msg_data          OUT NOCOPY VARCHAR2)
IS
BEGIN
  EAM_CONSTRUCTION_EST_PVT.UPDATE_ESTIMATE(
      p_api_version       => p_api_version,
      p_commit            => p_commit,
      p_init_msg_list     => p_init_msg_list,
      p_validation_level  => p_validation_level,
      p_estimate_rec      => p_estimate_rec,
      x_return_status     => x_return_status,
      x_msg_count         => x_msg_count,
      x_msg_data          => x_msg_data);

Line: 295

END UPDATE_ESTIMATE;

Line: 324

PROCEDURE UPDATE_CE_WO_LNS_BY_GROUP_OPT(
          p_api_version       IN  NUMBER,
          p_commit            IN  VARCHAR2,
          p_init_msg_list     IN  VARCHAR2,
          p_validation_level  IN  NUMBER,
          p_ce_wo_defaults    IN  EAM_EST_DATASTRUCTURES_PUB.EAM_CE_WO_DEFAULTS_REC,
          x_return_status     OUT NOCOPY VARCHAR2,
          x_msg_count         OUT NOCOPY NUMBER,
          x_msg_data          OUT NOCOPY VARCHAR2)
IS
BEGIN
  EAM_CONSTRUCTION_EST_PVT.UPDATE_CE_WO_LNS_BY_GROUP_OPT(
      p_api_version       => p_api_version,
      p_commit            => p_commit,
      p_init_msg_list     => p_init_msg_list,
      p_validation_level  => p_validation_level,
      p_ce_wo_defaults    => p_ce_wo_defaults,
      x_return_status     => x_return_status,
      x_msg_count         => x_msg_count,
      x_msg_data          => x_msg_data);

Line: 347

END UPDATE_CE_WO_LNS_BY_GROUP_OPT;