APPS.IGW_BUDGET_PERIODS_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_start_date		       DATE
  	,p_end_date		       DATE
  	,p_total_cost		       NUMBER
  	,p_total_direct_cost	       NUMBER
	,p_total_indirect_cost	       NUMBER
	,p_cost_sharing_amount	       NUMBER
	,p_underrecovery_amount	       NUMBER
	,p_total_cost_limit	       NUMBER
	,p_program_income              VARCHAR2
	,p_program_income_source       VARCHAR2
        ,x_rowid    	          OUT NOCOPY  VARCHAR2
        ,x_return_status          OUT NOCOPY  VARCHAR2) IS

    cursor c_budget_period is
    select  rowid
    from    igw_budget_periods
    where   proposal_id      = p_proposal_id
    and     version_id       = p_version_id
    and     budget_period_id = p_budget_period_id;

Line: 28

    l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 29

    l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 30

    l_last_update_date  DATE   := SYSDATE;

Line: 35

    insert into igw_budget_periods(
	proposal_id
	,version_id
        ,budget_period_id
	,start_date
	,end_date
	,total_cost
	,total_direct_cost
	,total_indirect_cost
	,cost_sharing_amount
	,underrecovery_amount
	,total_cost_limit
	,program_income
	,program_income_source
	,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_start_date
  	,p_end_date
  	,p_total_cost
  	,p_total_direct_cost
	,p_total_indirect_cost
	,p_cost_sharing_amount
	,p_underrecovery_amount
	,p_total_cost_limit
	,p_program_income
	,p_program_income_source
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_login
        ,1);

Line: 87

                              ,p_procedure_name => 'INSERT_ROW' );

Line: 90

end insert_row;

Line: 94

  procedure UPDATE_ROW (
  	p_rowid    	               ROWID
	,p_proposal_id		       NUMBER
	,p_version_id		       NUMBER
        ,p_budget_period_id            NUMBER
  	,p_start_date		       DATE
  	,p_end_date		       DATE
  	,p_total_cost		       NUMBER
  	,p_total_direct_cost	       NUMBER
	,p_total_indirect_cost	       NUMBER
	,p_cost_sharing_amount	       NUMBER
	,p_underrecovery_amount	       NUMBER
	,p_total_cost_limit	       NUMBER
	,p_program_income              VARCHAR2
	,p_program_income_source       VARCHAR2
        ,p_record_version_number       NUMBER
        ,x_return_status          OUT NOCOPY  VARCHAR2) IS

  l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 113

  l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 114

  l_last_update_date  DATE   := SYSDATE;

Line: 119

  SELECT rowid
  FROM   IGW_BUDGET_PERIODS
  WHERE  proposal_id = p_proposal_id
  AND    version_id = p_version_id
  AND    budget_period_id = p_budget_period_id;

Line: 134

    update igw_budget_periods
    set	   budget_period_id = p_budget_period_id
    ,      start_date = p_start_date
    ,	   end_date = p_end_date
    ,	   total_cost = p_total_cost
    ,	   total_direct_cost = p_total_direct_cost
    ,	   total_indirect_cost = p_total_indirect_cost
    ,      cost_sharing_amount = p_cost_sharing_amount
    ,	   underrecovery_amount = p_underrecovery_amount
    ,      total_cost_limit = p_total_cost_limit
    ,      program_income = p_program_income
    ,      program_income_source = p_program_income_source
    ,      record_version_number = record_version_number + 1
    where rowid = l_row_id
    and   record_version_number = p_record_version_number;

Line: 159

                             ,p_procedure_name => 'UPDATE_ROW' );

Line: 162

end update_row;

Line: 165

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

  l_row_id  ROWID := p_rowid;

Line: 176

  SELECT rowid
  FROM   IGW_BUDGET_PERIODS
  WHERE  proposal_id = p_proposal_id
  AND    version_id = p_version_id
  AND    budget_period_id = p_budget_period_id;

Line: 192

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

Line: 205

                              ,p_procedure_name => 'DELETE_ROW' );

Line: 208

end DELETE_ROW;