APPS.ZPB_DC_UTIL SQL Statements

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

Line: 30

  SELECT status
  INTO l_prior_lock_status
  FROM ZPB_DC_OBJECTS
  WHERE object_id = p_object_id;

Line: 35

  UPDATE ZPB_DC_OBJECTS
  SET status = 'LOCKED',
      prior_lock_status = l_prior_lock_status,
      freeze_flag = 'Y',
      --who columns
     last_updated_by =  fnd_global.USER_ID,
     last_update_date = SYSDATE,
     last_update_login  = fnd_global.LOGIN_ID
  WHERE object_id = p_object_id;

Line: 48

	x_msg :='Row updated successfully';

Line: 94

  SELECT prior_lock_status
    INTO l_prior_lock_status
    FROM ZPB_DC_OBJECTS
  WHERE object_id = p_object_id;

Line: 99

  UPDATE ZPB_DC_OBJECTS
  SET status = l_prior_lock_status,
      freeze_flag = 'N',
      --who columns
     last_updated_by =  fnd_global.USER_ID,
     last_update_date = SYSDATE,
     last_update_login  = fnd_global.LOGIN_ID
  WHERE object_id = p_object_id
  AND status = 'LOCKED';

Line: 112

	x_msg :='Row updated successfully';

Line: 157

  UPDATE ZPB_DC_OBJECTS
  SET status = 'DISTRIBUTION_PENDING',
      freeze_flag = 'N',
      distributor_user_id = -100,
      --who columns
     last_updated_by =  fnd_global.USER_ID,
     last_update_date = SYSDATE,
     last_update_login  = fnd_global.LOGIN_ID
  WHERE object_id = p_object_id;

Line: 170

	x_msg :='Row updated successfully';