APPS.IGW_PROP_RATES_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_rate_class_id	            NUMBER
        ,p_rate_type_id                     NUMBER
        ,p_fiscal_year                      VARCHAR2
        ,p_location_code                    VARCHAR2
        ,p_activity_type_code              VARCHAR2
        ,p_start_date                       DATE
        ,p_applicable_rate                  NUMBER
        ,p_institute_rate                   NUMBER
        ,x_rowid    	               OUT NOCOPY  VARCHAR2
        ,x_return_status               OUT NOCOPY  VARCHAR2) IS

  cursor c_rates is
  select rowid
  from   igw_prop_rates
  where  proposal_id = p_proposal_id
  and    version_id = p_version_id
  and    rate_class_id = p_rate_class_id
  and    rate_type_id = p_rate_type_id
  and    location_code = p_location_code
  and    activity_type_code = p_activity_type_code
  and    fiscal_year = p_fiscal_year;

Line: 29

  l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 30

  l_last_update_login   NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 31

  l_last_update_date    DATE   := SYSDATE;

Line: 36

    insert into igw_prop_rates(
	proposal_id
	,version_id
	,rate_class_id
	,rate_type_id
	,fiscal_year
	,location_code
        ,activity_type_code
        ,start_date
        ,applicable_rate
        ,institute_rate
	,last_update_date
	,last_updated_by
	,creation_date
	,created_by
	,last_update_login
        ,record_version_number)
    values
      ( p_proposal_id
	,p_version_id
	,p_rate_class_id
	,p_rate_type_id
	,p_fiscal_year
	,p_location_code
        ,p_activity_type_code
        ,p_start_date
        ,p_applicable_rate
        ,p_institute_rate
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_login
        ,1);

Line: 82

                              ,p_procedure_name => 'INSERT_ROW' );

Line: 85

end insert_row;

Line: 89

procedure UPDATE_ROW (
	p_proposal_id		            NUMBER
	,p_version_id		            NUMBER
  	,p_rate_class_id	            NUMBER
        ,p_rate_type_id                     NUMBER
        ,p_fiscal_year                      VARCHAR2
        ,p_location_code                    VARCHAR2
        ,p_activity_type_code              VARCHAR2
        ,p_start_date                       DATE
        ,p_applicable_rate                  NUMBER
        ,p_institute_rate                   NUMBER
        ,p_rowid    	                    VARCHAR2
        ,p_record_version_number            NUMBER
        ,x_return_status               OUT NOCOPY  VARCHAR2) IS

  l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 105

  l_last_update_login   NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 106

  l_last_update_date    DATE   := SYSDATE;

Line: 111

  select  rowid
  from   igw_prop_rates
  where  proposal_id = p_proposal_id
  and    version_id = p_version_id
  and    rate_class_id = p_rate_class_id
  and    rate_type_id = p_rate_type_id
  and    location_code = p_location_code
  and    activity_type_code = p_activity_type_code
  and    fiscal_year = p_fiscal_year;

Line: 130

    update igw_prop_rates
    set	   applicable_rate  = p_applicable_rate
    where rowid = l_row_id;

Line: 144

                             ,p_procedure_name => 'UPDATE_ROW' );

Line: 147

end update_row;

Line: 150

procedure DELETE_ROW (
        p_rowid                          IN ROWID
	,p_proposal_id		            NUMBER
	,p_version_id		            NUMBER
  	,p_rate_class_id	            NUMBER
        ,p_rate_type_id                     NUMBER
        ,p_fiscal_year                      VARCHAR2
        ,p_location_code                    VARCHAR2
        ,p_activity_type_code              VARCHAR2
        ,p_start_date                       DATE
        ,p_applicable_rate                  NUMBER
        ,p_institute_rate                   NUMBER
        ,p_record_version_number        IN  NUMBER
        ,x_return_status                OUT NOCOPY VARCHAR2) is

  l_row_id  ROWID := p_rowid;

Line: 169

  select  rowid
  from   igw_prop_rates
  where  proposal_id = p_proposal_id
  and    version_id = p_version_id
  and    rate_class_id = p_rate_class_id
  and    rate_type_id = p_rate_type_id
  and    location_code = p_location_code
  and    activity_type_code = p_activity_type_code
  and    fiscal_year = p_fiscal_year;

Line: 189

  delete from igw_prop_rates
  where rowid = l_row_id;

Line: 202

                              ,p_procedure_name => 'DELETE_ROW' );

Line: 205

end DELETE_ROW;