APPS.IGW_BUDGET_DETAILS_TBH SQL Statements

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

Line: 4

  procedure INSERT_ROW (
        p_proposal_id		       NUMBER
	,p_version_id		       NUMBER
        ,p_budget_period_id            NUMBER
        ,p_line_item_id                NUMBER
        ,p_expenditure_type            VARCHAR2
        ,p_expenditure_category_flag   VARCHAR2
        ,p_budget_category_code        VARCHAR2
        ,p_line_item_description       VARCHAR2
        ,p_based_on_line_item          NUMBER
        ,p_line_item_cost              NUMBER
	,p_cost_sharing_amount	       NUMBER
	,p_underrecovery_amount	       NUMBER
        ,p_apply_inflation_flag        VARCHAR2
        ,p_budget_justification        LONG
        ,p_location_code               VARCHAR2
        ,p_project_id                  NUMBER
        ,p_task_id                     NUMBER
        ,p_award_id                    NUMBER
        ,x_rowid    	          OUT NOCOPY  VARCHAR2
        ,x_return_status          OUT NOCOPY  VARCHAR2) IS

    cursor c_budget_line is
    select  rowid
    from    igw_budget_details
    where   proposal_id      = p_proposal_id
    and     version_id       = p_version_id
    and     budget_period_id = p_budget_period_id
    and     line_item_id  =    p_line_item_id;

Line: 34

    l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 35

    l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 36

    l_last_update_date  DATE   := SYSDATE;

Line: 41

    insert into igw_budget_details(
	proposal_id
	,version_id
        ,budget_period_id
        ,line_item_id
        ,expenditure_type
        ,expenditure_category_flag
        ,budget_category_code
        ,line_item_description
        ,based_on_line_item
        ,line_item_cost
	,cost_sharing_amount
	,underrecovery_amount
        ,apply_inflation_flag
        ,budget_justification
        ,location_code
        ,project_id
        ,task_id
        ,award_id
	,last_update_date
	,last_updated_by
	,creation_date
	,created_by
	,last_update_login
        ,record_version_number)
    values
      ( p_proposal_id
	,p_version_id
        ,p_budget_period_id
        ,p_line_item_id
        ,p_expenditure_type
        ,p_expenditure_category_flag
        ,p_budget_category_code
        ,p_line_item_description
        ,p_based_on_line_item
        ,p_line_item_cost
	,p_cost_sharing_amount
	,p_underrecovery_amount
        ,p_apply_inflation_flag
        ,p_budget_justification
        ,p_location_code
        ,p_project_id
        ,p_task_id
        ,p_award_id
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_login
        ,1);

Line: 103

                              ,p_procedure_name => 'INSERT_ROW' );

Line: 106

end insert_row;

Line: 110

  procedure UPDATE_ROW (
  	p_rowid    	               ROWID
        ,p_proposal_id		       NUMBER
	,p_version_id		       NUMBER
        ,p_budget_period_id            NUMBER
        ,p_line_item_id                NUMBER
        ,p_expenditure_type            VARCHAR2
        ,p_expenditure_category_flag   VARCHAR2
        ,p_budget_category_code        VARCHAR2
        ,p_line_item_description       VARCHAR2
        ,p_based_on_line_item          NUMBER
        ,p_line_item_cost              NUMBER
	,p_cost_sharing_amount	       NUMBER
	,p_underrecovery_amount	       NUMBER
        ,p_apply_inflation_flag        VARCHAR2
        ,p_budget_justification        LONG
        ,p_location_code               VARCHAR2
        ,p_project_id                  NUMBER
        ,p_task_id                     NUMBER
        ,p_award_id                    NUMBER
        ,p_record_version_number       NUMBER
        ,x_return_status          OUT NOCOPY  VARCHAR2) IS

  l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 134

  l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 135

  l_last_update_date  DATE   := SYSDATE;

Line: 140

  SELECT rowid
    from    igw_budget_details
    where   proposal_id      = p_proposal_id
    and     version_id       = p_version_id
    and     budget_period_id = p_budget_period_id
    and     line_item_id  =    p_line_item_id;

Line: 156

    update igw_budget_details
    set	   expenditure_type = p_expenditure_type
    ,	   expenditure_category_flag = p_expenditure_category_flag
    ,	   budget_category_code = p_budget_category_code
    ,	   line_item_description = p_line_item_description
    ,	   based_on_line_item = p_based_on_line_item
    ,	   line_item_cost = p_line_item_cost
    ,      cost_sharing_amount = p_cost_sharing_amount
    ,	   underrecovery_amount = p_underrecovery_amount
    ,	   apply_inflation_flag = p_apply_inflation_flag
    ,	   budget_justification = p_budget_justification
    ,	   location_code    = p_location_code
    ,	   project_id       = decode(p_project_id, FND_API.G_MISS_NUM, NULL, p_project_id)
    ,	   task_id          = decode(p_task_id, FND_API.G_MISS_NUM, NULL, p_task_id)
    ,	   award_id         = decode(p_award_id  , FND_API.G_MISS_NUM, NULL, p_award_id)
    ,      record_version_number = record_version_number + 1
    where rowid = l_row_id
    and   record_version_number = p_record_version_number;

Line: 184

                             ,p_procedure_name => 'UPDATE_ROW' );

Line: 187

end update_row;

Line: 191

procedure DELETE_ROW (
   p_rowid                        IN  ROWID
  ,p_proposal_id                  IN  NUMBER
  ,p_version_id                   IN  NUMBER
  ,p_budget_period_id             IN  NUMBER
  ,p_line_item_id                     NUMBER
  ,p_record_version_number        IN  NUMBER
  ,x_return_status                OUT NOCOPY VARCHAR2) is

  l_row_id  ROWID := p_rowid;

Line: 203

  SELECT rowid
    from    igw_budget_details
    where   proposal_id      = p_proposal_id
    and     version_id       = p_version_id
    and     budget_period_id = p_budget_period_id
    and     line_item_id  =    p_line_item_id;

Line: 220

  delete from igw_budget_details
  where rowid = l_row_id
  and record_version_number = p_record_version_number;

Line: 233

                              ,p_procedure_name => 'DELETE_ROW' );

Line: 236

end DELETE_ROW;