APPS.IEC_G_REGION_MAPPINGS_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,
  X_TERRITORY_CODE in VARCHAR2,
  X_PHONE_AREA_CODE in VARCHAR2,
	X_REGION_ID in NUMBER,
  X_CREATED_BY in NUMBER,
  X_CREATION_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
  cursor C is select ROWID
		from 	IEC_G_REGION_MAPPINGS
    where
					TERRITORY_CODE 	= X_TERRITORY_CODE
			and PHONE_AREA_CODE = X_PHONE_AREA_CODE
			and REGION_ID 			= X_REGION_ID;

Line: 25

     insert into IEC_G_REGION_MAPPINGS
                 (TERRITORY_CODE,
                  PHONE_AREA_CODE,
                  REGION_ID,
                  CREATED_BY,
                  CREATION_DATE,
                  LAST_UPDATED_BY,
                  LAST_UPDATE_DATE,
								  LAST_UPDATE_LOGIN,
                  OBJECT_VERSION_NUMBER)
     values
                 (X_TERRITORY_CODE,
                  X_PHONE_AREA_CODE,
                  X_REGION_ID,
								  X_CREATED_BY,
								  X_CREATION_DATE,
								  X_LAST_UPDATED_BY,
								  X_LAST_UPDATE_DATE,
								  X_LAST_UPDATE_LOGIN,
								  X_OBJECT_VERSION_NUMBER);

Line: 54

end INSERT_ROW;

Line: 62

  cursor c is select
      REGION_ID,
      OBJECT_VERSION_NUMBER
    from IEC_G_REGION_MAPPINGS
	  where TERRITORY_CODE 	= X_TERRITORY_CODE
	  and   PHONE_AREA_CODE = X_PHONE_AREA_CODE
    for update of REGION_ID, OBJECT_VERSION_NUMBER  nowait;

Line: 75

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

Line: 90

procedure UPDATE_ROW (
  X_TERRITORY_CODE in VARCHAR2,
  X_PHONE_AREA_CODE in VARCHAR2,
	X_REGION_ID in NUMBER,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
begin

	  update IEC_G_REGION_MAPPINGS
	  set REGION_ID 				= X_REGION_ID,
	      LAST_UPDATED_BY 	= X_LAST_UPDATED_BY,
	      LAST_UPDATE_DATE 	= X_LAST_UPDATE_DATE,
	      LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
	  where TERRITORY_CODE 	= X_TERRITORY_CODE
	  and   PHONE_AREA_CODE = X_PHONE_AREA_CODE;

Line: 113

end UPDATE_ROW;

Line: 115

procedure DELETE_ROW (
  X_TERRITORY_CODE in VARCHAR2,
  X_PHONE_AREA_CODE in VARCHAR2
) is
begin
  delete from IEC_G_REGION_MAPPINGS
	  where TERRITORY_CODE 	= X_TERRITORY_CODE
	  and   PHONE_AREA_CODE = X_PHONE_AREA_CODE;

Line: 127

end DELETE_ROW;

Line: 141

  UPDATE_ROW (X_TERRITORY_CODE, X_PHONE_AREA_CODE, X_REGION_ID, USER_ID, SYSDATE, USER_ID, 0);

Line: 145

    INSERT_ROW (ROW_ID, X_TERRITORY_CODE, X_PHONE_AREA_CODE, X_REGION_ID, USER_ID, SYSDATE, USER_ID, SYSDATE, USER_ID, 0);

Line: 181

   update IEC_G_REGION_MAPPINGS
   set REGION_ID 				 = X_REGION_ID,
       LAST_UPDATE_DATE  = SYSDATE,
       LAST_UPDATED_BY 	 = fnd_load_util.owner_id(X_OWNER),
       LAST_UPDATE_LOGIN = 0
   where TERRITORY_CODE  = X_TERRITORY_CODE
   and   PHONE_AREA_CODE = X_PHONE_AREA_CODE
   and   userenv('LANG') = ( select LANGUAGE_CODE from FND_LANGUAGES
                             where INSTALLED_FLAG = 'B' );