APPS.IGW_ORG_MAP_DETAILS_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_stop_id              NUMBER
        ,p_approver_type        VARCHAR2
        ,p_user_name            varchar2) is

    cursor  c is
    select  rowid
    from    igw_org_map_details
    where   map_id = p_map_id and
            stop_id = p_stop_id and
            user_name = p_user_name;

Line: 18

    l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 19

    l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 20

    l_last_update_date  DATE   := SYSDATE;

Line: 23

    insert into igw_org_map_details(
	map_id
       ,stop_id
       ,approver_type
       ,user_name
	,last_update_date
	,last_updated_by
	,creation_date
	,created_by
	,last_update_login)
    values(
	p_map_id
	,p_stop_id
	,p_approver_type
  	,p_user_name
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_date
	,l_last_updated_by
	,l_last_update_login);

Line: 51

  end insert_row;

Line: 62

      select  	*
     from  	igw_org_map_details
     where 	rowid = x_rowid
     for update of map_id,stop_id,user_name nowait;

Line: 72

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

Line: 93

  procedure update_row (
         x_rowid		VARCHAR2
	,p_map_id	        NUMBER
        ,p_stop_id              NUMBER
        ,p_approver_type        VARCHAR2
        ,p_user_name            varchar2) is

    l_last_updated_by  	NUMBER := FND_GLOBAL.USER_ID;

Line: 101

    l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line: 102

    l_last_update_date  DATE   := SYSDATE;

Line: 105

    update igw_org_map_details
    set stop_id = p_stop_id
       ,approver_type = p_approver_type
       ,user_name = p_user_name
       ,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: 117

  end update_row;

Line: 120

  procedure delete_row (x_rowid	VARCHAR2) is
  begin

    delete from igw_org_map_details
    where rowid = x_rowid;

Line: 129

  end delete_row;