APPS.IGW_BUDGET_DETAILS_OH_PVT SQL Statements

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

Line: 108

  procedure update_budget_line_oh
       (p_init_msg_list               IN    VARCHAR2   := FND_API.G_TRUE
        ,p_commit                     IN    VARCHAR2   := FND_API.G_FALSE
        ,p_validate_only              IN    VARCHAR2   := FND_API.G_TRUE
	,p_proposal_id		            NUMBER     := NULL
	,p_version_id		            NUMBER     := NULL
        ,p_budget_period_id                 NUMBER     := NULL
        ,p_line_item_id                     NUMBER
        ,p_rate_class_id                    NUMBER
        ,p_rate_type_id                     NUMBER
        ,p_apply_rate_flag                  VARCHAR2
        ,p_calculated_cost                  NUMBER
        ,p_calculated_cost_sharing          NUMBER
        ,p_record_version_number        IN  NUMBER
        ,p_rowid                        IN  ROWID
        ,x_return_status                OUT NOCOPY VARCHAR2
        ,x_msg_count                    OUT NOCOPY NUMBER
        ,x_msg_data                     OUT NOCOPY VARCHAR2) IS

  l_api_name                   VARCHAR2(30)     :='UPDATE_BUDGET_LINE_OH';

Line: 141

      SAVEPOINT update_budget_line_oh;

Line: 152

      SELECT 'x' INTO l_dummy
      FROM   igw_budget_details_cal_amts
      WHERE  ((line_item_id  = p_line_item_id and rate_class_id = p_rate_class_id and rate_type_id = p_rate_type_id)
	  OR rowid = p_rowid)
      AND record_version_number  = p_record_version_number;

Line: 184

      select proposal_id, version_id, budget_period_id
      into   l_proposal_id, l_version_id, l_budget_period_id
      from   igw_budget_details
      where  line_item_id = p_line_item_id;

Line: 196

      update igw_budget_details_cal_amts
      set    apply_rate_flag = p_apply_rate_flag
      ,      calculated_cost = l_calculated_cost
      ,      calculated_cost_sharing = l_calculated_cost_sharing
      ,      record_version_number = record_version_number + 1
      where  line_item_id = p_line_item_id
      and    rate_class_id = p_rate_class_id
      and    rate_type_id = p_rate_type_id;

Line: 237

       ROLLBACK TO update_budget_line_oh;

Line: 249

       ROLLBACK TO update_budget_line_oh;

Line: 255

       ROLLBACK TO update_budget_line_oh;

Line: 265

END; --UPDATE BUDGET LINE OH

Line: 269

procedure delete_budget_line_oh
       (p_init_msg_list                 IN  VARCHAR2   := FND_API.G_TRUE
        ,p_commit                       IN  VARCHAR2   := FND_API.G_FALSE
        ,p_validate_only                IN  VARCHAR2   := FND_API.G_TRUE
        ,p_proposal_id                  IN  NUMBER     := NULL
        ,p_version_id                   IN  NUMBER     := NULL
        ,p_budget_period_id                 NUMBER     := NULL
        ,p_line_item_id                     NUMBER
        ,p_rate_class_id                    NUMBER
        ,p_rate_type_id                     NUMBER
        ,p_record_version_number        IN  NUMBER
        ,p_rowid                        IN  ROWID
        ,x_return_status                OUT NOCOPY VARCHAR2
        ,x_msg_count                    OUT NOCOPY NUMBER
        ,x_msg_data                     OUT NOCOPY VARCHAR2)  is

  l_api_name          VARCHAR2(30)    :='DELETE_BUDGET_LINE_OH';

Line: 296

      SAVEPOINT delete_budget_line_oh;

Line: 306

      SELECT 'x' INTO l_dummy
      FROM    igw_budget_details_cal_amts
      WHERE  ((line_item_id  = p_line_item_id and rate_class_id = p_rate_class_id and rate_type_id = p_rate_type_id)
	  OR rowid = p_rowid)
      AND record_version_number  = p_record_version_number;

Line: 337

       delete from igw_budget_details_cal_amts
       where  line_item_id = p_line_item_id
       and    rate_class_id = p_rate_class_id
       and    rate_type_id = p_rate_type_id;

Line: 364

       ROLLBACK TO delete_budget_line_oh;

Line: 376

       ROLLBACK TO delete_budget_line_oh;

Line: 382

       ROLLBACK TO delete_budget_line_oh;

Line: 393

END; --DELETE BUDGET LINE OH