APPS.IGW_BUDGET_PERSONNEL_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_budget_personnel_detail_id  NUMBER
        ,p_person_id                   NUMBER
	,p_party_id		       NUMBER
  	,p_start_date		       DATE
  	,p_end_date		       DATE
        ,p_period_type_code            VARCHAR2
        ,p_appointment_type_code       VARCHAR2
        ,p_salary_requested            NUMBER
        ,p_percent_charged             NUMBER
        ,p_percent_effort              NUMBER
        ,p_cost_sharing_percent        NUMBER
	,p_cost_sharing_amount	       NUMBER
	,p_underrecovery_amount	       NUMBER
        ,x_rowid    	          OUT NOCOPY  VARCHAR2
        ,x_return_status          OUT NOCOPY  VARCHAR2) IS

    cursor c_budget_personnel is
    select  rowid
    from    igw_budget_personnel_details
    where   budget_personnel_detail_id  = p_budget_personnel_detail_id;

Line: 30

    l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 31

    l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 32

    l_last_update_date  DATE   := SYSDATE;

Line: 37

    insert into igw_budget_personnel_details(
	proposal_id
	,version_id
        ,budget_period_id
        ,line_item_id
        ,budget_personnel_detail_id
        ,person_id
        ,party_id
  	,start_date
  	,end_date
        ,period_type_code
        ,appointment_type_code
        ,salary_requested
        ,percent_charged
        ,percent_effort
        ,cost_sharing_percent
	,cost_sharing_amount
	,underrecovery_amount
	,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_budget_personnel_detail_id
        ,p_person_id
        ,p_party_id
  	,p_start_date
  	,p_end_date
        ,p_period_type_code
        ,p_appointment_type_code
        ,p_salary_requested
        ,p_percent_charged
        ,p_percent_effort
        ,p_cost_sharing_percent
	,p_cost_sharing_amount
	,p_underrecovery_amount
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_login
        ,1);

Line: 97

                              ,p_procedure_name => 'INSERT_ROW' );

Line: 100

end insert_row;

Line: 104

  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_budget_personnel_detail_id  NUMBER
        ,p_person_id                   NUMBER
	,p_party_id		       NUMBER
  	,p_start_date		       DATE
  	,p_end_date		       DATE
        ,p_period_type_code            VARCHAR2
        ,p_appointment_type_code       VARCHAR2
        ,p_salary_requested            NUMBER
        ,p_percent_charged             NUMBER
        ,p_percent_effort              NUMBER
        ,p_cost_sharing_percent        NUMBER
	,p_cost_sharing_amount	       NUMBER
	,p_underrecovery_amount	       NUMBER
        ,p_record_version_number       NUMBER
        ,x_return_status          OUT NOCOPY  VARCHAR2)IS

  l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 127

  l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 128

  l_last_update_date  DATE   := SYSDATE;

Line: 133

    select  rowid
    from    igw_budget_personnel_details
    where   budget_personnel_detail_id  = p_budget_personnel_detail_id;

Line: 146

    update igw_budget_personnel_details
    set	   person_id                = p_person_id
    ,      party_id	            = p_party_id
    ,	   start_date               = p_start_date
    ,	   end_date	            = p_end_date
    ,	   period_type_code         = p_period_type_code
    ,	   appointment_type_code    = p_appointment_type_code
    ,      salary_requested         = p_salary_requested
    ,	   percent_charged          = p_percent_charged
    ,      percent_effort           = p_percent_effort
    ,	   cost_sharing_percent     = p_cost_sharing_percent
    ,	   cost_sharing_amount      = p_cost_sharing_amount
    ,	   underrecovery_amount     = p_underrecovery_amount
    ,      record_version_number    = record_version_number + 1
    where rowid = l_row_id
    and   record_version_number = p_record_version_number;

Line: 172

                             ,p_procedure_name => 'UPDATE_ROW' );

Line: 175

end update_row;

Line: 179

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

  l_row_id  ROWID := p_rowid;

Line: 194

    select  rowid
    from    igw_budget_personnel_details
    where   budget_personnel_detail_id  = p_budget_personnel_detail_id;

Line: 208

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

Line: 221

                              ,p_procedure_name => 'DELETE_ROW' );

Line: 224

end DELETE_ROW;