APPS.IGW_ORG_MAPS_ALL_PKG SQL Statements

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

Line: 4

  procedure insert_row (
         x_rowid		IN OUT NOCOPY  VARCHAR2
	,p_map_id	        NUMBER
	,p_organization_id	NUMBER
	,p_description		VARCHAR2
  	,p_start_date_active	DATE
  	,p_end_date_active	DATE) is

    cursor  c is
    select  rowid
    from    igw_org_maps_all
    where   map_id = p_map_id;

Line: 17

    l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 18

    l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 19

    l_last_update_date  DATE   := SYSDATE;

Line: 22

    insert into igw_org_maps_all(
	map_id
	,organization_id
	,description
  	,start_date_active
  	,end_date_active
	,last_update_date
	,last_updated_by
	,creation_date
	,created_by
	,last_update_login)
    values(
	p_map_id
	,p_organization_id
	,p_description
  	,p_start_date_active
  	,p_end_date_active
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_login);

Line: 52

  end insert_row;

Line: 64

      select  	*
     from  	igw_org_maps_all
     where 	rowid = x_rowid
     for update of map_id nowait;

Line: 74

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 97

  procedure update_row (
         x_rowid		VARCHAR2
	,p_map_id	        NUMBER
	,p_organization_id	NUMBER
	,p_description		VARCHAR2
  	,p_start_date_active	DATE
  	,p_end_date_active	DATE) is

    l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 106

    l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 107

    l_last_update_date  DATE   := SYSDATE;

Line: 110

    update igw_org_maps_all
    set	   organization_id = p_organization_id
    ,	   description = p_description
    ,	   start_date_active = p_start_date_active
    ,	   end_date_active = p_end_date_active
    ,      last_update_date = l_last_update_date
    ,      last_updated_by = l_last_updated_by
    ,      last_update_login = l_last_update_login
    where  rowid  = x_rowid;

Line: 123

  end update_row;

Line: 126

  procedure delete_row (x_rowid	VARCHAR2) is
  begin

    delete from igw_org_maps_all
    where rowid = x_rowid;

Line: 135

  end delete_row;