APPS.EAM_POPULATE_STATUSES_PKG SQL Statements

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

Line: 5

procedure INSERT_ROW (
  X_ROWID						 in out NOCOPY VARCHAR2,
  X_STATUS_ID					  in out NOCOPY NUMBER,
  P_SEEDED_FLAG				in VARCHAR2,
  P_SYSTEM_STATUS			in NUMBER,
  P_ENABLED_FLAG				in VARCHAR2,
  P_USER_DEFINED_STATUS		 in VARCHAR2,
  P_CREATION_DATE				in DATE,
  P_CREATED_BY				in NUMBER,
  P_LAST_UPDATE_DATE			in DATE,
  P_LAST_UPDATED_BY			in NUMBER,
  P_LAST_UPDATE_LOGIN		in NUMBER
) is

  cursor C is select ROWID from EAM_WO_STATUSES_B
    where STATUS_ID = X_STATUS_ID ;

Line: 22

   CURSOR C2 IS SELECT eam_wo_statuses_b_s.nextval FROM sys.dual;

Line: 32

               			  insert into EAM_WO_STATUSES_B (
							    STATUS_ID,
							    SEEDED_FLAG,
							    SYSTEM_STATUS,
							    ENABLED_FLAG,
							    CREATION_DATE,
							    CREATED_BY,
							    LAST_UPDATE_DATE,
							    LAST_UPDATED_BY,
							    LAST_UPDATE_LOGIN
							  ) values (
							    X_STATUS_ID,
							    P_SEEDED_FLAG,
							    P_SYSTEM_STATUS,
							    P_ENABLED_FLAG,
							    P_CREATION_DATE,
							    P_CREATED_BY,
							    P_LAST_UPDATE_DATE,
							    P_LAST_UPDATED_BY,
							    P_LAST_UPDATE_LOGIN
							  );

Line: 57

											   insert into EAM_WO_STATUSES_TL (
											    LAST_UPDATE_LOGIN,
											    CREATION_DATE,
											    STATUS_ID,
											    USER_DEFINED_STATUS,
											    LAST_UPDATE_DATE,
											    LAST_UPDATED_BY,
											    CREATED_BY,
											    LANGUAGE,
											    SOURCE_LANG
											  ) select
											    P_LAST_UPDATE_LOGIN,
											    P_CREATION_DATE,
											    X_STATUS_ID,
											    P_USER_DEFINED_STATUS,
											    P_LAST_UPDATE_DATE,
											    P_LAST_UPDATED_BY,
											    P_CREATED_BY,
											    L.LANGUAGE_CODE,
											    userenv('LANG')
											  from
											      FND_LANGUAGES L
											  where
												     L.INSTALLED_FLAG in ('I', 'B')
												  and not exists
												    (select NULL
												    from EAM_WO_STATUSES_TL T
												    where T.STATUS_ID = X_STATUS_ID
												    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 95

end INSERT_ROW;

Line: 98

procedure UPDATE_ROW (
  P_STATUS_ID					  in NUMBER,
  P_SEEDED_FLAG				in VARCHAR2,
  P_SYSTEM_STATUS			in NUMBER,
  P_ENABLED_FLAG				in VARCHAR2,
  P_USER_DEFINED_STATUS		 in VARCHAR2,
  P_LAST_UPDATE_DATE			in DATE,
  P_LAST_UPDATED_BY			in NUMBER,
  P_LAST_UPDATE_LOGIN		in NUMBER,
  P_MODE                                              in VARCHAR2 DEFAULT 'FORMS'
) is

    l_user_id    NUMBER;

Line: 115

  update EAM_WO_STATUSES_B set
    SEEDED_FLAG = P_SEEDED_FLAG,
    SYSTEM_STATUS = P_SYSTEM_STATUS,
    ENABLED_FLAG  = P_ENABLED_FLAG,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where STATUS_ID = P_STATUS_ID;

Line: 131

						  update EAM_WO_STATUSES_TL set
						    USER_DEFINED_STATUS = P_USER_DEFINED_STATUS,
						    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
						    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
						    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
						    SOURCE_LANG = userenv('LANG')
						  where STATUS_ID = P_STATUS_ID
						  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 145

							--Launch concurrent program to update work order intermedia index only when update_row is called from forms not during upgrade
							l_user_id       := fnd_global.user_id;

Line: 163

end UPDATE_ROW;

Line: 168

procedure DELETE_ROW (
  P_STATUS_ID in NUMBER
) is
begin

  delete from EAM_WO_STATUSES_TL
  where STATUS_ID = P_STATUS_ID;

Line: 176

  delete from EAM_WO_STATUSES_B
  where STATUS_ID = P_STATUS_ID;

Line: 182

end DELETE_ROW;

Line: 190

  delete from EAM_WO_STATUSES_TL T
  where not exists
    (select NULL
    from EAM_WO_STATUSES_B B
    where B.STATUS_ID = T.STATUS_ID
    );

Line: 197

  update EAM_WO_STATUSES_TL T set (
      USER_DEFINED_STATUS
    ) = (select
      B.USER_DEFINED_STATUS
    from
          EAM_WO_STATUSES_TL B
    where
         B.STATUS_ID = T.STATUS_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.STATUS_ID,
      T.LANGUAGE
  ) in (select
      SUBT.STATUS_ID,
      SUBT.LANGUAGE
    from EAM_WO_STATUSES_TL SUBB, EAM_WO_STATUSES_TL SUBT
    where SUBB.STATUS_ID = SUBT.STATUS_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.USER_DEFINED_STATUS <> SUBT.USER_DEFINED_STATUS
    ));

