APPS.IGW_AWARD_BUDGETS_PVT SQL Statements

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

Line: 178

  PROCEDURE update_award_budget
        (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_award_budget_id            IN    NUMBER
	,p_proposal_id		      IN    NUMBER     := NULL
	,p_proposal_installment_id    IN    NUMBER     := NULL
        ,p_budget_period_id           IN    NUMBER     := NULL
        ,p_expenditure_type_cat       IN    VARCHAR2
        ,p_expenditure_category_flag  IN    VARCHAR2
        ,p_budget_amount              IN    NUMBER     := 0
        ,p_indirect_flag              IN    VARCHAR2
        ,p_project_id                 IN    NUMBER
	,p_project_number             IN    VARCHAR2
        ,p_task_id                    IN    NUMBER
	,p_task_number                IN    VARCHAR2
        ,p_award_id                   IN    NUMBER
	,p_award_number               IN    VARCHAR2
	,p_period_name                IN    VARCHAR2
        ,p_start_date                 IN    DATE
        ,p_end_date                   IN    DATE
        ,p_transferred_flag	      IN    VARCHAR2
        ,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_AWARD_BUDGET';

Line: 239

END; --UPDATE BUDGET LINE

Line: 243

PROCEDURE delete_award_budget
        (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_award_budget_id              IN  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_AWARD_BUDGET';

Line: 268

END; --DELETE AWARD BUDGET

Line: 279

  select project_id
  ,      task_id
  ,      period_name
  from   igw_award_budgets
  where  award_budget_id = p_award_budget_id;

Line: 286

  select *
  from   igw_award_budgets
  where  proposal_installment_id = p_proposal_installment_id
  and    award_budget_id <> p_award_budget_id;