APPS.FII_CHANGE_LOG_PKG SQL Statements

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

Line: 7

procedure update_change_log(p_log_item 		in varchar2,
                            p_item_value 	in varchar2,
			    x_status  		out nocopy varchar2,
                            x_message_count 	out nocopy number,
                            x_error_message 	out nocopy varchar2) is
begin
  if g_debug_flag = 'Y' then
    fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(+)');

Line: 17

  update fii_change_log
  set item_value = p_item_value,
      last_update_date = sysdate,
      last_updated_by = fnd_global.user_id,
      last_update_login = fnd_global.user_id
  where log_item = p_log_item;

Line: 26

    fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(-)');

Line: 34

    FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_CHANGE_LOG_PKG.update_change_log');

Line: 39

      fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(EXCEPTION)');

Line: 53

  UPDATE FII_CHANGE_LOG
  SET item_value = 'Y',
      last_update_date = sysdate,
      last_updated_by = fnd_global.user_id,
      last_update_login = fnd_global.user_id
  WHERE log_item IN
	('GL_RESUMMARIZE',
         'AP_RESUMMARIZE',
         'AR_RESUMMARIZE',
         'CCID_RELOAD',
		 'FA_RESUMMARIZE');

Line: 102

   Select count(*) into l_item_count from fii_change_log where log_item = p_log_item;

Line: 105

	   INSERT INTO FII_CHANGE_LOG
		 (log_item,
	      item_value,
	 	  creation_date,
		  created_by,
	      last_update_date,
		  last_update_login,
		  last_updated_by)
		VALUES (p_log_item,
				p_item_value,
				sysdate,
		      	fnd_global.user_id,
	            sysdate,
		        fnd_global.login_Id,
		        fnd_global.user_id);