Line: 218

  insert into EAM_WO_STATUSES_TL (
    LAST_UPDATE_LOGIN,
    CREATION_DATE,
    STATUS_ID,
    USER_DEFINED_STATUS,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATED_BY,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.LAST_UPDATE_LOGIN,
    B.CREATION_DATE,
    B.STATUS_ID,
    B.USER_DEFINED_STATUS,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATED_BY,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from EAM_WO_STATUSES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from EAM_WO_STATUSES_TL T
    where T.STATUS_ID = B.STATUS_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 254

                         P_LAST_UPDATE_DATE				in VARCHAR2,
                         P_CUSTOM_MODE					in VARCHAR2
) IS

f_luby    number;  -- entity owner in file

Line: 259

f_ludate  date;    -- entity update date in file

Line: 261

db_ludate date;    -- entity update date in db

Line: 268

											  f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 270

											  select LAST_UPDATED_BY, LAST_UPDATE_DATE
											  into  db_luby, db_ludate
											  from EAM_WO_STATUSES_TL
											  where STATUS_ID = P_STATUS_ID
											  and  language = userenv('LANG') ;

Line: 279

														    update EAM_WO_STATUSES_TL set
														      user_defined_status = P_USER_DEFINED_STATUS,
														      last_update_date  = f_ludate ,
														      last_updated_by   = f_luby,
														      last_update_login = 0,
														      source_lang       = userenv('LANG')
														    where STATUS_ID = P_STATUS_ID
														    and  userenv('LANG') in (language, source_lang);

Line: 306

   P_LAST_UPDATE_DATE			in VARCHAR2,
   P_CUSTOM_MODE					in VARCHAR2
) IS

l_row_id	  varchar2(64);

Line: 312

f_ludate  date;    -- entity update date in file

Line: 314

db_ludate date;    -- entity update date in db

Line: 319

  f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line: 321

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
  into  db_luby, db_ludate
  from EAM_WO_STATUSES_B
  where status_id = X_STATUS_ID;

Line: 329

     UPDATE_ROW (X_STATUS_ID ,
                 P_SEEDED_FLAG ,
                 P_SYSTEM_STATUS ,
                 P_ENABLED_FLAG ,
                 P_USER_DEFINED_STATUS ,
                 f_ludate ,
                 f_luby ,
                 0,
		 'UPGRADE');

Line: 344

	 INSERT_ROW (l_row_id ,
			 X_STATUS_ID ,
			 P_SEEDED_FLAG ,
			 P_SYSTEM_STATUS ,
			 P_ENABLED_FLAG ,
			 P_USER_DEFINED_STATUS ,
			  f_ludate ,
			  f_luby ,
			  f_ludate ,
			  f_luby ,
			  0 );